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