SQL Crash Course

This repo has slides, exercises, solutions and support material for the SQL crash course at Data Science Retreat

Examples and exercises are based on PostgreSQL and the DVD Rental DB
DataGrip is the recommended GUI (trial version available for 30 days)

Original content developed and maintained by Dania Meira - [email protected]

Distributed under the MIT license.

Table of contents

Introduction

What is SQL?
Why SQL?
The RDBMS Landscape
NoSQL ?

Concepts and Basic Operations

Database Structures
Database Objects
Data Types
Types of SQL Statements: DDL, DML and DCL
The Basic SQL Query

More Operations

Join
Union
Subqueries
The WITH Clause

Functions

Aggregate Functions with GROUP BY and HAVING
Window Functions
Date and String Functions

Data Science Interview Questions

Tricks and Tips

Connecting to a DB using python + pandas
User segmentation with SQL
Database Index
Optimization examples

Further Resources

Kaggle Learn offers free content with exercises to practice for both beginners and advanced students.
SQLZoo: Free resources for learning with exercises for SQL Server, Oracle, MySQL, DB2, and PostgreSQL.
"How To Write Better SQL Queries: The Definitive Guide" Part 1 and Part 2