|
|
1 - Introduction English.vtt
|
VTT
|
2 KB
|
|
|
1 - Introduction.mp4
|
MP4
|
9 MB
|
|
|
10 - SQLite Dump command English.vtt
|
VTT
|
7.6 KB
|
|
|
10 - SQLite Dump command.mp4
|
MP4
|
48 MB
|
|
|
11 - SQLite SELECT statement English.vtt
|
VTT
|
4.9 KB
|
|
|
11 - SQLite SELECT statement.mp4
|
MP4
|
21 MB
|
|
|
12 - Querying data from all columns in a table English.vtt
|
VTT
|
4.6 KB
|
|
|
12 - Querying data from all columns in a table.mp4
|
MP4
|
22.1 MB
|
|
|
13 - Querying data from specific columns in a table English.vtt
|
VTT
|
4.8 KB
|
|
|
13 - Querying data from specific columns in a table.mp4
|
MP4
|
25.5 MB
|
|
|
14 - Sorting data using ORDER BY clause English.vtt
|
VTT
|
7.4 KB
|
|
|
14 - Sorting data using ORDER BY clause.mp4
|
MP4
|
35.9 MB
|
|
|
15 - Removing duplicate records using DISTINCT clause English.vtt
|
VTT
|
4.8 KB
|
|
|
15 - Removing duplicate records using DISTINCT clause.mp4
|
MP4
|
26.2 MB
|
|
|
16 - Filtering data with WHERE clause English.vtt
|
VTT
|
6.2 KB
|
|
|
16 - Filtering data with WHERE clause.mp4
|
MP4
|
35 MB
|
|
|
17 - Identifying NULL values English.vtt
|
VTT
|
3.5 KB
|
|
|
17 - Identifying NULL values.mp4
|
MP4
|
19.6 MB
|
|
|
18 - SQLite Data Types English.vtt
|
VTT
|
5.5 KB
|
|
|
18 - SQLite Data Types.mp4
|
MP4
|
26.5 MB
|
|
|
19 - SQLite ALiases English.vtt
|
VTT
|
5.8 KB
|
|
|
19 - SQLite ALiases.mp4
|
MP4
|
32.1 MB
|
|
|
2 - What is SQLite English.vtt
|
VTT
|
5.5 KB
|
|
|
2 - What is SQLite.mp4
|
MP4
|
22 MB
|
|
|
20 - SQLite Constraints English.vtt
|
VTT
|
3.8 KB
|
|
|
20 - SQLite Constraints.mp4
|
MP4
|
19.7 MB
|
|
|
21 - SQLite Create Table Statement English.vtt
|
VTT
|
5.7 KB
|
|
|
21 - SQLite Create Table Statement Part 1.mp4
|
MP4
|
29.7 MB
|
|
|
22 - SQLite Create Table Statement English.vtt
|
VTT
|
6.8 KB
|
|
|
22 - SQLite Create Table Statement Part 2.mp4
|
MP4
|
43.5 MB
|
|
|
23 - SQLite INSERT INTO Table Statement English.vtt
|
VTT
|
7.4 KB
|
|
|
23 - SQLite INSERT INTO Table Statement.mp4
|
MP4
|
44.6 MB
|
|
|
24 - SQLite UPDATE Statement English.vtt
|
VTT
|
3.9 KB
|
|
|
24 - SQLite UPDATE Statement.mp4
|
MP4
|
18.3 MB
|
|
|
25 - SQLite DELETE Statement English.vtt
|
VTT
|
2.8 KB
|
|
|
25 - SQLite DELETE Statement.mp4
|
MP4
|
13.7 MB
|
|
|
26 - SQLite DROP Table Statement English.vtt
|
VTT
|
1.5 KB
|
|
|
26 - SQLite DROP Table Statement.mp4
|
MP4
|
7.5 MB
|
|
|
27 - SQLite BETWEEN Operator English.vtt
|
VTT
|
3.8 KB
|
|
|
27 - SQLite BETWEEN Operator.mp4
|
MP4
|
23.2 MB
|
|
|
28 - SQLite IN Operator English.vtt
|
VTT
|
4.1 KB
|
|
|
28 - SQLite IN Operator.mp4
|
MP4
|
28.5 MB
|
|
|
29 - SQLite LIKE operator English.vtt
|
VTT
|
6.1 KB
|
|
|
29 - SQLite LIKE operator.mp4
|
MP4
|
34.7 MB
|
|
|
3 - Download and Install SQLite English.vtt
|
VTT
|
6.3 KB
|
|
|
3 - Download and Install SQLite.mp4
|
MP4
|
45.6 MB
|
|
|
30 - SQLite GLOB Operator English.vtt
|
VTT
|
4.8 KB
|
|
|
30 - SQLite GLOB Operator.mp4
|
MP4
|
29.1 MB
|
|
|
31 - SQLite LIMIT clause English.vtt
|
VTT
|
4.4 KB
|
|
|
31 - SQLite LIMIT clause.mp4
|
MP4
|
31.5 MB
|
|
|
32 - What is a subquery English.vtt
|
VTT
|
2 KB
|
|
|
32 - What is a subquery.mp4
|
MP4
|
12.5 MB
|
|
|
33 - Building a subquery in a WHERE clause English.vtt
|
VTT
|
3.3 KB
|
|
|
33 - Building a subquery in a WHERE clause.mp4
|
MP4
|
22.8 MB
|
|
|
34 - Building a subquery in a WHERE clause using IN operator English.vtt
|
VTT
|
2.1 KB
|
|
|
34 - Building a subquery in a WHERE clause using IN operator.mp4
|
MP4
|
17.4 MB
|
|
|
35 - Building a subquery in FROM clause English.vtt
|
VTT
|
2.4 KB
|
|
|
35 - Building a subquery in FROM clause.mp4
|
MP4
|
14.6 MB
|
|
|
36 - SQLite LEFT Join English.vtt
|
VTT
|
4.8 KB
|
|
|
36 - SQLite LEFT Join.mp4
|
MP4
|
29.2 MB
|
|
|
37 - SQLite INNER Join English.vtt
|
VTT
|
4.9 KB
|
|
|
37 - SQLite INNER Join.mp4
|
MP4
|
31.8 MB
|
|
|
38 - SQLite CROSS Join English.vtt
|
VTT
|
5 KB
|
|
|
38 - SQLite CROSS Join.mp4
|
MP4
|
27.4 MB
|
|
|
39 - SQLite SELF Join English.vtt
|
VTT
|
6.2 KB
|
|
|
39 - SQLite SELF Join.mp4
|
MP4
|
45 MB
|
|
|
4 - What is SQLite Studio English.vtt
|
VTT
|
5.4 KB
|
|
|
4 - What is SQLite Studio.mp4
|
MP4
|
26.1 MB
|
|
|
40 - Introduction to SQLite Aggregate Functions English.vtt
|
VTT
|
2.9 KB
|
|
|
40 - Introduction to SQLite Aggregate Functions.mp4
|
MP4
|
14 MB
|
|
|
41 - SQLite AVG Function English.vtt
|
VTT
|
3.2 KB
|
|
|
41 - SQLite AVG Function.mp4
|
MP4
|
22.5 MB
|
|
|
42 - SQLite COUNT Function English.vtt
|
VTT
|
4.6 KB
|
|
|
42 - SQLite COUNT Function.mp4
|
MP4
|
28.6 MB
|
|
|
43 - SQLIte SUM Function English.vtt
|
VTT
|
2.3 KB
|
|
|
43 - SQLIte SUM Function.mp4
|
MP4
|
14 MB
|
|
|
44 - SQLite MAX Function English.vtt
|
VTT
|
1.1 KB
|
|
|
44 - SQLite MAX Function.mp4
|
MP4
|
6.4 MB
|
|
|
45 - SQLite MIN Function English.vtt
|
VTT
|
2.6 KB
|
|
|
45 - SQLite MIN Function.mp4
|
MP4
|
18.2 MB
|
|
|
46 - SQLite GROUP CONCAT Function English.vtt
|
VTT
|
1.4 KB
|
|
|
46 - SQLite GROUP CONCAT Function.mp4
|
MP4
|
9.2 MB
|
|
|
47 - SQLite GROUP BY Clause English.vtt
|
VTT
|
3.6 KB
|
|
|
47 - SQLite GROUP BY Clause.mp4
|
MP4
|
19.7 MB
|
|
|
48 - SQLite HAVING Clause English.vtt
|
VTT
|
5.8 KB
|
|
|
48 - SQLite HAVING Clause.mp4
|
MP4
|
34.9 MB
|
|
|
49 - Thank You.html
|
HTML
|
307.2 B
|
|
|
5 - Attaching Sample Database to SQLite English.vtt
|
VTT
|
6.1 KB
|
|
|
5 - Attaching Sample Database to SQLite.mp4
|
MP4
|
44.3 MB
|
|
|
5 - dbschema.jpg
|
JPG
|
335.9 KB
|
|
|
6 - How to connect to SQLite Database English.vtt
|
VTT
|
7.1 KB
|
|
|
6 - How to connect to SQLite Database.mp4
|
MP4
|
25.8 MB
|
|
|
7 - Database Concepts English.vtt
|
VTT
|
3.2 KB
|
|
|
7 - Database Concepts.mp4
|
MP4
|
6.3 MB
|
|
|
8 - What is sqlite3 tool English.vtt
|
VTT
|
2.5 KB
|
|
|
8 - What is sqlite3 tool.mp4
|
MP4
|
9.9 MB
|
|
|
9 - Some commonly used sqlite3 commands English.vtt
|
VTT
|
8.9 KB
|
|
|
9 - Some commonly used sqlite3 commands.mp4
|
MP4
|
39.1 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
chinook.db
|
DB
|
864 KB
|