Foundations in SQL (S1)
Learn the fundamentals of SQL through Notebooks, discover basic and complex SQL functionalities, data manipulation, and overall data management tools & techniques. £325 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