Learning SQL Queries - Understanding Advanced SQL Features, CTEs & Temp Tables

Learning SQL Queries -- Understanding Advanced SQL Features, plus CTEs and Temp Tables

* Note: we are taking two weeks off for Thanksgiving, and this session will be on December 6th.

This session will cover lesson 22 about database constraints and indexes. We are going to supplement the book with material about CTEs and Temp Tables. Overviews for these topics can be found here:

Everyone is welcome!

Schedule for the series (subject to change):

1: Understanding SQL
2: Retrieving Data and 3: Sorting Retrieved Data
4: Filtering Data and 5: Advanced Data Filtering
6: Using Wildcard Filtering and 7: Creating Calculated Fields
8: Using Data Manipulation Functions and 9: Summarizing Data
10: Grouping Data and 11: Working with Subqueries
12: Joining Tables and 13: Creating Advanced Joins
14: Combining Queries and 15: Inserting Data
16: Updating and Deleting Data and 17: Creating and Manipulating Tables
18: Using Views and 19: Working with Stored Procedures
20: Managing Transaction Processing and 21: Using Cursors
22: Understanding Advanced SQL Features, plus CTEs and Temp Tables (We are HERE!)
Advanced topics of window functions and CASE expressions
Potential additional topics TBD
Agenda
5:30 - 5:35 pm -- Arrival
5:35 - 6:30 pm -- Discussion and questions
Time permitting, breakout sessions

Location
This will be an online meetup until further notice.
Please Note: You must have a Zoom login in order to join the event. A free Zoom account will work. If you get an error message joining the Zoom, please login to your Zoom account and try again.

Questions?
Join our slack channel or leave a comment below if you have any questions about the group or need clarification on anything.