Foundations in SQL (S1)
Learn the fundamentals of SQL through interactive Jupyter Notebooks, discover basic and complex SQL functionalities, data manipulation, and overall data management tools & techniques. £250 once-off fee for 3 months' access.
0.1 Welcome
FREE PREVIEW0.2 A User Guide for Using Jupyter Notebooks
0.3 Overview of Quizzes, Coding Challenges and Assessments
1.1 Overview
1.2 Introducing SQL
1.3 Main Purposes of SQL
1.4 Understanding the Fundamentals of Databases
1.5 Database Schema
1.6 Basic Concepts
1.7 Example: Using SQL Queries
1.8 Summary
Coding Challenge Week 1
2.1 Overview
2.2 Introducing Different Operators
2.3 Aggregating Clauses
2.4 JOINS and UNION
2.5 Summary
Coding Challenge Week 2
3.1 Overview
3.2 UPDATE a TABLE
3.3 INSERT and DELETE
3.4 Transactions
3.5 Summary
4.1 Overview
4.2 Creating Tables
4.3 Example: Building our own Database
4.4 Summary
5.1 Overview
5.2 User Defined Functions
5.3 User Defined Stored Procedures
5.4 Functions and Procedures: Similarities and Differences
5.5 Summary
6.1 Overview
6.2 Legal, Regulatory, Professional and Ethical Considerations
6.3 Conduct and Governance
6.4 Summary
Blank SQLite Notebook (Optional)*
Additional: Using SQLalchemy and IPythonSQL
CSV Datasets for Chapter 5
References
Additional Resources