Tutorialsplanet NET Udemy SQL Masterclass SQL for Data Analytics | 125E6BC915266509DD7605CC17F363F03389B579

Tutorialsplanet NET Udemy SQL Masterclass SQL for Data Analytics

Name	[Tutorialsplanet.NET] Udemy - SQL Masterclass SQL for Data Analytics	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.1 GB
Total Files	252
Hash	125E6BC915266509DD7605CC17F363F03389B579

/1. Introduction/
1. Course Overview.mp4	30.8 MB
1. Course Overview.vtt	6.3 KB
1.1 IntroV_01.pdf.pdf	724.0 KB
/10. Group By Commands/
1. GROUP BY.mp4	97.9 MB
1. GROUP BY.vtt	11.5 KB
1.1 Lecture_22_group by.pdf.pdf	168.6 KB
2. HAVING.mp4	39.7 MB
2. HAVING.vtt	4.5 KB
2.1 Lecture_23_HAVING.pdf.pdf	170.5 KB
3. Exercise 9 Group By.mp4	6.5 MB
3. Exercise 9 Group By.vtt	1.6 KB
4. Quiz 2.html	0.2 KB
/11. Conditional Statement/
1. CASE WHEN.mp4	29.9 MB
1. CASE WHEN.vtt	5.5 KB
1.1 Lecture_CASE.pdf.pdf	163.9 KB
/12. JOINS/
1. Introduction to Joins.mp4	18.6 MB
1. Introduction to Joins.vtt	3.1 KB
1.1 Lecture_24_Joins_Query.txt.txt	0.4 KB
10. Joins.html	0.2 KB
2. Inner Join.mp4	62.2 MB
2. Inner Join.vtt	8.5 KB
2.1 Lecture_24_INNER join.pdf.pdf	219.3 KB
3. Left Join.mp4	52.8 MB
3. Left Join.vtt	8.5 KB
3.1 Lecture_25_LEFT join.pdf.pdf	224.3 KB
4. Right Join.mp4	51.0 MB
4. Right Join.vtt	6.5 KB
4.1 Lecture_26_RIGHT join.pdf.pdf	227.2 KB
5. Full Outer Join.mp4	41.2 MB
5. Full Outer Join.vtt	4.5 KB
5.1 Lecture_27_OUTER join.pdf.pdf	224.4 KB
6. Cross Join.mp4	27.2 MB
6. Cross Join.vtt	5.2 KB
6.1 Lecture_28_Cross join.pdf.pdf	191.2 KB
7. Except.mp4	18.2 MB
7. Except.vtt	3.5 KB
7.1 Lecture_29_EXCEPT.pdf.pdf	178.1 KB
8. Union.mp4	20.6 MB
8. Union.vtt	3.7 KB
8.1 Lecture_30_UNION.pdf.pdf	170.9 KB
9. Exercise 10 Joins.mp4	7.2 MB
9. Exercise 10 Joins.vtt	1.5 KB
/13. Subqueries/
1. Subqueries.mp4	108.9 MB
1. Subqueries.vtt	16.4 KB
1.1 Lecture_31_SUBQUERY.pdf.pdf	212.4 KB
2. Exercise 11 Subqueries.mp4	5.4 MB
2. Exercise 11 Subqueries.vtt	1.7 KB
/14. Views and Indexes/
1. VIEWS.mp4	44.6 MB
1. VIEWS.vtt	8.1 KB
1.1 Lecture_32_VIEWS.pdf.pdf	226.0 KB
2. INDEX.mp4	42.3 MB
2. INDEX.vtt	8.4 KB
2.1 Lecture_33_INDEX.pdf.pdf	206.4 KB
3. Exercise 12 Views.mp4	3.4 MB
3. Exercise 12 Views.vtt	1.1 KB
/15. String Functions/
1. LENGTH.mp4	19.5 MB
1. LENGTH.vtt	3.9 KB
1.1 Lecture_34_STRING functions.pdf.pdf	214.5 KB
2. UPPER LOWER.mp4	12.2 MB
2. UPPER LOWER.vtt	2.9 KB
3. REPLACE.mp4	26.5 MB
3. REPLACE.vtt	4.7 KB
4. TRIM, LTRIM, RTRIM.mp4	52.4 MB
4. TRIM, LTRIM, RTRIM.vtt	8.1 KB
5. CONCATENATION.mp4	17.7 MB
5. CONCATENATION.vtt	3.2 KB
6. SUBSTRING.mp4	44.3 MB
6. SUBSTRING.vtt	6.2 KB
7. LIST AGGREGATION.mp4	34.7 MB
7. LIST AGGREGATION.vtt	5.6 KB
8. Exercise 13 String Functions.mp4	17.3 MB
8. Exercise 13 String Functions.vtt	3.3 KB
/16. Mathematical Functions/
1. CEIL & FLOOR.mp4	22.0 MB
1. CEIL & FLOOR.vtt	4.0 KB
1.1 Lecture_35_MATH functions.pdf.pdf	197.5 KB
2. RANDOM.mp4	32.9 MB
2. RANDOM.vtt	5.6 KB
3. SETSEED.mp4	26.0 MB
3. SETSEED.vtt	3.8 KB
4. ROUND.mp4	17.6 MB
4. ROUND.vtt	2.6 KB
5. POWER.mp4	12.7 MB
5. POWER.vtt	2.6 KB
6. Exercise 14 Mathematical Functions.mp4	10.8 MB
6. Exercise 14 Mathematical Functions.vtt	2.1 KB
/17. Date-Time Functions/
1. CURRENT DATE & TIME.mp4	33.9 MB
1. CURRENT DATE & TIME.vtt	5.3 KB
1.1 Lecture_36_DATETIME functions.pdf.pdf	238.0 KB
2. AGE.mp4	27.9 MB
2. AGE.vtt	3.5 KB
3. EXTRACT.mp4	61.5 MB
3. EXTRACT.vtt	8.5 KB
4. Exercise 15 Date-time functions.mp4	6.0 MB
4. Exercise 15 Date-time functions.vtt	1.6 KB
/18. PATTERN (STRING) MATCHING/
1. PATTERN MATCHING BASICS.mp4	42.9 MB
1. PATTERN MATCHING BASICS.vtt	9.6 KB
1.1 Lecture_Pattern_Matching.pdf.pdf	244.6 KB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4	108.1 MB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).vtt	15.7 KB
2.1 User_table.txt.txt	0.2 KB
3. Exercise 16 Pattern Matching.mp4	8.7 MB
3. Exercise 16 Pattern Matching.vtt	2.3 KB
/19. Data Type conversion functions/
1. Converting Numbers Date to String.mp4	76.7 MB
1. Converting Numbers Date to String.vtt	10.9 KB
1.1 Lecture_37_Conversion functions.pdf.pdf	224.9 KB
2. Converting String to Numbers Date.mp4	40.9 MB
2. Converting String to Numbers Date.vtt	5.3 KB
/2. Installation and getting started/
1. Installation.mp4	47.8 MB
1. Installation.vtt	6.3 KB
1.1 Installing PostgreSQL on Mac.pdf.pdf	214.9 KB
/20. User Access Control Functions/
1. User Access Control.mp4	84.4 MB
1. User Access Control.vtt	13.8 KB
1.1 Lecture_38_ACCESS control.pdf.pdf	212.9 KB
/21. Bonus Section Nail that Interview!/
1. Tablespace.mp4	38.0 MB
1. Tablespace.vtt	6.1 KB
1.1 Lecture_TABLESPACE.pdf.pdf	193.2 KB
2. PRIMARY KEY & FOREIGN KEY.mp4	26.6 MB
2. PRIMARY KEY & FOREIGN KEY.vtt	7.2 KB
2.1 Lecture_5_Keys.pdf.pdf	240.2 KB
3. ACID compliance.mp4	44.7 MB
3. ACID compliance.vtt	8.5 KB
3.1 Lecture_ACID.pdf.pdf	195.3 KB
4. Truncate.mp4	22.1 MB
4. Truncate.vtt	4.6 KB
4.1 Lecture_TRUNCATE.pdf.pdf	164.4 KB
5. Practice Test 1.html	0.2 KB
/22. Performance tuning tips/
1. TIP 1 (EXPLAIN).mp4	26.7 MB
1. TIP 1 (EXPLAIN).vtt	3.8 KB
1.1 Lecture_Performance_Tuning.pdf.pdf	291.8 KB
2. TIP 2.mp4	6.1 MB
2. TIP 2.vtt	1.5 KB
3. TIP 3.mp4	15.0 MB
3. TIP 3.vtt	3.4 KB
4. TIP 4 (VACCUM).mp4	3.0 MB
4. TIP 4 (VACCUM).vtt	0.7 KB
5. TIP 5.mp4	12.0 MB
5. TIP 5.vtt	2.8 KB
6. TIP 6 (STRING FUNCTIONS).mp4	14.4 MB
6. TIP 6 (STRING FUNCTIONS).vtt	2.9 KB
7. TIP 7 (JOINS).mp4	11.3 MB
7. TIP 7 (JOINS).vtt	2.4 KB
8. TIP 8 (SCHEMAS).mp4	33.5 MB
8. TIP 8 (SCHEMAS).vtt	5.4 KB
/23. Practice Problems/
1. Practice Problem 1.html	0.2 KB
/24. Bonus Section Database Basics/
1. What is SQL.mp4	11.3 MB
1. What is SQL.vtt	2.6 KB
1.1 Lecture_1.pdf.pdf	225.6 KB
2. Tables and DBMS.mp4	18.2 MB
2. Tables and DBMS.vtt	4.0 KB
2.1 Lecture_2.pdf.pdf	296.4 KB
3. Types of SQL commands.mp4	26.5 MB
3. Types of SQL commands.vtt	5.7 KB
3.1 Lecture_3_Queries.pdf.pdf	213.4 KB
4. PostgreSQL.mp4	18.0 MB
4. PostgreSQL.vtt	3.3 KB
4.1 Lecture_5_Postgresql.pdf.pdf	221.6 KB
5. Bonus Lecture Our other courses for you.html	0.9 KB
6. Bonus Lecture.html	1.4 KB
/3. Case Study Demo/
1. Case Study Part 1.mp4	29.3 MB
1. Case Study Part 1.vtt	5.4 KB
2. Case Study Part 2.mp4	53.7 MB
2. Case Study Part 2.vtt	7.5 KB
/4. Fundamental SQL statements/
1. CREATE.mp4	66.9 MB
1. CREATE.vtt	13.8 KB
1.1 Lecture_04_create_Queries.pdf.pdf	224.6 KB
10. Logical Operators.mp4	43.9 MB
10. Logical Operators.vtt	5.7 KB
10.1 Lecture_09_AND&OR.pdf.pdf	180.6 KB
11. Exercise 3 SELECT & WHERE.mp4	7.5 MB
11. Exercise 3 SELECT & WHERE.vtt	1.7 KB
12. UPDATE.mp4	39.5 MB
12. UPDATE.vtt	4.6 KB
12.1 Lecture_10_UPDATEDelete.pdf.pdf	216.1 KB
13. DELETE.mp4	30.7 MB
13. DELETE.vtt	4.5 KB
14. ALTER.mp4	131.9 MB
14. ALTER.vtt	16.1 KB
14.1 Lecture_11_ALTER.pdf.pdf	206.6 KB
15. Exercise 4 Updating Table.mp4	4.1 MB
15. Exercise 4 Updating Table.vtt	1.3 KB
16. Fundamental SQL statements.html	0.2 KB
2. Exercise 1 Create DB and Table.mp4	6.2 MB
2. Exercise 1 Create DB and Table.vtt	2.2 KB
3. Solutions to all Exercises.html	0.1 KB
3.1 Solution.pdf.pdf	751.5 KB
4. INSERT.mp4	59.1 MB
4. INSERT.vtt	8.8 KB
4.1 Lecture_06_INSERT and COPY.pdf.pdf	224.5 KB
5. Import data from File.mp4	34.2 MB
5. Import data from File.vtt	5.2 KB
5.1 copy.csv.csv	0.1 KB
5.2 copytext.txt.txt	0.1 KB
6. Exercise 2 Inserting and Importing.mp4	4.8 MB
6. Exercise 2 Inserting and Importing.vtt	1.0 KB
6.1 Student.csv.csv	0.1 KB
7. SELECT statement.mp4	28.4 MB
7. SELECT statement.vtt	4.0 KB
7.1 Lecture_07_SELECT & DISTINCT.pdf.pdf	183.5 KB
8. SELECT DISTINCT.mp4	45.3 MB
8. SELECT DISTINCT.vtt	6.1 KB
9. WHERE.mp4	29.0 MB
9. WHERE.vtt	4.0 KB
9.1 Lecture_08_WHERE.pdf.pdf	179.8 KB
/5. Restore and Back-up/
1. Restore and Back-up.mp4	75.6 MB
1. Restore and Back-up.vtt	8.4 KB
1.1 Supermart_DB_new.zip.zip	304.9 KB
2. CSV files.html	0.2 KB
2.1 Sales.csv.csv	1.0 MB
2.2 Customer.csv.csv	65.6 KB
2.3 Product.csv.csv	142.8 KB
3. Exercise 5 Restore and Back-up.mp4	3.2 MB
3. Exercise 5 Restore and Back-up.vtt	1.1 KB
/6. Selection commands Filtering/
1. IN.mp4	30.8 MB
1. IN.vtt	4.5 KB
1.1 Lecture_12_IN_12.pdf.pdf	161.2 KB
2. BETWEEN.mp4	52.1 MB
2. BETWEEN.vtt	5.4 KB
2.1 Lecture_13_BETWEEN.pdf.pdf	192.1 KB
3. LIKE.mp4	64.1 MB
3. LIKE.vtt	10.3 KB
3.1 Lecture_14_LIKE.pdf.pdf	177.8 KB
4. Exercise 6 In, Like & Between.mp4	5.5 MB
4. Exercise 6 In, Like & Between.vtt	0.9 KB
/7. Selection commands Ordering/
1. Side Lecture Commenting in SQL.mp4	12.9 MB
1. Side Lecture Commenting in SQL.vtt	1.7 KB
2. ORDER BY.mp4	74.8 MB
2. ORDER BY.vtt	8.6 KB
2.1 Lecture_15_ORDER BY.pdf.pdf	184.5 KB
3. LIMIT.mp4	31.0 MB
3. LIMIT.vtt	4.2 KB
3.1 Lecture_16_LIMIT.pdf.pdf	166.0 KB
4. Exercise 7 Sorting.mp4	3.3 MB
4. Exercise 7 Sorting.vtt	0.9 KB
/8. Alias/
1. AS.mp4	26.8 MB
1. AS.vtt	4.2 KB
1.1 Lecture_17_AS.pdf.pdf	155.4 KB
1.2 Lecture_17_AS.pdf.pdf	155.4 KB
/9. Aggregate Commands/
1. COUNT.mp4	40.2 MB
1. COUNT.vtt	5.7 KB
1.1 Lecture_18_count.pdf.pdf	162.0 KB
2. SUM.mp4	22.1 MB
2. SUM.vtt	3.1 KB
2.1 Lecture_19_SUM.pdf.pdf	166.8 KB
3. AVERAGE.mp4	18.4 MB
3. AVERAGE.vtt	2.9 KB
3.1 Lecture_20_AVG.pdf.pdf	161.3 KB
4. MIN & MAX.mp4	34.1 MB
4. MIN & MAX.vtt	3.9 KB
4.1 Lecture_21_MIN&MAX.pdf.pdf	168.1 KB
5. Exercise 8 Aggregate functions.mp4	6.8 MB
5. Exercise 8 Aggregate functions.vtt	1.7 KB
/
[Tutorialsplanet.NET].url	0.1 KB
Total files 252