|
|
1. AS.mp4
|
MP4
|
25.6 MB
|
|
|
1. AS.srt
|
SRT
|
4.9 KB
|
|
|
1. CASE WHEN.mp4
|
MP4
|
28.5 MB
|
|
|
1. CASE WHEN.srt
|
SRT
|
6.6 KB
|
|
|
1. CEIL & FLOOR.mp4
|
MP4
|
21 MB
|
|
|
1. CEIL & FLOOR.srt
|
SRT
|
4.8 KB
|
|
|
1. COUNT.mp4
|
MP4
|
38.3 MB
|
|
|
1. COUNT.srt
|
SRT
|
6.8 KB
|
|
|
1. CREATE.mp4
|
MP4
|
63.8 MB
|
|
|
1. CREATE.srt
|
SRT
|
16.2 KB
|
|
|
1. CURRENT DATE & TIME.mp4
|
MP4
|
32.3 MB
|
|
|
1. CURRENT DATE & TIME.srt
|
SRT
|
6.3 KB
|
|
|
1. Case Study Part 1.mp4
|
MP4
|
28 MB
|
|
|
1. Case Study Part 1.srt
|
SRT
|
6.1 KB
|
|
|
1. Converting Numbers Date to String.mp4
|
MP4
|
73.2 MB
|
|
|
1. Converting Numbers Date to String.srt
|
SRT
|
13.1 KB
|
|
|
1. Course Overview.mp4
|
MP4
|
29.3 MB
|
|
|
1. Course Overview.srt
|
SRT
|
7.4 KB
|
|
|
1. GROUP BY.mp4
|
MP4
|
93.3 MB
|
|
|
1. GROUP BY.srt
|
SRT
|
13.8 KB
|
|
|
1. IN.mp4
|
MP4
|
29.4 MB
|
|
|
1. IN.srt
|
SRT
|
5.3 KB
|
|
|
1. Introduction to Joins.mp4
|
MP4
|
7.9 MB
|
|
|
1. Introduction to Joins.srt
|
SRT
|
3 KB
|
|
|
1. LENGTH.mp4
|
MP4
|
18.6 MB
|
|
|
1. LENGTH.srt
|
SRT
|
4.6 KB
|
|
|
1. PATTERN MATCHING BASICS.mp4
|
MP4
|
40.9 MB
|
|
|
1. PATTERN MATCHING BASICS.srt
|
SRT
|
11.2 KB
|
|
|
1. Restore and Back-up.mp4
|
MP4
|
72.1 MB
|
|
|
1. Restore and Back-up.srt
|
SRT
|
9.8 KB
|
|
|
1. Side Lecture Commenting in SQL.mp4
|
MP4
|
12.3 MB
|
|
|
1. Side Lecture Commenting in SQL.srt
|
SRT
|
2 KB
|
|
|
1. Subqueries.mp4
|
MP4
|
103.9 MB
|
|
|
1. Subqueries.srt
|
SRT
|
19.4 KB
|
|
|
1. TIP 1 (EXPLAIN).mp4
|
MP4
|
25.5 MB
|
|
|
1. TIP 1 (EXPLAIN).srt
|
SRT
|
4.2 KB
|
|
|
1. Tablespace.mp4
|
MP4
|
36.3 MB
|
|
|
1. Tablespace.srt
|
SRT
|
7.1 KB
|
|
|
1. This is a milestone!.mp4
|
MP4
|
20.7 MB
|
|
|
1. This is a milestone!.srt
|
SRT
|
3.8 KB
|
|
|
1. User Access Control.mp4
|
MP4
|
80.5 MB
|
|
|
1. User Access Control.srt
|
SRT
|
16.2 KB
|
|
|
1. VIEWS.mp4
|
MP4
|
42.5 MB
|
|
|
1. VIEWS.srt
|
SRT
|
9.7 KB
|
|
|
1. What is SQL.mp4
|
MP4
|
10.8 MB
|
|
|
1. What is SQL.srt
|
SRT
|
3 KB
|
|
|
10. Except.mp4
|
MP4
|
12.7 MB
|
|
|
10. Except.srt
|
SRT
|
3.3 KB
|
|
|
10. Exercise 3 SELECT & WHERE.mp4
|
MP4
|
7.2 MB
|
|
|
10. Exercise 3 SELECT & WHERE.srt
|
SRT
|
2 KB
|
|
|
11. UPDATE.mp4
|
MP4
|
37.7 MB
|
|
|
11. UPDATE.srt
|
SRT
|
5.6 KB
|
|
|
11. Union.mp4
|
MP4
|
15.1 MB
|
|
|
11. Union.srt
|
SRT
|
3.3 KB
|
|
|
12. DELETE.mp4
|
MP4
|
29.2 MB
|
|
|
12. DELETE.srt
|
SRT
|
5.4 KB
|
|
|
12. Exercise 10 Joins.mp4
|
MP4
|
6.9 MB
|
|
|
12. Exercise 10 Joins.srt
|
SRT
|
1.7 KB
|
|
|
13. ALTER.mp4
|
MP4
|
125.8 MB
|
|
|
13. ALTER.srt
|
SRT
|
19.4 KB
|
|
|
14. Exercise 4 Updating Table.mp4
|
MP4
|
3.9 MB
|
|
|
14. Exercise 4 Updating Table.srt
|
SRT
|
1.5 KB
|
|
|
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
|
MP4
|
103.1 MB
|
|
|
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt
|
SRT
|
18.5 KB
|
|
|
2. AGE.mp4
|
MP4
|
26.6 MB
|
|
|
2. AGE.srt
|
SRT
|
4.2 KB
|
|
|
2. BETWEEN.mp4
|
MP4
|
49.7 MB
|
|
|
2. BETWEEN.srt
|
SRT
|
6.5 KB
|
|
|
2. Case Study Part 2.mp4
|
MP4
|
51.2 MB
|
|
|
2. Case Study Part 2.srt
|
SRT
|
8.7 KB
|
|
|
2. Concepts of Joining and Combining Data.mp4
|
MP4
|
59.8 MB
|
|
|
2. Concepts of Joining and Combining Data.srt
|
SRT
|
13 KB
|
|
|
2. Converting String to Numbers Date.mp4
|
MP4
|
39.1 MB
|
|
|
2. Converting String to Numbers Date.srt
|
SRT
|
6.4 KB
|
|
|
2. Debugging restoration issues.mp4
|
MP4
|
50.2 MB
|
|
|
2. Debugging restoration issues.srt
|
SRT
|
9.5 KB
|
|
|
2. Exercise 1 Create DB and Table.mp4
|
MP4
|
5.9 MB
|
|
|
2. Exercise 1 Create DB and Table.srt
|
SRT
|
2.6 KB
|
|
|
2. Exercise 11 Subqueries.mp4
|
MP4
|
5.1 MB
|
|
|
2. Exercise 11 Subqueries.srt
|
SRT
|
2 KB
|
|
|
2. HAVING.mp4
|
MP4
|
37.9 MB
|
|
|
2. HAVING.srt
|
SRT
|
5.4 KB
|
|
|
2. INDEX.mp4
|
MP4
|
40.4 MB
|
|
|
2. INDEX.srt
|
SRT
|
9.9 KB
|
|
|
2. Installing and setting up PostgreSQL.mp4
|
MP4
|
58.7 MB
|
|
|
2. Installing and setting up PostgreSQL.srt
|
SRT
|
8.6 KB
|
|
|
2. ORDER BY.mp4
|
MP4
|
71.4 MB
|
|
|
2. ORDER BY.srt
|
SRT
|
10.4 KB
|
|
|
2. PRIMARY KEY & FOREIGN KEY.mp4
|
MP4
|
25.4 MB
|
|
|
2. PRIMARY KEY & FOREIGN KEY.srt
|
SRT
|
8.6 KB
|
|
|
2. RANDOM.mp4
|
MP4
|
31.4 MB
|
|
|
2. RANDOM.srt
|
SRT
|
6.6 KB
|
|
|
2. SUM.mp4
|
MP4
|
21.1 MB
|
|
|
2. SUM.srt
|
SRT
|
3.8 KB
|
|
|
2. TIP 2.mp4
|
MP4
|
5.8 MB
|
|
|
2. TIP 2.srt
|
SRT
|
1.8 KB
|
|
|
2. Tables and DBMS.mp4
|
MP4
|
17.4 MB
|
|
|
2. Tables and DBMS.srt
|
SRT
|
4.7 KB
|
|
|
2. UPPER LOWER.mp4
|
MP4
|
11.6 MB
|
|
|
2. UPPER LOWER.srt
|
SRT
|
3.4 KB
|
|
|
2828.dat
|
DAT
|
63.2 KB
|
|
|
2829.dat
|
DAT
|
137.7 KB
|
|
|
2830.dat
|
DAT
|
973.9 KB
|
|
|
3. ACID compliance.mp4
|
MP4
|
42.7 MB
|
|
|
3. ACID compliance.srt
|
SRT
|
10.2 KB
|
|
|
3. AVERAGE.mp4
|
MP4
|
17.5 MB
|
|
|
3. AVERAGE.srt
|
SRT
|
3.5 KB
|
|
|
3. Creating DB using CSV files.mp4
|
MP4
|
35.5 MB
|
|
|
3. Creating DB using CSV files.srt
|
SRT
|
6.1 KB
|
|
|
3. EXTRACT.mp4
|
MP4
|
58.7 MB
|
|
|
3. EXTRACT.srt
|
SRT
|
10.3 KB
|
|
|
3. Exercise 12 Views.mp4
|
MP4
|
3.2 MB
|
|
|
3. Exercise 12 Views.srt
|
SRT
|
1.2 KB
|
|
|
3. Exercise 16 Pattern Matching.mp4
|
MP4
|
8.3 MB
|
|
|
3. Exercise 16 Pattern Matching.srt
|
SRT
|
2.7 KB
|
|
|
3. Exercise 9 Group By.mp4
|
MP4
|
6.2 MB
|
|
|
3. Exercise 9 Group By.srt
|
SRT
|
1.8 KB
|
|
|
3. INSERT.mp4
|
MP4
|
56.4 MB
|
|
|
3. INSERT.srt
|
SRT
|
10.5 KB
|
|
|
3. LIKE.mp4
|
MP4
|
61.2 MB
|
|
|
3. LIKE.srt
|
SRT
|
12.3 KB
|
|
|
3. LIMIT.mp4
|
MP4
|
29.6 MB
|
|
|
3. LIMIT.srt
|
SRT
|
5.1 KB
|
|
|
3. Preparing the data.mp4
|
MP4
|
13.9 MB
|
|
|
3. Preparing the data.srt
|
SRT
|
2.3 KB
|
|
|
3. REPLACE.mp4
|
MP4
|
25.2 MB
|
|
|
3. REPLACE.srt
|
SRT
|
5.5 KB
|
|
|
3. SETSEED.mp4
|
MP4
|
24.8 MB
|
|
|
3. SETSEED.srt
|
SRT
|
4.5 KB
|
|
|
3. TIP 3.mp4
|
MP4
|
14.3 MB
|
|
|
3. TIP 3.srt
|
SRT
|
4.1 KB
|
|
|
3. Types of SQL commands.mp4
|
MP4
|
25.3 MB
|
|
|
3. Types of SQL commands.srt
|
SRT
|
6.6 KB
|
|
|
4. Exercise 15 Date-time functions.mp4
|
MP4
|
5.7 MB
|
|
|
4. Exercise 15 Date-time functions.srt
|
SRT
|
1.9 KB
|
|
|
4. Exercise 5 Restore and Back-up.mp4
|
MP4
|
3 MB
|
|
|
4. Exercise 5 Restore and Back-up.srt
|
SRT
|
1.3 KB
|
|
|
4. Exercise 6 In, Like & Between.mp4
|
MP4
|
5.3 MB
|
|
|
4. Exercise 6 In, Like & Between.srt
|
SRT
|
1 KB
|
|
|
4. Exercise 7 Sorting.mp4
|
MP4
|
3.2 MB
|
|
|
4. Exercise 7 Sorting.srt
|
SRT
|
1.1 KB
|
|
|
4. Import data from File.mp4
|
MP4
|
32.6 MB
|
|
|
4. Import data from File.srt
|
SRT
|
6 KB
|
|
|
4. Inner Join.mp4
|
MP4
|
47.2 MB
|
|
|
4. Inner Join.srt
|
SRT
|
7.7 KB
|
|
|
4. MIN & MAX.mp4
|
MP4
|
32.5 MB
|
|
|
4. MIN & MAX.srt
|
SRT
|
4.8 KB
|
|
|
4. PostgreSQL.mp4
|
MP4
|
17.2 MB
|
|
|
4. PostgreSQL.srt
|
SRT
|
3.8 KB
|
|
|
4. ROUND.mp4
|
MP4
|
16.8 MB
|
|
|
4. ROUND.srt
|
SRT
|
3.2 KB
|
|
|
4. TIP 4 (VACCUM).mp4
|
MP4
|
2.9 MB
|
|
|
4. TIP 4 (VACCUM).srt
|
SRT
|
819.2 B
|
|
|
4. TRIM, LTRIM, RTRIM.mp4
|
MP4
|
50 MB
|
|
|
4. TRIM, LTRIM, RTRIM.srt
|
SRT
|
9.6 KB
|
|
|
4. Truncate.mp4
|
MP4
|
21.1 MB
|
|
|
4. Truncate.srt
|
SRT
|
5.3 KB
|
|
|
5. CONCATENATION.mp4
|
MP4
|
16.9 MB
|
|
|
5. CONCATENATION.srt
|
SRT
|
3.8 KB
|
|
|
5. Exercise 2 Inserting and Importing.mp4
|
MP4
|
4.6 MB
|
|
|
5. Exercise 2 Inserting and Importing.srt
|
SRT
|
1.2 KB
|
|
|
5. Exercise 8 Aggregate functions.mp4
|
MP4
|
6.4 MB
|
|
|
5. Exercise 8 Aggregate functions.srt
|
SRT
|
2 KB
|
|
|
5. Left Join.mp4
|
MP4
|
36.8 MB
|
|
|
5. Left Join.srt
|
SRT
|
8.1 KB
|
|
|
5. POWER.mp4
|
MP4
|
12.1 MB
|
|
|
5. POWER.srt
|
SRT
|
3.1 KB
|
|
|
5. TIP 5.mp4
|
MP4
|
11.5 MB
|
|
|
5. TIP 5.srt
|
SRT
|
3.4 KB
|
|
|
5. The final milestone!.mp4
|
MP4
|
11.9 MB
|
|
|
5. The final milestone!.srt
|
SRT
|
1.7 KB
|
|
|
6. Exercise 14 Mathematical Functions.mp4
|
MP4
|
10.3 MB
|
|
|
6. Exercise 14 Mathematical Functions.srt
|
SRT
|
2.5 KB
|
|
|
6. Right Join.mp4
|
MP4
|
36 MB
|
|
|
6. Right Join.srt
|
SRT
|
6.3 KB
|
|
|
6. SELECT statement.mp4
|
MP4
|
27.1 MB
|
|
|
6. SELECT statement.srt
|
SRT
|
4.7 KB
|
|
|
6. SUBSTRING.mp4
|
MP4
|
42.3 MB
|
|
|
6. SUBSTRING.srt
|
SRT
|
7.4 KB
|
|
|
6. TIP 6 (STRING FUNCTIONS).mp4
|
MP4
|
13.7 MB
|
|
|
6. TIP 6 (STRING FUNCTIONS).srt
|
SRT
|
3.4 KB
|
|
|
7. Full Outer Join.mp4
|
MP4
|
32.1 MB
|
|
|
7. Full Outer Join.srt
|
SRT
|
4.6 KB
|
|
|
7. LIST AGGREGATION.mp4
|
MP4
|
33.1 MB
|
|
|
7. LIST AGGREGATION.srt
|
SRT
|
6.7 KB
|
|
|
7. SELECT DISTINCT.mp4
|
MP4
|
43.2 MB
|
|
|
7. SELECT DISTINCT.srt
|
SRT
|
7.3 KB
|
|
|
7. TIP 7 (JOINS).mp4
|
MP4
|
10.8 MB
|
|
|
7. TIP 7 (JOINS).srt
|
SRT
|
2.8 KB
|
|
|
8. Cross Join.mp4
|
MP4
|
18.8 MB
|
|
|
8. Cross Join.srt
|
SRT
|
5.1 KB
|
|
|
8. Exercise 13 String Functions.mp4
|
MP4
|
16.5 MB
|
|
|
8. Exercise 13 String Functions.srt
|
SRT
|
3.9 KB
|
|
|
8. TIP 8 (SCHEMAS).mp4
|
MP4
|
32 MB
|
|
|
8. TIP 8 (SCHEMAS).srt
|
SRT
|
6.3 KB
|
|
|
8. WHERE.mp4
|
MP4
|
27.7 MB
|
|
|
8. WHERE.srt
|
SRT
|
4.7 KB
|
|
|
9. Intersect and Intersect ALL.mp4
|
MP4
|
24.7 MB
|
|
|
9. Intersect and Intersect ALL.srt
|
SRT
|
7.4 KB
|
|
|
9. Logical Operators.mp4
|
MP4
|
41.8 MB
|
|
|
9. Logical Operators.srt
|
SRT
|
6.8 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Customer.csv
|
CSV
|
64 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Installing+PostgreSQL+on+Mac.pdf
|
PDF
|
209.8 KB
|
|
|
IntroV_01.pdf
|
PDF
|
707.1 KB
|
|
|
Lecture_04_create_Queries.pdf
|
PDF
|
219.3 KB
|
|
|
Lecture_06_INSERT+and+COPY.pdf
|
PDF
|
219.2 KB
|
|
|
Lecture_07_SELECT+&+DISTINCT.pdf
|
PDF
|
179.2 KB
|
|
|
Lecture_08_WHERE.pdf
|
PDF
|
175.6 KB
|
|
|
Lecture_09_AND&OR.pdf
|
PDF
|
176.3 KB
|
|
|
Lecture_1.pdf
|
PDF
|
220.3 KB
|
|
|
Lecture_10_UPDATEDelete.pdf
|
PDF
|
211 KB
|
|
|
Lecture_11_ALTER.pdf
|
PDF
|
201.7 KB
|
|
|
Lecture_12_IN_12.pdf
|
PDF
|
157.4 KB
|
|
|
Lecture_13_BETWEEN.pdf
|
PDF
|
187.6 KB
|
|
|
Lecture_14_LIKE.pdf
|
PDF
|
173.7 KB
|
|
|
Lecture_15_ORDER+BY.pdf
|
PDF
|
180.1 KB
|
|
|
Lecture_16_LIMIT.pdf
|
PDF
|
162.1 KB
|
|
|
Lecture_17_AS.pdf
|
PDF
|
151.7 KB
|
|
|
Lecture_18_count.pdf
|
PDF
|
158.2 KB
|
|
|
Lecture_19_SUM.pdf
|
PDF
|
162.9 KB
|
|
|
Lecture_2.pdf
|
PDF
|
289.5 KB
|
|
|
Lecture_20_AVG.pdf
|
PDF
|
157.5 KB
|
|
|
Lecture_21_MIN&MAX.pdf
|
PDF
|
164.1 KB
|
|
|
Lecture_22_group+by.pdf
|
PDF
|
164.6 KB
|
|
|
Lecture_23_HAVING.pdf
|
PDF
|
166.5 KB
|
|
|
Lecture_24_INNER+join.pdf
|
PDF
|
214.2 KB
|
|
|
Lecture_24_Joins_Query.txt
|
TXT
|
409.6 B
|
|
|
Lecture_25_LEFT+join.pdf
|
PDF
|
219 KB
|
|
|
Lecture_26_RIGHT+join.pdf
|
PDF
|
221.8 KB
|
|
|
Lecture_27_OUTER+join.pdf
|
PDF
|
219.1 KB
|
|
|
Lecture_28_Cross+join.pdf
|
PDF
|
186.7 KB
|
|
|
Lecture_29_EXCEPT.pdf
|
PDF
|
173.9 KB
|
|
|
Lecture_30_UNION.pdf
|
PDF
|
166.9 KB
|
|
|
Lecture_31_SUBQUERY.pdf
|
PDF
|
207.5 KB
|
|
|
Lecture_32_VIEWS.pdf
|
PDF
|
220.7 KB
|
|
|
Lecture_33_INDEX.pdf
|
PDF
|
201.6 KB
|
|
|
Lecture_34_STRING+functions.pdf
|
PDF
|
209.5 KB
|
|
|
Lecture_35_MATH+functions.pdf
|
PDF
|
192.9 KB
|
|
|
Lecture_36_DATETIME+functions.pdf
|
PDF
|
232.4 KB
|
|
|
Lecture_37_Conversion+functions (1).pdf
|
PDF
|
219.7 KB
|
|
|
Lecture_37_Conversion+functions.pdf
|
PDF
|
219.7 KB
|
|
|
Lecture_38_ACCESS+control.pdf
|
PDF
|
207.9 KB
|
|
|
Lecture_3_Queries.pdf
|
PDF
|
208.4 KB
|
|
|
Lecture_5_Postgresql.pdf
|
PDF
|
216.4 KB
|
|
|
Lecture_ACID.pdf
|
PDF
|
190.7 KB
|
|
|
Lecture_CASE.pdf
|
PDF
|
160 KB
|
|
|
Lecture_Pattern_Matching (1).pdf
|
PDF
|
238.9 KB
|
|
|
Lecture_Pattern_Matching.pdf
|
PDF
|
238.9 KB
|
|
|
Lecture_Performance_Tuning.pdf
|
PDF
|
285 KB
|
|
|
Lecture_TABLESPACE.pdf
|
PDF
|
188.7 KB
|
|
|
M3_T1_V3+Joins_Query.txt
|
TXT
|
409.6 B
|
|
|
Product.csv
|
CSV
|
139.6 KB
|
|
|
Sales.csv
|
CSV
|
983.7 KB
|
|
|
Solution.pdf
|
PDF
|
733.9 KB
|
|
|
Student.csv
|
CSV
|
102.4 B
|
|
|
User_table.txt
|
TXT
|
204.8 B
|
|
|
copy.csv
|
CSV
|
102.4 B
|
|
|
copytext.txt
|
TXT
|
0 B
|
|
|
restore.sql
|
SQL
|
4.1 KB
|
|
|
supermart.backup
|
BACKUP
|
297.6 KB
|
|
|
toc.dat
|
DAT
|
3.8 KB
|
