Diwali offer: Flat 30% off on all courses plus free career counselling. Ends 5 Nov.Claim offer

SQL & Database Course in Delhi

Learn to design databases and write SQL queries with MySQL. Joins, aggregations and practical exercises, taught hands-on at our Maujpur, Delhi centre.

3 Months Offline / Online Certificate Provided Project-Based Learning

Course Overview

SQL & Database at White Fortress Academy teaches you how data is stored, organised and retrieved. SQL is a core skill for developers, data analysts and anyone who works with business data.


You learn how relational databases work, how to create and design tables, and how to write queries to filter, join and summarise data. You also learn the basics of managing a database.


The course is short and practical. Most of your time is spent writing queries on real sample data.

Who Should Join This Course?

Beginners, students, accounts and office staff who work with data, and learners planning to move into programming, web development or data analytics. No programming background is needed.

Course Curriculum

30 modules · 93 topics

Intro to Databases & RDBMS

4 modules
01

What a Database Is

3 topics
  • Database Basics
  • What is a database
  • Data vs information
  • Spreadsheet vs database
  • DBMS and RDBMS
  • Why Databases Matter
  • Storing data reliably
  • Fast searching and sorting
  • Many users, one database
  • Real-world examples
  • SQL vs NoSQL & Terminology
  • SQL vs NoSQL overview
  • Table, row, column
  • Query, schema, record
  • Popular RDBMS: MySQL, PostgreSQL
02

Tables, Rows & Keys

3 topics
  • Tables, Rows & Columns
  • Table as entity
  • Rows as records
  • Columns as fields
  • Reading a sample table
  • Keys
  • Primary key rules
  • Candidate and composite keys
  • Foreign key links
  • Unique identifiers
  • Data Integrity
  • Entity integrity
  • Referential integrity
  • Valid and consistent data
03

How Relational Databases Work

3 topics
  • How RDBMS Works
  • Client and server model
  • Databases, tables, schemas
  • Splitting data across tables
  • Linking tables using keys
  • Relationships & ER Diagrams
  • One-to-one, one-to-many
  • Many-to-many relationship
  • Entities and attributes
  • Reading ER diagrams
  • Design Basics
  • Identifying entities
  • Choosing keys
  • Sketching tables on paper
04

Installing & Using MySQL

3 topics
  • Installing MySQL
  • MySQL Community Server
  • Installer on Windows
  • Setting the root password
  • Checking server is running
  • MySQL Workbench Tour
  • Connections and SQL editor
  • Schemas navigator panel
  • Result grid and output
  • Running Queries & Sample Data
  • Listing & selecting databases
  • Running your first query
  • Command-line client
  • Importing sample SQL file

Table Creation & Design

4 modules
05

CREATE TABLE

4 topics
  • CREATE TABLE Basics
  • Creating & selecting a database
  • Table creation structure
  • Column definitions
  • Inspecting tables
  • Choosing Data Types
  • INT and BIGINT
  • VARCHAR vs CHAR
  • DECIMAL for money
  • DATE, DATETIME, TIMESTAMP
  • Changing Tables
  • Adding a column
  • Modifying & renaming columns
  • Removing columns & tables
  • Emptying vs removing a table
  • Table Practice
  • Create students table
  • Create products table
06

Constraints & Primary Keys

4 topics
  • Primary Keys
  • Primary key constraint
  • Composite primary key
  • Choosing a key column
  • NOT NULL & UNIQUE
  • NOT NULL columns
  • UNIQUE constraint
  • Email and phone uniqueness
  • DEFAULT & CHECK
  • DEFAULT values
  • CHECK constraint
  • Naming constraints
  • Auto Increment
  • Auto-increment IDs
  • Getting the last inserted ID
  • Testing constraint errors
07

Normalisation

3 topics
  • Normalisation Basics
  • Why redundancy hurts
  • Insert, update, delete anomalies
  • Functional dependency idea
  • Normal Forms
  • 1NF atomic values
  • 2NF partial dependency
  • 3NF transitive dependency
  • Splitting tables step by step
  • Normalisation Practice
  • Normalise an order sheet
  • Fix a repeating-group table
  • When to denormalise
08

Planning Tables

3 topics
  • Planning Tables
  • Gathering requirements
  • Listing entities and attributes
  • Choosing keys and types
  • Drawing relationships
  • Student & Library Databases
  • Students, courses, marks
  • Books, members, issues
  • Resolving many-to-many link
  • Writing table creation scripts
  • Design Review
  • Checking normal forms
  • Peer review checklist
  • Improving a weak design

SQL Queries & Filtering

5 modules
09

SELECT

3 topics
  • SELECT Basics
  • SELECT specific columns
  • Selecting all columns & its risks
  • FROM clause
  • SQL comments
  • DISTINCT & Aliases
  • SELECT DISTINCT
  • Column aliases with AS
  • Table aliases
  • Calculated Columns
  • Arithmetic in SELECT
  • CONCAT for full names
  • Select Practice queries
10

WHERE, ORDER BY & LIMIT

3 topics
  • WHERE Filtering
  • Comparison operators
  • AND, OR, NOT
  • Operator precedence
  • Parentheses in conditions
  • ORDER BY
  • ASC and DESC
  • Sorting by multiple columns
  • Sorting by alias
  • LIMIT & Pagination
  • LIMIT n rows
  • LIMIT with OFFSET
  • Top-N queries
  • Pagination practice
11

INSERT, UPDATE & DELETE

3 topics
  • INSERT
  • Inserting a row
  • Listing column names
  • Multi-row bulk insert
  • Copying rows between tables
  • UPDATE & DELETE
  • Updating values
  • Deleting specific rows
  • Danger of a missing filter
  • Preview with a query first
  • Safe Modification
  • Safe updates mode
  • Backup table before changes
  • Modification practice
12

LIKE, IN & BETWEEN

3 topics
  • LIKE & Wildcards
  • Pattern matching with wildcards
  • Underscore single character
  • NOT LIKE
  • Case sensitivity and collation
  • IN & BETWEEN
  • IN list of values
  • NOT IN pitfalls
  • BETWEEN for ranges
  • Date range filters
  • NULL Handling
  • Checking for empty values
  • NULL is not zero
  • COALESCE and IFNULL
  • Pattern matching practice
13

Functions & CASE

3 topics
  • String Functions
  • UPPER, LOWER, LENGTH
  • SUBSTRING and TRIM
  • REPLACE and CONCAT
  • Date & Numeric Functions
  • NOW, CURDATE
  • DATE_FORMAT
  • DATEDIFF, DATE_ADD
  • ROUND, CEIL, FLOOR
  • CASE Expressions
  • Simple CASE
  • Searched CASE WHEN
  • Grading and bands example
  • Function practice queries

Joins & Relationships

4 modules
14

Foreign Keys & Relationships

3 topics
  • Foreign Keys in MySQL
  • Defining a foreign key
  • Parent and child tables
  • Adding keys to existing tables
  • Referential Integrity
  • Insert order matters
  • Cascading deletes
  • Restricting deletes & setting empty values
  • Foreign key errors
  • Many-to-Many & Diagrams
  • Junction table design
  • Students and courses example
  • Reverse engineer in Workbench
  • Reading relationship diagrams
15

Inner, Left & Right Joins

3 topics
  • INNER JOIN
  • Join conditions
  • INNER JOIN vs LEFT JOIN
  • Joining three tables
  • LEFT & RIGHT JOIN
  • LEFT JOIN unmatched rows
  • RIGHT JOIN basics
  • Finding rows with no match
  • NULLs after outer joins
  • Self & Cross Joins
  • Self join employee-manager
  • CROSS JOIN combinations
  • Join practice queries
16

One-to-Many Relationships

3 topics
  • One-to-Many Basics
  • One parent, many children
  • Foreign key on many side
  • Counting child rows
  • Orders & Customers
  • Customers and orders tables
  • Orders with customer names
  • Customers with no orders
  • Order totals per customer
  • Library & Join Reports
  • Authors and books
  • Members and issued books
  • Overdue books report
  • Multi-table join reports
17

Subqueries

3 topics
  • Subqueries
  • Subquery in WHERE
  • IN with subquery
  • Subquery in FROM
  • Scalar subquery
  • Correlated Subqueries
  • Correlated subquery logic
  • EXISTS and NOT EXISTS
  • Subquery vs JOIN
  • UNION & Set Operations
  • UNION vs UNION ALL
  • Matching column counts
  • Subquery practice queries

Aggregations & Analysis

4 modules
18

Aggregate Functions

3 topics
  • Core Aggregate Functions
  • COUNT rows
  • SUM and AVG
  • MIN and MAX
  • Counting all rows vs a column
  • NULLs & Rounding
  • Aggregates ignore NULL
  • COALESCE inside SUM
  • ROUND, TRUNCATE results
  • Formatting totals
  • Aggregate Practice
  • Total sales query
  • Average marks query
  • Highest and lowest salary
19

GROUP BY & HAVING

3 topics
  • GROUP BY
  • GROUP BY one column
  • Grouping multiple columns
  • Aggregates per group
  • GROUP BY with JOIN
  • Filtering Groups
  • HAVING clause
  • WHERE vs HAVING
  • GROUP BY with HAVING
  • Group Practice
  • Orders per customer
  • Students per course
  • Monthly sales totals
20

Summary Reports

3 topics
  • Summary Reports
  • Report design basics
  • Sales by month
  • Revenue by category
  • Top customers report
  • Ranking Records
  • Top-N per category idea
  • ORDER BY with LIMIT
  • RANK and DENSE_RANK
  • Window Function Basics
  • OVER clause
  • ROW_NUMBER
  • PARTITION BY
  • Running total
21

Business Questions with SQL

3 topics
  • From Question to Query
  • Reading a business question
  • Choosing tables and columns
  • Building query step by step
  • Data Cleaning Queries
  • Finding duplicate rows
  • Trimming and fixing text
  • Finding missing values
  • Standardising with CASE
  • Case Studies & Review
  • Retail sales case study
  • School results case study
  • Query review checklist
  • Readable query formatting

DB Management

4 modules
22

Users & Privileges

3 topics
  • Users & Accounts
  • Creating users
  • Host and password
  • Removing users
  • Viewing user accounts
  • GRANT & REVOKE
  • Granting read access
  • Revoking privileges
  • Viewing granted privileges
  • Applying privilege changes
  • Roles & Security Habits
  • Creating & assigning roles
  • Least privilege principle
  • Avoid root for apps
  • Strong passwords
23

Backup & Restore

3 topics
  • Backup Basics
  • Why backups matter
  • Logical vs physical backup
  • Backup schedule ideas
  • mysqldump
  • Taking a database backup
  • Backing up one database
  • Backing up all databases
  • Backing up a single table
  • Restore & Import/Export
  • Restoring from a backup file
  • Exporting query results to a file
  • Importing data from a file
  • Restore practice drill
24

Indexes & Views

3 topics
  • Indexes
  • What an index does
  • Creating indexes
  • Unique and composite index
  • Removing indexes
  • Views
  • Creating views
  • Views for reporting
  • Updating and dropping views
  • Performance Tuning Tips
  • Reading the query plan
  • Avoid selecting every column
  • Index on WHERE columns
  • Cost of too many indexes
25

Transactions & Good Habits

3 topics
  • Transactions
  • Starting a transaction
  • Saving & undoing changes
  • ACID properties
  • Bank transfer example
  • Stored Procedures & Triggers
  • Creating stored procedures
  • Procedure parameters & calling
  • BEFORE and AFTER triggers
  • Audit log trigger
  • Good Database Habits
  • Naming conventions
  • Test on copy first
  • Regular backups
  • Document your schema

Practical Exercises

4 modules
26

Query Practice Sets

3 topics
  • Query Practice Sets
  • Filtering and sorting set
  • Join practice set
  • Aggregation practice set
  • Subquery practice set
  • Interview Questions
  • Second highest salary
  • Find duplicate records
  • Delete vs truncate vs drop
  • WHERE vs HAVING
  • Case Studies & Timed Practice
  • Online store case study
  • Hospital data case study
  • 30-minute timed drill
27

Mini Database Project

3 topics
  • Planning & Design
  • Choosing a project topic
  • Listing requirements
  • ER diagram drawing
  • Normalising final design
  • Building & Querying
  • Creating tables and keys
  • Inserting sample data
  • Ten report queries
  • Views and indexes
  • Presenting Results
  • Project demo walkthrough
  • Explaining design choices
  • Submitting SQL script
28

Fixing SQL Errors

3 topics
  • Syntax Errors
  • Missing comma or quote
  • Misspelled keywords
  • Reserved word as column
  • Reading error messages
  • Logic Errors
  • Wrong join condition
  • Missing grouping column
  • Duplicate rows from joins
  • NULL comparison mistakes
  • Debugging Queries
  • Run query in parts
  • Check row counts
  • Test with small data
  • Common MySQL error codes
29

Revision

3 topics
  • Review & Revision
  • Revisit RDBMS and keys
  • Revisit joins and aggregates
  • Revise admin tasks
  • Mock Test
  • Multiple-choice section
  • Query writing section
  • Timed mock paper
  • Doubt Clearing & Assessment
  • Doubt-clearing session
  • Final practical assessment
  • Next steps after course

AI-Assisted SQL

1 module
30

Using AI with SQL

4 topics
  • Plain-English Prompts to SQL
  • Share schema with the prompt
  • Describing the question clearly
  • Asking for step-by-step logic
  • Refining with follow-ups
  • Explaining & Fixing Errors
  • Pasting error messages
  • Asking AI to explain queries
  • Comparing fixes to the docs
  • Verifying AI Queries
  • Test on small sample data
  • Cross-check with manual count
  • Review joins & filters
  • Never run unchecked deletions
  • Protecting Sensitive Data
  • No real customer data
  • Use dummy sample data
  • Share schema, not records

Practice Projects

Project 1Student database with queries
Project 2Library or inventory database using joins
Project 3Sales report queries
Project 4Employee records database
Project 5Order management database with joins
Project 6Bank transactions database with rollback

Tools & Technologies

MySQL MySQL Workbench SQL Command Line

Career Opportunities

Trainee Database Administrator

Help design, manage and back up databases for businesses.

Data Analyst (Entry Level)

SQL is a core skill for pulling and analysing business data.

Backend / Web Developer

Almost every web application stores its data in a database.

MIS / Reporting Executive

Prepare reports and dashboards from company data.

Course Details

Duration3 Months (individual course)
ModeOffline (Delhi Centre) / Online Classes Available
Batch TimingMorning & Evening Batches (Mon–Sat)
EligibilityBasic computer knowledge required. No prior programming experience needed.
CertificateCompletion Certificate from White Fortress Academy provided on passing
SupportLive project assignments + Code review sessions + Placement guidance

Frequently Asked Questions

How long is the SQL & Database course in Delhi?

The SQL & Database course takes 3 months. Batches run in the morning and evening, Monday to Saturday.

Do I need programming knowledge before learning SQL?

No. SQL is query based and beginner friendly, so no programming background is needed.

Is SQL useful for Data Analytics?

Yes. SQL is a core data analytics skill, and you can follow this course with our Data Analytics course.

Do I need any prior knowledge to join?

Basic computer knowledge required. No prior programming experience needed.

Is the SQL & Database course offline or online, and what are the batch timings?

Mode: Offline (Delhi Centre) / Online Classes Available. Batch timing: Morning & Evening Batches (Mon–Sat).

Will I get a certificate after the SQL & Database course?

Yes. White Fortress Academy provides a completion certificate on passing the course.

Which tools will I use in the SQL & Database course?

You will work with MySQL, MySQL Workbench, SQL Command Line.

What jobs can I aim for after the SQL & Database course?

Roles related to this skill include Trainee Database Administrator, Data Analyst (Entry Level), Backend / Web Developer and MIS / Reporting Executive. Hiring depends on your skills and the market. The academy's support includes live project assignments, code review sessions and placement guidance.

What is the fee for the SQL & Database course, and can I try a demo class?

The fee is not listed on this page, so please ask the centre for the current fee and the next batch date. Call or WhatsApp +91 88104 71374, or visit 53, Maujpur Main Road, Opp. HDFC Bank, Delhi 110053 (Monday to Saturday, 9:00 AM to 8:00 PM). A free demo class is available.

Start Learning SQL & Database Today!

Join a hands-on batch at our Maujpur, Delhi centre and learn by writing real code.

Enroll Now Ask on WhatsApp