Skip to content

MarkWilcock/sql-course

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
.gitignore
.gitignore
 
 
Airport Exercise - Final.sql
Airport Exercise - Final.sql
 
 
Airport Exercise.sql
Airport Exercise.sql
 
 
Brainteaser Exercises - Final.sql
Brainteaser Exercises - Final.sql
 
 
Brainteaser Exercises.sql
Brainteaser Exercises.sql
 
 
Build Inquiry Long.sql
Build Inquiry Long.sql
 
 
CASE Exercise - Final.sql
CASE Exercise - Final.sql
 
 
CASE Exercise.sql
CASE Exercise.sql
 
 
CASE Lesson.sql
CASE Lesson.sql
 
 
CTE Lesson.sql
CTE Lesson.sql
 
 
CTE Subquery Temp Table Comparison - PricePaid data.sql
CTE Subquery Temp Table Comparison - PricePaid data.sql
 
 
Chinook Exercise - Final.sql
Chinook Exercise - Final.sql
 
 
Chinook Exercise.sql
Chinook Exercise.sql
 
 
Combining and Joining Tables Lesson.sql
Combining and Joining Tables Lesson.sql
 
 
Covid Case Exercise - Final.sql
Covid Case Exercise - Final.sql
 
 
Covid Case Exercise.sql
Covid Case Exercise.sql
 
 
Create Objects Exercise - Final.sql
Create Objects Exercise - Final.sql
 
 
Create Objects Exercise.sql
Create Objects Exercise.sql
 
 
Football Exercise - Final.sql
Football Exercise - Final.sql
 
 
Football Exercise.sql
Football Exercise.sql
 
 
Foundation Recap Exercise - Final.sql
Foundation Recap Exercise - Final.sql
 
 
Foundation Recap Exercise.sql
Foundation Recap Exercise.sql
 
 
Foundation SQL Lesson.sql
Foundation SQL Lesson.sql
 
 
Joins Exercise (Chinook Data) - Final.sql
Joins Exercise (Chinook Data) - Final.sql
 
 
Joins Exercise (Chinook Data).sql
Joins Exercise (Chinook Data).sql
 
 
LICENSE
LICENSE
 
 
League Table Case Study.sql
League Table Case Study.sql
 
 
NULLS Exercise - Final.sql
NULLS Exercise - Final.sql
 
 
NULLS Exercise.sql
NULLS Exercise.sql
 
 
NULLs Lesson - Counting NULL Values.sql
NULLs Lesson - Counting NULL Values.sql
 
 
NULLs Lesson.sql
NULLs Lesson.sql
 
 
Oracle Microsoft SQL Differences - Oracle.sql
Oracle Microsoft SQL Differences - Oracle.sql
 
 
Oracle Microsoft SQL Differences.sql
Oracle Microsoft SQL Differences.sql
 
 
Pivot Lesson.sql
Pivot Lesson.sql
 
 
Price Paid Exercise - Final.sql
Price Paid Exercise - Final.sql
 
 
Price Paid Exercise.sql
Price Paid Exercise.sql
 
 
README.md
README.md
 
 
Subqueries - Cambray Road Example.sql
Subqueries - Cambray Road Example.sql
 
 
Subqueries Exercise 1 - Self Contained - Final.sql
Subqueries Exercise 1 - Self Contained - Final.sql
 
 
Subqueries Exercise 1 - Self Contained.sql
Subqueries Exercise 1 - Self Contained.sql
 
 
Subqueries Exercise 2 - Correlated - Final.sql
Subqueries Exercise 2 - Correlated - Final.sql
 
 
Subqueries Exercise 2 - Correlated.sql
Subqueries Exercise 2 - Correlated.sql
 
 
Subqueries Lesson 1 - Self Contained.sql
Subqueries Lesson 1 - Self Contained.sql
 
 
Subqueries Lesson 2 - Correlated.sql
Subqueries Lesson 2 - Correlated.sql
 
 
Subqueries and alternatives (PricePaid data).sql
Subqueries and alternatives (PricePaid data).sql
 
 
Tally Tables Exercise - Final.sql
Tally Tables Exercise - Final.sql
 
 
Tally Tables Exercise.sql
Tally Tables Exercise.sql
 
 
Tally Tables Extended Example.sql
Tally Tables Extended Example.sql
 
 
Tally Tables Lesson.sql
Tally Tables Lesson.sql
 
 
Useful SQL Functions Lesson.sql
Useful SQL Functions Lesson.sql
 
 
Well-performing Queries Lesson.sql
Well-performing Queries Lesson.sql
 
 
Window Functions Lesson.sql
Window Functions Lesson.sql
 
 
_prep_build_airport_freq_data.sql
_prep_build_airport_freq_data.sql
 
 
lesson.sql
lesson.sql
 
 
lesson2.sql
lesson2.sql
 
 

Repository files navigation

sql-course

Materials for SQL training courses

About

Materials for SQL training courses

Resources

Readme

License

MIT license
Activity

Stars

1 star

Watchers

1 watching

Forks

6 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages