FreeCourseSite com Udemy SQL Masterclass SQL for Data Analytics | DBF65FB599CD24FFD7695707C47CF52AFAAE3A25

FreeCourseSite com Udemy SQL Masterclass SQL for Data Analytics

Name	[FreeCourseSite.com] Udemy - SQL Masterclass SQL for Data Analytics	DOWNLOAD Copy Link
Total Size	3.1 GB
Total Files	257
Hash	DBF65FB599CD24FFD7695707C47CF52AFAAE3A25

/0. Websites you may like/
[CourseClub.ME].url	0.1 KB
[FCS Forum].url	0.1 KB
[FreeCourseSite.com].url	0.1 KB
/1. Introduction/
1. Course Overview.mp4	30.8 MB
1. Course Overview.srt	7.6 KB
1.1 IntroV_01.pdf	724.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	168.6 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
/12. JOINS/
1. Introduction to Joins.mp4	18.6 MB
1. Introduction to Joins.srt	3.7 KB
1.1 Lecture_24_Joins_Query.txt	0.4 KB
10. Quiz.html	0.2 KB
2. Inner Join.mp4	62.2 MB
2. Inner Join.srt	10.4 KB
2.1 Lecture_24_INNER join.pdf	219.3 KB
3. Left Join.mp4	52.8 MB
3. Left Join.srt	10.4 KB
3.1 Lecture_25_LEFT join.pdf	224.3 KB
4. Right Join.mp4	51.0 MB
4. Right Join.srt	7.8 KB
4.1 Lecture_26_RIGHT join.pdf	227.2 KB
5. Full Outer Join.mp4	41.2 MB
5. Full Outer Join.srt	5.3 KB
5.1 Lecture_27_OUTER join.pdf	224.4 KB
6. Cross Join.mp4	27.2 MB
6. Cross Join.srt	6.2 KB
6.1 Lecture_28_Cross join.pdf	191.2 KB
7. Except.mp4	18.2 MB
7. Except.srt	4.1 KB
7.1 Lecture_29_EXCEPT.pdf	178.1 KB
8. Union.mp4	20.6 MB
8. Union.srt	4.4 KB
8.1 Lecture_30_UNION.pdf	170.9 KB
9. Exercise 10 Joins.mp4	7.2 MB
9. Exercise 10 Joins.srt	1.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.3 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
/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. 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
/2. Installation and getting started/
1. Installing and setting up PostgreSQL.mp4	61.5 MB
1. Installing and setting up PostgreSQL.srt	8.8 KB
1.1 Installing+PostgreSQL+on+Mac.pdf	214.9 KB
/20. 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
/21. Bonus Section 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
/22. 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
/23. Bonus Section Database Basics/
1. What is SQL.mp4	11.3 MB
1. What is SQL.srt	3.1 KB
1.1 Lecture_1.pdf	225.6 KB
2. Tables and DBMS.mp4	18.2 MB
2. Tables and DBMS.srt	4.8 KB
2.1 Lecture_2.pdf	296.4 KB
3. Types of SQL commands.mp4	26.5 MB
3. Types of SQL commands.srt	6.8 KB
3.1 Lecture_3_Queries.pdf	213.4 KB
4. PostgreSQL.mp4	18.0 MB
4. PostgreSQL.srt	3.9 KB
4.1 Lecture_5_Postgresql.pdf	221.6 KB
5. Congratulations & About your certificate.html	1.6 KB
6. Bonus Lecture.html	1.5 KB
/3. Case Study Demo/
1. Course Resources.html	0.4 KB
2. Case Study Part 1.mp4	29.3 MB
2. Case Study Part 1.srt	6.3 KB
3. Case Study Part 2.mp4	53.7 MB
3. Case Study Part 2.srt	8.9 KB
/4. Fundamental SQL statements/
1. CREATE.mp4	66.9 MB
1. CREATE.srt	16.6 KB
1.1 Lecture_04_create_Queries.pdf	224.6 KB
10. Logical Operators.mp4	43.9 MB
10. Logical Operators.srt	7.0 KB
10.1 Lecture_09_AND&OR.pdf	180.6 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	59.1 MB
4. INSERT.srt	10.7 KB
4.1 Lecture_06_INSERT and COPY.pdf	224.5 KB
5. Import data from File.mp4	34.2 MB
5. Import data from File.srt	6.2 KB
5.1 copytext.txt	0.1 KB
5.2 copy.csv	0.1 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	28.4 MB
7. SELECT statement.srt	4.8 KB
7.1 Lecture_07_SELECT & DISTINCT.pdf	183.5 KB
8. SELECT DISTINCT.mp4	45.3 MB
8. SELECT DISTINCT.srt	7.4 KB
9. WHERE.mp4	29.0 MB
9. WHERE.srt	4.8 KB
9.1 Lecture_08_WHERE.pdf	179.8 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. If your restore fails, then....html	1.4 KB
2.1 Product.csv	142.8 KB
2.2 Customer.csv	65.6 KB
2.3 Sales.csv	1.0 MB
3. Exercise 5 Restore and Back-up.mp4	3.1 MB
3. 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.2 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
/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.1 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
Total files 257