Industry Connect
  • Industry Connect
  • Team
  • Automation Lab
    • Proposed Automation Lab
  • Founding Cohort
    • Program Details
    • Program Tech Skills Schedule
    • Google Data Analytics Pacing
    • Kaggle Tutorial Pathway & Pacing
    • Weekly Sessions
      • W1 January 12 ✓
      • W2 January 19 ×
      • W3 January 26 ✓
      • W4 February 2 ✓
      • W5 February 9 ✓
      • W6 February 16 ×
      • W7 February 23 ✓
      • W8 March 1 ✓
      • W9 March 8 ✓
      • W10 March 15 ✓
      • W11 March 22 ×
      • W12 March 29 ×
      • W13 April 5 ✓
      • W14 April 12 ✓
      • W15 April 19 ✓
      • W16 April 26 ✓
      • W17 May 3 ✓
      • W18 May 10 ✓
      • W19 May 17 ✓
    • Projects
      • Data Analytics Project
      • Cobot Project
    • Reference
      • Cobot Reference
      • Files
      • Your Learning Strategy
Powered by GitBook
  1. Founding Cohort
  2. Weekly Sessions

W9 March 8 ✓

Last updated 1 year ago

Agenda

  • During Lunch Review Coursera course structure, pacing, and incentives

  • Survey: T-shirt Sizes and Summer Plans https://form.jotform.com/240674228249057

  • Data Students Complete the data analytics exercise

  • Robotics Students Review the concepts for the Cobot Node Novice badge and complete the assessment

  • Data Students Continue Progress on Coursera

SQL: WHERE, LIKE, LIMIT

Exercise

Today we will continue to use Structured Query Language (SQL) to pull data from a movie database. This time we will learn basic filtering techniques.

Demo

WHERE, LIKE, LIMIT

Constructing SQL Statements

Construct the appropriate SQL statements to satisfy each of the following requests. Use the LaunchBoard SQL Lab to test your statements.

  1. List movies since the year 2000 in ascending alphabetical order. Include title and year columns.

  2. List all movies containing the string "night" anywhere in the title. Include the title and year columns.

  3. List movies before 2000 ordered by ascending vote_average. Show only the top 30. Include all columns.

Demonstrate your executed SQL statements with an instructor.

Continue work on the Data Analytics Certificate on Coursera (Pacing)

Cobot Node Novice Assessment

Today you will demonstrate your understanding of the cobot concepts we have applied in the program to date to earn the Cobot Node Novice badge.

Review

Assessment

👉
✔️
LogoPassword Protected Form