GetFreeCourses Co Udemy SQL Masterclass SQL for Data Analytics | A77F9FF0D66EB3B2E48D12C30A40DCD3EF062DE0

GetFreeCourses Co Udemy SQL Masterclass SQL for Data Analytics

Name	GetFreeCourses.Co-Udemy-SQL Masterclass SQL for Data Analytics	DOWNLOAD Copy Link
Total Size	4.1 GB
Total Files	289
Last Seen	2024-11-08 00:38
Hash	A77F9FF0D66EB3B2E48D12C30A40DCD3EF062DE0

/1. Introduction/
1. Introduction.mp4	31.1 MB
1. Introduction.srt	5.0 KB
/10. Group By Commands/
1. GROUP BY.mp4	97.9 MB
1. GROUP BY.srt	14.1 KB
1.1 Lecture_22_group by.pdf	178.8 KB
2. HAVING.mp4	39.7 MB
2. HAVING.srt	5.5 KB
2.1 Lecture_23_HAVING.pdf	170.5 KB
3. Exercise 9 Group By.mp4	6.5 MB
3. Exercise 9 Group By.srt	1.8 KB
4. Quiz.html	0.2 KB
/11. Conditional Statement/
1. CASE WHEN.mp4	29.9 MB
1. CASE WHEN.srt	6.8 KB
1.1 Lecture_CASE.pdf	163.9 KB
GetFreeCourses.Co.url	0.1 KB
/12. JOINS/
1. Introduction to Joins.mp4	8.3 MB
1. Introduction to Joins.srt	3.2 KB
1.1 Lecture_24_Joins_Query.txt	0.4 KB
10. Except.mp4	13.3 MB
10. Except.srt	3.6 KB
10.1 Lecture_29_EXCEPT.pdf	178.1 KB
11. Union.mp4	15.9 MB
11. Union.srt	3.6 KB
11.1 Lecture_30_UNION.pdf	170.9 KB
12. Exercise 10 Joins.mp4	7.2 MB
12. Exercise 10 Joins.srt	1.8 KB
13. Quiz.html	0.2 KB
2. Concepts of Joining and Combining Data.mp4	62.7 MB
2. Concepts of Joining and Combining Data.srt	13.7 KB
3. Preparing the data.mp4	14.5 MB
3. Preparing the data.srt	2.4 KB
3.1 M3_T1_V3 Joins_Query.txt	0.4 KB
4. Inner Join.mp4	49.4 MB
4. Inner Join.srt	8.2 KB
4.1 Lecture_24_INNER join.pdf	219.3 KB
5. Left Join.mp4	38.6 MB
5. Left Join.srt	8.6 KB
5.1 Lecture_25_LEFT join.pdf	224.3 KB
6. Right Join.mp4	37.8 MB
6. Right Join.srt	6.8 KB
6.1 Lecture_26_RIGHT join.pdf	227.2 KB
7. Full Outer Join.mp4	33.6 MB
7. Full Outer Join.srt	5.0 KB
7.1 Lecture_27_OUTER join.pdf	224.4 KB
8. Cross Join.mp4	19.7 MB
8. Cross Join.srt	5.4 KB
8.1 Lecture_28_Cross join.pdf	191.2 KB
9. Intersect and Intersect ALL.mp4	25.9 MB
9. Intersect and Intersect ALL.srt	7.8 KB
/13. Subqueries/
1. Subqueries.mp4	108.9 MB
1. Subqueries.srt	19.9 KB
1.1 Lecture_31_SUBQUERY.pdf	212.4 KB
2. Exercise 11 Subqueries.mp4	5.4 MB
2. Exercise 11 Subqueries.srt	2.0 KB
/14. Views and Indexes/
1. VIEWS.mp4	44.6 MB
1. VIEWS.srt	9.9 KB
1.1 Lecture_32_VIEWS.pdf	226.0 KB
2. INDEX.mp4	42.3 MB
2. INDEX.srt	10.1 KB
2.1 Lecture_33_INDEX.pdf	206.4 KB
3. Exercise 12 Views.mp4	3.4 MB
3. Exercise 12 Views.srt	1.3 KB
/15. String Functions/
1. LENGTH.mp4	19.5 MB
1. LENGTH.srt	4.7 KB
1.1 Lecture_34_STRING functions.pdf	214.5 KB
2. UPPER LOWER.mp4	12.2 MB
2. UPPER LOWER.srt	3.5 KB
3. REPLACE.mp4	26.5 MB
3. REPLACE.srt	5.6 KB
4. TRIM, LTRIM, RTRIM.mp4	52.4 MB
4. TRIM, LTRIM, RTRIM.srt	9.9 KB
5. CONCATENATION.mp4	17.7 MB
5. CONCATENATION.srt	3.9 KB
6. SUBSTRING.mp4	44.4 MB
6. SUBSTRING.srt	7.6 KB
7. LIST AGGREGATION.mp4	34.7 MB
7. LIST AGGREGATION.srt	6.8 KB
8. Exercise 13 String Functions.mp4	17.3 MB
8. Exercise 13 String Functions.srt	3.9 KB
/16. Mathematical Functions/
1. CEIL & FLOOR.mp4	22.0 MB
1. CEIL & FLOOR.srt	4.9 KB
1.1 Lecture_35_MATH functions.pdf	197.5 KB
2. RANDOM.mp4	32.9 MB
2. RANDOM.srt	6.8 KB
3. SETSEED.mp4	26.0 MB
3. SETSEED.srt	4.6 KB
4. ROUND.mp4	17.6 MB
4. ROUND.srt	3.2 KB
5. POWER.mp4	12.7 MB
5. POWER.srt	3.2 KB
6. Exercise 14 Mathematical Functions.mp4	10.8 MB
6. Exercise 14 Mathematical Functions.srt	2.6 KB
GetFreeCourses.Co.url	0.1 KB
/17. Date-Time Functions/
1. CURRENT DATE & TIME.mp4	33.9 MB
1. CURRENT DATE & TIME.srt	6.4 KB
1.1 Lecture_36_DATETIME functions.pdf	238.0 KB
2. AGE.mp4	27.9 MB
2. AGE.srt	4.3 KB
3. EXTRACT.mp4	61.5 MB
3. EXTRACT.srt	10.5 KB
4. Exercise 15 Date-time functions.mp4	6.0 MB
4. Exercise 15 Date-time functions.srt	2.0 KB
/18. PATTERN (STRING) MATCHING/
1. PATTERN MATCHING BASICS.mp4	42.9 MB
1. PATTERN MATCHING BASICS.srt	11.5 KB
1.1 Lecture_Pattern_Matching.pdf	244.6 KB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4	108.1 MB
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt	18.9 KB
2.1 User_table.txt	0.2 KB
3. Exercise 16 Pattern Matching.mp4	8.7 MB
3. Exercise 16 Pattern Matching.srt	2.8 KB
/19. Window Functions/
1. Introduction to Window functions.mp4	60.5 MB
1. Introduction to Window functions.srt	10.6 KB
1.1 Windows Function PPT.pdf	631.5 KB
10. LAG and LEAD.mp4	74.1 MB
10. LAG and LEAD.srt	8.7 KB
2. Introduction to Row number.mp4	39.4 MB
2. Introduction to Row number.srt	6.2 KB
3. Implementing Row number in SQL.mp4	182.7 MB
3. Implementing Row number in SQL.srt	19.7 KB
4. RANK and DENSERANK.mp4	57.4 MB
4. RANK and DENSERANK.srt	7.8 KB
5. NTILE function.mp4	69.9 MB
5. NTILE function.srt	7.1 KB
6. AVERAGE function.mp4	61.8 MB
6. AVERAGE function.srt	8.2 KB
7. COUNT.mp4	33.2 MB
7. COUNT.srt	4.1 KB
8. SUM TOTAL.mp4	91.7 MB
8. SUM TOTAL.srt	11.1 KB
9. RUNNING TOTAL.mp4	67.3 MB
9. RUNNING TOTAL.srt	7.4 KB
/2. Installation and getting started/
1. Installing PostgreSQL and pgAdmin in your PC.mp4	71.4 MB
1. Installing PostgreSQL and pgAdmin in your PC.srt	13.3 KB
1.1 00 Debugging PostgreSQL installation issues.pdf	259.5 KB
1.2 Installing+PostgreSQL+on+Mac.pdf	214.9 KB
2. This is a milestone!.mp4	21.7 MB
2. This is a milestone!.srt	4.0 KB
3. If pgAdmin is not opening....html	1.6 KB
4. Course Resources.html	0.4 KB
/20. COALESCE function/
1. COALESCE function.mp4	44.7 MB
1. COALESCE function.srt	6.3 KB
1.1 Windows Function PPT.pdf	631.5 KB
GetFreeCourses.Co.url	0.1 KB
/21. Data Type conversion functions/
1. Converting Numbers Date to String.mp4	76.7 MB
1. Converting Numbers Date to String.srt	13.4 KB
1.1 Lecture_37_Conversion functions.pdf	224.9 KB
2. Converting String to Numbers Date.mp4	40.9 MB
2. Converting String to Numbers Date.srt	6.5 KB
/22. User Access Control Functions/
1. User Access Control.mp4	84.4 MB
1. User Access Control.srt	16.6 KB
1.1 Lecture_38_ACCESS control.pdf	212.9 KB
/23. Nail that Interview!/
1. Tablespace.mp4	38.0 MB
1. Tablespace.srt	7.3 KB
1.1 Lecture_TABLESPACE.pdf	193.2 KB
2. PRIMARY KEY & FOREIGN KEY.mp4	26.6 MB
2. PRIMARY KEY & FOREIGN KEY.srt	8.8 KB
2.1 Lecture_5_Keys.pdf	240.2 KB
3. ACID compliance.mp4	44.8 MB
3. ACID compliance.srt	10.5 KB
3.1 Lecture_ACID.pdf	195.3 KB
4. Truncate.mp4	22.1 MB
4. Truncate.srt	5.5 KB
4.1 Lecture_TRUNCATE.pdf	164.4 KB
5. Practice Test 1.html	0.2 KB
6. SQL Quiz.html	0.2 KB
GetFreeCourses.Co.url	0.1 KB
/24. Performance tuning tips/
1. TIP 1 (EXPLAIN).mp4	26.7 MB
1. TIP 1 (EXPLAIN).srt	4.3 KB
1.1 Lecture_Performance_Tuning.pdf	291.8 KB
2. TIP 2.mp4	6.1 MB
2. TIP 2.srt	1.8 KB
3. TIP 3.mp4	15.0 MB
3. TIP 3.srt	4.2 KB
4. TIP 4 (VACCUM).mp4	3.0 MB
4. TIP 4 (VACCUM).srt	0.8 KB
5. TIP 5.mp4	12.0 MB
5. TIP 5.srt	3.5 KB
6. TIP 6 (STRING FUNCTIONS).mp4	14.4 MB
6. TIP 6 (STRING FUNCTIONS).srt	3.5 KB
7. TIP 7 (JOINS).mp4	11.3 MB
7. TIP 7 (JOINS).srt	2.9 KB
8. TIP 8 (SCHEMAS).mp4	33.5 MB
8. TIP 8 (SCHEMAS).srt	6.4 KB
/25. Final Section Database Basics/
1. What is SQL.mp4	9.1 MB
1. What is SQL.srt	2.4 KB
2. Tables and DBMS.mp4	15.4 MB
2. Tables and DBMS.srt	3.7 KB
3. Types of SQL commands.mp4	23.1 MB
3. Types of SQL commands.srt	5.7 KB
4. PostgreSQL.mp4	14.8 MB
4. PostgreSQL.srt	3.5 KB
5. The final milestone!.mp4	12.4 MB
5. The final milestone!.srt	1.8 KB
6. Bonus Lecture.html	2.4 KB
/3. Case Study Demo/
1. Case Study Part 1 - Business problems.mp4	39.6 MB
1. Case Study Part 1 - Business problems.srt	5.5 KB
2. Case Study Part 2 - How SQL is Used.mp4	61.8 MB
2. Case Study Part 2 - How SQL is Used.srt	7.6 KB
/4. Fundamental SQL statements/
1. CREATE.mp4	95.6 MB
1. CREATE.srt	14.8 KB
10. Logical Operators.mp4	52.9 MB
10. Logical Operators.srt	6.1 KB
11. Exercise 3 SELECT & WHERE.mp4	7.5 MB
11. Exercise 3 SELECT & WHERE.srt	2.1 KB
12. UPDATE.mp4	39.5 MB
12. UPDATE.srt	5.7 KB
12.1 Lecture_10_UPDATEDelete.pdf	216.1 KB
13. DELETE.mp4	30.7 MB
13. DELETE.srt	5.6 KB
14. ALTER.mp4	131.9 MB
14. ALTER.srt	19.8 KB
14.1 Lecture_11_ALTER.pdf	206.6 KB
15. Exercise 4 Updating Table.mp4	4.1 MB
15. Exercise 4 Updating Table.srt	1.5 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.srt	2.7 KB
3. Solutions to all Exercises.html	0.1 KB
3.1 Solution.pdf	751.5 KB
4. INSERT.mp4	76.6 MB
4. INSERT.srt	9.8 KB
5. Import data from File.mp4	44.0 MB
5. Import data from File.srt	5.6 KB
6. Exercise 2 Inserting and Importing.mp4	4.8 MB
6. Exercise 2 Inserting and Importing.srt	1.2 KB
6.1 Student.csv	0.1 KB
7. SELECT statement.mp4	33.4 MB
7. SELECT statement.srt	4.7 KB
8. SELECT DISTINCT.mp4	48.4 MB
8. SELECT DISTINCT.srt	6.2 KB
9. WHERE.mp4	34.1 MB
9. WHERE.srt	4.2 KB
/5. Restore and Back-up/
1. Restore and Back-up.mp4	75.6 MB
1. Restore and Back-up.srt	10.1 KB
1.1 BackupFiles.zip	599.9 KB
1.2 Supermart_DB.tar	1.2 MB
2. Debugging restoration issues.mp4	52.6 MB
2. Debugging restoration issues.srt	10.0 KB
3. Creating DB using CSV files.mp4	37.2 MB
3. Creating DB using CSV files.srt	6.5 KB
4. Debugging summary and Code for CSV files.html	2.5 KB
4.1 Customer.csv	65.6 KB
4.2 Product.csv	143.0 KB
4.3 Sales.csv	1.0 MB
5. Exercise 5 Restore and Back-up.mp4	3.1 MB
5. Exercise 5 Restore and Back-up.srt	1.3 KB
/6. Selection commands Filtering/
1. IN.mp4	30.8 MB
1. IN.srt	5.4 KB
1.1 Lecture_12_IN_12.pdf	161.2 KB
2. BETWEEN.mp4	52.1 MB
2. BETWEEN.srt	6.7 KB
2.1 Lecture_13_BETWEEN.pdf	192.1 KB
3. LIKE.mp4	64.1 MB
3. LIKE.srt	12.6 KB
3.1 Lecture_14_LIKE.pdf	177.8 KB
4. Exercise 6 In, Like & Between.mp4	5.5 MB
4. Exercise 6 In, Like & Between.srt	1.0 KB
GetFreeCourses.Co.url	0.1 KB
/7. Selection commands Ordering/
1. Side Lecture Commenting in SQL.mp4	12.9 MB
1. Side Lecture Commenting in SQL.srt	2.0 KB
2. ORDER BY.mp4	74.8 MB
2. ORDER BY.srt	10.6 KB
2.1 Lecture_15_ORDER BY.pdf	184.5 KB
3. LIMIT.mp4	31.0 MB
3. LIMIT.srt	5.2 KB
3.1 Lecture_16_LIMIT.pdf	166.0 KB
4. Exercise 7 Sorting.mp4	3.3 MB
4. Exercise 7 Sorting.srt	1.1 KB
/8. Alias/
1. AS.mp4	26.8 MB
1. AS.srt	5.0 KB
1.1 Lecture_17_AS.pdf	155.4 KB
1.2 Lecture_17_AS.pdf	155.4 KB
/9. Aggregate Commands/
1. COUNT.mp4	40.2 MB
1. COUNT.srt	6.9 KB
1.1 Lecture_18_count.pdf	162.0 KB
2. SUM.mp4	22.1 MB
2. SUM.srt	3.8 KB
2.1 Lecture_19_SUM.pdf	166.8 KB
3. AVERAGE.mp4	18.4 MB
3. AVERAGE.srt	3.5 KB
3.1 Lecture_20_AVG.pdf	161.3 KB
4. MIN & MAX.mp4	34.1 MB
4. MIN & MAX.srt	4.9 KB
4.1 Lecture_21_MIN&MAX.pdf	168.1 KB
5. Exercise 8 Aggregate functions.mp4	6.7 MB
5. Exercise 8 Aggregate functions.srt	2.0 KB
6. Quiz.html	0.2 KB
/
Download Paid Udemy Courses For Free.url	0.1 KB
GetFreeCourses.Co.url	0.1 KB
Total files 289