|
|
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.4 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. 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. Course Resources.html
|
HTML
|
102 B
|
|
|
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. Installation.mp4
|
MP4
|
45.6 MB
|
|
|
1. Installation.srt
|
SRT
|
7.3 KB
|
|
|
1. Introduction to Joins.mp4
|
MP4
|
17.8 MB
|
|
|
1. Introduction to Joins.srt
|
SRT
|
3.6 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. Practice Problem 1.html
|
HTML
|
204 B
|
|
|
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.8 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. 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
|
|
|
1.1 Files_sql.zip
|
ZIP
|
10 MB
|
|
|
1.1 Installing PostgreSQL on Mac.pdf
|
PDF
|
209.8 KB
|
|
|
1.1 IntroV_01.pdf
|
PDF
|
707.1 KB
|
|
|
1.1 Lecture_04_create_Queries.pdf
|
PDF
|
219.3 KB
|
|
|
1.1 Lecture_1.pdf
|
PDF
|
220.3 KB
|
|
|
1.1 Lecture_12_IN_12.pdf
|
PDF
|
157.4 KB
|
|
|
1.1 Lecture_17_AS.pdf
|
PDF
|
151.7 KB
|
|
|
1.1 Lecture_18_count.pdf
|
PDF
|
158.2 KB
|
|
|
1.1 Lecture_22_group by.pdf
|
PDF
|
164.6 KB
|
|
|
1.1 Lecture_24_Joins_Query.txt
|
TXT
|
204 B
|
|
|
1.1 Lecture_31_SUBQUERY.pdf
|
PDF
|
207.5 KB
|
|
|
1.1 Lecture_32_VIEWS.pdf
|
PDF
|
220.7 KB
|
|
|
1.1 Lecture_34_STRING functions.pdf
|
PDF
|
209.5 KB
|
|
|
1.1 Lecture_35_MATH functions.pdf
|
PDF
|
192.9 KB
|
|
|
1.1 Lecture_36_DATETIME functions.pdf
|
PDF
|
232.4 KB
|
|
|
1.1 Lecture_37_Conversion functions.pdf
|
PDF
|
219.7 KB
|
|
|
1.1 Lecture_38_ACCESS control.pdf
|
PDF
|
207.9 KB
|
|
|
1.1 Lecture_CASE.pdf
|
PDF
|
160 KB
|
|
|
1.1 Lecture_Pattern_Matching.pdf
|
PDF
|
238.9 KB
|
|
|
1.1 Lecture_Performance_Tuning.pdf
|
PDF
|
285 KB
|
|
|
1.1 Lecture_TABLESPACE.pdf
|
PDF
|
188.7 KB
|
|
|
1.1 Supermart_DB_new.zip
|
ZIP
|
297.8 KB
|
|
|
1.2 Lecture_17_AS.pdf
|
PDF
|
151.7 KB
|
|
|
10. Joins.html
|
HTML
|
204 B
|
|
|
10. Logical Operators.mp4
|
MP4
|
41.8 MB
|
|
|
10. Logical Operators.srt
|
SRT
|
6.8 KB
|
|
|
10.1 Lecture_09_AND&OR.pdf
|
PDF
|
176.3 KB
|
|
|
11. Exercise 3 SELECT & WHERE.mp4
|
MP4
|
7.2 MB
|
|
|
11. Exercise 3 SELECT & WHERE.srt
|
SRT
|
2 KB
|
|
|
12. UPDATE.mp4
|
MP4
|
37.7 MB
|
|
|
12. UPDATE.srt
|
SRT
|
5.6 KB
|
|
|
12.1 Lecture_10_UPDATEDelete.pdf
|
PDF
|
211 KB
|
|
|
13. DELETE.mp4
|
MP4
|
29.2 MB
|
|
|
13. DELETE.srt
|
SRT
|
5.4 KB
|
|
|
14. ALTER.mp4
|
MP4
|
125.7 MB
|
|
|
14. ALTER.srt
|
SRT
|
19.4 KB
|
|
|
14.1 Lecture_11_ALTER.pdf
|
PDF
|
201.7 KB
|
|
|
15. Exercise 4 Updating Table.mp4
|
MP4
|
3.9 MB
|
|
|
15. Exercise 4 Updating Table.srt
|
SRT
|
1.5 KB
|
|
|
16. Fundamental SQL statements.html
|
HTML
|
204 B
|
|
|
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. CSV files.html
|
HTML
|
512 B
|
|
|
2. Case Study Part 1.mp4
|
MP4
|
28 MB
|
|
|
2. Case Study Part 1.srt
|
SRT
|
6.1 KB
|
|
|
2. Converting String to Numbers Date.mp4
|
MP4
|
39.1 MB
|
|
|
2. Converting String to Numbers Date.srt
|
SRT
|
6.4 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.3 MB
|
|
|
2. INDEX.srt
|
SRT
|
9.9 KB
|
|
|
2. Inner Join.mp4
|
MP4
|
59.3 MB
|
|
|
2. Inner Join.srt
|
SRT
|
10.2 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
|
|
|
2.1 Lecture_13_BETWEEN.pdf
|
PDF
|
187.6 KB
|
|
|
2.1 Lecture_15_ORDER BY.pdf
|
PDF
|
180.1 KB
|
|
|
2.1 Lecture_19_SUM.pdf
|
PDF
|
162.9 KB
|
|
|
2.1 Lecture_2.pdf
|
PDF
|
289.5 KB
|
|
|
2.1 Lecture_23_HAVING.pdf
|
PDF
|
166.5 KB
|
|
|
2.1 Lecture_24_INNER join.pdf
|
PDF
|
214.2 KB
|
|
|
2.1 Lecture_33_INDEX.pdf
|
PDF
|
201.6 KB
|
|
|
2.1 Lecture_5_Keys.pdf
|
PDF
|
234.6 KB
|
|
|
2.1 Product.csv
|
CSV
|
139.5 KB
|
|
|
2.1 User_table.txt
|
TXT
|
204 B
|
|
|
2.2 Customer.csv
|
CSV
|
64 KB
|
|
|
2.3 Sales.csv
|
CSV
|
983.7 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. Case Study Part 2.mp4
|
MP4
|
51.2 MB
|
|
|
3. Case Study Part 2.srt
|
SRT
|
8.7 KB
|
|
|
3. EXTRACT.mp4
|
MP4
|
58.6 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 5 Restore and Back-up.mp4
|
MP4
|
3 MB
|
|
|
3. Exercise 5 Restore and Back-up.srt
|
SRT
|
1.3 KB
|
|
|
3. Exercise 9 Group By.mp4
|
MP4
|
6.2 MB
|
|
|
3. Exercise 9 Group By.srt
|
SRT
|
1.8 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. Left Join.mp4
|
MP4
|
50.4 MB
|
|
|
3. Left Join.srt
|
SRT
|
10.1 KB
|
|
|
3. REPLACE.mp4
|
MP4
|
25.3 MB
|
|
|
3. REPLACE.srt
|
SRT
|
5.5 KB
|
|
|
3. SETSEED.mp4
|
MP4
|
24.8 MB
|
|
|
3. SETSEED.srt
|
SRT
|
4.5 KB
|
|
|
3. Solutions to all Exercises.html
|
HTML
|
102 B
|
|
|
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
|
|
|
3.1 Lecture_14_LIKE.pdf
|
PDF
|
173.7 KB
|
|
|
3.1 Lecture_16_LIMIT.pdf
|
PDF
|
162.1 KB
|
|
|
3.1 Lecture_20_AVG.pdf
|
PDF
|
157.5 KB
|
|
|
3.1 Lecture_25_LEFT join.pdf
|
PDF
|
219 KB
|
|
|
3.1 Lecture_3_Queries.pdf
|
PDF
|
208.4 KB
|
|
|
3.1 Lecture_ACID.pdf
|
PDF
|
190.7 KB
|
|
|
3.1 Solution.pdf
|
PDF
|
733.9 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 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. INSERT.mp4
|
MP4
|
56.4 MB
|
|
|
4. INSERT.srt
|
SRT
|
10.5 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. Quiz.html
|
HTML
|
204 B
|
|
|
4. ROUND.mp4
|
MP4
|
16.8 MB
|
|
|
4. ROUND.srt
|
SRT
|
3.2 KB
|
|
|
4. Right Join.mp4
|
MP4
|
48.6 MB
|
|
|
4. Right Join.srt
|
SRT
|
7.6 KB
|
|
|
4. TIP 4 (VACCUM).mp4
|
MP4
|
2.9 MB
|
|
|
4. TIP 4 (VACCUM).srt
|
SRT
|
819 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
|
|
|
4.1 Lecture_06_INSERT and COPY.pdf
|
PDF
|
219.2 KB
|
|
|
4.1 Lecture_21_MIN&MAX.pdf
|
PDF
|
164.1 KB
|
|
|
4.1 Lecture_26_RIGHT join.pdf
|
PDF
|
221.8 KB
|
|
|
4.1 Lecture_5_Postgresql.pdf
|
PDF
|
216.4 KB
|
|
|
4.1 Lecture_TRUNCATE.pdf
|
PDF
|
160.5 KB
|
|
|
5. CONCATENATION.mp4
|
MP4
|
16.9 MB
|
|
|
5. CONCATENATION.srt
|
SRT
|
3.8 KB
|
|
|
5. Congratulations & About your certificate.html
|
HTML
|
1.6 KB
|
|
|
5. Exercise 8 Aggregate functions.mp4
|
MP4
|
6.4 MB
|
|
|
5. Exercise 8 Aggregate functions.srt
|
SRT
|
2 KB
|
|
|
5. Full Outer Join.mp4
|
MP4
|
39.3 MB
|
|
|
5. Full Outer Join.srt
|
SRT
|
5.2 KB
|
|
|
5. Import data from File.mp4
|
MP4
|
32.6 MB
|
|
|
5. Import data from File.srt
|
SRT
|
6 KB
|
|
|
5. POWER.mp4
|
MP4
|
12.1 MB
|
|
|
5. POWER.srt
|
SRT
|
3.1 KB
|
|
|
5. Practice Test 1.html
|
HTML
|
204 B
|
|
|
5. TIP 5.mp4
|
MP4
|
11.5 MB
|
|
|
5. TIP 5.srt
|
SRT
|
3.4 KB
|
|
|
5.1 Lecture_27_OUTER join.pdf
|
PDF
|
219.1 KB
|
|
|
5.1 copytext.txt
|
TXT
|
0 B
|
|
|
5.2 copy.csv
|
CSV
|
102 B
|
|
|
6. Bonus Lecture.html
|
HTML
|
1.4 KB
|
|
|
6. Cross Join.mp4
|
MP4
|
26 MB
|
|
|
6. Cross Join.srt
|
SRT
|
6 KB
|
|
|
6. Exercise 14 Mathematical Functions.mp4
|
MP4
|
10.3 MB
|
|
|
6. Exercise 14 Mathematical Functions.srt
|
SRT
|
2.5 KB
|
|
|
6. Exercise 2 Inserting and Importing.mp4
|
MP4
|
4.6 MB
|
|
|
6. Exercise 2 Inserting and Importing.srt
|
SRT
|
1.2 KB
|
|
|
6. Quiz.html
|
HTML
|
204 B
|
|
|
6. SQL Quiz.html
|
HTML
|
204 B
|
|
|
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
|
|
|
6.1 Lecture_28_Cross join.pdf
|
PDF
|
186.7 KB
|
|
|
6.1 Student.csv
|
CSV
|
102 B
|
|
|
7. Except.mp4
|
MP4
|
17.3 MB
|
|
|
7. Except.srt
|
SRT
|
4 KB
|
|
|
7. LIST AGGREGATION.mp4
|
MP4
|
33.1 MB
|
|
|
7. LIST AGGREGATION.srt
|
SRT
|
6.7 KB
|
|
|
7. SELECT statement.mp4
|
MP4
|
27.1 MB
|
|
|
7. SELECT statement.srt
|
SRT
|
4.7 KB
|
|
|
7. TIP 7 (JOINS).mp4
|
MP4
|
10.8 MB
|
|
|
7. TIP 7 (JOINS).srt
|
SRT
|
2.8 KB
|
|
|
7.1 Lecture_07_SELECT & DISTINCT.pdf
|
PDF
|
179.2 KB
|
|
|
7.1 Lecture_29_EXCEPT.pdf
|
PDF
|
173.9 KB
|
|
|
8. Exercise 13 String Functions.mp4
|
MP4
|
16.5 MB
|
|
|
8. Exercise 13 String Functions.srt
|
SRT
|
3.9 KB
|
|
|
8. SELECT DISTINCT.mp4
|
MP4
|
43.2 MB
|
|
|
8. SELECT DISTINCT.srt
|
SRT
|
7.3 KB
|
|
|
8. TIP 8 (SCHEMAS).mp4
|
MP4
|
32 MB
|
|
|
8. TIP 8 (SCHEMAS).srt
|
SRT
|
6.3 KB
|
|
|
8. Union.mp4
|
MP4
|
19.7 MB
|
|
|
8. Union.srt
|
SRT
|
4.3 KB
|
|
|
8.1 Lecture_30_UNION.pdf
|
PDF
|
166.9 KB
|
|
|
9. Exercise 10 Joins.mp4
|
MP4
|
6.9 MB
|
|
|
9. Exercise 10 Joins.srt
|
SRT
|
1.7 KB
|
|
|
9. WHERE.mp4
|
MP4
|
27.7 MB
|
|
|
9. WHERE.srt
|
SRT
|
4.7 KB
|
|
|
9.1 Lecture_08_WHERE.pdf
|
PDF
|
175.6 KB
|
|
|
Verify Files.txt
|
TXT
|
1 KB
|
|
|
[FreeAllCourse.Com].url
|
URL
|
102 B
|
![Udemy - SQL Masterclass: SQL for Data Analytics [FreeAllCourse]](/upload_files/resize_cache/torrents-posters/059/174_260_2/0599b5245ccb6fdc2fba227c2f309491.jpg "Udemy - SQL Masterclass: SQL for Data Analytics [FreeAllCourse]")
