Master SQL to get High Paying Jobs!
Aditya Jain (AJ)
17 modules
Hinghlish
Access for 60 days
Master SQL to unlock powerful data management capabilities.
Overview
In today’s data-driven world, being able to understand and analyze data is a crucial skill.
Whether you're looking to switch careers or enhance your current job prospects, mastering SQL (Structured Query Language) is a game-changer.
This course is designed for complete beginners with no prior technical background, and will guide you through the core concepts and practical applications of SQL.
What Makes This Course Special?
- 🎓 Beginner-Friendly: Designed for those with no technical background.
- 📊 Master SQL Essentials: Learn to query, filter, and aggregate data.
- 🔑 Understand Database Terminology: Grasp key terms like tables, rows, and columns.
- 🔢 Leverage SQL Functions: Perform calculations and use powerful SQL functions.
- 🔄 Work with Joins: Combine data from multiple tables with ease.
- 💻 Explore Advanced Features: Master window functions and subqueries.
- 🌍 Real-World Applications: Apply SQL skills to make data-driven decisions.
- 📈 Hands-On Practice: Gain practical experience through exercises and case studies.
Modules
Course Material by AJ
1 attachment
SQL Course Material by AJ
71 pages
Basic Terminologies
Case-Study Walkhthrough
Google Big-Query Setup
Data Extraction: SELECT
6 attachments • 21.44 mins
3.1-select
3.2-select-q1
3.3-select-q2
3.4-select-q3
3.5-select-q4
3.6-select-terminologies
Commonly used Functions
4 attachments • 16.61 mins
4.1-lower
4.2-upper
4.3-concat
4.4-substring
Data Filtering: WHERE
4 attachments • 17.74 mins
5.1-where
5.2-where-q1
5.3-where-q2
5.4-between
Data Aggregation
4 attachments • 22.28 mins
6.1-sum
6.2-average
6.3-min-max
6.4-count
Sorting the Data: ORDER BY
4 attachments • 22.35 mins
7.1-oderby
7.2-asc
7.3-desc
7.4-multi-column
Conditional Statements: CASE WHEN
3 attachments • 14.53 mins
8.1-case-when
8.2-q1
8.3-q2
Grouping Data: GROUP BY
3 attachments • 16.05 mins
9.1-groupby
9.2-groupby-aggr-q1
9.3-groupby-aggr-q2
Group-level Filtering: HAVING
6 attachments • 31.19 mins
10.1-having
10.2-q1
10.3-having-vs-where
10.4-having-and-where
10.5-end-to-end
10.6-end-to-end-ques
JOINS
12 attachments • 1 hrs
11.1-inner-join
11.2-joining-multi-columns-q1
11.3-q2
11.4-q3
12.1-left-join
12.2-left-join-q1
12.3-left-join-q2
12.4-right-join
12.5-left-vs-right
13.1-self-join-q1
13.2-self-join-q2
13.3-cross-join
Union and Union All
2 attachments • 13.41 mins
14.1-union-distinct
14.2-union-all
Window Functions
12 attachments • 1 hrs
15.1-window-functions
15.2-row-number
15.3-rank
15.4-dense-rank
15.5-rownum-rank-denserank
16.1-lead-and-lag
16.2-lead-q1
16.3-lag-q1
16.4-lead-q2
16.5-lag-q2
16.6-groupby-vs-window
16.7-groupby-vs-window-q1
Subqueries
Date & Time Functions
About the creator
Aditya Jain (AJ)
Aditya Jain, an IIT Bombay alumnus and AIR 60 in GATE, is a former Data Scientist at Dream11. He has taught and mentored over 10,000 professionals, helping them upskill and accelerate their hiring journey.
Rate this Course
₹ 999.00
₹4500
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Access for 60 days. Do you still wish to enroll again?
