SQL Sessions: SQL for Data Science - Recurring

SQL for Data Science is a custom-made session focused on solving personalized needs with SQL via SQLite in Google Colab. Students will develop a bespoke solution for individual project using a tailored-made training and curriculum. Students will improve technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries as well as conceptional understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries.

Benefits

• Bespoke solution for individual project

• Technical skillset in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries

• Conceptual understanding of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries

• Personalized private training

• Continuous learning resources

Topics

1. Querying data using SELECT, DISTINCT, and CAST

2. Sorting and filtering queries using ORDER BY and WHERE

3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY

4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN

5. Nesting queries using Subqueries

Deliverables

• Live 60-min screensharing via Google Meet

Requirements

• Google Colab

• Private information secured during screensharing