Basic SQL Statements-Intro to SQL and Relational Databases
Navigating Codio Assignments
Intro to SQL and Relational Databases (Optional Download)
Basic SQL Statements-Data Manipulations from Python
New Reading
Basic SQL Statements-CRUD and Data Types
CRUD and Data Types (Optional Download)
Basic SQL Statements-Coding Exercises
How to Reset an Assignment in Codio
Tables Relations-Tables Relations and Joins
Navigating Codio Assignments
Table Relations and Joins (optional download)
Tables Relations-Diving into SELECT
Diving into SELECT (optional download)
Tables Relations-Extra JOIN Types
Extra JOIN types (optional download)
Tables Relations-Coding Exercises
How to Reset an Assignment in Codio
Tables structure-Creating Tables Structure
Copy of Navigating Codio Assignments
Creating Tables Structure (optional download)
Tables structure-Tables references and alters
New Reading
Tables structure-Indexes, transactions and triggers
Indexes, transactions and triggers (optional download)
Tables structure-Coding Exercises
Copy of How to Reset an Assignment in Codio