| 1 - Welcome to HandsOn SQL for Data Analysts.mp4 | 15.5 MB | ||
| 10 - Using ORDER BY to arrange your results.mp4 | 67.6 MB | ||
| 10 - scripts-for-ORDER-BY.txt | 819.2 B | ||
| 11 - WHERE condition and an introduction to SQL Operators.mp4 | 11.3 MB | ||
| 11 - scripts-for-WHERE.txt | 614.4 B | ||
| 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 | 819.2 B | ||
| 14 - Handling NULLs Part 2 Using COALESCE.mp4 | 24.1 MB | ||
| 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 | 921.6 B | ||
| 18 - UNION Part 1.mp4 | 21.2 MB | ||
| 19 - UNION Part 2.mp4 | 23.5 MB | ||
| 19 - scripts-for-UNION.txt | 1 KB | ||
| 2 - Objectives of this course.mp4 | 7.3 MB | ||
| 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 | ||
| 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 MB | ||
| 27 - scripts-for-MULTI-TABLE-JOIN.txt | 921.6 B | ||
| 28 - Simple Aggregation.mp4 | 17.8 MB | ||
| 28 - scripts-for-SIMPLE-AGGREGATION.txt | 819.2 B | ||
| 29 - GROUP BY Part 1.mp4 | 69 MB | ||
| 29 - scripts-for-GROUP-BY.txt | 716.8 B | ||
| 3 - Installing PostgreSQL and PGAdmin on MacOS.mp4 | 22.8 MB | ||
| 3 - Note-on-Postgresql-ports.rtf | 2.1 KB | ||
| 30 - GROUP BY Part 2.mp4 | 33.4 MB | ||
| 31 - Explain-Plans.rtf | 614.4 B | ||
| 31 - HAVING.mp4 | 40.4 MB | ||
| 31 - scripts-for-HAVING.txt | 819.2 B | ||
| 32 - DISTINCT revisited.mp4 | 37.7 MB | ||
| 32 - scripts-for-DISTINCT-REVISITED.txt | 512 B | ||
| 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 | 716.8 B | ||
| 39 - Date and Time Part 1.mp4 | 24.5 MB | ||
| 39 - scripts-for-DATE-TIME.txt | 1.9 KB | ||
| 4 - Installing PostgreSQL and PGAdmin on Microsoft Windows.mp4 | 11.5 MB | ||
| 4 - Note-on-Postgresql-ports.rtf | 2.1 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 | ||
| 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 | ||
| 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 | ||
| 5 - Creating our database for the course.mp4 | 32.3 MB | ||
| 5 - build-wardown-schema-and-data.sql | 111.8 KB | ||
| 50 - LAG and LEAD.mp4 | 32 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 | ||
| 52 - Congratulations.mp4 | 4.5 MB | ||
| 53 - Bonus Lecture Learn More For Free.mp4 | 3.8 MB | ||
| 6 - Claims-Entity-Relationship-Diagram.png | 178 KB | ||
| 6 - Understanding the Wardown Park Insurance database.mp4 | 21 MB | ||
| 7 - The SELECT statement.mp4 | 73.4 MB | ||
| 7 - scripts-for-SELECT.txt | 409.6 B | ||
| 8 - The COUNT function.mp4 | 24.7 MB | ||
| 8 - scripts-for-COUNT.txt | 512 B | ||
| 9 - The DISTINCT statement.mp4 | 20.7 MB | ||
| 9 - scripts-for-DISTINCT.txt | 614.4 B | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 86 total files | |||
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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.6 GB | freecoursewb | 3 days | 0 | 0 | |
| 1.3 GB | freecoursewb | 3 days | 0 | 0 | |
| 258.8 MB | freecoursewb | 3 days | 0 | 0 | |
| 3.8 GB | freecoursewb | 1 month | 23 | 3 | |
| 1.7 GB | freecoursewb | 1 month | 16 | 1 |
All Comments