This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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
SQLite Data Types
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock