Master SQL - Simple to advanced 200+ queries

Focused View

Adnan Waheed

5:28:33

21 View

1. Introduction

1. Introduction.html

2. Install PostgreSQL 13.mp4

07:02

3. Install pgAdmin 4 v5.5.mp4

10:52

4. Run PostgreSQL on the cloud.mp4

05:53

2. Employees Management System

1. Understand the database model.mp4

03:14

2.1 sql emp tables and data.zip

2. Create tables and populate data.mp4

12:54

3. Get filtered data via WHERE clause.mp4

17:11

4. Referencing an alias and concatenate columns.mp4

09:10

5. Using conditional logic with CASE expression.mp4

06:44

6. Using ORDER BY, LIMIT and RANDOM.mp4

07:58

7. Find NULL values and transform into real values.mp4

07:18

8. Searching for patterns.mp4

09:39

9. Sorting on data dependent key.mp4

09:19

10. Staking tables together.mp4

11:54

3. Hierarchical Queries

1. Expressing a Parent-Child Relationship.mp4

10:38

2. Expressing a Child-Parent-Grandparent Relationship.mp4

08:11

3. Creating a hierarchical view of a table.mp4

07:26

4. Finding all child rows for a given parent row.mp4

03:09

5. Which rows are leaf, branch, or root nodes.mp4

09:47

4. Working with numbers

1. Computing an average, minmax values.mp4

04:16

2. Sum, and count.mp4

02:58

3. Generating a running total.mp4

05:45

4.1 daily sales.zip

4. Calculating 3-point moving averages.mp4

07:17

5. Calculate a mode.mp4

08:40

6. Calculate a median, averages without highs and lows.mp4

05:09

5. Date Arithmetic

1. Add, subtract dates, and numbers of days.mp4

07:37

2. Compute running date difference.mp4

05:06

3. Comparing records using dates.mp4

05:06

6. Advances Searching

1. Find differences between rows within same group or partition.mp4

04:49

2. Pagination.mp4

03:22

3. Skipping n rows.mp4

02:51

4. Selecting the Top n Records.mp4

04:32

7. Window Functions

1. Turn aggregate function to window function.mp4

08:10

2. PARTITION BY clause.mp4

08:01

3. Handling NULLs.mp4

05:03

4. The ORDER BY clause matters.mp4

07:52

8. Metadata Queries

1. Listing tables, columns and indexes.mp4

08:53

2. Listing constraints on a table.mp4

06:37

3. Using SQL to Generate SQL.mp4

05:02

9. International Debt Analysis

1.1 sql international debts data.zip

1. Preparing the data.mp4

03:14

2. Analyzing International debt - Part 1.mp4

08:44

3. Analyzing International debt - Part 2.mp4

12:24

10. Stocks Markets Analysis

1. Introduction to Stock Markets Data.html

2. CODE Table Creation - Sectors, Symbols, Prices.html

3.1 data sectors symbols prices latest prices historial.zip

3. Import sample datasets.mp4

11:21

4. CODE Import sample datasets.html

5. Important - SQL Query is in CODE Articles.mp4

02:59

6. List data, sectors in ascending and descending orders.mp4

10:21

7. CODE List data, sectors in ascending and descending orders.html

8. Using COUNT, WHERE, IN and NOT IN with sectors.mp4

04:05

9. CODE Using COUNT, WHERE, IN and NOT IN with sectors.html

10. CODE Find total stocks per each sectors.html

11. Congratulations and Thank You!

1. Your feedback is very valuable!.html

2. Updates to the course.html

3. Bonus Lectures.html

Description

Learn about Subqueries, CTEs, , Window Functions on real-world practical datasets...

What You'll Learn?

Solve 200+ SQL hands-on practical query exercises
Work with real-world, practical datasets and problems
Step-by-step walkthrough to perform simple to complex SQL queries
Learn simple to complex queries
Subqueries
Common Table Expressions (CTEs)
Advanced Window Functions

Who is this for?

Complete beginners to database world

Anyone wanting to learn SQL or PostgreSQL

Application engineers seeking to expand their backend skillset

Anyone who wants to apply SQL knowledge on practical datasets

Anyone wants to learn from basic to advanced functionality of PostgreSQL

What You Need to Know?

No pre-knowledge is required: I'll teach you absolutely everything you need to know!

A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux

All the software used in the course is free, and I'll personally walk you through setting it all up

More details

Description
Are you ready to embark on an exciting journey through the dynamic world of PostgreSQL?

Look no further! Our comprehensive PostgreSQL course has been meticulously designed to transform you from a novice into a PostgreSQL wizard, armed with the skills to conquer real-world data challenges!

By the end of this course, you will run 200+ SQL queries to:
Apply Powerful SQL Commands: Gain the expertise to effectively store, update, and retrieve information using PostgreSQL's powerful SQL commands.
Master Complex Joins: Navigate the intricate web of data by seamlessly joining multiple tables with various techniques.
Harness the Magic of Subqueries: Move from the basics to advanced subqueries with ease, enabling you to extract precise information from complex datasets.
Unlock the Secrets of Aggregate Functions: Learn how to aggregate data using functions that turn raw data into meaningful insights.
Time Travel with Date/Time: Handle date and time data types, intervals, and timezones like a pro.
Data Grouping: Organize your data with GROUP BY and apply conditional filters using HAVING, allowing for more structured analysis.
Combining Queries: Combine query results using UNION, INTERSECT, and EXCEPT, creating a powerful toolbox for data manipulation.
Windows Functions: Delve into the world of window functions, from the basics to advanced techniques for advanced data analysis.
Real-world Practice: Work on practical datasets, including Employee Management System, International Debt Data Analysis, Stock Market Analysis, World Trades databases, and much more to preparing you for real-world scenarios.

Ready to Take the Leap? Join Us Today!
Don't miss this opportunity to master PostgreSQL, one of the most popular and powerful relational database systems in the world. Sign up now, and you'll be well on your way to becoming a PostgreSQL pro! Your next big project is waiting â€“ seize it with PostgreSQL expertise!

Your journey begins with a single click. Enroll now and revolutionize your data handling skills with PostgreSQL!
Who this course is for:
Complete beginners to database world
Anyone wanting to learn SQL or PostgreSQL
Application engineers seeking to expand their backend skillset
Anyone who wants to apply SQL knowledge on practical datasets
Anyone wants to learn from basic to advanced functionality of PostgreSQL

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Adnan Waheed

Instructor's Courses

Hello Everyone, I am an entrepreneur, a deliverer, a dreamer, a believer, a darer and a doer. I had worked in Bloomberg for 17 years, and build, manage, and lead several projects and team on global basis. After Bloomberg, had build my own companies like KlickAnalytics, ClickAPIs, ZoomMarkets providing global financial markets analytics with tera bytes data on cloud servers.I've worked extensively with PHP, Python, Angular, Rest APIs, Cloud systems, time series database, financial data analytics, UNIX systems, MongoDB, PostgreSQL, and advanced system architecture design and more.My utmost passion is the invention, innovation, changing paradigms, game-changing disruptions, people, personal development and the true adventures of life. Master the getting the job done well.My Motto: Change the Game!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.