Udemy - Sql For Data Analysis, Hands-On Industry Skills For Analysts

seeders: 0
leechers: 0
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ WebToolTip.com ] Udemy - Sql For Data Analysis, Hands-On Industry Skills For Analysts
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Welcome
    • 1 - Welcome to HandsOn SQL for Data Analysts.mp4 (15.5 MB)
    • 2 - Objectives of this course.mp4 (7.3 MB)
    10 - WindowAnalytical Functions
    • 48 - ROWNUM.mp4 (133.2 MB)
    • 48 - scripts-for-WINFN-Rownum.txt (2.4 KB)
    • 49 - RANK and DENSE RANK.mp4 (60.9 MB)
    • 49 - scripts-for-WINFN-RANK.txt (2.4 KB)
    • 50 - LAG and LEAD.mp4 (32.0 MB)
    • 50 - scripts-for-WINFN-LAG-LEAD.txt (2.3 KB)
    • 51 - Other useful Window Functions.mp4 (79.5 MB)
    • 51 - scripts-for-WINFN-OTHER.txt (2.6 KB)
    11 - Closing Remarks and Exciting Bonus Material
    • 52 - Congratulations.mp4 (4.5 MB)
    • 53 - Bonus Lecture Learn More For Free.mp4 (3.8 MB)
    2 - Setting up
    • 3 - Installing PostgreSQL and PGAdmin on MacOS.mp4 (22.8 MB)
    • 3 - Note-on-Postgresql-ports.rtf (2.1 KB)
    • 4 - Installing PostgreSQL and PGAdmin on Microsoft Windows.mp4 (11.5 MB)
    • 4 - Note-on-Postgresql-ports.rtf (2.1 KB)
    • 5 - Creating our database for the course.mp4 (32.3 MB)
    • 5 - build-wardown-schema-and-data.sql (111.8 KB)
    • 6 - Claims-Entity-Relationship-Diagram.png (178.0 KB)
    • 6 - Understanding the Wardown Park Insurance database.mp4 (21.0 MB)
    3 - The Basics of SQL
    • 10 - Using ORDER BY to arrange your results.mp4 (67.6 MB)
    • 10 - scripts-for-ORDER-BY.txt (0.8 KB)
    • 11 - WHERE condition and an introduction to SQL Operators.mp4 (11.3 MB)
    • 11 - scripts-for-WHERE.txt (0.6 KB)
    • 12 - Decision making using CASE.mp4 (26.9 MB)
    • 12 - scripts-for-CASE.txt (1.1 KB)
    • 13 - Handling NULLs Part 1.mp4 (25.9 MB)
    • 13 - scripts-for-NULL.txt (0.8 KB)
    • 14 - Handling NULLs Part 2 Using COALESCE.mp4 (24.1 MB)
    • 7 - The SELECT statement.mp4 (73.4 MB)
    • 7 - scripts-for-SELECT.txt (0.4 KB)
    • 8 - The COUNT function.mp4 (24.7 MB)
    • 8 - scripts-for-COUNT.txt (0.5 KB)
    • 9 - The DISTINCT statement.mp4 (20.7 MB)
    • 9 - scripts-for-DISTINCT.txt (0.6 KB)
    4 - SQL Operators
    • 15 - SQL Logical Operators Part 1.mp4 (27.7 MB)
    • 15 - scripts-for-LOGICAL-OPERATORS.txt (2.5 KB)
    • 16 - SQL Logical Operators Part 2.mp4 (32.9 MB)
    • 17 - SQL Comparison Operators.mp4 (20.8 MB)
    • 17 - scripts-for-COMPARISON-OPERATORS.txt (0.9 KB)
    • 18 - UNION Part 1.mp4 (21.2 MB)
    • 19 - UNION Part 2.mp4 (23.5 MB)
    • 19 - scripts-for-UNION.txt (1.0 KB)
    5 - Subqueries Common Table Expressions CTEs
    • 20 - Subqueries Part 1 Scalar and Multicolumn Subqueries.mp4 (34.2 MB)
    • 20 - scripts-for-SUBQUERIES.txt (1.7 KB)
    • 21 - Subqueries Part 2 Correlated Subqueries.mp4 (25.2 MB)
    • 22 - Subqueries Part 3 Common Table Expressions CTEs.mp4 (28.1 MB)
    6 - How to JOIN tables
    • 23 - Table Join concepts.mp4 (20.3 MB)
    • 24 - Coding Joins.mp4 (61.3 MB)
    • 24 - scripts-for-JOIN.txt (1.4 KB)
    • 25 - Self Join.mp4 (28.8 MB)
    • 26 - Understanding Multitable Joins.mp4 (20.7 MB)
    • 27 - Coding Multitable Joins.mp4 (39.0 MB)
    • 27 - scripts-for-MULTI-TABLE-JOIN.txt (0.9 KB)
    7 - Aggregating Data
    • 28 - Simple Aggregation.mp4 (17.8 MB)
    • 28 - scripts-for-SIMPLE-AGGREGATION.txt (0.8 KB)
    • 29 - GROUP BY Part 1.mp4 (69.0 MB)
    • 29 - scripts-for-GROUP-BY.txt (0.7 KB)
    • 30 - GROUP BY Part 2.mp4 (33.4 MB)
    • 31 - Explain-Plans.rtf (0.6 KB)
    • 31 - HAVING.mp4 (40.4 MB)
    • 31 - scripts-for-HAVING.txt (0.8 KB)
    • 32 - DISTINCT revisited.mp4 (37.7 MB)
    • 32 - scripts-for-DISTINCT-REVISITED.txt (0.5 KB)
    8 - Data Manipulation
    • 33 - Data Types Constraints PrimaryKeys Explained.mp4 (18.4 MB)
    • 34 - Considering data types when building queries.mp4 (40.6 MB)
    • 35 - Manipulating Column Data Part 1.mp4 (11.3 MB)
    • 36 - Manipulating Column Data Part 2.mp4 (41.7 MB)
    • 36 - scripts-for-MANIPULATING-COLUMN-DATA.txt (1.2 KB)
    • 37 - Manipulating Column Data Part 3.mp4 (19.5 MB)
    • 38 - Number Manipulation.mp4 (18.6 MB)
    • 38 - scripts-for-NUMBER-MANIPULATION.txt (0.7 KB)
    • 39 - Date and Time Part 1.mp4 (24.5 MB)
    • 39 - scripts-for-DATE-TIME.txt (1.9 KB)
    • 40 - Date and Time Part 2.mp4 (106.3 MB)
    • 41 - Pivot Data Part 1.mp4 (24.6 MB)
    • 42 - Pivot Data Part 2.mp4 (55.7 MB)
    • 42 - scripts-for-PIVOT.txt (1.6 KB)
    9 - Regular Expressions finding data using pattern matching
    • 43 - Regular Expressions explained.mp4 (13.8 MB)
    • 44 - LIKE and Wildcard in Regular Expressions.mp4 (25.4 MB)
    • 44 - scripts-for-REGULAR-EXPRESSIONS.txt (1.9 KB)
    • 45 - POSIX operators.mp4 (45.2 MB)
    • 46 - Ranges in Regular Expressions.mp4 (81.2 MB)
    • 47 - Worked example using Regular Expressions.mp4 (34.6 MB)
    • Bonus Resources.txt (0.1 KB)

Description

Sql For Data Analysis, Hands-On Industry Skills For Analysts

https://WebToolTip.com

Last updated 2/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.80 GB | Duration: 7h 19m

Master advanced data analysis with SQL, Window Functions,Joins, CTEs & more to advance your career: PostgreSQL; MySQL ..

What you'll learn
Use Industry-style data to learn how to CONSTRUCT SQL QUERIES for the purpose of analysing data and reporting
Learn how to MANIPULATE DATA using advanced SQL techniques as used in industry today using our included insurance database
Gain the confidence to query data using SQL on ANY PLATFORM for analysis or reporting including AWS and Azure
Learn how SQL gives you the power to gain valuable INSIGHT into your organisation's data
Create queries for the purpose of PRODUCING REPORTS, by formatting the output for your business

Requirements
Confidence with a computer and installing (free) software
No prior programming experience required
Understanding of what a database is and basic understanding of tables and columns



Download torrent
1.8 GB
seeders:0
leechers:0
Udemy - Sql For Data Analysis, Hands-On Industry Skills For Analysts

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.8 GB
seeders:0
leechers:0
Udemy - Sql For Data Analysis, Hands-On Industry Skills For Analysts

Torrent hash: 65729BF43D392E69238159B7F1DA76EBAA303FF3