30
Getting started with Anaconda Notebooks
Course Overview and Learning Objectives
Course Materials
SQL and Relational Database Overview
Connecting to a SQLite Database
SQL versus pandas
SELECT, WHERE, and GROUP BY Review
Exercise: SQL Query
Case Expressions
Identifying Null Values
String Operations
UNION, UNION ALL, and CASE Tricks
Exercise: Data Cleaning
Patterns With Subqueries
Derived Tables
Common Table Expressions (CTEs)
Excercise: Common Table Expression
INNER, LEFT, RIGHT, and FULL OUTER JOIN
Temporary Tables
Self Joins and Non-Equal Joins
Cross Joins
Recursive Self Joins
Exercise: Advanced Join
PARTITION BY
ORDER BY
LEAD and LAG
Ranking
Exercise: Analytic Functions
Summary
End of course survey
img