种子简介

种子名称： [FreeCourseSite.com] Udemy - SQL Masterclass SQL for Data Analytics
文件类型： 视频
文件数目： 110个文件
文件大小： 3.8 GB
收录时间： 2023-4-13 23:17
已经下载： 3次
资源热度： 101
最近下载： 2024-6-26 22:44

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:070bf60aaf1c84f3669dd01a44ab5044c2c26edf&dn=[FreeCourseSite.com] Udemy - SQL Masterclass SQL for Data Analytics 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseSite.com] Udemy - SQL Masterclass SQL for Data Analytics.torrent

1. Introduction/1. Introduction.mp429.65MB

10. Group By Commands/1. GROUP BY.mp493.33MB

10. Group By Commands/2. HAVING.mp437.91MB

10. Group By Commands/3. Exercise 9 Group By.mp46.17MB

11. Conditional Statement/1. CASE WHEN.mp428.52MB

12. JOINS/1. Introduction to Joins.mp47.93MB

12. JOINS/10. Except.mp412.67MB

12. JOINS/11. Union.mp415.13MB

12. JOINS/12. Exercise 10 Joins.mp46.9MB

12. JOINS/2. Concepts of Joining and Combining Data.mp459.79MB

12. JOINS/3. Preparing the data.mp413.86MB

12. JOINS/4. Inner Join.mp447.15MB

12. JOINS/5. Left Join.mp436.79MB

12. JOINS/6. Right Join.mp436MB

12. JOINS/7. Full Outer Join.mp432.07MB

12. JOINS/8. Cross Join.mp418.76MB

12. JOINS/9. Intersect and Intersect ALL.mp424.73MB

13. Subqueries/1. Subqueries.mp4103.85MB

13. Subqueries/2. Exercise 11 Subqueries.mp45.11MB

14. Views and Indexes/1. VIEWS.mp442.52MB

14. Views and Indexes/2. INDEX.mp440.34MB

14. Views and Indexes/3. Exercise 12 Views.mp43.2MB

15. String Functions/1. LENGTH.mp418.57MB

15. String Functions/2. UPPER LOWER.mp411.64MB

15. String Functions/3. REPLACE.mp425.26MB

15. String Functions/4. TRIM, LTRIM, RTRIM.mp449.97MB

15. String Functions/5. CONCATENATION.mp416.91MB

15. String Functions/6. SUBSTRING.mp442.3MB

15. String Functions/7. LIST AGGREGATION.mp433.08MB

15. String Functions/8. Exercise 13 String Functions.mp416.46MB

16. Mathematical Functions/1. CEIL & FLOOR.mp420.96MB

16. Mathematical Functions/2. RANDOM.mp431.41MB

16. Mathematical Functions/3. SETSEED.mp424.81MB

16. Mathematical Functions/4. ROUND.mp416.76MB

16. Mathematical Functions/5. POWER.mp412.12MB

16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp410.34MB

17. Date-Time Functions/1. CURRENT DATE & TIME.mp432.31MB

17. Date-Time Functions/2. AGE.mp426.64MB

17. Date-Time Functions/3. EXTRACT.mp458.65MB

17. Date-Time Functions/4. Exercise 15 Date-time functions.mp45.71MB

18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.mp440.93MB

18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4103.05MB

18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.mp48.31MB

19. Window Functions/1. Introduction to Window functions.mp457.68MB

19. Window Functions/10. LAG and LEAD.mp470.64MB

19. Window Functions/2. Introduction to Row number.mp437.54MB

19. Window Functions/3. Implementing Row number in SQL.mp4174.2MB

19. Window Functions/4. RANK and DENSERANK.mp454.72MB

19. Window Functions/5. NTILE function.mp466.64MB

19. Window Functions/6. AVERAGE function.mp458.92MB

19. Window Functions/7. COUNT.mp431.62MB

19. Window Functions/8. SUM TOTAL.mp487.45MB

19. Window Functions/9. RUNNING TOTAL.mp464.22MB

2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.mp468.13MB

2. Installation and getting started/2. This is a milestone!.mp420.66MB

20. COALESCE function/1. COALESCE function.mp442.61MB

21. Data Type conversion functions/1. Converting Numbers Date to String.mp473.18MB

21. Data Type conversion functions/2. Converting String to Numbers Date.mp439.04MB

22. User Access Control Functions/1. User Access Control.mp480.48MB

23. Nail that Interview!/1. Tablespace.mp436.28MB

23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp425.41MB

23. Nail that Interview!/3. ACID compliance.mp442.68MB

23. Nail that Interview!/4. Truncate.mp421.09MB

24. Performance tuning tips/1. TIP 1 (EXPLAIN).mp425.5MB

24. Performance tuning tips/2. TIP 2.mp45.8MB

24. Performance tuning tips/3. TIP 3.mp414.26MB

24. Performance tuning tips/4. TIP 4 (VACCUM).mp42.86MB

24. Performance tuning tips/5. TIP 5.mp411.46MB

24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).mp413.7MB

24. Performance tuning tips/7. TIP 7 (JOINS).mp410.81MB

24. Performance tuning tips/8. TIP 8 (SCHEMAS).mp431.97MB

25. Final Section Database Basics/1. What is SQL.mp48.66MB

25. Final Section Database Basics/2. Tables and DBMS.mp414.68MB

25. Final Section Database Basics/3. Types of SQL commands.mp422.07MB

25. Final Section Database Basics/4. PostgreSQL.mp414.11MB

25. Final Section Database Basics/5. The final milestone!.mp411.85MB

3. Case Study Demo/1. Case Study Part 1 - Business problems.mp437.75MB

3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.mp458.94MB

4. Fundamental SQL statements/1. CREATE.mp491.13MB

4. Fundamental SQL statements/10. Logical Operators.mp450.48MB

4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.mp47.18MB

4. Fundamental SQL statements/12. UPDATE.mp437.67MB

4. Fundamental SQL statements/13. DELETE.mp429.23MB

4. Fundamental SQL statements/14. ALTER.mp4125.75MB

4. Fundamental SQL statements/15. Exercise 4 Updating Table.mp43.93MB

4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.mp45.88MB

4. Fundamental SQL statements/4. INSERT.mp473.09MB

4. Fundamental SQL statements/5. Import data from File.mp442.01MB

4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.mp44.59MB

4. Fundamental SQL statements/7. SELECT statement.mp431.83MB

4. Fundamental SQL statements/8. SELECT DISTINCT.mp446.19MB

4. Fundamental SQL statements/9. WHERE.mp432.56MB

5. Restore and Back-up/1. Restore and Back-up.mp472.1MB

5. Restore and Back-up/2. Debugging restoration issues.mp450.18MB

5. Restore and Back-up/3. Creating DB using CSV files.mp435.47MB

5. Restore and Back-up/5. Exercise 5 Restore and Back-up.mp43MB

6. Selection commands Filtering/1. IN.mp429.41MB

6. Selection commands Filtering/2. BETWEEN.mp449.73MB

6. Selection commands Filtering/3. LIKE.mp461.17MB

6. Selection commands Filtering/4. Exercise 6 In, Like & Between.mp45.25MB

7. Selection commands Ordering/1. Side Lecture Commenting in SQL.mp412.3MB

7. Selection commands Ordering/2. ORDER BY.mp471.37MB

7. Selection commands Ordering/3. LIMIT.mp429.61MB

7. Selection commands Ordering/4. Exercise 7 Sorting.mp43.17MB

8. Alias/1. AS.mp425.58MB

9. Aggregate Commands/1. COUNT.mp438.36MB

9. Aggregate Commands/2. SUM.mp421.06MB

9. Aggregate Commands/3. AVERAGE.mp417.52MB

9. Aggregate Commands/4. MIN & MAX.mp432.48MB

9. Aggregate Commands/5. Exercise 8 Aggregate functions.mp46.43MB