种子简介

种子名称： [FreeCourseSite.com] Udemy - SQL Masterclass - SQL for Data Analytics
文件类型： 视频
文件数目： 103个文件
文件大小： 2.98 GB
收录时间： 2022-6-21 16:21
已经下载： 3次
资源热度： 162
最近下载： 2024-12-10 23:04

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

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

1. Introduction/1. Course Overview.mp429.33MB

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

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.53MB

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

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

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

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

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.16MB

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

12. JOINS/6. Right Join.mp436.01MB

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.86MB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

19. Data Type conversion functions/2. Converting String to Numbers Date.mp439.05MB

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

2. Installation and getting started/2. Installing and setting up PostgreSQL.mp458.66MB

20. User Access Control Functions/1. User Access Control.mp480.47MB

21. Bonus Section Nail that Interview!/1. Tablespace.mp436.27MB

21. Bonus Section Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp425.41MB

21. Bonus Section Nail that Interview!/3. ACID compliance.mp442.68MB

21. Bonus Section Nail that Interview!/4. Truncate.mp421.09MB

22. Performance tuning tips/1. TIP 1 (EXPLAIN).mp425.49MB

22. Performance tuning tips/2. TIP 2.mp45.81MB

22. Performance tuning tips/3. TIP 3.mp414.27MB

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

22. Performance tuning tips/5. TIP 5.mp411.47MB

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

22. Performance tuning tips/7. TIP 7 (JOINS).mp410.8MB

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

23. Bonus Section Database Basics/1. What is SQL.mp410.76MB

23. Bonus Section Database Basics/2. Tables and DBMS.mp417.38MB

23. Bonus Section Database Basics/3. Types of SQL commands.mp425.29MB

23. Bonus Section Database Basics/4. PostgreSQL.mp417.16MB

23. Bonus Section Database Basics/5. The final milestone!.mp411.85MB

3. Case Study Demo/1. Case Study Part 1.mp427.99MB

3. Case Study Demo/2. Case Study Part 2.mp451.24MB

4. Fundamental SQL statements/1. CREATE.mp463.84MB

4. Fundamental SQL statements/10. Exercise 3 SELECT & WHERE.mp47.19MB

4. Fundamental SQL statements/11. UPDATE.mp437.68MB

4. Fundamental SQL statements/12. DELETE.mp429.24MB

4. Fundamental SQL statements/13. ALTER.mp4125.76MB

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

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

4. Fundamental SQL statements/3. INSERT.mp456.37MB

4. Fundamental SQL statements/4. Import data from File.mp432.64MB

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

4. Fundamental SQL statements/6. SELECT statement.mp427.09MB

4. Fundamental SQL statements/7. SELECT DISTINCT.mp443.23MB

4. Fundamental SQL statements/8. WHERE.mp427.68MB

4. Fundamental SQL statements/9. Logical Operators.mp441.85MB

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

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

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

5. Restore and Back-up/4. Exercise 5 Restore and Back-up.mp43.01MB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Resources/2828.dat63.18KB

Resources/2829.dat137.73KB

Resources/2830.dat973.85KB

Resources/toc.dat3.83KB