Udemy - SQL for Data Analysis - Beginner to Advanced
- Category Other
- Type Tutorials
- Language English
- Total size 2.2 GB
- Uploaded By freecoursewb
- Downloads 588
- Last checked 1 day ago
- Date uploaded 4 months ago
- Seeders 24
- Leechers 1
Infohash : C0C0BC3523A3DF9DCEEAFB6C76AD4978C4C52E7C
SQL for Data Analysis: Beginner to Advanced
https://WebToolTip.com
Published 8/2025
Created by Yusuf Raheem
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 63 Lectures ( 5h 57m ) | Size: 2.15 GB
Start with SQL basics and advance through joins, subqueries, CTEs, and window functions—real business use cases included
What you'll learn
Write powerful SQL queries to filter, aggregate, and transform data for real-world data analysis projects.
Master SQL joins, subqueries, and window functions to combine and analyze complex datasets efficiently.
Create, manage, and optimize databases using best practices in SQL for performance and scalability.
Apply SQL in data analytics workflows by extracting insights from business datasets and building reports.
Use advanced SQL techniques such as Common Table Expressions (CTEs), stored procedures, and functions for automation.
Master foundational to advanced SQL syntax (SELECT, JOIN, GROUP BY, subqueries, CTEs) to extract and analyze data efficiently.
Apply SQL to practical business scenarios like sales reports, customer segmentation, and performance metrics using real datasets.
Requirements
No prior SQL or database experience required — this course starts from the absolute basics and builds up to advanced SQL for data analysis.
A computer (Windows, macOS, or Linux) with internet access.
Willingness to learn by practicing SQL queries through hands-on exercises and real-world datasets.
(Optional but helpful) Basic understanding of data analysis or working with spreadsheets like Excel or Google Sheets.
A Curiosity for Data! – Whether you’re in marketing, finance, or just love numbers, this course turns raw data into insights.
Files:
[ WebToolTip.com ] Udemy - SQL for Data Analysis - Beginner to Advanced- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - INTRODUCTION
- 1 -Introduction - Meet the Instructor.mp4 (12.9 MB)
- 1 -LinkedIn Profile.url (0.1 KB)
- 2 -SQL Installation.mp4 (83.3 MB)
- 3 -Case Study Part1 - Business Problems.mp4 (16.9 MB)
- 4 -Case Study Part2 - Understanding the Data.mp4 (11.6 MB)
- 5 - ORDER BY Practice.html (1.3 KB)
- 1 -CREATE Statement.mp4 (64.6 MB)
- 10 -WHERE Clause with Logical Operator 2.mp4 (2.9 MB)
- 11 -WHERE Clause with Logical Operator 3.mp4 (180.6 MB)
- 12 -ORDER BY 1.sql (0.1 KB)
- 12 -ORDER BY Statement.mp4 (21.0 MB)
- 13 - ORDER BY practice.html (1.2 KB)
- 13 -ARITHMETIC.mp4 (30.1 MB)
- 13 -Arithmetic.sql (0.2 KB)
- 13 -ORDER BY Practice Solution.sql (0.3 KB)
- 14 -BASIC SECTION RECAP.mp4 (6.8 MB)
- 2 -CREATE and INSERT Statement 1.mp4 (44.5 MB)
- 2 -accounts.sql (0.4 KB)
- 2 -region.sql (0.1 KB)
- 2 -sales_reps.sql (0.3 KB)
- 3 -CREATE and INSERT Statement 2.mp4 (44.6 MB)
- 3 -accounts.csv (28.7 KB)
- 3 -region.csv (0.0 KB)
- 3 -sales_reps.csv (1.2 KB)
- 4 -CREATE and INSERT Statement 3.mp4 (56.2 MB)
- 4 -orders.sql (682.7 KB)
- 4 -web_events.sql (659.1 KB)
- 5 -SELECT Statement.mp4 (36.0 MB)
- 6 -TOP Statement.mp4 (11.9 MB)
- 7 -WHERE Clause.mp4 (20.3 MB)
- 8 -WHERE Clause with Comparison Operator.mp4 (53.9 MB)
- 8 -Where clause with comparison operator.sql (0.1 KB)
- 9 -WHERE Clause with Logical Operator 1.mp4 (134.7 MB)
- 9 -Where clause with logical operator 1_1.sql (0.2 KB)
- 9 -Where clause with logical operator 1_2.sql (0.1 KB)
- 9 -Where clause with logical operator 1_3.sql (0.2 KB)
- 9 -Where clause with logical operator 1_4.sql (0.1 KB)
- 1 -Introduction to JOINS.mp4 (2.8 MB)
- 2 -Database Design.mp4 (10.3 MB)
- 3 -JOIN Syntax.mp4 (33.6 MB)
- 4 -INNER JOIN.mp4 (130.1 MB)
- 4 -Inner Join Example.sql (0.4 KB)
- 4 -Inner Join Practice Q.sql (0.2 KB)
- 5 -LEFT & RIGHT JOINS.mp4 (95.7 MB)
- 5 -Left & Right.sql (0.5 KB)
- 6 -FULL OUTER JOIN.mp4 (116.1 MB)
- 6 -Full Outer Join Example.sql (0.1 KB)
- 6 -Full Outer Join Practice.sql (0.6 KB)
- 1 -Introduction to SQL Aggregation.mp4 (5.1 MB)
- 10 - DATE GROUP BY Practice.html (0.6 KB)
- 10 -10.sql (1.0 KB)
- 10 -CASE Statement.mp4 (95.4 MB)
- 10 -Date GROUP BY Practice.sql (0.6 KB)
- 11 - CASE Statement Practice.html (0.5 KB)
- 11 -CASE Statement Practice.sql (0.4 KB)
- 2 -SQL NULLs.mp4 (5.7 MB)
- 3 -COUNT.mp4 (22.0 MB)
- 3 -Count.sql (0.3 KB)
- 4 -SUM.mp4 (21.9 MB)
- 4 -Sum Example.sql (0.1 KB)
- 5 - SUM Practice.html (1.0 KB)
- 5 -MIN & MAX.mp4 (31.0 MB)
- 5 -MIN & MAX.sql (0.2 KB)
- 5 -SUM practice solution.sql (0.4 KB)
- 6 - MIN & MAX Practice.html (0.6 KB)
- 6 -AVG QE.sql (0.1 KB)
- 6 -AVG.mp4 (10.9 MB)
- 6 -MIN & MAX Practice.sql (0.3 KB)
- 7 - AVG Practice.html (0.4 KB)
- 7 -AVG.sql (0.2 KB)
- 7 -GROUP BY.mp4 (52.7 MB)
- 7 -GROUP BY.sql (0.4 KB)
- 8 - GROUP BY Practice.html (0.8 KB)
- 8 -GROUP BY Practice.sql (0.5 KB)
- 8 -HAVING.mp4 (40.8 MB)
- 8 -HAVING.sql (0.3 KB)
- 9 - HAVING Practice.html (0.7 KB)
- 9 -DATE GROUP BY.mp4 (77.7 MB)
- 9 -Date GROUP BY.sql (0.7 KB)
- 9 -HAVING.sql (0.3 KB)
- 1 -Introduction.mp4 (3.8 MB)
- 2 -2.sql (0.2 KB)
- 2 -First Subqueries.mp4 (52.9 MB)
- 3 -Subqueries in Other Clauses.sql (0.4 KB)
- 3 -Subqueries in other Clauses.mp4 (39.5 MB)
- 4 - Subqueries Practice.html (0.6 KB)
- 4 -4.sql (1.4 KB)
- 4 -Common Table Expression (CTE).mp4 (61.2 MB)
- 4 -Subquries Practice.sql (1.5 KB)
- 5 - CTE Practice.html (0.8 KB)
- 5 -5.sql (0.7 KB)
- 5 -Temp Table.mp4 (37.7 MB)
- 5 -With CTE Practice.sql (2.5 KB)
- 1 -Introduction.mp4 (2.7 MB)
- 2 -2.sql (0.1 KB)
- 2 -LEFT & RIGHT.mp4 (29.6 MB)
- 3 -CHARINDEX & SUBSTRING.mp4 (88.0 MB)
- 3 -CHARINDEX n SUBSTRING.sql (0.2 KB)
- 4 -4.sql (0.3 KB)
- 4 -CONCAT.mp4 (51.3 MB)
- 5 -CAST.mp4 (4.4 MB)
- 1 -Introduction.mp4 (4.5 MB)
- 2 -2.sql (0.3 KB)
- 2 -Windows Functions.mp4 (55.9 MB)
- 3 -3.sql (0.6 KB)
- 3 -ROW_NUMBER(), RANK() & DENSE_RANK().mp4 (69.3 MB)
- 4 -4.sql (1.2 KB)
- 4 -Aggregation in Window Function.mp4 (28.6 MB)
- 5 -5.sql (0.4 KB)
- 5 -LAG() & LEAD().mp4 (65.4 MB)
- 1 -Final Word.mp4 (4.7 MB)
- 2 -Demo of Gen AI tools.mp4 (18.2 MB)
- 2 -LinkedIn.url (0.1 KB)
- 2 -Tiktok.url (0.1 KB)
- 2 -Youtube.url (0.1 KB)
- 3 - Dataset websites.html (1.9 KB)
- Bonus Resources.txt (0.1 KB)
There are currently no comments. Feel free to leave one :)
Code:
- 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