W9 March 8 ✓

Main

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

Data Analytics

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)

Robotics

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

Password Protected Form