Introduction to SQL
Querying relational databases using Python.
22
Getting started with Anaconda Notebooks
Overview and Setup
Connecting to a Database
Pulling Data with SELECT
Expressions and Functions + Exercise
Filtering Data with WHERE
Filtering Text Expressions
Exercise: Filtering data with WHERE
Aggregating and Sorting
Counting Records + Exercise
Nulls, CASE Expressions
The NULL Case Trick + Exercise
INNER JOIN
LEFT JOIN
Exercise: Joins
Subqueries
Common Table Expressions (CTEs) + Exercise
Creating Tables
Creating and Dropping Tables
Transactions + Exercise
Conclusion
End of course survey
