Skip to content

This is the repository with teaching material, exercises and solutions for the SQL crash course.

License

Notifications You must be signed in to change notification settings

meiradania/data-science-retreat-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQL Crash Course

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

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

About

This is the repository with teaching material, exercises and solutions for the SQL crash course.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages