Agenda
During Lunch
Review Coursera course structure, pacing, and incentives 👉
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 year 2000 in ascending alphabetical order. Include title and year columns.
List all movies containing the string "night" anywhere in the title. Include the title and year columns.
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
