Turning Learners Into Developers

SQL·Beginner

SQL

The universal language of data.

Query any relational database with confidence.

4 weeks

298 lessons

1 examples

Certificate on completion

// preview.sql

sql

SELECT name, SUM(amount) AS total
FROM orders
GROUP BY name
HAVING total > 1000;

Start learning now </> Examples Q· Viva Questions Σ Exam Questions

# curriculum

0 / 298 lessons·0% complete

01What is SQL?02History of SQL 03Features of SQL 04Applications of SQL 05Types of Databases 06Relational Database Concepts 07RDBMS vs DBMS 08SQL Standards 09Popular Database Systems 10SQL Architecture 11Client-Server Database Model 12What is a Database?13Tables, Rows, Columns 14Records & Fields 15Primary Key 16Foreign Key 17Candidate Key 18Composite Key 19Unique Key 20Relationships in Database 21One-to-One Relationship 22One-to-Many Relationship 23Many-to-Many Relationship 24Entity Relationship Model (ER Model)25Database Normalization 26Denormalization 27Installing MySQL/PostgreSQL 28SQL Environment Setup 29Database Tools & Interfaces 30Creating First Database 31Creating First Table 32SQL Syntax Rules 33SQL Statements 34SQL Comments 35Naming Conventions 36Numeric Data Types 37String Data Types 38CHAR vs VARCHAR 39Date & Time Data Types 40Boolean Data Types 41Binary Data Types 42ENUM & SET Types 43Choosing Correct Data Types 44CREATE DATABASE 45DROP DATABASE 46ALTER DATABASE 47RENAME DATABASE 48SHOW DATABASES 49USE DATABASE 50CREATE TABLE 51DROP TABLE 52ALTER TABLE 53RENAME TABLE 54TRUNCATE TABLE 55TRUNCATE vs DELETE vs DROP 56DESCRIBE TABLE 57Adding Columns 58Modifying Columns 59Deleting Columns 60Changing Constraints 61PRIMARY KEY 62Primary Key vs Foreign Key 63FOREIGN KEY 64UNIQUE 65NOT NULL 66CHECK 67DEFAULT 68AUTO_INCREMENT 69Composite Constraints 70Constraint Management 71INSERT INTO 72INSERT Multiple Rows 73SELECT Statement 74UPDATE Statement 75DELETE Statement 76REPLACE Statement 77UPSERT Concepts 78SELECT *79Selecting Specific Columns 80DISTINCT Keyword 81Column Aliases 82Arithmetic Operations 83String Concatenation 84LIMIT Clause 85TOP Clause 86OFFSET Clause 87WHERE Clause 88AND Operator 89OR Operator 90NOT Operator 91BETWEEN Operator 92IN Operator 93NOT IN Operator 94LIKE Operator 95Wildcards 96IS NULL 97IS NOT NULL 98EXISTS Operator 99ORDER BY Clause 100ASC Sorting 101DESC Sorting 102Sorting Multiple Columns 103Custom Sorting 104CONCAT()105LENGTH()106UPPER()107LOWER()108SUBSTRING()109REPLACE()110TRIM()111REVERSE()112ROUND()113CEIL()114FLOOR()115ABS()116MOD()117POWER()118NOW()119CURDATE()120DATE_ADD()121DATE_SUB()122DATEDIFF()123YEAR()124MONTH()125DAY()126COUNT()127SUM()128AVG()129MIN()130MAX()131GROUP BY Clause 132HAVING Clause 133WHERE vs HAVING 134Aggregate Filtering 135Grouping Multiple Columns 136Advanced Grouping (ROLLUP / CUBE)137INNER JOIN 138LEFT JOIN 139RIGHT JOIN 140FULL JOIN 141CROSS JOIN 142SELF JOIN 143INNER JOIN vs LEFT JOIN 144Joining Multiple Tables 145Join Optimization 146Single Row Subquery 147Multiple Row Subquery 148Correlated Subquery 149Nested Subqueries 150Subquery with EXISTS 151Subquery with IN 152UNION 153UNION ALL 154UNION vs UNION ALL 155INTERSECT 156EXCEPT / MINUS 157What is a View?158CREATE VIEW 159UPDATE VIEW 160DROP VIEW 161Advantages of Views 162Materialized Views 163What is an Index?164CREATE INDEX 165UNIQUE INDEX 166Composite Index 167DROP INDEX 168Clustered Index 169Non-Clustered Index 170Clustered vs Non-Clustered Index 171Index Optimization 172What is a Transaction?173ACID Properties 174COMMIT 175ROLLBACK 176SAVEPOINT 177Transaction Control Language (TCL)178Deadlocks 179Concurrency Control 180What are Stored Procedures?181CREATE PROCEDURE 182Parameters in Procedures 183Procedure Variables 184Control Statements 185Calling Procedures 186Altering Procedures 187Dropping Procedures 188User Defined Functions 189CREATE FUNCTION 190Scalar Functions 191Table-Valued Functions 192Triggers 193BEFORE Trigger 194AFTER Trigger 195INSERT Trigger 196UPDATE Trigger 197DELETE Trigger 198Trigger Applications 199What is a Cursor?200Cursor Lifecycle 201Cursor Operations 202Cursor Examples 203Database Users 204Roles & Permissions 205GRANT Statement 206REVOKE Statement 207SQL Injection 208Preventing SQL Injection 209Database Security Best Practices 2101NF 2112NF 2123NF 2131NF vs 2NF vs 3NF 214BCNF 2154NF 2165NF 217Functional Dependencies 218Common Table Expressions (CTE)219Recursive Queries 220Window Functions 221Ranking Functions 222ROW_NUMBER()223RANK()224DENSE_RANK()225LEAD()226LAG()227Partitioning 228Pivot & Unpivot 229Dynamic SQL 230Query Optimization 231Execution Plans 232Index Tuning 233Query Caching 234Performance Monitoring 235Optimizing Joins 236Optimizing Subqueries 237Database Scaling 238Database Backup 239Database Restore 240Exporting Data 241Importing Data 242Replication Basics 243SQL with Python 244SQL with PHP 245SQL with Node.js 246SQL with Java 247SQL with C#248ORM Basics 249MySQL Architecture 250Storage Engines 251InnoDB 252MyISAM 253MySQL Workbench 254MySQL User Management 255PostgreSQL Features 256JSON Support 257Arrays in PostgreSQL 258PostgreSQL Extensions 259Project — Student Management System 260Project — Library Management System 261Project — Ecommerce Database 262Project — Banking System 263Project — Hospital Management System 264Project — Inventory Management System 265Project — Employee Management System 266Writing Complex Queries 267Report Generation 268Analytics Queries 269Dashboard Queries 270Interview Questions 271Company SQL Problems 272SQL Interview Preparation 273SQL Interview Questions 274Query Challenges 275Optimization Questions 276Scenario-Based Questions 277Database Design Questions 278Mini Project — Attendance System 279Mini Project — Online Store Database 280Mini Project — Blogging Database 281Mini Project — CRM Database 282Mini Project — Food Delivery Database 283Advanced Project — Enterprise ERP Database 284Advanced Project — AI Analytics Database 285Advanced Project — Subscription Management Database 286Advanced Project — Real Estate CRM Database 287Advanced Project — Hospital ERP Database 288Clean Query Writing 289Database Design Standards 290Query Readability 291Error Handling 292Secure Coding Practices 293Capstone — Full Database Design 294Capstone — Schema Planning 295Capstone — Query Optimization 296Capstone — Reports & Analytics 297Capstone — Security Implementation 298Capstone — Deployment & Backup

enroll.now()

Free

Full access. No credit card.

✓ Lifetime access

✓ Code along with projects

✓ Community support 24/7

Explore all courses