Dive into an extensive SQLite3 tutorial covering advanced topics including ENUMs, composite primary keys, dates, data types, data affinities, various join types (inner, left, natural, cross), ON clauses, GROUP BY statements, nested select statements, views, and triggers. Review key concepts from previous tutorials while exploring new, complex SQLite3 functionalities to enhance your database management skills.
Overview
Syllabus
Introduction
Data Types
Data Diagram
Creating Tables
Inserting Values
Join
Inner Join
Left Join
Natural Join
Best and Worst
Test Scores
Select Statements
Create a View
Triggers
Taught by
Derek Banas
