磁石

[ WebToolTip.com ] Udemy - Sql For Data Analysis, Hands-On Industry Skills For Analysts

正在检测能否在线播放…

大小
1.8 GB
文件数
86
分类
视频
热度
16
最近活跃
4 小时前

文件列表

  • Get Bonus Downloads Here.url180 B
  • ~Get Your Files Here !/1 - Welcome/1 - Welcome to HandsOn SQL for Data Analysts.mp415.5 MB
  • ~Get Your Files Here !/1 - Welcome/2 - Objectives of this course.mp47.3 MB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/48 - ROWNUM.mp4133.2 MB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/48 - scripts-for-WINFN-Rownum.txt2.4 KB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/49 - RANK and DENSE RANK.mp460.9 MB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/49 - scripts-for-WINFN-RANK.txt2.4 KB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/50 - LAG and LEAD.mp432.0 MB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/50 - scripts-for-WINFN-LAG-LEAD.txt2.3 KB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/51 - Other useful Window Functions.mp479.5 MB
  • ~Get Your Files Here !/10 - WindowAnalytical Functions/51 - scripts-for-WINFN-OTHER.txt2.6 KB
  • ~Get Your Files Here !/11 - Closing Remarks and Exciting Bonus Material/52 - Congratulations.mp44.5 MB
  • ~Get Your Files Here !/11 - Closing Remarks and Exciting Bonus Material/53 - Bonus Lecture Learn More For Free.mp43.8 MB
  • ~Get Your Files Here !/2 - Setting up/3 - Installing PostgreSQL and PGAdmin on MacOS.mp422.8 MB
  • ~Get Your Files Here !/2 - Setting up/3 - Note-on-Postgresql-ports.rtf2.1 KB
  • ~Get Your Files Here !/2 - Setting up/4 - Installing PostgreSQL and PGAdmin on Microsoft Windows.mp411.5 MB
  • ~Get Your Files Here !/2 - Setting up/4 - Note-on-Postgresql-ports.rtf2.1 KB
  • ~Get Your Files Here !/2 - Setting up/5 - Creating our database for the course.mp432.3 MB
  • ~Get Your Files Here !/2 - Setting up/5 - build-wardown-schema-and-data.sql111.8 KB
  • ~Get Your Files Here !/2 - Setting up/6 - Claims-Entity-Relationship-Diagram.png178.0 KB
  • ~Get Your Files Here !/2 - Setting up/6 - Understanding the Wardown Park Insurance database.mp421.0 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/10 - Using ORDER BY to arrange your results.mp467.6 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/10 - scripts-for-ORDER-BY.txt781 B
  • ~Get Your Files Here !/3 - The Basics of SQL/11 - WHERE condition and an introduction to SQL Operators.mp411.3 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/11 - scripts-for-WHERE.txt647 B
  • ~Get Your Files Here !/3 - The Basics of SQL/12 - Decision making using CASE.mp426.9 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/12 - scripts-for-CASE.txt1.1 KB
  • ~Get Your Files Here !/3 - The Basics of SQL/13 - Handling NULLs Part 1.mp425.9 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/13 - scripts-for-NULL.txt812 B
  • ~Get Your Files Here !/3 - The Basics of SQL/14 - Handling NULLs Part 2 Using COALESCE.mp424.1 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/7 - The SELECT statement.mp473.4 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/7 - scripts-for-SELECT.txt408 B
  • ~Get Your Files Here !/3 - The Basics of SQL/8 - The COUNT function.mp424.7 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/8 - scripts-for-COUNT.txt531 B
  • ~Get Your Files Here !/3 - The Basics of SQL/9 - The DISTINCT statement.mp420.7 MB
  • ~Get Your Files Here !/3 - The Basics of SQL/9 - scripts-for-DISTINCT.txt586 B
  • ~Get Your Files Here !/4 - SQL Operators/15 - SQL Logical Operators Part 1.mp427.7 MB
  • ~Get Your Files Here !/4 - SQL Operators/15 - scripts-for-LOGICAL-OPERATORS.txt2.5 KB
  • ~Get Your Files Here !/4 - SQL Operators/16 - SQL Logical Operators Part 2.mp432.9 MB
  • ~Get Your Files Here !/4 - SQL Operators/17 - SQL Comparison Operators.mp420.8 MB
  • ~Get Your Files Here !/4 - SQL Operators/17 - scripts-for-COMPARISON-OPERATORS.txt936 B
  • ~Get Your Files Here !/4 - SQL Operators/18 - UNION Part 1.mp421.2 MB
  • ~Get Your Files Here !/4 - SQL Operators/19 - UNION Part 2.mp423.5 MB
  • ~Get Your Files Here !/4 - SQL Operators/19 - scripts-for-UNION.txt1.0 KB
  • ~Get Your Files Here !/5 - Subqueries Common Table Expressions CTEs/20 - Subqueries Part 1 Scalar and Multicolumn Subqueries.mp434.2 MB
  • ~Get Your Files Here !/5 - Subqueries Common Table Expressions CTEs/20 - scripts-for-SUBQUERIES.txt1.7 KB
  • ~Get Your Files Here !/5 - Subqueries Common Table Expressions CTEs/21 - Subqueries Part 2 Correlated Subqueries.mp425.2 MB
  • ~Get Your Files Here !/5 - Subqueries Common Table Expressions CTEs/22 - Subqueries Part 3 Common Table Expressions CTEs.mp428.1 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/23 - Table Join concepts.mp420.3 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/24 - Coding Joins.mp461.3 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/24 - scripts-for-JOIN.txt1.4 KB
  • ~Get Your Files Here !/6 - How to JOIN tables/25 - Self Join.mp428.8 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/26 - Understanding Multitable Joins.mp420.7 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/27 - Coding Multitable Joins.mp439.0 MB
  • ~Get Your Files Here !/6 - How to JOIN tables/27 - scripts-for-MULTI-TABLE-JOIN.txt909 B
  • ~Get Your Files Here !/7 - Aggregating Data/28 - Simple Aggregation.mp417.8 MB
  • ~Get Your Files Here !/7 - Aggregating Data/28 - scripts-for-SIMPLE-AGGREGATION.txt792 B
  • ~Get Your Files Here !/7 - Aggregating Data/29 - GROUP BY Part 1.mp469.0 MB
  • ~Get Your Files Here !/7 - Aggregating Data/29 - scripts-for-GROUP-BY.txt764 B
  • ~Get Your Files Here !/7 - Aggregating Data/30 - GROUP BY Part 2.mp433.4 MB
  • ~Get Your Files Here !/7 - Aggregating Data/31 - Explain-Plans.rtf630 B
  • ~Get Your Files Here !/7 - Aggregating Data/31 - HAVING.mp440.4 MB
  • ~Get Your Files Here !/7 - Aggregating Data/31 - scripts-for-HAVING.txt800 B
  • ~Get Your Files Here !/7 - Aggregating Data/32 - DISTINCT revisited.mp437.7 MB
  • ~Get Your Files Here !/7 - Aggregating Data/32 - scripts-for-DISTINCT-REVISITED.txt494 B
  • ~Get Your Files Here !/8 - Data Manipulation/33 - Data Types Constraints PrimaryKeys Explained.mp418.4 MB
  • ~Get Your Files Here !/8 - Data Manipulation/34 - Considering data types when building queries.mp440.6 MB
  • ~Get Your Files Here !/8 - Data Manipulation/35 - Manipulating Column Data Part 1.mp411.3 MB
  • ~Get Your Files Here !/8 - Data Manipulation/36 - Manipulating Column Data Part 2.mp441.7 MB
  • ~Get Your Files Here !/8 - Data Manipulation/36 - scripts-for-MANIPULATING-COLUMN-DATA.txt1.2 KB
  • ~Get Your Files Here !/8 - Data Manipulation/37 - Manipulating Column Data Part 3.mp419.5 MB
  • ~Get Your Files Here !/8 - Data Manipulation/38 - Number Manipulation.mp418.6 MB
  • ~Get Your Files Here !/8 - Data Manipulation/38 - scripts-for-NUMBER-MANIPULATION.txt737 B
  • ~Get Your Files Here !/8 - Data Manipulation/39 - Date and Time Part 1.mp424.5 MB
  • ~Get Your Files Here !/8 - Data Manipulation/39 - scripts-for-DATE-TIME.txt1.9 KB
  • ~Get Your Files Here !/8 - Data Manipulation/40 - Date and Time Part 2.mp4106.3 MB
  • ~Get Your Files Here !/8 - Data Manipulation/41 - Pivot Data Part 1.mp424.6 MB
  • ~Get Your Files Here !/8 - Data Manipulation/42 - Pivot Data Part 2.mp455.7 MB
  • ~Get Your Files Here !/8 - Data Manipulation/42 - scripts-for-PIVOT.txt1.6 KB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/43 - Regular Expressions explained.mp413.8 MB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/44 - LIKE and Wildcard in Regular Expressions.mp425.4 MB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/44 - scripts-for-REGULAR-EXPRESSIONS.txt1.9 KB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/45 - POSIX operators.mp445.2 MB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/46 - Ranges in Regular Expressions.mp481.2 MB
  • ~Get Your Files Here !/9 - Regular Expressions finding data using pattern matching/47 - Worked example using Regular Expressions.mp434.6 MB
  • ~Get Your Files Here !/Bonus Resources.txt70 B

相关资源

举报这个资源