|
|
1 - Databases Theory Quiz.html
|
HTML
|
0 B
|
|
|
1 - Introduction English.vtt
|
VTT
|
3.9 KB
|
|
|
1 - Introduction.mp4
|
MP4
|
12.4 MB
|
|
|
10 - Creating databases English.vtt
|
VTT
|
4.2 KB
|
|
|
10 - Creating databases.mp4
|
MP4
|
14 MB
|
|
|
10 - Indexes Quiz.html
|
HTML
|
0 B
|
|
|
100 - Transaction example English.vtt
|
VTT
|
6 KB
|
|
|
100 - Transaction example SAVEPOINT.mp4
|
MP4
|
11.3 MB
|
|
|
101 - CODE savepoint.html
|
HTML
|
307.2 B
|
|
|
102 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
102 - transactions.pdf
|
PDF
|
328.6 KB
|
|
|
103 - What are views English.vtt
|
VTT
|
5.7 KB
|
|
|
103 - What are views.mp4
|
MP4
|
17.5 MB
|
|
|
104 - Views example English.vtt
|
VTT
|
1.8 KB
|
|
|
104 - Views example initialize database.mp4
|
MP4
|
3 MB
|
|
|
105 - Views example English.vtt
|
VTT
|
3.7 KB
|
|
|
105 - Views example create views.mp4
|
MP4
|
7.7 MB
|
|
|
106 - CODE creating views.html
|
HTML
|
102.4 B
|
|
|
107 - Views example English.vtt
|
VTT
|
3.1 KB
|
|
|
107 - Views example update views.mp4
|
MP4
|
5.9 MB
|
|
|
108 - Views example English.vtt
|
VTT
|
1.1 KB
|
|
|
108 - Views example dropping views.mp4
|
MP4
|
1.8 MB
|
|
|
109 - CODE update and drop views.html
|
HTML
|
307.2 B
|
|
|
11 - CODE creating databases.html
|
HTML
|
512 B
|
|
|
11 - Database Data Structures Quiz.html
|
HTML
|
0 B
|
|
|
110 - Exercise.html
|
HTML
|
409.6 B
|
|
|
111 - Solution.html
|
HTML
|
204.8 B
|
|
|
112 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
112 - views.pdf
|
PDF
|
324.8 KB
|
|
|
113 - What are indexes English.vtt
|
VTT
|
15.1 KB
|
|
|
113 - What are indexes.mp4
|
MP4
|
49.1 MB
|
|
|
114 - Indexes example English.vtt
|
VTT
|
5.1 KB
|
|
|
114 - Indexes example.mp4
|
MP4
|
9.3 MB
|
|
|
115 - Constraints introduction English.vtt
|
VTT
|
2.9 KB
|
|
|
115 - Constraints introduction.mp4
|
MP4
|
6.7 MB
|
|
|
116 - Primary keys English.vtt
|
VTT
|
3.3 KB
|
|
|
116 - Primary keys.mp4
|
MP4
|
5.9 MB
|
|
|
117 - Unique constraints English.vtt
|
VTT
|
3 KB
|
|
|
117 - Unique constraints.mp4
|
MP4
|
5.6 MB
|
|
|
118 - Check constraints English.vtt
|
VTT
|
7.3 KB
|
|
|
118 - Check constraints.mp4
|
MP4
|
28 MB
|
|
|
119 - What is bitmap indexing English.vtt
|
VTT
|
13.8 KB
|
|
|
119 - What is bitmap indexing.mp4
|
MP4
|
37.1 MB
|
|
|
12 - Creating a table English.vtt
|
VTT
|
5.2 KB
|
|
|
12 - Creating a table.mp4
|
MP4
|
19.1 MB
|
|
|
12 - Stored Procedures Quiz.html
|
HTML
|
0 B
|
|
|
120 - External memory and paging English.vtt
|
VTT
|
9.4 KB
|
|
|
120 - External memory and paging.mp4
|
MP4
|
35 MB
|
|
|
121 - B tree data structures English.vtt
|
VTT
|
9.9 KB
|
|
|
121 - B tree data structures.mp4
|
MP4
|
27.9 MB
|
|
|
122 - Using B trees English.vtt
|
VTT
|
7.2 KB
|
|
|
122 - Using B trees.mp4
|
MP4
|
18.2 MB
|
|
|
123 - What are stored procedures English.vtt
|
VTT
|
6.9 KB
|
|
|
123 - What are stored procedures.mp4
|
MP4
|
26 MB
|
|
|
124 - Creating our first stored procedure English.vtt
|
VTT
|
6.3 KB
|
|
|
124 - Creating our first stored procedure.mp4
|
MP4
|
28.2 MB
|
|
|
125 - CODE first stored procedure.html
|
HTML
|
102.4 B
|
|
|
126 - Listing and removing stored procedures English.vtt
|
VTT
|
3.6 KB
|
|
|
126 - Listing and removing stored procedures.mp4
|
MP4
|
21.3 MB
|
|
|
127 - CODE listing and removing stored procedures.html
|
HTML
|
204.8 B
|
|
|
128 - Variables English.vtt
|
VTT
|
5.4 KB
|
|
|
128 - Variables.mp4
|
MP4
|
18 MB
|
|
|
129 - Exercise.html
|
HTML
|
307.2 B
|
|
|
13 - CODE creating database tables.html
|
HTML
|
819.2 B
|
|
|
130 - Solution.html
|
HTML
|
307.2 B
|
|
|
131 - Session variables English.vtt
|
VTT
|
3.5 KB
|
|
|
131 - Session variables.mp4
|
MP4
|
11.4 MB
|
|
|
132 - Parameters English.vtt
|
VTT
|
8 KB
|
|
|
132 - Parameters.mp4
|
MP4
|
31 MB
|
|
|
133 - CODE parameters.html
|
HTML
|
307.2 B
|
|
|
134 - Exercise.html
|
HTML
|
409.6 B
|
|
|
135 - Solution.html
|
HTML
|
307.2 B
|
|
|
136 - Conditional statements English.vtt
|
VTT
|
8.7 KB
|
|
|
136 - Conditional statements.mp4
|
MP4
|
46.4 MB
|
|
|
137 - CODE conditional statements.html
|
HTML
|
307.2 B
|
|
|
138 - Loops English.vtt
|
VTT
|
9.3 KB
|
|
|
138 - Loops.mp4
|
MP4
|
35.9 MB
|
|
|
139 - ITERATE English.vtt
|
VTT
|
2.8 KB
|
|
|
139 - ITERATE.mp4
|
MP4
|
11.6 MB
|
|
|
14 - Inserting into a table English.vtt
|
VTT
|
5.7 KB
|
|
|
14 - Inserting into a table.mp4
|
MP4
|
23.8 MB
|
|
|
140 - WHILE English.vtt
|
VTT
|
4.7 KB
|
|
|
140 - WHILE.mp4
|
MP4
|
17.4 MB
|
|
|
141 - CODE loops.html
|
HTML
|
307.2 B
|
|
|
142 - Returning multiple values English.vtt
|
VTT
|
4.4 KB
|
|
|
142 - Returning multiple values.mp4
|
MP4
|
21.6 MB
|
|
|
143 - CODE returning multiple values.html
|
HTML
|
409.6 B
|
|
|
144 - Course materials.html
|
HTML
|
102.4 B
|
|
|
15 - Inserting multiple items in one statement English.vtt
|
VTT
|
1.7 KB
|
|
|
15 - Inserting multiple items in one statement.mp4
|
MP4
|
5.9 MB
|
|
|
16 - CODE inserting into tables.html
|
HTML
|
819.2 B
|
|
|
17 - Delete row from a table English.vtt
|
VTT
|
5.2 KB
|
|
|
17 - Delete row from a table.mp4
|
MP4
|
24.3 MB
|
|
|
18 - CODE delete row.html
|
HTML
|
204.8 B
|
|
|
19 - Updating a row English.vtt
|
VTT
|
2.7 KB
|
|
|
19 - Updating a row.mp4
|
MP4
|
10.5 MB
|
|
|
2 - Installing SQL and MySQL on Windows.html
|
HTML
|
1.1 KB
|
|
|
2 - Table Manipulation Quiz.html
|
HTML
|
0 B
|
|
|
20 - CODE updating rows.html
|
HTML
|
409.6 B
|
|
|
21 - Changing table structure English.vtt
|
VTT
|
4.1 KB
|
|
|
21 - Changing table structure.mp4
|
MP4
|
18.4 MB
|
|
|
22 - CODE change table structure.html
|
HTML
|
716.8 B
|
|
|
23 - Drop tables English.vtt
|
VTT
|
2.3 KB
|
|
|
23 - Drop tables.mp4
|
MP4
|
3.7 MB
|
|
|
24 - What are primary keys English.vtt
|
VTT
|
6.8 KB
|
|
|
24 - What are primary keys.mp4
|
MP4
|
26.8 MB
|
|
|
25 - The auto increment feature English.vtt
|
VTT
|
4.8 KB
|
|
|
25 - The auto increment feature.mp4
|
MP4
|
22.4 MB
|
|
|
26 - CODE auto incremented primary keys.html
|
HTML
|
614.4 B
|
|
|
27 - Enums English.vtt
|
VTT
|
4.7 KB
|
|
|
27 - Enums.mp4
|
MP4
|
24 MB
|
|
|
28 - Booleans English.vtt
|
VTT
|
6.1 KB
|
|
|
28 - Booleans.mp4
|
MP4
|
30.7 MB
|
|
|
29 - Floating point numbers with decimals English.vtt
|
VTT
|
6.2 KB
|
|
|
29 - Floating point numbers with decimals.mp4
|
MP4
|
29.5 MB
|
|
|
3 - Basic SQL Quiz.html
|
HTML
|
0 B
|
|
|
3 - Installing SQL and MySQL on Mac.html
|
HTML
|
1.1 KB
|
|
|
30 - Dates English.vtt
|
VTT
|
4.9 KB
|
|
|
30 - Dates.mp4
|
MP4
|
17.4 MB
|
|
|
31 - Exercise.html
|
HTML
|
1 KB
|
|
|
32 - Solution English.vtt
|
VTT
|
6.2 KB
|
|
|
32 - Solution.mp4
|
MP4
|
32.4 MB
|
|
|
33 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
33 - tablemanipulation.pdf
|
PDF
|
338.3 KB
|
|
|
34 - SQL dump English.vtt
|
VTT
|
5.8 KB
|
|
|
34 - SQL dump the city and country tables.mp4
|
MP4
|
52 MB
|
|
|
35 - SELECT English.vtt
|
VTT
|
4.4 KB
|
|
|
35 - SELECT.mp4
|
MP4
|
29.1 MB
|
|
|
36 - WHERE English.vtt
|
VTT
|
3.3 KB
|
|
|
36 - WHERE.mp4
|
MP4
|
17.3 MB
|
|
|
37 - IN English.vtt
|
VTT
|
2.8 KB
|
|
|
37 - IN.mp4
|
MP4
|
8.7 MB
|
|
|
38 - BETWEEN English.vtt
|
VTT
|
3.4 KB
|
|
|
38 - BETWEEN.mp4
|
MP4
|
7.7 MB
|
|
|
39 - NOT English.vtt
|
VTT
|
2 KB
|
|
|
39 - NOT negation in SQL.mp4
|
MP4
|
4.5 MB
|
|
|
4 - Multiple Tables Quiz.html
|
HTML
|
0 B
|
|
|
4 - What are databases and database management systems DBMS English.vtt
|
VTT
|
6.6 KB
|
|
|
4 - What are databases and database management systems DBMS.mp4
|
MP4
|
19.9 MB
|
|
|
40 - Logical operators English.vtt
|
VTT
|
3.7 KB
|
|
|
40 - Logical operators.mp4
|
MP4
|
8 MB
|
|
|
41 - Wildcards English.vtt
|
VTT
|
3.6 KB
|
|
|
41 - Wildcards.mp4
|
MP4
|
9.2 MB
|
|
|
42 - Functions English.vtt
|
VTT
|
6 KB
|
|
|
42 - Functions.mp4
|
MP4
|
11.8 MB
|
|
|
43 - ORDER BY English.vtt
|
VTT
|
4.9 KB
|
|
|
43 - ORDER BY.mp4
|
MP4
|
13.7 MB
|
|
|
44 - Code order by.html
|
HTML
|
204.8 B
|
|
|
45 - GROUP BY English.vtt
|
VTT
|
3.2 KB
|
|
|
45 - GROUP BY.mp4
|
MP4
|
6.2 MB
|
|
|
46 - CODE group by.html
|
HTML
|
307.2 B
|
|
|
47 - Exercise.html
|
HTML
|
307.2 B
|
|
|
48 - Solution English.vtt
|
VTT
|
2.7 KB
|
|
|
48 - Solution.mp4
|
MP4
|
5.1 MB
|
|
|
49 - HAVING English.vtt
|
VTT
|
3 KB
|
|
|
49 - HAVING.mp4
|
MP4
|
6.4 MB
|
|
|
5 - Database Normalization Quiz.html
|
HTML
|
0 B
|
|
|
5 - The relational model English.vtt
|
VTT
|
5.8 KB
|
|
|
5 - The relational model.mp4
|
MP4
|
14.7 MB
|
|
|
50 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
50 - basicsql.pdf
|
PDF
|
345 KB
|
|
|
51 - What is a foreign key English.vtt
|
VTT
|
3.4 KB
|
|
|
51 - What is a foreign key.mp4
|
MP4
|
11.5 MB
|
|
|
52 - Foreign key example English.vtt
|
VTT
|
6.7 KB
|
|
|
52 - Foreign key example.mp4
|
MP4
|
29.4 MB
|
|
|
53 - CODE foreign keys.html
|
HTML
|
716.8 B
|
|
|
54 - How to handle changes when dealing with multiple tables English.vtt
|
VTT
|
6.1 KB
|
|
|
54 - How to handle changes when dealing with multiple tables.mp4
|
MP4
|
21.1 MB
|
|
|
55 - Updating dependent tables example English.vtt
|
VTT
|
8.9 KB
|
|
|
55 - Updating dependent tables example.mp4
|
MP4
|
42 MB
|
|
|
56 - CODE updating tables.html
|
HTML
|
716.8 B
|
|
|
57 - Exercise.html
|
HTML
|
1.4 KB
|
|
|
58 - Solution.html
|
HTML
|
716.8 B
|
|
|
59 - What is database normalization English.vtt
|
VTT
|
4.7 KB
|
|
|
59 - What is database normalization.mp4
|
MP4
|
12.3 MB
|
|
|
6 - Data structures behind database servers English.vtt
|
VTT
|
9.6 KB
|
|
|
6 - Data structures behind database servers.mp4
|
MP4
|
31.5 MB
|
|
|
6 - Joining Tables Quiz.html
|
HTML
|
0 B
|
|
|
60 - The first normal form English.vtt
|
VTT
|
4.4 KB
|
|
|
60 - The first normal form.mp4
|
MP4
|
14.6 MB
|
|
|
61 - The second normal form English.vtt
|
VTT
|
5.6 KB
|
|
|
61 - The second normal form.mp4
|
MP4
|
18.8 MB
|
|
|
62 - The third normal form English.vtt
|
VTT
|
4.1 KB
|
|
|
62 - The third normal form.mp4
|
MP4
|
13 MB
|
|
|
63 - Configuring the database tables English.vtt
|
VTT
|
3 KB
|
|
|
63 - Configuring the database tables PERSON and UNIVERSITY.mp4
|
MP4
|
5.6 MB
|
|
|
64 - Inner join introduction English.vtt
|
VTT
|
6.7 KB
|
|
|
64 - Inner join introduction.mp4
|
MP4
|
14.7 MB
|
|
|
65 - Inner join example English.vtt
|
VTT
|
5.2 KB
|
|
|
65 - Inner join example.mp4
|
MP4
|
23.8 MB
|
|
|
66 - CODE inner join.html
|
HTML
|
512 B
|
|
|
67 - Left join introduction English.vtt
|
VTT
|
4.2 KB
|
|
|
67 - Left join introduction.mp4
|
MP4
|
10.4 MB
|
|
|
68 - Left join example English.vtt
|
VTT
|
2.6 KB
|
|
|
68 - Left join example.mp4
|
MP4
|
12.7 MB
|
|
|
69 - CODE left join.html
|
HTML
|
204.8 B
|
|
|
7 - Procedural and non English.vtt
|
VTT
|
4.4 KB
|
|
|
7 - Procedural and nonprocedural languages.mp4
|
MP4
|
13.9 MB
|
|
|
7 - Subqueries Quiz.html
|
HTML
|
0 B
|
|
|
70 - Right join introduction English.vtt
|
VTT
|
3.1 KB
|
|
|
70 - Right join introduction.mp4
|
MP4
|
7.7 MB
|
|
|
71 - Right join example English.vtt
|
VTT
|
1.5 KB
|
|
|
71 - Right join example.mp4
|
MP4
|
2.7 MB
|
|
|
72 - CODE right join.html
|
HTML
|
204.8 B
|
|
|
73 - JOIN example English.vtt
|
VTT
|
5.3 KB
|
|
|
73 - JOIN example number of cities.mp4
|
MP4
|
11.1 MB
|
|
|
74 - CODE joining cities.html
|
HTML
|
409.6 B
|
|
|
75 - Exercise.html
|
HTML
|
204.8 B
|
|
|
76 - Solution English.vtt
|
VTT
|
3.3 KB
|
|
|
76 - Solution.mp4
|
MP4
|
7.2 MB
|
|
|
77 - Online SQL console English.vtt
|
VTT
|
1.1 KB
|
|
|
77 - Online SQL console.mp4
|
MP4
|
2.2 MB
|
|
|
78 - JOIN example English.vtt
|
VTT
|
3.1 KB
|
|
|
78 - JOIN example customers and orders.mp4
|
MP4
|
5.7 MB
|
|
|
79 - JOIN example English.vtt
|
VTT
|
3.5 KB
|
|
|
79 - JOIN example number of orders by customers.mp4
|
MP4
|
6.5 MB
|
|
|
8 - Transactions Quiz.html
|
HTML
|
0 B
|
|
|
8 - Types of DBMS and database languages English.vtt
|
VTT
|
5.6 KB
|
|
|
8 - Types of DBMS and database languages.mp4
|
MP4
|
21 MB
|
|
|
80 - JOIN example English.vtt
|
VTT
|
2 KB
|
|
|
80 - JOIN example number of orders by country.mp4
|
MP4
|
3.9 MB
|
|
|
81 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
81 - JOIN.pdf
|
PDF
|
334.8 KB
|
|
|
82 - What are subqueries English.vtt
|
VTT
|
8.5 KB
|
|
|
82 - What are subqueries.mp4
|
MP4
|
30.3 MB
|
|
|
83 - Non English.vtt
|
VTT
|
2.2 KB
|
|
|
83 - Noncorrelated scalar subquery.mp4
|
MP4
|
4.5 MB
|
|
|
84 - CODE scalar subquery.html
|
HTML
|
102.4 B
|
|
|
85 - Non English.vtt
|
VTT
|
3 KB
|
|
|
85 - Noncorrelated multiplerow subquery.mp4
|
MP4
|
5.8 MB
|
|
|
86 - CODE multiple row subquery.html
|
HTML
|
102.4 B
|
|
|
87 - Correlated subquery English.vtt
|
VTT
|
2.9 KB
|
|
|
87 - Correlated subquery.mp4
|
MP4
|
5.9 MB
|
|
|
88 - CODE correlated subquery.html
|
HTML
|
204.8 B
|
|
|
89 - Subqueries and joins English.vtt
|
VTT
|
1.6 KB
|
|
|
89 - Subqueries and joins.mp4
|
MP4
|
4.5 MB
|
|
|
9 - Data types English.vtt
|
VTT
|
11 KB
|
|
|
9 - Data types.mp4
|
MP4
|
43.7 MB
|
|
|
9 - Views Quiz.html
|
HTML
|
0 B
|
|
|
90 - Transforming subquery into join English.vtt
|
VTT
|
2.9 KB
|
|
|
90 - Transforming subquery into join.mp4
|
MP4
|
6.3 MB
|
|
|
91 - CODE subquery and join.html
|
HTML
|
307.2 B
|
|
|
92 - Chapter summary & source code.html
|
HTML
|
102.4 B
|
|
|
92 - subqueies.pdf
|
PDF
|
328 KB
|
|
|
93 - Transactions introduction English.vtt
|
VTT
|
12.7 KB
|
|
|
93 - Transactions introduction locking.mp4
|
MP4
|
45.5 MB
|
|
|
94 - Transactions introduction English.vtt
|
VTT
|
5.3 KB
|
|
|
94 - Transactions introduction transactions.mp4
|
MP4
|
18.8 MB
|
|
|
95 - What are the ACID principles English.vtt
|
VTT
|
4.5 KB
|
|
|
95 - What are the ACID principles.mp4
|
MP4
|
14.6 MB
|
|
|
96 - Transaction example COMMIT.mp4
|
MP4
|
8.8 MB
|
|
|
96 - Transaction example English.vtt
|
VTT
|
5 KB
|
|
|
97 - CODE commit.html
|
HTML
|
204.8 B
|
|
|
98 - Transaction example English.vtt
|
VTT
|
2.9 KB
|
|
|
98 - Transaction example ROLLBACK.mp4
|
MP4
|
5.3 MB
|
|
|
99 - CODE rollback.html
|
HTML
|
204.8 B
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
country_city.txt
|
TXT
|
638.4 KB
|
|
|
sql_database.pptx
|
PPTX
|
695.9 KB
|
|
|
students_university.txt
|
TXT
|
1.6 KB
|
