Learning SQL Queries -- Wildcard Filtering and Calculated Fields

SQL is a useful skill for data scientists which often appears in job descriptions and interviews. The SDML book club will be meeting Tuesdays for an introduction to writing SQL queries. This series will focus on the practical side of writing SQL to pull data out of a database. We will be using the book Sams Teach Yourself SQL in 10 Minutes by Ben Forta (https://www.amazon.com/gp/product/0135182794/) as our primary source. This series is open to beginners and has no prerequisites.

This session will cover chapters 6 and 7, about wildcard filtering with LIKE and about calculated fields. 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 (We are HERE!)
• 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

Agenda

• 5:30 - 5:45 pm -- Arrival
• 5:45 - 6:30 pm -- Discussion and questions
• Time permitting, breakout sessions

Links to notes/slides and videos of prior meetups are available on the SDML GitHub repo https://github.com/SanDiegoMachineLearning/bookclub

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.
https://join.slack.com/t/sdmachinelearning/shared_invite/zt-6b0ojqdz-9bG7tyJMddVHZ3Zm9IajJA