Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQLite3 Tutorial - Advanced Concepts and Techniques

Derek Banas via YouTube

Start learning Write review
Coursera Ad

Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Start your review of SQLite3 Tutorial - Advanced Concepts and Techniques

  • Profile image for Zamzam Abdallah
    Zamzam Abdallah
    2
    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.
  • Nooreldin Mahmoud
    1
    Practical and well-structured course; gained confidence in SQLite and real database tasks. Very good
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.