|
|
1. AS.mp4
|
MP4
|
25.6 MB
|
|
|
1. AS.vtt
|
VTT
|
4.1 KB
|
|
|
1. CASE WHEN.mp4
|
MP4
|
28.5 MB
|
|
|
1. CASE WHEN.vtt
|
VTT
|
5.4 KB
|
|
|
1. CEIL & FLOOR.mp4
|
MP4
|
21 MB
|
|
|
1. CEIL & FLOOR.vtt
|
VTT
|
3.9 KB
|
|
|
1. COUNT.mp4
|
MP4
|
38.3 MB
|
|
|
1. COUNT.vtt
|
VTT
|
5.6 KB
|
|
|
1. CREATE.mp4
|
MP4
|
63.8 MB
|
|
|
1. CREATE.vtt
|
VTT
|
13.5 KB
|
|
|
1. CURRENT DATE & TIME.mp4
|
MP4
|
32.3 MB
|
|
|
1. CURRENT DATE & TIME.vtt
|
VTT
|
5.2 KB
|
|
|
1. Case Study Part 1.mp4
|
MP4
|
28 MB
|
|
|
1. Case Study Part 1.vtt
|
VTT
|
5.2 KB
|
|
|
1. Converting Numbers Date to String.mp4
|
MP4
|
73.2 MB
|
|
|
1. Converting Numbers Date to String.vtt
|
VTT
|
10.7 KB
|
|
|
1. Course Overview.mp4
|
MP4
|
29.3 MB
|
|
|
1. Course Overview.vtt
|
VTT
|
6.2 KB
|
|
|
1. GROUP BY.mp4
|
MP4
|
93.3 MB
|
|
|
1. GROUP BY.vtt
|
VTT
|
11.3 KB
|
|
|
1. IN.mp4
|
MP4
|
29.4 MB
|
|
|
1. IN.vtt
|
VTT
|
4.4 KB
|
|
|
1. Installation.mp4
|
MP4
|
45.6 MB
|
|
|
1. Installation.vtt
|
VTT
|
6.2 KB
|
|
|
1. Introduction to Joins.mp4
|
MP4
|
17.8 MB
|
|
|
1. Introduction to Joins.vtt
|
VTT
|
3 KB
|
|
|
1. LENGTH.mp4
|
MP4
|
18.6 MB
|
|
|
1. LENGTH.vtt
|
VTT
|
3.8 KB
|
|
|
1. PATTERN MATCHING BASICS.mp4
|
MP4
|
40.9 MB
|
|
|
1. PATTERN MATCHING BASICS.vtt
|
VTT
|
9.4 KB
|
|
|
1. Practice Problem 1.html
|
HTML
|
204.8 B
|
|
|
1. Restore and Back-up.mp4
|
MP4
|
72.1 MB
|
|
|
1. Restore and Back-up.vtt
|
VTT
|
8.2 KB
|
|
|
1. Side Lecture Commenting in SQL.mp4
|
MP4
|
12.3 MB
|
|
|
1. Side Lecture Commenting in SQL.vtt
|
VTT
|
1.7 KB
|
|
|
1. Subqueries.mp4
|
MP4
|
103.8 MB
|
|
|
1. Subqueries.vtt
|
VTT
|
16 KB
|
|
|
1. TIP 1 (EXPLAIN).mp4
|
MP4
|
25.5 MB
|
|
|
1. TIP 1 (EXPLAIN).vtt
|
VTT
|
3.7 KB
|
|
|
1. Tablespace.mp4
|
MP4
|
36.3 MB
|
|
|
1. Tablespace.vtt
|
VTT
|
5.9 KB
|
|
|
1. User Access Control.mp4
|
MP4
|
80.5 MB
|
|
|
1. User Access Control.vtt
|
VTT
|
13.4 KB
|
|
|
1. VIEWS.mp4
|
MP4
|
42.5 MB
|
|
|
1. VIEWS.vtt
|
VTT
|
7.9 KB
|
|
|
1. What is SQL.mp4
|
MP4
|
10.8 MB
|
|
|
1. What is SQL.vtt
|
VTT
|
2.5 KB
|
|
|
1.1 Installing PostgreSQL on Mac.pdf.pdf
|
PDF
|
209.8 KB
|
|
|
1.1 IntroV_01.pdf.pdf
|
PDF
|
707.1 KB
|
|
|
1.1 Lecture_04_create_Queries.pdf.pdf
|
PDF
|
219.3 KB
|
|
|
1.1 Lecture_1.pdf.pdf
|
PDF
|
220.3 KB
|
|
|
1.1 Lecture_12_IN_12.pdf.pdf
|
PDF
|
157.4 KB
|
|
|
1.1 Lecture_17_AS.pdf.pdf
|
PDF
|
151.7 KB
|
|
|
1.1 Lecture_18_count.pdf.pdf
|
PDF
|
158.2 KB
|
|
|
1.1 Lecture_22_group by.pdf.pdf
|
PDF
|
164.6 KB
|
|
|
1.1 Lecture_24_Joins_Query.txt.txt
|
TXT
|
409.6 B
|
|
|
1.1 Lecture_31_SUBQUERY.pdf.pdf
|
PDF
|
207.5 KB
|
|
|
1.1 Lecture_32_VIEWS.pdf.pdf
|
PDF
|
220.7 KB
|
|
|
1.1 Lecture_34_STRING functions.pdf.pdf
|
PDF
|
209.5 KB
|
|
|
1.1 Lecture_35_MATH functions.pdf.pdf
|
PDF
|
192.9 KB
|
|
|
1.1 Lecture_36_DATETIME functions.pdf.pdf
|
PDF
|
232.4 KB
|
|
|
1.1 Lecture_37_Conversion functions.pdf.pdf
|
PDF
|
219.7 KB
|
|
|
1.1 Lecture_38_ACCESS control.pdf.pdf
|
PDF
|
207.9 KB
|
|
|
1.1 Lecture_CASE.pdf.pdf
|
PDF
|
160 KB
|
|
|
1.1 Lecture_Pattern_Matching.pdf.pdf
|
PDF
|
238.9 KB
|
|
|
1.1 Lecture_Performance_Tuning.pdf.pdf
|
PDF
|
285 KB
|
|
|
1.1 Lecture_TABLESPACE.pdf.pdf
|
PDF
|
188.7 KB
|
|
|
1.1 Supermart_DB_new.zip.zip
|
ZIP
|
297.8 KB
|
|
|
1.2 Lecture_17_AS.pdf.pdf
|
PDF
|
151.7 KB
|
|
|
10. Joins.html
|
HTML
|
204.8 B
|
|
|
10. Logical Operators.mp4
|
MP4
|
41.8 MB
|
|
|
10. Logical Operators.vtt
|
VTT
|
5.5 KB
|
|
|
10.1 Lecture_09_AND&OR.pdf.pdf
|
PDF
|
176.3 KB
|
|
|
11. Exercise 3 SELECT & WHERE.mp4
|
MP4
|
7.2 MB
|
|
|
11. Exercise 3 SELECT & WHERE.vtt
|
VTT
|
1.7 KB
|
|
|
12. UPDATE.mp4
|
MP4
|
37.7 MB
|
|
|
12. UPDATE.vtt
|
VTT
|
4.5 KB
|
|
|
12.1 Lecture_10_UPDATEDelete.pdf.pdf
|
PDF
|
211 KB
|
|
|
13. DELETE.mp4
|
MP4
|
29.2 MB
|
|
|
13. DELETE.vtt
|
VTT
|
4.4 KB
|
|
|
14. ALTER.mp4
|
MP4
|
125.7 MB
|
|
|
14. ALTER.vtt
|
VTT
|
15.8 KB
|
|
|
14.1 Lecture_11_ALTER.pdf.pdf
|
PDF
|
201.7 KB
|
|
|
15. Exercise 4 Updating Table.mp4
|
MP4
|
3.9 MB
|
|
|
15. Exercise 4 Updating Table.vtt
|
VTT
|
1.2 KB
|
|
|
16. Fundamental SQL statements.html
|
HTML
|
204.8 B
|
|
|
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
|
MP4
|
103.1 MB
|
|
|
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).vtt
|
VTT
|
15.3 KB
|
|
|
2. AGE.mp4
|
MP4
|
26.6 MB
|
|
|
2. AGE.vtt
|
VTT
|
3.4 KB
|
|
|
2. BETWEEN.mp4
|
MP4
|
49.7 MB
|
|
|
2. BETWEEN.vtt
|
VTT
|
5.3 KB
|
|
|
2. CSV files.html
|
HTML
|
204.8 B
|
|
|
2. Case Study Part 2.mp4
|
MP4
|
51.2 MB
|
|
|
2. Case Study Part 2.vtt
|
VTT
|
7.3 KB
|
|
|
2. Converting String to Numbers Date.mp4
|
MP4
|
39 MB
|
|
|
2. Converting String to Numbers Date.vtt
|
VTT
|
5.2 KB
|
|
|
2. Exercise 1 Create DB and Table.mp4
|
MP4
|
5.9 MB
|
|
|
2. Exercise 1 Create DB and Table.vtt
|
VTT
|
2.2 KB
|
|
|
2. Exercise 11 Subqueries.mp4
|
MP4
|
5.1 MB
|
|
|
2. Exercise 11 Subqueries.vtt
|
VTT
|
1.6 KB
|
|
|
2. HAVING.mp4
|
MP4
|
37.9 MB
|
|
|
2. HAVING.vtt
|
VTT
|
4.4 KB
|
|
|
2. INDEX.mp4
|
MP4
|
40.3 MB
|
|
|
2. INDEX.vtt
|
VTT
|
8.2 KB
|
|
|
2. Inner Join.mp4
|
MP4
|
59.3 MB
|
|
|
2. Inner Join.vtt
|
VTT
|
8.3 KB
|
|
|
2. ORDER BY.mp4
|
MP4
|
71.4 MB
|
|
|
2. ORDER BY.vtt
|
VTT
|
8.4 KB
|
|
|
2. PRIMARY KEY & FOREIGN KEY.mp4
|
MP4
|
25.4 MB
|
|
|
2. PRIMARY KEY & FOREIGN KEY.vtt
|
VTT
|
7 KB
|
|
|
2. RANDOM.mp4
|
MP4
|
31.4 MB
|
|
|
2. RANDOM.vtt
|
VTT
|
5.4 KB
|
|
|
2. SUM.mp4
|
MP4
|
21.1 MB
|
|
|
2. SUM.vtt
|
VTT
|
3 KB
|
|
|
2. TIP 2.mp4
|
MP4
|
5.8 MB
|
|
|
2. TIP 2.vtt
|
VTT
|
1.5 KB
|
|
|
2. Tables and DBMS.mp4
|
MP4
|
17.4 MB
|
|
|
2. Tables and DBMS.vtt
|
VTT
|
3.9 KB
|
|
|
2. UPPER LOWER.mp4
|
MP4
|
11.6 MB
|
|
|
2. UPPER LOWER.vtt
|
VTT
|
2.8 KB
|
|
|
2.1 Lecture_13_BETWEEN.pdf.pdf
|
PDF
|
187.6 KB
|
|
|
2.1 Lecture_15_ORDER BY.pdf.pdf
|
PDF
|
180.1 KB
|
|
|
2.1 Lecture_19_SUM.pdf.pdf
|
PDF
|
162.9 KB
|
|
|
2.1 Lecture_2.pdf.pdf
|
PDF
|
289.5 KB
|
|
|
2.1 Lecture_23_HAVING.pdf.pdf
|
PDF
|
166.5 KB
|
|
|
2.1 Lecture_24_INNER join.pdf.pdf
|
PDF
|
214.2 KB
|
|
|
2.1 Lecture_33_INDEX.pdf.pdf
|
PDF
|
201.6 KB
|
|
|
2.1 Lecture_5_Keys.pdf.pdf
|
PDF
|
234.6 KB
|
|
|
2.1 Sales.csv.csv
|
CSV
|
983.7 KB
|
|
|
2.1 User_table.txt.txt
|
TXT
|
204.8 B
|
|
|
2.2 Customer.csv.csv
|
CSV
|
64 KB
|
|
|
2.3 Product.csv.csv
|
CSV
|
139.5 KB
|
|
|
3. ACID compliance.mp4
|
MP4
|
42.7 MB
|
|
|
3. ACID compliance.vtt
|
VTT
|
8.3 KB
|
|
|
3. AVERAGE.mp4
|
MP4
|
17.5 MB
|
|
|
3. AVERAGE.vtt
|
VTT
|
2.8 KB
|
|
|
3. EXTRACT.mp4
|
MP4
|
58.6 MB
|
|
|
3. EXTRACT.vtt
|
VTT
|
8.3 KB
|
|
|
3. Exercise 12 Views.mp4
|
MP4
|
3.2 MB
|
|
|
3. Exercise 12 Views.vtt
|
VTT
|
1 KB
|
|
|
3. Exercise 16 Pattern Matching.mp4
|
MP4
|
8.3 MB
|
|
|
3. Exercise 16 Pattern Matching.vtt
|
VTT
|
2.3 KB
|
|
|
3. Exercise 5 Restore and Back-up.mp4
|
MP4
|
3 MB
|
|
|
3. Exercise 5 Restore and Back-up.vtt
|
VTT
|
1.1 KB
|
|
|
3. Exercise 9 Group By.mp4
|
MP4
|
6.2 MB
|
|
|
3. Exercise 9 Group By.vtt
|
VTT
|
1.5 KB
|
|
|
3. LIKE.mp4
|
MP4
|
61.2 MB
|
|
|
3. LIKE.vtt
|
VTT
|
10 KB
|
|
|
3. LIMIT.mp4
|
MP4
|
29.6 MB
|
|
|
3. LIMIT.vtt
|
VTT
|
4.1 KB
|
|
|
3. Left Join.mp4
|
MP4
|
50.4 MB
|
|
|
3. Left Join.vtt
|
VTT
|
8.3 KB
|
|
|
3. REPLACE.mp4
|
MP4
|
25.2 MB
|
|
|
3. REPLACE.vtt
|
VTT
|
4.6 KB
|
|
|
3. SETSEED.mp4
|
MP4
|
24.8 MB
|
|
|
3. SETSEED.vtt
|
VTT
|
3.8 KB
|
|
|
3. Solutions to all Exercises.html
|
HTML
|
102.4 B
|
|
|
3. TIP 3.mp4
|
MP4
|
14.3 MB
|
|
|
3. TIP 3.vtt
|
VTT
|
3.4 KB
|
|
|
3. Types of SQL commands.mp4
|
MP4
|
25.3 MB
|
|
|
3. Types of SQL commands.vtt
|
VTT
|
5.6 KB
|
|
|
3.1 Lecture_14_LIKE.pdf.pdf
|
PDF
|
173.7 KB
|
|
|
3.1 Lecture_16_LIMIT.pdf.pdf
|
PDF
|
162.1 KB
|
|
|
3.1 Lecture_20_AVG.pdf.pdf
|
PDF
|
157.5 KB
|
|
|
3.1 Lecture_25_LEFT join.pdf.pdf
|
PDF
|
219 KB
|
|
|
3.1 Lecture_3_Queries.pdf.pdf
|
PDF
|
208.4 KB
|
|
|
3.1 Lecture_ACID.pdf.pdf
|
PDF
|
190.7 KB
|
|
|
3.1 Solution.pdf.pdf
|
PDF
|
733.9 KB
|
|
|
4. Exercise 15 Date-time functions.mp4
|
MP4
|
5.7 MB
|
|
|
4. Exercise 15 Date-time functions.vtt
|
VTT
|
1.6 KB
|
|
|
4. Exercise 6 In, Like & Between.mp4
|
MP4
|
5.3 MB
|
|
|
4. Exercise 6 In, Like & Between.vtt
|
VTT
|
819.2 B
|
|
|
4. Exercise 7 Sorting.mp4
|
MP4
|
3.2 MB
|
|
|
4. Exercise 7 Sorting.vtt
|
VTT
|
921.6 B
|
|
|
4. INSERT.mp4
|
MP4
|
56.4 MB
|
|
|
4. INSERT.vtt
|
VTT
|
8.6 KB
|
|
|
4. MIN & MAX.mp4
|
MP4
|
32.5 MB
|
|
|
4. MIN & MAX.vtt
|
VTT
|
3.8 KB
|
|
|
4. PostgreSQL.mp4
|
MP4
|
17.1 MB
|
|
|
4. PostgreSQL.vtt
|
VTT
|
3.2 KB
|
|
|
4. Quiz 2.html
|
HTML
|
204.8 B
|
|
|
4. ROUND.mp4
|
MP4
|
16.7 MB
|
|
|
4. ROUND.vtt
|
VTT
|
2.6 KB
|
|
|
4. Right Join.mp4
|
MP4
|
48.6 MB
|
|
|
4. Right Join.vtt
|
VTT
|
6.3 KB
|
|
|
4. TIP 4 (VACCUM).mp4
|
MP4
|
2.9 MB
|
|
|
4. TIP 4 (VACCUM).vtt
|
VTT
|
614.4 B
|
|
|
4. TRIM, LTRIM, RTRIM.mp4
|
MP4
|
50 MB
|
|
|
4. TRIM, LTRIM, RTRIM.vtt
|
VTT
|
7.9 KB
|
|
|
4. Truncate.mp4
|
MP4
|
21.1 MB
|
|
|
4. Truncate.vtt
|
VTT
|
4.5 KB
|
|
|
4.1 Lecture_06_INSERT and COPY.pdf.pdf
|
PDF
|
219.2 KB
|
|
|
4.1 Lecture_21_MIN&MAX.pdf.pdf
|
PDF
|
164.1 KB
|
|
|
4.1 Lecture_26_RIGHT join.pdf.pdf
|
PDF
|
221.8 KB
|
|
|
4.1 Lecture_5_Postgresql.pdf.pdf
|
PDF
|
216.4 KB
|
|
|
4.1 Lecture_TRUNCATE.pdf.pdf
|
PDF
|
160.5 KB
|
|
|
5. Bonus Lecture Our other courses for you.html
|
HTML
|
921.6 B
|
|
|
5. CONCATENATION.mp4
|
MP4
|
16.9 MB
|
|
|
5. CONCATENATION.vtt
|
VTT
|
3.1 KB
|
|
|
5. Exercise 8 Aggregate functions.mp4
|
MP4
|
6.4 MB
|
|
|
5. Exercise 8 Aggregate functions.vtt
|
VTT
|
1.7 KB
|
|
|
5. Full Outer Join.mp4
|
MP4
|
39.3 MB
|
|
|
5. Full Outer Join.vtt
|
VTT
|
4.4 KB
|
|
|
5. Import data from File.mp4
|
MP4
|
32.6 MB
|
|
|
5. Import data from File.vtt
|
VTT
|
5.1 KB
|
|
|
5. POWER.mp4
|
MP4
|
12.1 MB
|
|
|
5. POWER.vtt
|
VTT
|
2.5 KB
|
|
|
5. Practice Test 1.html
|
HTML
|
204.8 B
|
|
|
5. TIP 5.mp4
|
MP4
|
11.5 MB
|
|
|
5. TIP 5.vtt
|
VTT
|
2.8 KB
|
|
|
5.1 Lecture_27_OUTER join.pdf.pdf
|
PDF
|
219.1 KB
|
|
|
5.1 copy.csv.csv
|
CSV
|
102.4 B
|
|
|
5.2 copytext.txt.txt
|
TXT
|
0 B
|
|
|
6. Bonus Lecture.html
|
HTML
|
1.4 KB
|
|
|
6. Cross Join.mp4
|
MP4
|
25.9 MB
|
|
|
6. Cross Join.vtt
|
VTT
|
5.1 KB
|
|
|
6. Exercise 14 Mathematical Functions.mp4
|
MP4
|
10.3 MB
|
|
|
6. Exercise 14 Mathematical Functions.vtt
|
VTT
|
2.1 KB
|
|
|
6. Exercise 2 Inserting and Importing.mp4
|
MP4
|
4.6 MB
|
|
|
6. Exercise 2 Inserting and Importing.vtt
|
VTT
|
1 KB
|
|
|
6. SUBSTRING.mp4
|
MP4
|
42.3 MB
|
|
|
6. SUBSTRING.vtt
|
VTT
|
6.1 KB
|
|
|
6. TIP 6 (STRING FUNCTIONS).mp4
|
MP4
|
13.7 MB
|
|
|
6. TIP 6 (STRING FUNCTIONS).vtt
|
VTT
|
2.9 KB
|
|
|
6.1 Lecture_28_Cross join.pdf.pdf
|
PDF
|
186.7 KB
|
|
|
6.1 Student.csv.csv
|
CSV
|
102.4 B
|
|
|
7. Except.mp4
|
MP4
|
17.3 MB
|
|
|
7. Except.vtt
|
VTT
|
3.4 KB
|
|
|
7. LIST AGGREGATION.mp4
|
MP4
|
33.1 MB
|
|
|
7. LIST AGGREGATION.vtt
|
VTT
|
5.5 KB
|
|
|
7. SELECT statement.mp4
|
MP4
|
27.1 MB
|
|
|
7. SELECT statement.vtt
|
VTT
|
3.9 KB
|
|
|
7. TIP 7 (JOINS).mp4
|
MP4
|
10.8 MB
|
|
|
7. TIP 7 (JOINS).vtt
|
VTT
|
2.4 KB
|
|
|
7.1 Lecture_07_SELECT & DISTINCT.pdf.pdf
|
PDF
|
179.2 KB
|
|
|
7.1 Lecture_29_EXCEPT.pdf.pdf
|
PDF
|
173.9 KB
|
|
|
8. Exercise 13 String Functions.mp4
|
MP4
|
16.5 MB
|
|
|
8. Exercise 13 String Functions.vtt
|
VTT
|
3.2 KB
|
|
|
8. SELECT DISTINCT.mp4
|
MP4
|
43.2 MB
|
|
|
8. SELECT DISTINCT.vtt
|
VTT
|
6 KB
|
|
|
8. TIP 8 (SCHEMAS).mp4
|
MP4
|
32 MB
|
|
|
8. TIP 8 (SCHEMAS).vtt
|
VTT
|
5.3 KB
|
|
|
8. Union.mp4
|
MP4
|
19.7 MB
|
|
|
8. Union.vtt
|
VTT
|
3.6 KB
|
|
|
8.1 Lecture_30_UNION.pdf.pdf
|
PDF
|
166.9 KB
|
|
|
9. Exercise 10 Joins.mp4
|
MP4
|
6.9 MB
|
|
|
9. Exercise 10 Joins.vtt
|
VTT
|
1.4 KB
|
|
|
9. WHERE.mp4
|
MP4
|
27.7 MB
|
|
|
9. WHERE.vtt
|
VTT
|
3.9 KB
|
|
|
9.1 Lecture_08_WHERE.pdf.pdf
|
PDF
|
175.6 KB
|
|
|
[Tutorialsplanet.NET].url
|
URL
|
102.4 B
|
![Udemy - SQL Masterclass: SQL For Data Analytics [TP]](/static/img/no-torrent-image.png "Udemy - SQL Masterclass: SQL For Data Analytics [TP]")
