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.
Welcome Screen
Welcome Presentation
Why SQL?
FREE PREVIEWIntroduction to the Platform
FREE PREVIEW0.1 Welcome
FREE PREVIEW0.2 How to use the Actuartech platform
FREE PREVIEW0.3 How to get set up
0.4 A User Guide for Jupyter Notebooks
0.5 Software and package requirements
FREE PREVIEW1.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
2.1 Overview
2.2 Introducing Different Operators
2.3 Aggregating Clauses
2.4 JOINS and UNION
2.5 Summary
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
Additional: Using SQLalchemy and IPythonSQL
CSV Datasets for Chapter 5
References
Additional Resources
Downloadable notebooks and data (zipped)