NFO
Mimir, Keeper of the Well of Wisdom
The Complete SQL Bootcamp : From Beginner to Advanced
https://www.udemy.com/course/sql-bootcamp-abdulbari/
Year : 2026
Language : English
Level : All Levels
Category : Development
Subcategory : Database Design & Development
Duration : 14h 10m
Lectures : 113
Rating : 4.6/5 (35 reviews)
Students : 178
INSTRUCTOR(S)
HEADLINE
Learn SQL,MySQL & Database Design. Master JOINS, Subqueries,
Window Functions, CTEs, Views, and and Real-World Projects
WHAT YOU'LL LEARN
* Write SQL queries confidently from beginner to advanced
level
using real-world databases
* Master SQL JOINS (INNER, LEFT, RIGHT, FULL, SELF, CROSS) to
combine multiple tables effectively
* Use Subqueries, CASE statements, and advanced WHERE clause
filtering techniques
* Apply Window Functions like ROW_NUMBER, RANK, DENSE_RANK,
LAG,
and LEAD for data analysis
* Design and understand relational database structures
including
tables, keys, and relationships
* Implement Common Table Expressions (CTE) and Recursive CTEs
for complex query building
* Perform data aggregation using GROUP BY, HAVING, and
advanced
SQL functions
* Create, modify, and manage databases using DDL and DML
commands in MySQL
REQUIREMENTS
* No prior SQL experience needed ? we start from fundamentals
and build step-by-step
* Basic computer skills and familiarity with using a computer
* A computer (Mac or Windows) to install SQL tools
* Motivation to practice queries and complete coding exercises
WHO IS THIS COURSE FOR
* It is ideal for:
* Students preparing for placements or technical interviews
who
want structured SQL mastery
* Working professionals looking to upgrade their database and
query-writing skills
* Developers who want to strengthen backend database knowledge
* Data analysts and aspiring data professionals who want to
master advanced SQL techniques
* Anyone who wants hands-on experience with real-world
databases
and complex queries
* This course is especially valuable for learners who prefer:
* A step-by-step structured progression
* Practical examples using real databases
* In-lecture labs and coding exercises
* Quizzes and notes for reinforcement
* Clear explanations of both basic and advanced SQL concepts
DESCRIPTION
Complete SQL Master Course ? Learn SQL the Right Way SQL is
one
of the most in-demand technical skills in data analytics,
backend development, business intelligence, and database
management. Whether you're a student, working professional,
developer, or aspiring data analyst, mastering SQL is
essential.
This course is a complete, structured SQL bootcamp designed to
take you from absolute beginner to advanced query writing
using
real-world databases and practical business scenarios. You?ll
start with database fundamentals and SQL basics, then
progressively move into advanced topics including: ├║ SELECT
statements and query execution flow ├║ WHERE clauses and
filtering techniques ├║ GROUP BY & HAVING with aggregate
functions ├║ All types of JOINS (INNER, LEFT, RIGHT, FULL,
SELF,
CROSS) CASE WHEN logic ├║ Subqueries in SELECT, WHERE, HAVING &
FROM ├║ Advanced Window Functions (ROW_NUMBER, RANK,
DENSE_RANK,
LAG, LEAD, NTILE) ├║ Common Table Expressions (CTE) & Recursive
CTE ├║ Views and CTAS ├║ Data Definition Language (DDL) and Data
Manipulation Language (DML) ├║ Stored Procedures You?ll work
with
multiple practical databases including: ? CompanyDB
(enterprise
structure) ? eCommerceDB (transactional system) ? WebFlix
database (advanced analytical queries) Each section includes
notes, quizzes, labs, and coding exercises to reinforce
learning
and build real confidence. By the end of this course, you will
confidently write complex SQL queries, understand database
structure, and solve real-world data problems ? making you
interview-ready and job-ready.
COURSE CONTENT
Chapter 1: Introduction to Databases
1. What are Databases ?
2. Applications & Uses
3. Database Terminology
4. SQL Command Categories
Chapter 2: Designing Database - CompanyDB
5. Database Design -- CompanyDB
Chapter 3: Setup & Install Databases
6. MySQL Installation
7. PostgreSQL Installation
Chapter 4: Create companyDB Database (Must Watch)
8. Create CompanyDB
Chapter 5: What is DDL and DML ?
9. Creating Database -- DDL Queries
10. Inserting into Database -- DML Queries
Chapter 6: Select Queries
11. Introduction to Select Queries
12. Order of Query Execution
13. Selecting Entire Table
14. Filtering Columns
15. Aliasing Columns
16. Distinct Queries
17. OrderBy Clause
18. Limit & Offset
Chapter 7: Database Design - eCommerce
19. Designing eCommerce Database
20. Create e-CommerceDB
Chapter 8: Database Design - Normalization & Natural JOIN
21. Normalization
22. Natural JOIN
Chapter 9: WHERE Clause
23. WHERE Clause
24. Comparison Operators
25. CompoundConditions-FilteringRecords
26. Compound Conditions
27. Membership Operators
28. Pattern Matching
29. Range Queries
Chapter 10: Designing Database - WebFlix
30. Designing WebFlix Database
31. Create WebFlixDB
Chapter 11: Group By & Having
32. Aggregate Function
33. Group By & Having
34. Sum( ) & Avg( )
35. Min( ) & Max( )
Chapter 12: Strings
36. String Functions
37. String Functions-Length
38. String Functions -Concatenation
39. StringFunctions-Trimming&Padding
40. String Functions-CaseChange
41. StringFunctions-SubStrings
42. StringFunctions-Replace&Search
Chapter 13: Set Operations
43. Set Operations
44. Set Operations In SQL
45. UNION & UNIONALL
46. INTERSECT
47. EXCEPT
Chapter 14: Date & Time Functions
48. Introduction Date & Time Functions
49. CurrentDate & Time
50. Date & Time Extraction
51. Date & Time Extraction-Date Format
52. Date & Time Conversion
53. Date & Time-Arithmetic
54. Date & Time-UTC
55. Date & Time-Difference
Chapter 15: JOINS
56. What are JOINS
57. All JOINS
58. More JOINS
59. Self JOIN
60. Cross & InnerJoin Queries
61. Left,Right & Full JOIN Queries
62. Natural JOIN Queries
63. Self JOIN Queries
Chapter 16: CASE WHEN
64. 1.1. Case_When-Select
65. 1.2. Case_When-OrderBy
66. Case_When-Where
67. Case_When-Having
Chapter 17: Sub Query
68. Introduction to Sub Queries
69. Sub Queries-WHERE Clause
70. Sub Queries-HAVING Clause
71. Sub Queries-SELECT Clause
72. Sub Queries-FROM Clause
Chapter 18: Window Functions - Aggregate Functions
73. Introduction to Window Functions
74. SUM ( )
75. Queries on SUM ( )
76. AVG( )
77. Queries on AVG( )
78. COUNT( )
79. MAX( )
80. MIN( )
Chapter 19: Window Functions - Ranking Functions
81. ROW_NUMBER( )
82. RANK( ) - DENSERANK( )
83. Queries on ROW_NUMBER( )
84. Queries on RANK( ) & DENSE_RANK( )
85. More Queries on RANK( ) & DENSE_RANK( )
86. NTILE( )
87. Queries on NTILE( )
Chapter 20: Window Functions - Value Access Functions
88. LAG( )
89. LEAD( )
90. Queries on LAG( ) & LEAD( )
91. FIRST_VALUE( ) - LAST_VALUE( ) - NTH_VALUE( )
Chapter 21: Common Table Expressions ( CTE )
92. Introduction to CTE
93. Multiple CTE's
94. Recursive CTE's
95. Queries on Recursive CTE's
Chapter 22: VIEWS
96. Simple VIEW
97. Complex & Materialized VIEW
Chapter 23: CTAS:( Create TABLE As SELECT )
98. CTAS
Chapter 24: Stored Procedures
99. Introduction to Stored Procedures
100. Parameterized Stored Procedure
101. Multiple Parameter Stored Prodeures
102. Out Parameter
103. Variable Stored Procedure
104. Control Flow-Stored Procedures
Chapter 25: Data Definition Language (DDL)
105. What is DDL ?
106. Create TABLE.
107. What is Data Dictionary?
108. ALTER TABLE
109. RENAME TABLE
110. TRUNCATE TABLE
Chapter 26: Data Manipulation Language (DML)
111. INSERT TABLE
112. UPDATE TABLE
113. DELETE TABLE
DATES
Published : 2026-02-27
Last Updated : 2026-03-05
If you fear the truth, dont come to my well.
CRC32: 9ea14f5298b175dcabc10d4d992be0e671e1cf25