MIT Sloan AI Adoption: Build a Playbook That Drives Real Business ROI
Launch a New Career with Certificates from Google, IBM & Microsoft
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
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
Reviews
4.0 rating, based on 2 Class Central reviews
Showing Class Central Sort
-
The tutorial was excellent and very detailed. Derek Banas explained SQLite3 concepts clearly and covered advanced techniques in a simple and practical way. The examples were easy to follow, and I learned how to create and manage databases effectively. I highly recommend this course for anyone who wants to understand SQLite in depth.
-
Practical and well-structured course; gained confidence in SQLite and real database tasks. Very good