Other
[ FreeCourseWeb com ] Udemy - SQL Masterclass - SQL for Data Analytics
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.00 GB) (Files: 263)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Introduction
1. Course Overview.mp4
1. Course Overview.srt
10. Group By Commands
1. GROUP BY.mp4
1. GROUP BY.srt
2. HAVING.mp4
2. HAVING.srt
3. Exercise 9 Group By.mp4
3. Exercise 9 Group By.srt
11. Conditional Statement
1. CASE WHEN.mp4
1. CASE WHEN.srt
12. JOINS
1. Introduction to Joins.mp4
1. Introduction to Joins.srt
10. Except.mp4
10. Except.srt
11. Union.mp4
11. Union.srt
12. Exercise 10 Joins.mp4
12. Exercise 10 Joins.srt
2. Concepts of Joining and Combining Data.mp4
2. Concepts of Joining and Combining Data.srt
3. Preparing the data.mp4
3. Preparing the data.srt
4. Inner Join.mp4
4. Inner Join.srt
5. Left Join.mp4
5. Left Join.srt
6. Right Join.mp4
6. Right Join.srt
7. Full Outer Join.mp4
7. Full Outer Join.srt
8. Cross Join.mp4
8. Cross Join.srt
9. Intersect and Intersect ALL.mp4
9. Intersect and Intersect ALL.srt
13. Subqueries
1. Subqueries.mp4
1. Subqueries.srt
2. Exercise 11 Subqueries.mp4
2. Exercise 11 Subqueries.srt
14. Views and Indexes
1. VIEWS.mp4
1. VIEWS.srt
2. INDEX.mp4
2. INDEX.srt
3. Exercise 12 Views.mp4
3. Exercise 12 Views.srt
15. String Functions
1. LENGTH.mp4
1. LENGTH.srt
2. UPPER LOWER.mp4
2. UPPER LOWER.srt
3. REPLACE.mp4
3. REPLACE.srt
4. TRIM, LTRIM, RTRIM.mp4
4. TRIM, LTRIM, RTRIM.srt
5. CONCATENATION.mp4
5. CONCATENATION.srt
6. SUBSTRING.mp4
6. SUBSTRING.srt
7. LIST AGGREGATION.mp4
7. LIST AGGREGATION.srt
8. Exercise 13 String Functions.mp4
8. Exercise 13 String Functions.srt
16. Mathematical Functions
1. CEIL & FLOOR.mp4
1. CEIL & FLOOR.srt
2. RANDOM.mp4
2. RANDOM.srt
3. SETSEED.mp4
3. SETSEED.srt
4. ROUND.mp4
4. ROUND.srt
5. POWER.mp4
5. POWER.srt
6. Exercise 14 Mathematical Functions.mp4
6. Exercise 14 Mathematical Functions.srt
17. Date-Time Functions
1. CURRENT DATE & TIME.mp4
1. CURRENT DATE & TIME.srt
2. AGE.mp4
2. AGE.srt
3. EXTRACT.mp4
3. EXTRACT.srt
4. Exercise 15 Date-time functions.mp4
4. Exercise 15 Date-time functions.srt
18. PATTERN (STRING) MATCHING
1. PATTERN MATCHING BASICS.mp4
1. PATTERN MATCHING BASICS.srt
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4
2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt
3. Exercise 16 Pattern Matching.mp4
3. Exercise 16 Pattern Matching.srt
19. Data Type conversion functions
1. Converting Numbers Date to String.mp4
1. Converting Numbers Date to String.srt
2. Converting String to Numbers Date.mp4
2. Converting String to Numbers Date.srt
2. Installation and getting started
1. This is a milestone!.mp4
1. This is a milestone!.srt
2. Installing and setting up PostgreSQL.mp4
2. Installing and setting up PostgreSQL.srt
20. User Access Control Functions
1. User Access Control.mp4
1. User Access Control.srt
21. Bonus Section Nail that Interview!
1. Tablespace.mp4
1. Tablespace.srt
2. PRIMARY KEY & FOREIGN KEY.mp4
2. PRIMARY KEY & FOREIGN KEY.srt
3. ACID compliance.mp4
3. ACID compliance.srt
4. Truncate.mp4
4. Truncate.srt
22. Performance tuning tips
1. TIP 1 (EXPLAIN).mp4
1. TIP 1 (EXPLAIN).srt
2. TIP 2.mp4
2. TIP 2.srt
3. TIP 3.mp4
3. TIP 3.srt
4. TIP 4 (VACCUM).mp4
4. TIP 4 (VACCUM).srt
5. TIP 5.mp4
5. TIP 5.srt
6. TIP 6 (STRING FUNCTIONS).mp4
6. TIP 6 (STRING FUNCTIONS).srt
7. TIP 7 (JOINS).mp4
7. TIP 7 (JOINS).srt
8. TIP 8 (SCHEMAS).mp4
8. TIP 8 (SCHEMAS).srt
23. Bonus Section Database Basics
1. What is SQL.mp4
1. What is SQL.srt
2. Tables and DBMS.mp4
2. Tables and DBMS.srt
3. Types of SQL commands.mp4
3. Types of SQL commands.srt
4. PostgreSQL.mp4
4. PostgreSQL.srt
5. The final milestone!.mp4
5. The final milestone!.srt
3. Case Study Demo
1. Case Study Part 1.mp4
1. Case Study Part 1.srt
2. Case Study Part 2.mp4
2. Case Study Part 2.srt
4. Fundamental SQL statements
1. CREATE.mp4
1. CREATE.srt
10. Exercise 3 SELECT & WHERE.mp4
10. Exercise 3 SELECT & WHERE.srt
11. UPDATE.mp4
11. UPDATE.srt
12. DELETE.mp4
12. DELETE.srt
13. ALTER.mp4
13. ALTER.srt
14. Exercise 4 Updating Table.mp4
14. Exercise 4 Updating Table.srt
2. Exercise 1 Create DB and Table.mp4
2. Exercise 1 Create DB and Table.srt
3. INSERT.mp4
3. INSERT.srt
4. Import data from File.mp4
4. Import data from File.srt
5. Exercise 2 Inserting and Importing.mp4
5. Exercise 2 Inserting and Importing.srt
6. SELECT statement.mp4
6. SELECT statement.srt
7. SELECT DISTINCT.mp4
7. SELECT DISTINCT.srt
8. WHERE.mp4
8. WHERE.srt
9. Logical Operators.mp4
9. Logical Operators.srt
5. Restore and Back-up
1. Restore and Back-up.mp4
1. Restore and Back-up.srt
2. Debugging restoration issues.mp4
2. Debugging restoration issues.srt
3. Creating DB using CSV files.mp4
3. Creating DB using CSV files.srt
4. Exercise 5 Restore and Back-up.mp4
4. Exercise 5 Restore and Back-up.srt
6. Selection commands Filtering
1. IN.mp4
1. IN.srt
2. BETWEEN.mp4
2. BETWEEN.srt
3. LIKE.mp4
3. LIKE.srt
4. Exercise 6 In, Like & Between.mp4
4. Exercise 6 In, Like & Between.srt
7. Selection commands Ordering
1. Side Lecture Commenting in SQL.mp4
1. Side Lecture Commenting in SQL.srt
2. ORDER BY.mp4
2. ORDER BY.srt
3. LIMIT.mp4
3. LIMIT.srt
4. Exercise 7 Sorting.mp4
4. Exercise 7 Sorting.srt
8. Alias
1. AS.mp4
1. AS.srt
9. Aggregate Commands
1. COUNT.mp4
1. COUNT.srt
2. SUM.mp4
2. SUM.srt
3. AVERAGE.mp4
3. AVERAGE.srt
4. MIN & MAX.mp4
4. MIN & MAX.srt
5. Exercise 8 Aggregate functions.mp4
5. Exercise 8 Aggregate functions.srt
Bonus Resources.txt
Resources
2828.dat
2829.dat
2830.dat
Customer.csv
Installing+PostgreSQL+on+Mac.pdf
IntroV_01.pdf
Lecture_04_create_Queries.pdf
Lecture_06_INSERT+and+COPY.pdf
Lecture_07_SELECT+&+DISTINCT.pdf
Lecture_08_WHERE.pdf
Lecture_09_AND&OR.pdf
Lecture_1.pdf
Lecture_10_UPDATEDelete.pdf
Lecture_11_ALTER.pdf
Lecture_12_IN_12.pdf
Lecture_13_BETWEEN.pdf
Lecture_14_LIKE.pdf
Lecture_15_ORDER+BY.pdf
Lecture_16_LIMIT.pdf
Lecture_17_AS.pdf
Lecture_18_count.pdf
Lecture_19_SUM.pdf
Lecture_2.pdf
Lecture_20_AVG.pdf
Lecture_21_MIN&MAX.pdf
Lecture_22_group+by.pdf
Lecture_23_HAVING.pdf
Lecture_24_INNER+join.pdf
Lecture_24_Joins_Query.txt
Lecture_25_LEFT+join.pdf
Lecture_26_RIGHT+join.pdf
Lecture_27_OUTER+join.pdf
Lecture_28_Cross+join.pdf
Lecture_29_EXCEPT.pdf
Lecture_30_UNION.pdf
Lecture_31_SUBQUERY.pdf
Lecture_32_VIEWS.pdf
Lecture_33_INDEX.pdf
Lecture_34_STRING+functions.pdf
Lecture_35_MATH+functions.pdf
Lecture_36_DATETIME+functions.pdf
Lecture_37_Conversion+functions (1).pdf
Lecture_37_Conversion+functions.pdf
Lecture_38_ACCESS+control.pdf
Lecture_3_Queries.pdf
Lecture_5_Postgresql.pdf
Lecture_ACID.pdf
Lecture_CASE.pdf
Lecture_Pattern_Matching (1).pdf
Lecture_Pattern_Matching.pdf
Lecture_Performance_Tuning.pdf
Lecture_TABLESPACE.pdf
M3_T1_V3+Joins_Query.txt
Product.csv
Sales.csv
Solution.pdf
Student.csv
User_table.txt
copy.csv
copytext.txt
restore.sql
supermart.backup
toc.dat
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ FreeCourseWeb com ] Udemy - SQL Masterclass - SQL for Data Analytics Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
