W9 March 8 ✓
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.
List movies since the
year2000 in ascending alphabetical order. Includetitleandyearcolumns.List all movies containing the string "night" anywhere in the
title. Include thetitleandyearcolumns.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
Last updated