SQL Masterclass: SQL for Data Analytics

seeders: 1 leechers: 2 updated: 1 year ago
Added 3 years ago by External Trusted Uploader cybil18 in Other
Downloaded 20 times.
thepiratebay.org
SQL Masterclass: SQL for Data Analytics

Torrent Contents Size: 3.81 GB

SQL Masterclass: SQL for Data Analytics
▼ show more 274 files
1. Introduction
1. Introduction.mp4
MP4
29.65 MB
1. Introduction.srt
SRT
4.92 KB
10. Group By Commands
1. GROUP BY.mp4
MP4
93.33 MB
1. GROUP BY.srt
SRT
13.78 KB
1.1 Lecture_22_group by.pdf
PDF
174.64 KB
2. HAVING.mp4
MP4
37.91 MB
2. HAVING.srt
SRT
5.39 KB
2.1 Lecture_23_HAVING.pdf
PDF
166.52 KB
3. Exercise 9 Group By.mp4
MP4
6.17 MB
3. Exercise 9 Group By.srt
SRT
1.8 KB
4. Quiz.html
HTML
198 B
11. Conditional Statement
1. CASE WHEN.mp4
MP4
28.52 MB
1. CASE WHEN.srt
SRT
6.63 KB
1.1 Lecture_CASE.pdf
PDF
160.02 KB
GetFreeCourses.Co.url
URL
116 B
12. JOINS
1. Introduction to Joins.mp4
MP4
7.93 MB
1. Introduction to Joins.srt
SRT
3.11 KB
1.1 Lecture_24_Joins_Query.txt
TXT
417 B
10. Except.mp4
MP4
12.67 MB
10. Except.srt
SRT
3.47 KB
10.1 Lecture_29_EXCEPT.pdf
PDF
173.89 KB
11. Union.mp4
MP4
15.13 MB
11. Union.srt
SRT
3.49 KB
11.1 Lecture_30_UNION.pdf
PDF
166.94 KB
12. Exercise 10 Joins.mp4
MP4
6.9 MB
12. Exercise 10 Joins.srt
SRT
1.73 KB
13. Quiz.html
HTML
198 B
2. Concepts of Joining and Combining Data.mp4
MP4
59.79 MB
2. Concepts of Joining and Combining Data.srt
SRT
13.35 KB
3. Preparing the data.mp4
MP4
13.86 MB
3. Preparing the data.srt
SRT
2.3 KB
3.1 M3_T1_V3 Joins_Query.txt
TXT
417 B
4. Inner Join.mp4
MP4
47.15 MB
4. Inner Join.srt
SRT
7.97 KB
4.1 Lecture_24_INNER join.pdf
PDF
214.2 KB
5. Left Join.mp4
MP4
36.79 MB
5. Left Join.srt
SRT
8.44 KB
5.1 Lecture_25_LEFT join.pdf
PDF
219.01 KB
6. Right Join.mp4
MP4
36 MB
6. Right Join.srt
SRT
6.63 KB
6.1 Lecture_26_RIGHT join.pdf
PDF
221.83 KB
7. Full Outer Join.mp4
MP4
32.07 MB
7. Full Outer Join.srt
SRT
4.85 KB
7.1 Lecture_27_OUTER join.pdf
PDF
219.09 KB
8. Cross Join.mp4
MP4
18.76 MB
8. Cross Join.srt
SRT
5.28 KB
8.1 Lecture_28_Cross join.pdf
PDF
186.71 KB
9. Intersect and Intersect ALL.mp4
MP4
24.73 MB
9. Intersect and Intersect ALL.srt
SRT
7.63 KB
13. Subqueries
1. Subqueries.mp4
MP4
103.85 MB
1. Subqueries.srt
SRT
19.41 KB
1.1 Lecture_31_SUBQUERY.pdf
PDF
207.47 KB
2. Exercise 11 Subqueries.mp4
MP4
5.11 MB
2. Exercise 11 Subqueries.srt
SRT
1.95 KB
14. Views and Indexes
1. VIEWS.mp4
MP4
42.52 MB
1. VIEWS.srt
SRT
9.66 KB
1.1 Lecture_32_VIEWS.pdf
PDF
220.67 KB
2. INDEX.mp4
MP4
40.34 MB
2. INDEX.srt
SRT
9.89 KB
2.1 Lecture_33_INDEX.pdf
PDF
201.61 KB
3. Exercise 12 Views.mp4
MP4
3.2 MB
3. Exercise 12 Views.srt
SRT
1.25 KB
15. String Functions
1. LENGTH.mp4
MP4
18.57 MB
1. LENGTH.srt
SRT
4.58 KB
1.1 Lecture_34_STRING functions.pdf
PDF
209.47 KB
2. UPPER LOWER.mp4
MP4
11.64 MB
2. UPPER LOWER.srt
SRT
3.42 KB
3. REPLACE.mp4
MP4
25.26 MB
3. REPLACE.srt
SRT
5.46 KB
4. TRIM, LTRIM, RTRIM.mp4
MP4
49.97 MB
4. TRIM, LTRIM, RTRIM.srt
SRT
9.62 KB
5. CONCATENATION.mp4
MP4
16.91 MB
5. CONCATENATION.srt
SRT
3.81 KB
6. SUBSTRING.mp4
MP4
42.3 MB
6. SUBSTRING.srt
SRT
7.42 KB
7. LIST AGGREGATION.mp4
MP4
33.08 MB
7. LIST AGGREGATION.srt
SRT
6.68 KB
8. Exercise 13 String Functions.mp4
MP4
16.46 MB
8. Exercise 13 String Functions.srt
SRT
3.85 KB
16. Mathematical Functions
1. CEIL & FLOOR.mp4
MP4
20.96 MB
1. CEIL & FLOOR.srt
SRT
4.81 KB
1.1 Lecture_35_MATH functions.pdf
PDF
192.89 KB
2. RANDOM.mp4
MP4
31.41 MB
2. RANDOM.srt
SRT
6.62 KB
3. SETSEED.mp4
MP4
24.81 MB
3. SETSEED.srt
SRT
4.48 KB
4. ROUND.mp4
MP4
16.76 MB
4. ROUND.srt
SRT
3.15 KB
5. POWER.mp4
MP4
12.12 MB
5. POWER.srt
SRT
3.12 KB
6. Exercise 14 Mathematical Functions.mp4
MP4
10.34 MB
6. Exercise 14 Mathematical Functions.srt
SRT
2.51 KB
GetFreeCourses.Co.url
URL
116 B
17. Date-Time Functions
1. CURRENT DATE & TIME.mp4
MP4
32.31 MB
1. CURRENT DATE & TIME.srt
SRT
6.27 KB
1.1 Lecture_36_DATETIME functions.pdf
PDF
232.41 KB
2. AGE.mp4
MP4
26.64 MB
2. AGE.srt
SRT
4.21 KB
3. EXTRACT.mp4
MP4
58.65 MB
3. EXTRACT.srt
SRT
10.28 KB
4. Exercise 15 Date-time functions.mp4
MP4
5.71 MB
4. Exercise 15 Date-time functions.srt
SRT
1.9 KB
18. PATTERN (STRING) MATCHING
1. PATTERN MATCHING BASICS.mp4
MP4
40.93 MB
1. PATTERN MATCHING BASICS.srt
SRT
11.24 KB
1.1 Lecture_Pattern_Matching.pdf
PDF
238.92 KB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
MP4
103.05 MB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt
SRT
18.49 KB
2.1 User_table.txt
TXT
242 B
3. Exercise 16 Pattern Matching.mp4
MP4
8.31 MB
3. Exercise 16 Pattern Matching.srt
SRT
2.7 KB
19. Window Functions
1. Introduction to Window functions.mp4
MP4
57.68 MB
1. Introduction to Window functions.srt
SRT
10.33 KB
1.1 Windows Function PPT.pdf
PDF
616.72 KB
10. LAG and LEAD.mp4
MP4
70.64 MB
10. LAG and LEAD.srt
SRT
8.49 KB
2. Introduction to Row number.mp4
MP4
37.54 MB
2. Introduction to Row number.srt
SRT
6.05 KB
3. Implementing Row number in SQL.mp4
MP4
174.2 MB
3. Implementing Row number in SQL.srt
SRT
19.2 KB
4. RANK and DENSERANK.mp4
MP4
54.72 MB
4. RANK and DENSERANK.srt
SRT
7.57 KB
5. NTILE function.mp4
MP4
66.64 MB
5. NTILE function.srt
SRT
6.95 KB
6. AVERAGE function.mp4
MP4
58.92 MB
6. AVERAGE function.srt
SRT
8 KB
7. COUNT.mp4
MP4
31.62 MB
7. COUNT.srt
SRT
4.01 KB
8. SUM TOTAL.mp4
MP4
87.45 MB
8. SUM TOTAL.srt
SRT
10.83 KB
9. RUNNING TOTAL.mp4
MP4
64.22 MB
9. RUNNING TOTAL.srt
SRT
7.19 KB
2. Installation and getting started
1. Installing PostgreSQL and pgAdmin in your PC.mp4
MP4
68.13 MB
1. Installing PostgreSQL and pgAdmin in your PC.srt
SRT
13.01 KB
1.1 00 Debugging PostgreSQL installation issues.pdf
PDF
253.44 KB
1.2 Installing+PostgreSQL+on+Mac.pdf
PDF
209.83 KB
2. This is a milestone!.mp4
MP4
20.66 MB
2. This is a milestone!.srt
SRT
3.94 KB
3. If pgAdmin is not opening....html
HTML
1.55 KB
4. Course Resources.html
HTML
411 B
20. COALESCE function
1. COALESCE function.mp4
MP4
42.61 MB
1. COALESCE function.srt
SRT
6.13 KB
1.1 Windows Function PPT.pdf
PDF
616.72 KB
GetFreeCourses.Co.url
URL
116 B
21. Data Type conversion functions
1. Converting Numbers Date to String.mp4
MP4
73.18 MB
1. Converting Numbers Date to String.srt
SRT
13.05 KB
1.1 Lecture_37_Conversion functions.pdf
PDF
219.66 KB
2. Converting String to Numbers Date.mp4
MP4
39.04 MB
2. Converting String to Numbers Date.srt
SRT
6.38 KB
22. User Access Control Functions
1. User Access Control.mp4
MP4
80.48 MB
1. User Access Control.srt
SRT
16.23 KB
1.1 Lecture_38_ACCESS control.pdf
PDF
207.86 KB
23. Nail that Interview!
1. Tablespace.mp4
MP4
36.28 MB
1. Tablespace.srt
SRT
7.13 KB
1.1 Lecture_TABLESPACE.pdf
PDF
188.68 KB
2. PRIMARY KEY & FOREIGN KEY.mp4
MP4
25.41 MB
2. PRIMARY KEY & FOREIGN KEY.srt
SRT
8.58 KB
2.1 Lecture_5_Keys.pdf
PDF
234.59 KB
3. ACID compliance.mp4
MP4
42.68 MB
3. ACID compliance.srt
SRT
10.23 KB
3.1 Lecture_ACID.pdf
PDF
190.69 KB
4. Truncate.mp4
MP4
21.09 MB
4. Truncate.srt
SRT
5.34 KB
4.1 Lecture_TRUNCATE.pdf
PDF
160.5 KB
5. Practice Test 1.html
HTML
198 B
6. SQL Quiz.html
HTML
198 B
GetFreeCourses.Co.url
URL
116 B
24. Performance tuning tips
1. TIP 1 (EXPLAIN).mp4
MP4
25.5 MB
1. TIP 1 (EXPLAIN).srt
SRT
4.22 KB
1.1 Lecture_Performance_Tuning.pdf
PDF
285 KB
2. TIP 2.mp4
MP4
5.8 MB
2. TIP 2.srt
SRT
1.76 KB
3. TIP 3.mp4
MP4
14.26 MB
3. TIP 3.srt
SRT
4.07 KB
4. TIP 4 (VACCUM).mp4
MP4
2.86 MB
4. TIP 4 (VACCUM).srt
SRT
777 B
5. TIP 5.mp4
MP4
11.46 MB
5. TIP 5.srt
SRT
3.38 KB
6. TIP 6 (STRING FUNCTIONS).mp4
MP4
13.7 MB
6. TIP 6 (STRING FUNCTIONS).srt
SRT
3.43 KB
7. TIP 7 (JOINS).mp4
MP4
10.81 MB
7. TIP 7 (JOINS).srt
SRT
2.85 KB
8. TIP 8 (SCHEMAS).mp4
MP4
31.97 MB
8. TIP 8 (SCHEMAS).srt
SRT
6.26 KB
25. Final Section Database Basics
1. What is SQL.mp4
MP4
8.66 MB
1. What is SQL.srt
SRT
2.34 KB
2. Tables and DBMS.mp4
MP4
14.68 MB
2. Tables and DBMS.srt
SRT
3.61 KB
3. Types of SQL commands.mp4
MP4
22.07 MB
3. Types of SQL commands.srt
SRT
5.6 KB
4. PostgreSQL.mp4
MP4
14.11 MB
4. PostgreSQL.srt
SRT
3.37 KB
5. The final milestone!.mp4
MP4
11.85 MB
5. The final milestone!.srt
SRT
1.79 KB
6. Bonus Lecture.html
HTML
2.35 KB
3. Case Study Demo
1. Case Study Part 1 - Business problems.mp4
MP4
37.75 MB
1. Case Study Part 1 - Business problems.srt
SRT
5.38 KB
2. Case Study Part 2 - How SQL is Used.mp4
MP4
58.94 MB
2. Case Study Part 2 - How SQL is Used.srt
SRT
7.45 KB
4. Fundamental SQL statements
1. CREATE.mp4
MP4
91.13 MB
1. CREATE.srt
SRT
14.48 KB
10. Logical Operators.mp4
MP4
50.48 MB
10. Logical Operators.srt
SRT
5.99 KB
11. Exercise 3 SELECT & WHERE.mp4
MP4
7.18 MB
11. Exercise 3 SELECT & WHERE.srt
SRT
2.04 KB
12. UPDATE.mp4
MP4
37.67 MB
12. UPDATE.srt
SRT
5.56 KB
12.1 Lecture_10_UPDATEDelete.pdf
PDF
211 KB
13. DELETE.mp4
MP4
29.23 MB
13. DELETE.srt
SRT
5.44 KB
14. ALTER.mp4
MP4
125.75 MB
14. ALTER.srt
SRT
19.38 KB
14.1 Lecture_11_ALTER.pdf
PDF
201.72 KB
15. Exercise 4 Updating Table.mp4
MP4
3.93 MB
15. Exercise 4 Updating Table.srt
SRT
1.47 KB
16. Fundamental SQL statements.html
HTML
198 B
2. Exercise 1 Create DB and Table.mp4
MP4
5.88 MB
2. Exercise 1 Create DB and Table.srt
SRT
2.64 KB
3. Solutions to all Exercises.html
HTML
120 B
3.1 Solution.pdf
PDF
733.87 KB
4. INSERT.mp4
MP4
73.09 MB
4. INSERT.srt
SRT
9.58 KB
5. Import data from File.mp4
MP4
42.01 MB
5. Import data from File.srt
SRT
5.49 KB
6. Exercise 2 Inserting and Importing.mp4
MP4
4.59 MB
6. Exercise 2 Inserting and Importing.srt
SRT
1.17 KB
6.1 Student.csv
CSV
129 B
7. SELECT statement.mp4
MP4
31.83 MB
7. SELECT statement.srt
SRT
4.6 KB
8. SELECT DISTINCT.mp4
MP4
46.19 MB
8. SELECT DISTINCT.srt
SRT
6.07 KB
9. WHERE.mp4
MP4
32.56 MB
9. WHERE.srt
SRT
4.15 KB
5. Restore and Back-up
1. Restore and Back-up.mp4
MP4
72.1 MB
1. Restore and Back-up.srt
SRT
9.84 KB
1.1 BackupFiles.zip
ZIP
585.82 KB
1.2 Supermart_DB.tar
TAR
1.16 MB
2. Debugging restoration issues.mp4
MP4
50.18 MB
2. Debugging restoration issues.srt
SRT
9.75 KB
3. Creating DB using CSV files.mp4
MP4
35.47 MB
3. Creating DB using CSV files.srt
SRT
6.39 KB
4. Debugging summary and Code for CSV files.html
HTML
2.46 KB
4.1 Customer.csv
CSV
64.02 KB
4.2 Product.csv
CSV
139.6 KB
4.3 Sales.csv
CSV
983.71 KB
5. Exercise 5 Restore and Back-up.mp4
MP4
3 MB
5. Exercise 5 Restore and Back-up.srt
SRT
1.31 KB
6. Selection commands Filtering
1. IN.mp4
MP4
29.41 MB
1. IN.srt
SRT
5.29 KB
1.1 Lecture_12_IN_12.pdf
PDF
157.38 KB
2. BETWEEN.mp4
MP4
49.73 MB
2. BETWEEN.srt
SRT
6.55 KB
2.1 Lecture_13_BETWEEN.pdf
PDF
187.63 KB
3. LIKE.mp4
MP4
61.17 MB
3. LIKE.srt
SRT
12.26 KB
3.1 Lecture_14_LIKE.pdf
PDF
173.67 KB
4. Exercise 6 In, Like & Between.mp4
MP4
5.25 MB
4. Exercise 6 In, Like & Between.srt
SRT
973 B
GetFreeCourses.Co.url
URL
116 B
7. Selection commands Ordering
1. Side Lecture Commenting in SQL.mp4
MP4
12.3 MB
1. Side Lecture Commenting in SQL.srt
SRT
1.97 KB
2. ORDER BY.mp4
MP4
71.37 MB
2. ORDER BY.srt
SRT
10.36 KB
2.1 Lecture_15_ORDER BY.pdf
PDF
180.15 KB
3. LIMIT.mp4
MP4
29.61 MB
3. LIMIT.srt
SRT
5.08 KB
3.1 Lecture_16_LIMIT.pdf
PDF
162.11 KB
4. Exercise 7 Sorting.mp4
MP4
3.17 MB
4. Exercise 7 Sorting.srt
SRT
1.06 KB
8. Alias
1. AS.mp4
MP4
25.58 MB
1. AS.srt
SRT
4.93 KB
1.1 Lecture_17_AS.pdf
PDF
151.75 KB
1.2 Lecture_17_AS.pdf
PDF
151.75 KB
9. Aggregate Commands
1. COUNT.mp4
MP4
38.36 MB
1. COUNT.srt
SRT
6.77 KB
1.1 Lecture_18_count.pdf
PDF
158.2 KB
2. SUM.mp4
MP4
21.06 MB
2. SUM.srt
SRT
3.76 KB
2.1 Lecture_19_SUM.pdf
PDF
162.88 KB
3. AVERAGE.mp4
MP4
17.52 MB
3. AVERAGE.srt
SRT
3.46 KB
3.1 Lecture_20_AVG.pdf
PDF
157.54 KB
4. MIN & MAX.mp4
MP4
32.48 MB
4. MIN & MAX.srt
SRT
4.78 KB
4.1 Lecture_21_MIN&MAX.pdf
PDF
164.14 KB
5. Exercise 8 Aggregate functions.mp4
MP4
6.43 MB
5. Exercise 8 Aggregate functions.srt
SRT
2 KB
6. Quiz.html
HTML
198 B
Download Paid Udemy Courses For Free.url
URL
116 B
GetFreeCourses.Co.url
URL
116 B

Description

Related Torrents

Location

Trackers

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce
Torrent hash: