|
|
1. About the exercise.mp4
|
MP4
|
8.5 MB
|
|
|
1. About the exercise.srt
|
SRT
|
1.4 KB
|
|
|
1. Create DB and Tables hands-on.mp4
|
MP4
|
27.1 MB
|
|
|
1. Create DB and Tables hands-on.srt
|
SRT
|
8.9 KB
|
|
|
1. Introduction to course.mp4
|
MP4
|
11.6 MB
|
|
|
1. Introduction to course.srt
|
SRT
|
3 KB
|
|
|
1. Joining tables hands-on.mp4
|
MP4
|
35.7 MB
|
|
|
1. Joining tables hands-on.srt
|
SRT
|
8.1 KB
|
|
|
1. Operators IN - NOT IN theory.mp4
|
MP4
|
1.9 MB
|
|
|
1. Operators IN - NOT IN theory.srt
|
SRT
|
614.4 B
|
|
|
1. Ordering theory.mp4
|
MP4
|
7.2 MB
|
|
|
1. Ordering theory.srt
|
SRT
|
2.2 KB
|
|
|
1. Power of Aliases hands-on.mp4
|
MP4
|
27.3 MB
|
|
|
1. Power of Aliases hands-on.srt
|
SRT
|
6.4 KB
|
|
|
1. SQL syntax theory.mp4
|
MP4
|
14.9 MB
|
|
|
1. SQL syntax theory.srt
|
SRT
|
4.1 KB
|
|
|
1. Smallest and Largest Values hands-on.mp4
|
MP4
|
30.8 MB
|
|
|
1. Smallest and Largest Values hands-on.srt
|
SRT
|
8.1 KB
|
|
|
10. Insert data theory.mp4
|
MP4
|
4.7 MB
|
|
|
10. Insert data theory.srt
|
SRT
|
1.7 KB
|
|
|
11. Insert data hands-on.mp4
|
MP4
|
46.9 MB
|
|
|
11. Insert data hands-on.srt
|
SRT
|
6.9 KB
|
|
|
12. NULL OP Theory.mp4
|
MP4
|
4.2 MB
|
|
|
12. NULL OP Theory.srt
|
SRT
|
2.4 KB
|
|
|
13. NULL and Not OP hands-on.mp4
|
MP4
|
33.3 MB
|
|
|
13. NULL and Not OP hands-on.srt
|
SRT
|
6.2 KB
|
|
|
14. Updating data records theory.mp4
|
MP4
|
5.8 MB
|
|
|
14. Updating data records theory.srt
|
SRT
|
2.2 KB
|
|
|
15. Updating data records hands-on.mp4
|
MP4
|
41.7 MB
|
|
|
15. Updating data records hands-on.srt
|
SRT
|
7.5 KB
|
|
|
16. Deleting data theory.mp4
|
MP4
|
4.1 MB
|
|
|
16. Deleting data theory.srt
|
SRT
|
2 KB
|
|
|
17. Deleting data hands-on.mp4
|
MP4
|
22.7 MB
|
|
|
17. Deleting data hands-on.srt
|
SRT
|
5.4 KB
|
|
|
2. Combining result-sets hands-on.mp4
|
MP4
|
34.1 MB
|
|
|
2. Combining result-sets hands-on.srt
|
SRT
|
6.8 KB
|
|
|
2. Counting records with different ways hands-on.mp4
|
MP4
|
20.6 MB
|
|
|
2. Counting records with different ways hands-on.srt
|
SRT
|
3.9 KB
|
|
|
2. Deleting newOrders hands-on.mp4
|
MP4
|
10.9 MB
|
|
|
2. Deleting newOrders hands-on.srt
|
SRT
|
4.2 KB
|
|
|
2. Exercise solution.mp4
|
MP4
|
20.3 MB
|
|
|
2. Exercise solution.srt
|
SRT
|
4.9 KB
|
|
|
2. Operators - IN and Not IN.mp4
|
MP4
|
16.9 MB
|
|
|
2. Operators - IN and Not IN.srt
|
SRT
|
4 KB
|
|
|
2. Ordering and sorting hands-on.mp4
|
MP4
|
51 MB
|
|
|
2. Ordering and sorting hands-on.srt
|
SRT
|
8.5 KB
|
|
|
2. SELECT Statement theory.mp4
|
MP4
|
6.4 MB
|
|
|
2. SELECT Statement theory.srt
|
SRT
|
2.4 KB
|
|
|
2. Set conditions hands-on.mp4
|
MP4
|
28.2 MB
|
|
|
2. Set conditions hands-on.srt
|
SRT
|
4.4 KB
|
|
|
2. The course goals.mp4
|
MP4
|
13.8 MB
|
|
|
2. The course goals.srt
|
SRT
|
4 KB
|
|
|
3. ALTER ADD OR DELETE fields hands-on.mp4
|
MP4
|
13.4 MB
|
|
|
3. ALTER ADD OR DELETE fields hands-on.srt
|
SRT
|
3.4 KB
|
|
|
3. Average of numeric columns hands-on.mp4
|
MP4
|
19.9 MB
|
|
|
3. Average of numeric columns hands-on.srt
|
SRT
|
3.9 KB
|
|
|
3. LIMIT with condition hands-on.mp4
|
MP4
|
28.4 MB
|
|
|
3. LIMIT with condition hands-on.srt
|
SRT
|
6 KB
|
|
|
3. SELECT Statement hands-on.mp4
|
MP4
|
23.2 MB
|
|
|
3. SELECT Statement hands-on.srt
|
SRT
|
6.8 KB
|
|
|
3. SQL Logical Operators theory.mp4
|
MP4
|
5.5 MB
|
|
|
3. SQL Logical Operators theory.srt
|
SRT
|
1.8 KB
|
|
|
3. The course requirements.mp4
|
MP4
|
1.9 MB
|
|
|
3. The course requirements.srt
|
SRT
|
819.2 B
|
|
|
4. Operators- Logical op hands-on.mp4
|
MP4
|
63.3 MB
|
|
|
4. Operators- Logical op hands-on.srt
|
SRT
|
10.5 KB
|
|
|
4. Renaming tables hands-on.mp4
|
MP4
|
15 MB
|
|
|
4. Renaming tables hands-on.srt
|
SRT
|
3.6 KB
|
|
|
4. SELECT DISTINCT Theory.mp4
|
MP4
|
3.8 MB
|
|
|
4. SELECT DISTINCT Theory.srt
|
SRT
|
1.4 KB
|
|
|
4. Total sum for numerics hands-on.mp4
|
MP4
|
18.1 MB
|
|
|
4. Total sum for numerics hands-on.srt
|
SRT
|
3.6 KB
|
|
|
4. Who is this course for.mp4
|
MP4
|
4.1 MB
|
|
|
4. Who is this course for.srt
|
SRT
|
1.5 KB
|
|
|
5. Constraints theory.mp4
|
MP4
|
7 MB
|
|
|
5. Constraints theory.srt
|
SRT
|
2.6 KB
|
|
|
5. Operators - Arithmetic op hands-on.mp4
|
MP4
|
24.6 MB
|
|
|
5. Operators - Arithmetic op hands-on.srt
|
SRT
|
5.4 KB
|
|
|
5. SELECT DISTINCT hands-on.mp4
|
MP4
|
29.6 MB
|
|
|
5. SELECT DISTINCT hands-on.srt
|
SRT
|
5.6 KB
|
|
|
5. SQL quick intro.mp4
|
MP4
|
6.9 MB
|
|
|
5. SQL quick intro.srt
|
SRT
|
2 KB
|
|
|
6. Constraints hands-on.mp4
|
MP4
|
24.9 MB
|
|
|
6. Constraints hands-on.srt
|
SRT
|
4 KB
|
|
|
6. Installing the working environment DB Manager.mp4
|
MP4
|
23 MB
|
|
|
6. Installing the working environment DB Manager.srt
|
SRT
|
6.9 KB
|
|
|
6. Operators - Comparisons hands-on.mp4
|
MP4
|
44.3 MB
|
|
|
6. Operators - Comparisons hands-on.srt
|
SRT
|
7.9 KB
|
|
|
6. WHERE Statement theory.mp4
|
MP4
|
4.5 MB
|
|
|
6. WHERE Statement theory.srt
|
SRT
|
2 KB
|
|
|
7. Operators- SQL BETWEEN and NOT hands-on.mp4
|
MP4
|
36.4 MB
|
|
|
7. Operators- SQL BETWEEN and NOT hands-on.srt
|
SRT
|
7.5 KB
|
|
|
7. WHERE Statement hands-on.mp4
|
MP4
|
35 MB
|
|
|
7. WHERE Statement hands-on.srt
|
SRT
|
6 KB
|
|
|
8. Count rows theory.mp4
|
MP4
|
4.9 MB
|
|
|
8. Count rows theory.srt
|
SRT
|
1.9 KB
|
|
|
8. SQL Data Types.mp4
|
MP4
|
5 MB
|
|
|
8. SQL Data Types.srt
|
SRT
|
1.9 KB
|
|
|
9. Count rows hands-on.mp4
|
MP4
|
22.9 MB
|
|
|
9. Count rows hands-on.srt
|
SRT
|
6 KB
|
|
|
Exercise+files (1).zip
|
ZIP
|
4.3 KB
|
|
|
Exercise+files (2).zip
|
ZIP
|
4.3 KB
|
|
|
Exercise+files.zip
|
ZIP
|
4.3 KB
|
|
|
[CourseClub.Me].url
|
URL
|
102.4 B
|
|
|
[GigaCourse.Com].url
|
URL
|
0 B
|
