W8 March 1 ✓
SQL: SELECT, FROM, ORDER BY
Exercise
Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.
Demo: SELECT
, FROM
, ORDER BY
, ASC
, DESC
Practice: 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 all movies in the
movies
table. Include all columns.List all movies, but include only
title
andyear
columns.List all movies by ascending
year
. Include all columns.List all movies by descending
vote_count
. Include onlytitle
andvote_count
columns.
✔️ Demonstrate your executed SQL statements with an instructor.
Continue work on the Data Analytics Certificate on Coursera (Pacing)
Using Cobot Vision to Recognize and Pick Objects
Demo
We will demonstrate how to define a visual servoing job to a cobot flow to recognize the position of objects. This will create a base that we can use to then pick up the object and move to another location. We will also use a subflow to separate functions.
Challenge
Work in small groups to modify the demo flow.
Create a new visual servoing job that picks up a different object. This will require learning the new pattern to match
Update the point node to position the cobot vacuum gripper above the object.
If needed, adjust the move node to grip the object.
Test your updated flow.
✔️ Demonstrate your solution.
Last updated