Curiasity | Advanced SQL for data analytics

Course / Course Details

Advanced SQL for data analytics

IT & Software

By - Gayathri Perumal
0 students
N/A
(0)

Course Description

This Advanced SQL for Data Analytics course is designed to help learners master complex SQL techniques used in real-world data analysis. Moving beyond basic queries, this course focuses on writing efficient, optimized queries to extract meaningful insights from large datasets.
You will learn how to work with advanced joins, window functions, subqueries, Common Table Expressions (CTEs), and performance tuning. The course also covers practical scenarios such as data cleaning, transformation, and reporting—making it ideal for aspiring data analysts, developers, and business intelligence professionals.
By the end of this course, you will be able to confidently analyze structured data and support data-driven decision-making using SQL.

Course Outcomes

Write complex SQL queries using advanced joins and nested subqueries
Use window functions (ROW_NUMBER, RANK, LEAD, LAG) for analytical insights
Apply Common Table Expressions (CTEs) for better query readability and performance
Perform data aggregation and advanced filtering techniques
Optimize SQL queries for better performance on large datasets
Clean and transform raw data into analysis-ready formats
Build reports and dashboards using SQL queries
Solve real-world data analysis problems efficiently

Course Curriculum

1 chapters
37 lectures
0 quizzes
N/A total length

Toggle all chapters

1 How I d Learn Advanced SQL and Why If I Had to Start Over SQL Course 1

8.52 Min

2 How to Download Install FREE Microsoft SQL Server SSMS and 3 AdventureWorks Databases

15.37 Min

3 SQL Window Functions Basics Partition By Order By Frame SQL Course 3

57.19 Min

4 SQL Aggregate Window Functions COUNT AVG SUM MAX MIN SQL Course 4

1.07 Min

5 SQL Ranking Window Functions ROW NUMBER RANK DENSE RANK NTILE CUME DIST PERCENT RANK

1.04 Min

6 SQL Value Window Functions LEAD LAG FIRST VALUE LAST VALUE SQL Course 6

45.02 Min

7 SQL Union Union All Except Minus Except Set Operators SQL Course 7

48.38 Min

8 SQL Case When Statement Use Cases SQL Course 8

36.19 Min

9 SQL NULL Functions COALESCE ISNULL NULLIF IS NOT NULL SQL Course 9

53 Min

10 SQL NULL vs Empty String vs Blank Space Explained SQL Course 10

17.04 Min

11 SQL Date Time Functions Datepart Datename Datetrunc Eomonth SQL Course 11

43.27 Min

12 SQL Date Time Functions Format Convert Cast SQL Course 12

30.47 Min

13 SQL Date Time Functions Dateadd Datediff Isdate SQL Course 13

23.48 Min

14 Why You Need These 5 SQL Techniques in Your SQL Project Architecture SQL Course 14

18.52 Min

15 SQL Subquery Complete Guide with Correlated Subquery SQL Course 15

1.21 Min

16 SQL CTE Common Table Expression Full Guide WITH Clause SQL Course 16

1.17 Min

17 SQL Views Tutorial 6 Top Use Cases for Views SQL Course 17

1.02 Min

18 SQL CTAS How to Create SQL Tables From a Query SQL Course 18

25.59 Min

19 SQL Temp Tables

16.19 Min

20 SQL Subquery vs CTE vs Views vs CTAS vs TEMP SQL Course 20

9.43 Min

21 SQL Indexes Clustered vs Nonclustered Index SQL Course 21

43.1 Min

22 SQL Columnstore Index Explained Columnstore vs Rowstore Indexes SQL Course 22

26.23 Min

23 SQL Unique Filtered Indexes SQL Course 23

12.03 Min

24 How to Choose the Right Index SQL Course 24

3.53 Min

25 SQL Index Maintenance 5 Things to Do after Creating Indexes SQL Statistics SQL Course 25

35 Min

26 SQL Execution Plans EXPLAINED SQL Hints SQL Course 26

32.16 Min

27 My Indexing Strategy for Every SQL Project Indexing Best Practices

19.01 Min

28 SQL Table Partitioning Explained Optimize Big Table Performance

33.22 Min

29 30 SQL Tips and Tricks From 15 Years of Experience SQL Course 29

45.54 Min

30 SQL Stored Procedure Step by Step Comprehensive Guide SQL Course 30

46.53 Min

31 SQL Triggers Explained Audit Logs Use Case SQL Course 31

11.13 Min

32 How I Use ChatGPT GitHub Copilot in My Projects

57.24 Min

33 Intro To SQL Project Data Engineer Portfolio Project SQL Project 1

1.47 Min

34 Data Warehouse Basics Explained Data Engineer Portfolio Project SQL Project 2

6.54 Min

35 ETL Process Explained Data Engineer Portfolio Project SQL Project 3

11.11 Min

36 Notion Project Plan Set Up Your Environment Data Engineer Portfolio Project SQL Project 4

10.03 Min

37 Design Data Architecture for Your Data Warehouse Data Engineer Portfolio Project SQL Project 5

25.3 Min

Instructor

Gayathri Perumal

0 Rating

0 Reviews

0 Students

36 Courses

Course Full Rating

0

Course Rating

(0)

No Review found

Student Feedback

You must be enrolled to ask a question

Enrol

Duration N/A
Lectures 37 lessons
Enrolled 0 students
Category: IT & Software
0 Quizzes
Language: English
Skill Level Beginner
Certificate of Completion
Full lifetime access

Shopping Cart

We collect and use cookies to give you the best and most relevant website experience. Kindly accept the cookies. Privacy Policy

When you visit any of our websites, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and manage your preferences. Please note, that blocking some types of cookies may impact your experience of the site and the services we are able to offer

Strictly Necessary

These cookies are necessary for our website to function properly and cannot be switched off in our systems. They are usually only set in response to actions made by you that amount to a request for services, such as setting your privacy preferences, logging in or filling in forms, or where they’re essential to providing you with a service you have requested. You cannot opt out of these cookies. You can set your browser to block or alert you about these cookies, but if you do, some parts of the site will not then work. These cookies do not store any personally identifiable information
Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site, which helps us optimize your experience. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not be able to use your data in this way.
Functional Cookies

These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third-party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.