Udemy - Zero to Hero in SQL - SQL for Data Analytics (1.2024)
大小
3.36 GB
文件数
287
Info Hash:
D557B84C22E71EF718D0D8AE158603B505279E9F
收录时间
2026-01-20 18:28:42
更新时间
2026-01-20 18:28:42
文件列表 (287)
1 - Introduction/1 - Introduction.mp4
14.71 MB
1 - Introduction/1 - Introduction.srt
5.06 KB
10 - Group By Commands/42 - GROUP BY.mp4
117.33 MB
10 - Group By Commands/42 - GROUP BY.srt
13.54 KB
10 - Group By Commands/42 - Lecture-22-group-by.pdf
164.64 KB
10 - Group By Commands/43 - HAVING.mp4
26.15 MB
10 - Group By Commands/43 - HAVING.srt
5.33 KB
10 - Group By Commands/43 - Lecture-23-HAVING.pdf
166.52 KB
10 - Group By Commands/44 - Exercise 9 Group By.mp4
3.5 MB
10 - Group By Commands/44 - Exercise 9 Group By.srt
1.8 KB
11 - Conditional Statement/45 - CASE WHEN.mp4
20.48 MB
11 - Conditional Statement/45 - CASE WHEN.srt
6.55 KB
11 - Conditional Statement/45 - Lecture-CASE.pdf
160.02 KB
12 - JOINS/46 - Introduction to Joins.mp4
5.72 MB
12 - JOINS/46 - Introduction to Joins.srt
3.09 KB
12 - JOINS/46 - Lecture-24-Joins-Query.txt
417 B
12 - JOINS/47 - Concepts of Joining and Combining Data.mp4
41.18 MB
12 - JOINS/47 - Concepts of Joining and Combining Data.srt
13.22 KB
12 - JOINS/48 - M3-T1-V3-Joins-Query.txt
417 B
12 - JOINS/48 - Preparing the data.mp4
11.33 MB
12 - JOINS/48 - Preparing the data.srt
2.29 KB
12 - JOINS/49 - Inner Join.mp4
43.84 MB
12 - JOINS/49 - Inner Join.srt
7.9 KB
12 - JOINS/49 - Lecture-24-INNER-join.pdf
214.2 KB
12 - JOINS/50 - Lecture-25-LEFT-join.pdf
219.01 KB
12 - JOINS/50 - Left Join.mp4
30.49 MB
12 - JOINS/50 - Left Join.srt
8.37 KB
12 - JOINS/51 - Lecture-26-RIGHT-join.pdf
221.83 KB
12 - JOINS/51 - Right Join.mp4
47.85 MB
12 - JOINS/51 - Right Join.srt
6.58 KB
12 - JOINS/52 - Full Outer Join.mp4
40.22 MB
12 - JOINS/52 - Full Outer Join.srt
4.82 KB
12 - JOINS/52 - Lecture-27-OUTER-join.pdf
219.09 KB
12 - JOINS/53 - Cross Join.mp4
15.28 MB
12 - JOINS/53 - Cross Join.srt
5.24 KB
12 - JOINS/53 - Lecture-28-Cross-join.pdf
186.71 KB
12 - JOINS/54 - Intersect and Intersect ALL.mp4
28.64 MB
12 - JOINS/54 - Intersect and Intersect ALL.srt
7.57 KB
12 - JOINS/55 - Except.mp4
17.61 MB
12 - JOINS/55 - Except.srt
3.46 KB
12 - JOINS/55 - Lecture-29-EXCEPT.pdf
173.89 KB
12 - JOINS/56 - Lecture-30-UNION.pdf
166.94 KB
12 - JOINS/56 - Union.mp4
10.22 MB
12 - JOINS/56 - Union.srt
3.47 KB
12 - JOINS/57 - Exercise 10 Joins.mp4
3.84 MB
12 - JOINS/57 - Exercise 10 Joins.srt
1.72 KB
13 - Subqueries/58 - Lecture-31-SUBQUERY.pdf
207.47 KB
13 - Subqueries/58 - Subqueries.mp4
112.79 MB
13 - Subqueries/58 - Subqueries.srt
19.05 KB
13 - Subqueries/59 - Exercise 11 Subqueries.mp4
2.98 MB
13 - Subqueries/59 - Exercise 11 Subqueries.srt
1.94 KB
14 - Fun way to practice SQL/60 - Solve Murder Mystery using SQL.html
1.14 KB
15 - Views and Indexes/61 - Lecture-32-VIEWS.pdf
220.67 KB
15 - Views and Indexes/61 - VIEWS.mp4
46.47 MB
15 - Views and Indexes/61 - VIEWS.srt
9.52 KB
15 - Views and Indexes/62 - INDEX.mp4
28.18 MB
15 - Views and Indexes/62 - INDEX.srt
9.76 KB
15 - Views and Indexes/62 - Lecture-33-INDEX.pdf
201.61 KB
15 - Views and Indexes/63 - Exercise 12 Views.mp4
1.82 MB
15 - Views and Indexes/63 - Exercise 12 Views.srt
1.25 KB
16 - String Functions/64 - Lecture-34-STRING-functions.pdf
209.47 KB
16 - String Functions/64 - LENGTH.mp4
11.14 MB
16 - String Functions/64 - LENGTH.srt
4.54 KB
16 - String Functions/65 - UPPER LOWER.mp4
7.12 MB
16 - String Functions/65 - UPPER LOWER.srt
3.39 KB
16 - String Functions/66 - REPLACE.mp4
15.06 MB
16 - String Functions/66 - REPLACE.srt
5.41 KB
16 - String Functions/67 - TRIM LTRIM RTRIM.mp4
34.94 MB
16 - String Functions/67 - TRIM LTRIM RTRIM.srt
9.49 KB
16 - String Functions/68 - CONCATENATION.mp4
10.03 MB
16 - String Functions/68 - CONCATENATION.srt
3.78 KB
16 - String Functions/69 - SUBSTRING.mp4
29.41 MB
16 - String Functions/69 - SUBSTRING.srt
7.34 KB
16 - String Functions/70 - LIST AGGREGATION.mp4
36 MB
16 - String Functions/70 - LIST AGGREGATION.srt
6.61 KB
16 - String Functions/71 - Exercise 13 String Functions.mp4
8.81 MB
16 - String Functions/71 - Exercise 13 String Functions.srt
3.82 KB
17 - Mathematical Functions/72 - CEIL FLOOR.mp4
24.9 MB
17 - Mathematical Functions/72 - CEIL FLOOR.srt
4.76 KB
17 - Mathematical Functions/72 - Lecture-35-MATH-functions.pdf
192.89 KB
17 - Mathematical Functions/73 - RANDOM.mp4
22.43 MB
17 - Mathematical Functions/73 - RANDOM.srt
6.55 KB
17 - Mathematical Functions/74 - SETSEED.mp4
15.04 MB
17 - Mathematical Functions/74 - SETSEED.srt
4.44 KB
17 - Mathematical Functions/75 - ROUND.mp4
11.59 MB
17 - Mathematical Functions/75 - ROUND.srt
3.12 KB
17 - Mathematical Functions/76 - POWER.mp4
7.35 MB
17 - Mathematical Functions/76 - POWER.srt
3.09 KB
17 - Mathematical Functions/77 - Exercise 14 Mathematical Functions.mp4
5.57 MB
17 - Mathematical Functions/77 - Exercise 14 Mathematical Functions.srt
2.5 KB
18 - DateTime Functions/78 - CURRENT DATE TIME.mp4
17.89 MB
18 - DateTime Functions/78 - CURRENT DATE TIME.srt
6.2 KB
18 - DateTime Functions/78 - Lecture-36-DATETIME-functions.pdf
232.41 KB
18 - DateTime Functions/79 - AGE.mp4
15.35 MB
18 - DateTime Functions/79 - AGE.srt
4.17 KB
18 - DateTime Functions/80 - EXTRACT.mp4
41.07 MB
18 - DateTime Functions/80 - EXTRACT.srt
10.11 KB
18 - DateTime Functions/81 - Exercise 15 Datetime functions.mp4
3.32 MB
18 - DateTime Functions/81 - Exercise 15 Datetime functions.srt
1.89 KB
19 - PATTERN STRING MATCHING/82 - Lecture-Pattern-Matching.pdf
238.92 KB
19 - PATTERN STRING MATCHING/82 - PATTERN MATCHING BASICS.mp4
27.84 MB
19 - PATTERN STRING MATCHING/82 - PATTERN MATCHING BASICS.srt
11.08 KB
19 - PATTERN STRING MATCHING/83 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS.mp4
112.08 MB
19 - PATTERN STRING MATCHING/83 - ADVANCE PATTERN MATCHING REGULAR EXPRESSIONS.srt
18.16 KB
19 - PATTERN STRING MATCHING/83 - User-table.txt
242 B
19 - PATTERN STRING MATCHING/84 - Exercise 16 Pattern Matching.mp4
4.66 MB
19 - PATTERN STRING MATCHING/84 - Exercise 16 Pattern Matching.srt
2.68 KB
2 - Installation and getting started/2 - 00-Debugging-PostgreSQL-installation-issues.pdf
253.44 KB
2 - Installation and getting started/2 - Installing PostgreSQL and pgAdmin in your PC.mp4
68.46 MB
2 - Installation and getting started/2 - Installing PostgreSQL and pgAdmin in your PC.srt
13.44 KB
2 - Installation and getting started/2 - Installing-PostgreSQL-on-Mac.pdf
209.83 KB
2 - Installation and getting started/3 - This is a milestone.mp4
26.12 MB
2 - Installation and getting started/3 - This is a milestone.srt
3.9 KB
2 - Installation and getting started/4 - If pgAdmin is not opening.html
1.55 KB
2 - Installation and getting started/5 - Course Resources.html
117 B
2 - Installation and getting started/5 - SQL-Masterclass-SQL-for-Data-Analytics.zip
16.76 MB
20 - Window Functions/85 - Introduction to Window functions.mp4
40.17 MB
20 - Window Functions/85 - Introduction to Window functions.srt
10.65 KB
20 - Window Functions/85 - Windows-Function-PPT.pdf
616.72 KB
20 - Window Functions/86 - Introduction to Row number.mp4
22.76 MB
20 - Window Functions/86 - Introduction to Row number.srt
6.25 KB
20 - Window Functions/87 - Implementing Row number in SQL.mp4
144.31 MB
20 - Window Functions/87 - Implementing Row number in SQL.srt
19.95 KB
20 - Window Functions/88 - RANK and DENSERANK.mp4
43.49 MB
20 - Window Functions/88 - RANK and DENSERANK.srt
7.83 KB
20 - Window Functions/89 - NTILE function.mp4
74.45 MB
20 - Window Functions/89 - NTILE function.srt
7.19 KB
20 - Window Functions/90 - AVERAGE function.mp4
91.7 MB
20 - Window Functions/90 - AVERAGE function.srt
8.31 KB
20 - Window Functions/91 - COUNT.mp4
22.48 MB
20 - Window Functions/91 - COUNT.srt
4.15 KB
20 - Window Functions/92 - SUM TOTAL.mp4
73.34 MB
20 - Window Functions/92 - SUM TOTAL.srt
11.26 KB
20 - Window Functions/93 - RUNNING TOTAL.mp4
72.68 MB
20 - Window Functions/93 - RUNNING TOTAL.srt
7.43 KB
20 - Window Functions/94 - LAG and LEAD.mp4
57.41 MB
20 - Window Functions/94 - LAG and LEAD.srt
8.81 KB
21 - COALESCE function/95 - COALESCE function.mp4
30.51 MB
21 - COALESCE function/95 - COALESCE function.srt
6.33 KB
21 - COALESCE function/95 - Windows-Function-PPT.pdf
616.72 KB
22 - Data Type conversion functions/96 - Converting Numbers Date to String.mp4
50.86 MB
22 - Data Type conversion functions/96 - Converting Numbers Date to String.srt
12.83 KB
22 - Data Type conversion functions/96 - Lecture-37-Conversion-functions.pdf
219.66 KB
22 - Data Type conversion functions/97 - Converting String to Numbers Date.mp4
27.59 MB
22 - Data Type conversion functions/97 - Converting String to Numbers Date.srt
6.31 KB
23 - User Access Control Functions/98 - Lecture-38-ACCESS-control.pdf
207.86 KB
23 - User Access Control Functions/98 - User Access Control.mp4
65.85 MB
23 - User Access Control Functions/98 - User Access Control.srt
15.96 KB
24 - Nail that Interview/100 - Lecture-TABLESPACE.pdf
188.68 KB
24 - Nail that Interview/100 - Tablespace.mp4
40.2 MB
24 - Nail that Interview/100 - Tablespace.srt
7.06 KB
24 - Nail that Interview/101 - Lecture-5-Keys.pdf
234.59 KB
24 - Nail that Interview/101 - PRIMARY KEY FOREIGN KEY.mp4
19.29 MB
24 - Nail that Interview/101 - PRIMARY KEY FOREIGN KEY.srt
8.48 KB
24 - Nail that Interview/102 - ACID compliance.mp4
23.11 MB
24 - Nail that Interview/102 - ACID compliance.srt
10.07 KB
24 - Nail that Interview/102 - Lecture-ACID.pdf
190.69 KB
24 - Nail that Interview/103 - Lecture-TRUNCATE.pdf
160.5 KB
24 - Nail that Interview/103 - Truncate.mp4
14.88 MB
24 - Nail that Interview/103 - Truncate.srt
5.29 KB
24 - Nail that Interview/99 - Showcasing SQL Skills with HackerRank Stars.html
1.62 KB
25 - Performance tuning tips/104 - Lecture-Performance-Tuning.pdf
285 KB
25 - Performance tuning tips/104 - TIP 1 EXPLAIN.mp4
21.89 MB
25 - Performance tuning tips/104 - TIP 1 EXPLAIN.srt
4.2 KB
25 - Performance tuning tips/105 - TIP 2.mp4
3.39 MB
25 - Performance tuning tips/105 - TIP 2.srt
1.76 KB
25 - Performance tuning tips/106 - TIP 3.mp4
7.89 MB
25 - Performance tuning tips/106 - TIP 3.srt
4.04 KB
25 - Performance tuning tips/107 - TIP 4 VACCUM.mp4
1.6 MB
25 - Performance tuning tips/107 - TIP 4 VACCUM.srt
782 B
25 - Performance tuning tips/108 - TIP 5.mp4
6.53 MB
25 - Performance tuning tips/108 - TIP 5.srt
3.34 KB
25 - Performance tuning tips/109 - TIP 6 STRING FUNCTIONS.mp4
7.78 MB
25 - Performance tuning tips/109 - TIP 6 STRING FUNCTIONS.srt
3.4 KB
25 - Performance tuning tips/110 - TIP 7 JOINS.mp4
6 MB
25 - Performance tuning tips/110 - TIP 7 JOINS.srt
2.83 KB
25 - Performance tuning tips/111 - TIP 8 SCHEMAS.mp4
26.32 MB
25 - Performance tuning tips/111 - TIP 8 SCHEMAS.srt
6.2 KB
26 - Final Section Database Basics/112 - Lecture-1.pdf
220.28 KB
26 - Final Section Database Basics/112 - What is SQL.mp4
5.6 MB
26 - Final Section Database Basics/112 - What is SQL.srt
2.33 KB
26 - Final Section Database Basics/113 - Lecture-2.pdf
289.49 KB
26 - Final Section Database Basics/113 - Tables and DBMS.mp4
9.7 MB
26 - Final Section Database Basics/113 - Tables and DBMS.srt
3.59 KB
26 - Final Section Database Basics/114 - Lecture-3-Queries.pdf
208.4 KB
26 - Final Section Database Basics/114 - Types of SQL commands.mp4
13.9 MB
26 - Final Section Database Basics/114 - Types of SQL commands.srt
5.56 KB
26 - Final Section Database Basics/115 - Lecture-5-Postgresql.pdf
216.37 KB
26 - Final Section Database Basics/115 - PostgreSQL.mp4
8.52 MB
26 - Final Section Database Basics/115 - PostgreSQL.srt
3.36 KB
26 - Final Section Database Basics/116 - The final milestone.mp4
8.36 MB
26 - Final Section Database Basics/116 - The final milestone.srt
1.79 KB
26 - Final Section Database Basics/117 - Bonus Lecture.html
2.35 KB
3 - Case Study Demo/6 - Case Study Part 1 Business problems.mp4
16.91 MB
3 - Case Study Demo/6 - Case Study Part 1 Business problems.srt
5.53 KB
3 - Case Study Demo/7 - Case Study Part 2 How SQL is Used.mp4
70.03 MB
3 - Case Study Demo/7 - Case Study Part 2 How SQL is Used.srt
7.68 KB
4 - Fundamental SQL statements/10 - Solution.pdf
733.87 KB
4 - Fundamental SQL statements/10 - Solutions to all Exercises.html
120 B
4 - Fundamental SQL statements/11 - INSERT.mp4
87.63 MB
4 - Fundamental SQL statements/11 - INSERT.srt
9.93 KB
4 - Fundamental SQL statements/12 - copy.csv
97 B
4 - Fundamental SQL statements/12 - copytext.txt
51 B
4 - Fundamental SQL statements/12 - Import data from File.mp4
32.11 MB
4 - Fundamental SQL statements/12 - Import data from File.srt
5.68 KB
4 - Fundamental SQL statements/13 - Exercise 2 Inserting and Importing.mp4
2.54 MB
4 - Fundamental SQL statements/13 - Exercise 2 Inserting and Importing.srt
1.17 KB
4 - Fundamental SQL statements/13 - Student.csv
129 B
4 - Fundamental SQL statements/14 - Lecture-07-SELECT-DISTINCT.pdf
179.18 KB
4 - Fundamental SQL statements/14 - SELECT statement.mp4
37.75 MB
4 - Fundamental SQL statements/14 - SELECT statement.srt
4.78 KB
4 - Fundamental SQL statements/15 - SELECT DISTINCT.mp4
30.12 MB
4 - Fundamental SQL statements/15 - SELECT DISTINCT.srt
6.28 KB
4 - Fundamental SQL statements/16 - Lecture-08-WHERE.pdf
175.61 KB
4 - Fundamental SQL statements/16 - WHERE.mp4
39.59 MB
4 - Fundamental SQL statements/16 - WHERE.srt
4.3 KB
4 - Fundamental SQL statements/17 - Lecture-09-AND-OR.pdf
176.34 KB
4 - Fundamental SQL statements/17 - Logical Operators.mp4
60.01 MB
4 - Fundamental SQL statements/17 - Logical Operators.srt
6.23 KB
4 - Fundamental SQL statements/18 - Exercise 3 SELECT WHERE.mp4
4 MB
4 - Fundamental SQL statements/18 - Exercise 3 SELECT WHERE.srt
2.03 KB
4 - Fundamental SQL statements/19 - Lecture-10-UPDATEDelete.pdf
211 KB
4 - Fundamental SQL statements/19 - UPDATE.mp4
21.83 MB
4 - Fundamental SQL statements/19 - UPDATE.srt
5.49 KB
4 - Fundamental SQL statements/20 - DELETE.mp4
20.73 MB
4 - Fundamental SQL statements/20 - DELETE.srt
5.37 KB
4 - Fundamental SQL statements/21 - ALTER.mp4
154.84 MB
4 - Fundamental SQL statements/21 - ALTER.srt
18.99 KB
4 - Fundamental SQL statements/21 - Lecture-11-ALTER.pdf
201.72 KB
4 - Fundamental SQL statements/22 - Exercise 4 Updating Table.mp4
2.3 MB
4 - Fundamental SQL statements/22 - Exercise 4 Updating Table.srt
1.47 KB
4 - Fundamental SQL statements/8 - CREATE.mp4
56.97 MB
4 - Fundamental SQL statements/8 - CREATE.srt
14.97 KB
4 - Fundamental SQL statements/9 - Exercise 1 Create DB and Table.mp4
3.35 MB
4 - Fundamental SQL statements/9 - Exercise 1 Create DB and Table.srt
2.62 KB
5 - Restore and Backup/23 - BackupFiles.zip
585.82 KB
5 - Restore and Backup/23 - Restore and Backup.mp4
76.06 MB
5 - Restore and Backup/23 - Restore and Backup.srt
9.71 KB
5 - Restore and Backup/23 - Supermart-DB.tar
1.16 MB
5 - Restore and Backup/24 - Debugging restoration issues.mp4
44.29 MB
5 - Restore and Backup/24 - Debugging restoration issues.srt
9.67 KB
5 - Restore and Backup/25 - Creating DB using CSV files.mp4
33.59 MB
5 - Restore and Backup/25 - Creating DB using CSV files.srt
6.34 KB
5 - Restore and Backup/26 - Customer.csv
64.02 KB
5 - Restore and Backup/26 - Debugging summary and Code for CSV files.html
2.46 KB
5 - Restore and Backup/26 - Product.csv
139.6 KB
5 - Restore and Backup/26 - Sales.csv
983.71 KB
5 - Restore and Backup/27 - Exercise 5 Restore and Backup.mp4
1.84 MB
5 - Restore and Backup/27 - Exercise 5 Restore and Backup.srt
1.31 KB
6 - Selection commands Filtering/28 - IN.mp4
23.13 MB
6 - Selection commands Filtering/28 - IN.srt
5.23 KB
6 - Selection commands Filtering/28 - Lecture-12-IN-12.pdf
157.38 KB
6 - Selection commands Filtering/29 - BETWEEN.mp4
36.81 MB
6 - Selection commands Filtering/29 - BETWEEN.srt
6.47 KB
6 - Selection commands Filtering/29 - Lecture-13-BETWEEN.pdf
187.63 KB
6 - Selection commands Filtering/30 - Lecture-14-LIKE.pdf
173.67 KB
6 - Selection commands Filtering/30 - LIKE.mp4
41.83 MB
6 - Selection commands Filtering/30 - LIKE.srt
12.05 KB
6 - Selection commands Filtering/31 - Exercise 6 In Like Between.mp4
2.81 MB
6 - Selection commands Filtering/31 - Exercise 6 In Like Between.srt
978 B
7 - Selection commands Ordering/32 - Side Lecture Commenting in SQL.mp4
6.63 MB
7 - Selection commands Ordering/32 - Side Lecture Commenting in SQL.srt
1.96 KB
7 - Selection commands Ordering/33 - Lecture-15-ORDER-BY.pdf
180.15 KB
7 - Selection commands Ordering/33 - ORDER BY.mp4
93.2 MB
7 - Selection commands Ordering/33 - ORDER BY.srt
10.19 KB
7 - Selection commands Ordering/34 - Lecture-16-LIMIT.pdf
162.11 KB
7 - Selection commands Ordering/34 - LIMIT.mp4
19.27 MB
7 - Selection commands Ordering/34 - LIMIT.srt
5.02 KB
7 - Selection commands Ordering/35 - Exercise 7 Sorting.mp4
1.82 MB
7 - Selection commands Ordering/35 - Exercise 7 Sorting.srt
1.06 KB
8 - Alias/36 - AS.mp4
17.39 MB
8 - Alias/36 - AS.srt
4.88 KB
8 - Alias/36 - Lecture-17-AS.pdf
151.75 KB
9 - Aggregate Commands/37 - COUNT.mp4
25.92 MB
9 - Aggregate Commands/37 - COUNT.srt
6.7 KB
9 - Aggregate Commands/37 - Lecture-18-count.pdf
158.2 KB
9 - Aggregate Commands/38 - Lecture-19-SUM.pdf
162.88 KB
9 - Aggregate Commands/38 - SUM.mp4
26.16 MB
9 - Aggregate Commands/38 - SUM.srt
3.72 KB
9 - Aggregate Commands/39 - AVERAGE.mp4
21.82 MB
9 - Aggregate Commands/39 - AVERAGE.srt
3.43 KB
9 - Aggregate Commands/39 - Lecture-20-AVG.pdf
157.54 KB
9 - Aggregate Commands/40 - Lecture-21-MIN-MAX.pdf
164.14 KB
9 - Aggregate Commands/40 - MIN MAX.mp4
22.69 MB
9 - Aggregate Commands/40 - MIN MAX.srt
4.73 KB
9 - Aggregate Commands/41 - Exercise 8 Aggregate functions.mp4
3.57 MB
9 - Aggregate Commands/41 - Exercise 8 Aggregate functions.srt
1.99 KB