SQL Training | Deva - Senior Data Analytics Trainer

1.1 SQL Overview

Introduction to SQL (Structured Query Language)
Purpose and importance of SQL
SQL standards and versions
SQL vs NoSQL comparison

1.2 SQL Servers

What is a SQL Server?
Client–server architecture
Popular SQL servers: MySQL, Oracle, PostgreSQL

1.3 DBMS & RDBMS

Database Management System concepts
Relational Database Management System
Tables, rows, columns, and keys
Primary Key, Foreign Key, Candidate Key

1.4 Database Concepts

Database vs Table
Schema and instance
Normalization (1NF, 2NF, 3NF)
Indexes basics

1.5 Data Types

Numeric: INT, BIGINT, FLOAT, DECIMAL
Date & Time: DATE, DATETIME, TIMESTAMP
String: CHAR, VARCHAR, TEXT

2.1 Database Commands

CREATE DATABASE, SHOW DATABASES
DROP DATABASE, ALTER DATABASE
Selecting a database (USE)

2.2 Table Commands

CREATE TABLE with constraints
SHOW TABLES, DESCRIBE table
DROP TABLE, TRUNCATE TABLE

2.3 Data Manipulation (DML)

INSERT INTO (single & multiple rows)
UPDATE with conditions
DELETE with conditions
DELETE vs TRUNCATE difference

2.4 ALTER TABLE Operations

ADD, MODIFY, DROP column
RENAME column and table
Adding and removing constraints

3.1 Filtering Data

WHERE clause usage
AND, OR, NOT operators
IN and NOT IN operators
BETWEEN operator for ranges

3.2 Comparison Operators

Greater than, Less than operators
Greater/Less than or equal to
Not equal to (!= , <>)

3.3 Sorting & Grouping

ORDER BY (ASC, DESC)
GROUP BY clause
GROUP BY with aggregate functions

3.4 Pattern Matching & Limiting

LIMIT clause and OFFSET
LIKE operator for patterns
Wildcards (%, _)
HAVING vs WHERE clause

Core Aggregate Functions

COUNT() - counting records
SUM() - total calculation
AVG() - average calculation
MIN() and MAX() functions
DISTINCT with aggregates

5.1 Types of Joins

INNER JOIN
LEFT JOIN (LEFT OUTER JOIN)
RIGHT JOIN (RIGHT OUTER JOIN)
FULL OUTER JOIN
CROSS JOIN and Self Join

5.2 Subqueries

Single-row subqueries
Multi-row subqueries
Correlated subqueries
Subqueries in SELECT, FROM, WHERE

6.1 String Functions

CONCAT, LENGTH, UPPER, LOWER
SUBSTRING, TRIM, REPLACE
Pattern matching with REGEXP

6.2 Date & Time Functions

NOW(), CURDATE(), CURTIME()
DATEDIFF, DATE_ADD, DATE_SUB
Formatting dates with DATE_FORMAT

6.3 Real-World Case Studies

E-commerce database design
Sales reporting queries
Customer analytics projects
Interview preparation questions

Database Design

Create efficient database structures with proper normalization

Query Writing

Write complex queries to extract meaningful insights from data

Data Manipulation

Insert, update, and delete records efficiently

Joins & Relationships

Combine data from multiple tables using various join types

Data Aggregation

Summarize data using aggregate functions for reporting

Interview Ready

Practice real interview questions from top companies

MySQL Complete Training

Course Syllabus

SQL Basics