Learning SQL with Python
Master database concepts through hands-on lessons covering SQLite, SQL queries, Python integration, and advanced database operations.
Resources
Lesson 1 - Understanding CRUD Operations in DB Browser
Exploring how to use DB Browser's Graphical interface to Create, Read, Update and Delete records in a database of inspiring Computer Science books.
Lesson 2 - Executing SQL Commands in DB Browser
Using SELECT, WHERE, FROM to investigate a database of 80s movies and Rolling Stone Magazine's top 500 albums
Lesson 3 - Executing SQL Commands With Python
Using SELECT, WHERE, FROM in Python to make basic queries, then dynamically by taking user input in order to find the perfect American car.
Lesson 4 - ORDER BY, ASC/DESC and LIMIT
Explore a dataset of world populations produced by the World Bank, and learn how to sort and limit your query results using the ORDER BY and LIMIT clauses.
Lesson 5 - UPDATE and DELETE
Make revisions to the Periodic table as it was in 1900 by using the UPDATE and DELETE keywords.
Lesson 6 - INSERT INTO
Use SQL to create database tables and keep records of student test scores by using the UPDATE keywords.
Lesson 7 - Aggregate Functions
Use functions like SUM, AVG, COUNT, MAX, and MIN to analyse data from a database of sales of mobile phone.
Lesson 8 - JOIN
Combine data from multiple tables using SQL joins
Lesson 9 - Subqueries
Nest SELECT statements to create complex queries