Window functions & ranking
ROW_NUMBER, RANK, DENSE_RANK and partitioned aggregates, applied to ranking and running-total problems.
- Window Fns
- Partition By
- Ranking
/ Udemy Course
Complete Database & SQL Masterclass
Master SQL, DB Design, ER Modeling, Normalization, Transactions, Indexing, Views, Stored Procedures
- 23
- Sections
- 211
- Lectures
- 24.5h
- On-demand video
- 0+
- Students enrolled
- ER MODELING
- NORMALIZATION
- SQL
- INDEXING
- TRANSACTIONS
- RELATIONAL ALGEBRA
- B+ TREES
- WINDOW FUNCTIONS
- ACID
- JOINS
- VIEWS
- STORED PROCEDURES
/ Curriculum
23 sections, one continuous arc
From keys and ER modeling through to stored procedures — every section builds on the last, and every one of the 211 lectures is accounted for below.
- 01
Model
Sections 1–2
Keys, ER diagrams and turning a real-world scenario into a schema.
- 02
Design
Sections 3–4
Functional dependency and normalization, 1NF through BCNF.
- 03
Query
Sections 5–7
SQL beginner to advanced, plus relational algebra and calculus.
- 04
Optimize
Sections 9–10
File organization, B/B+ Tree indexing, and query performance.
- 05
Operate
Sections 8, 11–23
Transactions, concurrency control, and 12 sections of SQL in practice.
7 lectures · 24min
- Types of keys and why relations need them
- Candidate keys and primary keys
- Super keys and surrogate keys
- Foreign keys and referential integrity
10 lectures · 55min
- Entities, attributes and relationships
- Mapping cardinalities
- Building ER diagrams for real application scenarios
- Converting an ER diagram into a relational schema
26 lectures · 2hr 35min
- Defining functional dependencies
- Armstrong's axioms and closure
- Deriving candidate keys from FDs
- Decomposition and dependency preservation
10 lectures · 1hr 16min
- 1NF through 3NF
- BCNF and its edge cases
- Lossless-join decomposition
- Normalizing real tables step by step
26 lectures · 3hr 11min
- DDL, DML and DCL
- SELECT, filtering and sorting
- Joins across multiple tables
- GROUP BY, HAVING and aggregate functions
8 lectures · 50min
- Subqueries and nested queries
- Query patterns for multi-table problems
- Common query-writing mistakes
- Worked practice problems
18 lectures · 1hr 43min
- Selection, projection and join operators
- Set operations on relations
- Tuple and domain relational calculus
- Translating SQL queries into relational algebra
24 lectures · 2hr 10min
- ACID properties
- Locking mechanisms and schedules
- Deadlock detection and prevention
- Recovery techniques after failure
10 lectures · 58min
- Heap, sorted and hashed file structures
- Record layout and storage
- Choosing a file organization for a workload
10 lectures · 1hr 51min
- B-Tree structure and operations
- B+ Tree structure and range queries
- Multi-level index design
- How indexes actually accelerate a query
19 lectures · 2hr 34min
- Fact tables and dimension tables
- Star and snowflake schemas
- Slowly Changing Dimensions, Types 1–6
2 lectures · 28min
- NOT NULL, UNIQUE and CHECK constraints
- Enforcing data integrity at the schema level
8 lectures · 45min
- Comparison and logical operators
- Arithmetic and string operators
- Operator precedence in real queries
6 lectures · 49min
- Built-in string, date and numeric functions
- Type conversion functions
- Using functions inside SELECT and WHERE
9 lectures · 1hr 7min
- ROW_NUMBER, RANK and DENSE_RANK
- Aggregate window functions
- PARTITION BY and ORDER BY in windows
- Ranking and running-total problems
5 lectures · 30min
- Correlated vs. non-correlated subqueries
- Subqueries in SELECT, WHERE and FROM
- EXISTS and IN patterns
2 lectures · 21min
- Writing readable CTEs
- Recursive CTEs for hierarchical data
2 lectures · 13min
- Creating and using temporary tables
- When a temp table beats a subquery or CTE
4 lectures · 26min
- Bulk-loading large datasets
- Performance at scale
- Batch inserts vs. row-by-row inserts
2 lectures · 14min
- STRING_AGG and grouped concatenation
- COPY and bulk-import commands
1 lectures · 14min
- Creating and querying views
- When a view simplifies downstream SQL
1 lectures · 23min
- Creating indexes in practice
- Measuring the impact on a query plan
1 lectures · 29min
- Writing a stored procedure
- Parameters, reuse and encapsulating logic
/ Skills
What you’ll actually be able to do
- 01
ER Modeling & Schema Design
Turning a scenario into entities, relationships and a schema.
- 02
Keys & Referential Integrity
Candidate, primary, super, foreign and surrogate keys.
- 03
Functional Dependency Theory
Armstrong's axioms, closure and candidate-key derivation.
- 04
Normalization, 1NF to BCNF
Lossless-join decomposition on real, messy tables.
- 05
SQL, Beginner to Advanced
DDL, DML, joins, subqueries, GROUP BY and aggregates.
- 06
Relational Algebra & Calculus
The formal theory behind every SQL query you write.
- 07
Transactions & Concurrency Control
ACID, locking, deadlocks and recovery.
- 08
Indexing & Query Performance
File organization, B-Trees and B+ Trees.
- 09
Data Warehousing & SCDs
Fact/dimension tables and Slowly Changing Dimensions.
- 10
Window Functions & CTEs
Ranking, running totals and recursive queries.
- 11
Views, Indexes & Stored Procedures
Encapsulating logic the way production systems do.
- 12
Exam-Ready DBMS Theory
Depth for GATE, ISRO and PSU-level exams.
/ Practice
12 sections of hands-on SQL
Theory sections are paired with a dedicated “SQL in Practice” track — constraints, operators, window functions, CTEs and more, each worked through on real queries.
A million rows, inserted and queried
Bulk-loading a million-record table, then measuring how batch inserts and indexing change performance.
- Bulk Insert
- Performance
- Indexing
Views, indexes & stored procedures
Wrapping real queries into views and stored procedures, and confirming an index actually changes the query plan.
- Views
- Stored Procs
- Query Plans
/ Program
One course, lifetime access
₹2,509
or from ₹500/month on a Udemy subscription
Exact pricing depends on active Udemy offers at checkout — verify against the live listing before each deploy.
- 24.5 hours on-demand video
- 4 articles
- 223 downloadable resources
- Assignments
- Full lifetime access · mobile & TV
- Certificate of completion
- 30-day money-back guarantee
4.4★
from 7,998 ratings
“Helpful to understand the concepts.”
“It is very useful and I have learnt a lot from it.”
“It is very good for learning.”
/ Instructor
Taught by Atchyut Kumar
Atchyut Kumar
Data Engineering & GATE CS/IT Faculty
Atchyut holds an M.Tech from NIT Calicut and placed in the 99.97 percentile of GATE CS/IT (AIR 440). Across 15+ years in teaching, research and industry he has mentored students into roles at Amazon, Google, Oracle, Samsung and Adobe — and brings 9+ years of hands-on data engineering to every module of this course.
- Data Engineering
- GATE CS/IT
- SQL & RDBMS
- 15+
- Years experience
- 110k+
- Students mentored
- 99.97
- GATE percentile
/ Contact
Questions before you enroll?
Reach the edufulness team directly — no form to fill out here, just a real inbox on the other end.