The SDML book club will start discussing Sams Teach Yourself SQL in 10 Minutes, 5th Edition
by Ben Forta (https://www.amazon.com/gp/product/0135182794/) in September 2022.
Additional practice problems may be drawn from online resources like SQLZOO
and SQLBolt.
Below are the notes/slides and meetup recordings.
All of the videos will be posted to Ryan's YouTube channel: https://www.youtube.com/c/ITConnected/videos
Session 1: Kickoff and Chapter 1, Understanding SQL
Meetup (https://www.meetup.com/san-diego-machine-learning/events/287539370/) will be Tuesday, September 6, 2022, from 5:30-6:30 pm Pacific
We will meet other people in small breakout rooms and discuss chapter 1 of the SQL book.
Here are kickoff info and notes for chapter 1,
sample SQLite database file from the author,
and a sample Jupyter notebook for running queries on a SQLite database.
Sample data for other database systems is available on the author's book page in the section about Appendix A.
Video recording of kickoff and chapter 1.
Session 2: Chapter 2, Retrieving Data and Chapter 3, Sorting Retrieved Data
The meetup will be Tuesday, September 13, 2022, 5:30-6:30 pm PDT.
Discussion leader: James Colbert
We start with the SELECT statement for retrieving data.
Notes and video
Session 3: Chapter 4, Filtering Data and Chapter 5, Advanced Data Filtering
This session will be Tuesday, September 20, 2022, 5:30-6:30 pm PDT
Discussion leader: Ian Cook
We add the WHERE clause to filter the rows returned.
Notes and video
Session 4: Chapter 6, Using Wildcard Filtering and Chapter 7, Creating Calculated Fields
This meetup will be Tuesday, September 27, 2022, 5:30-6:30 pm PDT.
We discuss filtering with the LIKE clause, and we talk about calculated fields.
Notes and video
Session 5: Chapter 8, Using Data Manipulation Functions and Chapter 9, Summarizing Data
This session will be Tuesday, October 4, 2022, 5:30-6:30 pm PDT
Discussion leader: Vibhu Sapra
Using built-in functions and summarizing data with aggregation functions.
Notes
Session 6: Chapter 10, Grouping Data and Chapter 11, Working with Subqueries
This meetup will be Tuesday, October 11, 2022, 5:30-6:30 pm PDT
Discussion leader: Sule Sidigu
We will introduce the GROUP BY clause and discuss subqueries.
Slides and Notes
and video
Session 7: Chapter 12, Joining Tables and Chapter 13, Creating Advanced Joins
The meeting will be on Tuesday, October 18, 2002, 5:30-6:30 pm PDT
Discussion leader: Mya Bakhova
This session will discuss both basic and advanced ways to join tables.
Slides
Session 8: Chapter 14, Combining Queries and Chapter 15, Inserting Data
This session will be Tuesday, October 25, 2022, 5:30-6:30 pm PDT
Discussion leader: Harold Anderson
We will introduce the UNION operation and discuss ways to insert rows.
Slides and video
Session 9: Chapter 16, Updating and Deleting Data and Chapter 17, Creating and Manipulating Tables
This meetup will be Tuesday, November 1, 2022, 5:30-6:30 pm PDT
Discussion leader: Sule Sidigu
Topics will be the UPDATE and DELETE statements, then creating and modifying database tables.
Slides and video
Session 10: Chapter 18, Using Views and Chapter 19, Working with Stored Procedures
This session will be Tuesday, November 8, 2022, 5:30-6:30 pm PST
Discussion leader: Xi Chen
We will discuss SQL code saved in the database as views and as stored procedures.
Slides and video
Session 11: Chapter 20, Managing Transaction Processing and Chapter 21, Using Cursors
This session will be Tuesday, November 15, 2022, 5:30-6:30 pm PST
Discussion leader: Ryan Chesler
New content will cover wrapping SQL code in transactions and using cursors to iterate through rows.
video
Session 12: Chapter 22, Understanding Advanced SQL Features, plus additional topics of CTEs and temp tables
This meetup will be Tuesday, December 6, 2022, 5:30-6:30 pm PST
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 additional topics can be found here:
- https://learnsql.com/blog/cte-with-examples/
- https://www.tutorialgateway.org/temp-table-in-sql-server/
Session 13: Advanced topics of window functions and CASE expressions
We are supplementing the book with material about CASE expressions and window functions.
Here is a good overview of window functions:
If there is interest, additional sessions could be scheduled to understand more deeply how relational databases work and concepts around why some queries are slow & how to write good queries.
Solutions to the challenge exercises in each chapter can be found here: https://forta.com/books/0135182794/challenges/
Errata for the 5th edition is located on Ben Forta's website: https://forta.com/books/0135182794/errata/