Recap

Applying SQL to Real-World Problems

Dmitriy (Dima) Gorenshteyn

Lead Data Scientist, Memorial Sloan Kettering Cancer Center

Chapter 1 - Use Real-World SQL

 
 

- Essential SQL

- Transforming Your Results

- Working With Aggregate Functions

 
 
 
aggregate visualization

Applying SQL to Real-World Problems

Chapter 2 - Find Your Data

 
 

- Find the Right Table

- Join the Correct Table

- Working With Aggregate Functions

 
 
entity relationship diagram

Applying SQL to Real-World Problems

Chapter 3 - Manage Your Data

 
 

- Store Your Data

- Update Your Data

- Delete Your Data

Applying SQL to Real-World Problems

Chapter 4 - Best Practices for Writing SQL

 
 

- Convey Your Intent

- Write Readable Code

- Avoid Common Mistakes

 
 
smiley face who doesn't care

Applying SQL to Real-World Problems

Congratulations!

Applying SQL to Real-World Problems

Preparing Video For Download...