Skip to content

Latest commit

 

History

History
20 lines (13 loc) · 1.04 KB

SQL-Part-2.md

File metadata and controls

20 lines (13 loc) · 1.04 KB
Raw

SQL Part 2

In the prep work for this class, the students learned:

  1. What string functions are available and how to structure SELECT queries with them.
  2. What date and time functions are available and how to structure SELECT queries with them.
  3. What aggregate functions are available and how to structure SELECT queries with them.

Announcements

  1. Always check with your program manager to see if there are any upcoming deadlines you should highlight!

Large Group Time (Instructor)

Topics That Require Careful Attention

  1. Q & A from the prep work and/or exercises.
    1. Students continued to practiced writing SQL queries. Make sure when discussing SQL queries to remind them to think about the result set returned and how they can follow the best practices introduced at this stage in their learning.

Studio (IA Notes)

  1. Students will be working with the BooksDB dataset from the previous lesson. They should already have access to this but ensure they have the necessary permissions to perform queries against the database!