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

W8 March 1 ✓

Last updated 1 year ago

Agenda

  • During Lunch: Custom GPT Demo with Audio

  • Review Progress on Coursera and Summer Opportunities

  • Breakouts into Data Analytics and Robotics

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 to test your statements.

  1. List all movies in the movies table. Include all columns.

  2. List all movies, but include only title and year columns.

  3. List all movies by ascending year. Include all columns.

  4. List all movies by descending vote_count. Include only title and vote_count columns.

Demonstrate your executed SQL statements with an instructor.

Continue work on the Data Analytics Certificate on Coursera ()

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.

✔️
🗣️
🚀
✔️
LaunchBoard SQL Lab
Pacing