Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQLite For Beginners
Setting Up SQLite Database Environment
Course Introduction (2:08)
What is SQLite (7:32)
Download and Install SQLite (6:40)
What is SQLite Studio (5:50)
Attaching sample database to SQLite (7:16)
How to connect to SQLite Database (7:26)
Basic Database Concepts (9:00)
What is sqlite3 tool (3:10)
Some commonly used sqlite3 command (10:31)
Retrieving and Manipulating Data
SQLite SELECT Statement (5:37)
Querying data from all columns in a table (4:53)
Querying data from specific columns in a table (5:17)
Sorting data using ORDER BY Clause (8:21)
Removing duplicate records (5:29)
Filtering data (6:59)
Identifying NULL Values (4:30)
SQLite Data Types (7:23)
SQLite Aliases (6:03)
Creating Database Tables | Updating Data | Deleting Data
SQLite Constraints (4:21)
SQLite CREATE Table Statement - Part 1 (6:46)
SQLite CREATE Table Statement - Part 2 (7:03)
SQLite INSERT INTO Table Statement (7:43)
SQLite UPDATE Statement (3:47)
SQLite DELETE Statement (2:41)
SQLite DROP Table Statement (1:37)
Some SQLite Operators
SQLite BETWEEN Operator (4:28)
SQLite IN Operator (4:53)
SQLite LIKE Operator (6:51)
SQLite GLOB Operator (5:38)
SQLite LIMIT Clause (5:19)
SQLite Subqueries
What is a Subquery (2:52)
Building a Subquery in a WHERE clause (3:37)
Building a Subquery with WHERE Clause and IN Operator (2:43)
Building a Subquery in FROM clause (2:54)
SQLite Table Joins
SQLite LEFT Join (5:51)
SQLite INNER Join (5:43)
SQLite CROSS Join (5:20)
SQLite SELF Join (7:04)
SQLite Aggregate Functions
Introduction to Aggregate Functions (3:30)
SQLite AVG Function (3:32)
SQLite COUNT Function (4:29)
SQLite SUM Function (2:25)
SQLite MAX Function (1:08)
SQLite MIN Function (2:53)
SQLite GROUP CONCAT Function (1:45)
SQLite GROUP BY Clause
What is SQLite
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login