Home Courses DBMS & SQL
Database SQL & PL/SQL ✔ 3 Levels Available

DBMS & SQL
Full Programme

A structured three-level path from ANSI SQL foundations and core DDL/DML/DQL through enterprise DBMS architecture, normalization, NoSQL and cloud concepts, PL/SQL, and a professional capstone with Oracle architecture and dimensional modeling. Format: Theory + Lab/Assignments per syllabus.

🎯
Format
Theory + Lab/Assignments
🏆
Certificate
Arich Certified
Enrol Now →
Course Code
DBMS-SQL
Click a Level to View its Syllabus
L1
DBMS-SQL · Certification
10 Modules · Core SQL
›
L2
DBMS-SQL · Advanced
19 Modules · PL/SQL
›
L3
DBMS-SQL · Professional
26 Modules · Oracle + Project
›
📄 DBMS-SQL — Certification Level
L1
DBMS-SQL
Certificate Track — DBMS & SQL
01
DBMS – Introduction
▼
Data
Classification of Data
Purpose of Database
File-Based System
Introduction to Database
Usage of Database
Lab: Compare file-based vs database systems
02
SQL – An Introduction
▼
SQL Overview
Lab: Run basic SQL queries
03
Database Objects
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
04
Data Types – ANSI
▼
Character Types: char(n), varchar(n)
Numeric Types
Date/Time Types: Date, Time, Timestamp
Binary Types: binary(n), varbinary(n)
Boolean Type: true/false
Lab: Define and test data types in tables
05
Types of SQL Commands
▼
DDL – Data Definition Language
DML – Data Manipulation Language
DCL – Data Control Language
TCL – Transaction Control Language
DQL – Data Query Language
Lab: Categorize SQL statements by type
06
DDL – Data Definition Language
▼
Create
Alter
Drop
Truncate
Rename
Index
View
Synonyms
Sequences
SQL Operators
Lab: Practice DDL operations on sample schema
07
DML – Data Manipulation Language
▼
Insert
Update
Delete
Lab: Perform DML operations on sample data
08
DQL – Data Query Language
▼
SELECT
Aggregate Functions: sum(), avg(), max(), min(), count()
String Functions: concat(), substring(), length(), upper(), lower(), trim(), replace(), position()
Miscellaneous Functions: coalesce(), nullif(), case, cast(), convert()
SELECT with GROUP BY
SELECT with HAVING
Joins: inner, left, right, full, cross
Subqueries
Window Functions
Lab: Write and optimize complex queries
09
DCL – Data Control Language
▼
GRANT
REVOKE
Lab: Apply access control using DCL
10
TCL – Transaction Control Language
▼
COMMIT
ROLLBACK
SAVEPOINT
Lab: Simulate transactions and recovery
📄 DBMS-SQL — Advanced Level
L2
DBMS-SQL
Advanced DBMS & SQL
01
DBMS – Introduction
▼
Data
Classification of Data
Purpose of Database
File-Based System
Introduction to Database
Usage of Database
Lab: Compare file-based and relational systems
02
Database Architecture
▼
Three-Level Architecture
Database Functions
ACID Properties
Lab: Map architecture layers and test ACID compliance
03
Types of Database
▼
Base Model
New Model
Lab: Identify database types from use cases
04
Base Models
▼
Hierarchical
Network
Relational
Lab: Compare base model structures
05
New Models
▼
Object-Oriented
NoSQL
Lab: Explore NoSQL and object-oriented models
06
Cloud & NoSQL
▼
Types of Data
CAP Theorem
Document, Graph, Key-Value Models
Lab: Simulate CAP scenarios and NoSQL queries
07
Columnar & Normalization
▼
Normalization
1NF, 2NF, 3NF, BCNF
Lab: Normalize sample datasets
08
Dimensional Modeling
▼
Specialization & Generalization
Lab: Design dimensional models
09
Support for Views & ACID
▼
Atomicity
Consistency
Isolation
Durability
Lab: Test ACID properties using views
10
SQL – An Introduction
▼
SQL Overview
Lab: Run basic SQL queries
11
Database Objects
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
12
Data Types – ANSI
▼
Character, Numeric, Date/Time, Binary, Boolean
Lab: Define and test data types
13
Types of SQL Commands
▼
DDL, DML, DCL, TCL, DQL
Lab: Categorize SQL statements
14
DDL – Data Definition Language
▼
Create, Alter, Drop, Truncate
Rename, Index, View, Synonyms, Sequences
SQL Operators
Lab: Practice DDL operations
15
DML – Data Manipulation Language
▼
Insert, Update, Delete
Lab: Perform DML operations
16
DQL – Data Query Language
▼
SELECT
Aggregate, String, Miscellaneous Functions
GROUP BY, HAVING
Joins, Subqueries, Window Functions
Lab: Write and optimize complex queries
17
DCL – Data Control Language
▼
GRANT, REVOKE
Lab: Apply access control
18
TCL – Transaction Control Language
▼
COMMIT, ROLLBACK, SAVEPOINT
Lab: Simulate transactions
19
PL/SQL Programming
▼
PL/SQL Architecture
Operators, Data Types
Structure, Control Flow, Loops
Varray, Procedures, Functions
Cursor, Record Types
Exception Handling, Triggers
Lab: Build PL/SQL programs and test logic
📄 DBMS-SQL — Professional Level
L3
DBMS-SQL
Professional DBMS & SQL
01
DBMS – Introduction
▼
Data
Classification of Data
Purpose of Database
File-Based System
Introduction to Database
Usage of Database
Lab: Compare file-based and relational systems
02
Database Architecture
▼
Three-Level Architecture
Database Functions
ACID Properties
Lab: Map architecture layers and test ACID compliance
03
Types of Database
▼
Base Model
New Model
Lab: Identify database types from use cases
04
Base Models
▼
Hierarchical
Network
Relational
Lab: Compare base model structures
05
New Models
▼
Object-Oriented
NoSQL
Lab: Explore NoSQL and object-oriented models
06
Cloud & NoSQL
▼
Types of Data
CAP Theorem
Document, Graph, Key-Value Models
Lab: Simulate CAP scenarios and NoSQL queries
07
Columnar & Normalization
▼
Normalization
1NF, 2NF, 3NF, BCNF
Lab: Normalize sample datasets
08
Data Model Approach
▼
Top-Down
Bottom-Up
Lab: Apply modeling approaches to sample schema
09
Overview & Benefits of Data Models
▼
Role in Applications
Data Model Stages: Conceptual, Logical, Physical
Lab: Map stages to real-world scenarios
10
Logical & Physical Modeling
▼
Conversion Steps
Contents of Logical & Physical Models
Lab: Convert conceptual to logical and physical models
11
ERWIN Tool Demo
▼
Data Model Categories
OLTP
Lab: Explore ERWIN interface and model types
12
Dimensional Modeling
▼
Specialization & Generalization
Lab: Design dimensional models
13
Rollup & Rolldown Concepts
▼
Storage, Retrieval, Update
Authorization
Transaction Management
Concurrency Control
Backup & Recovery
Data Integrity
Metadata Handling
Communication Interfaces
Lab: Simulate rollup/rolldown operations
14
Support for Views & ACID
▼
Atomicity
Consistency
Isolation
Durability
Lab: Test ACID properties using views
15
RDBMS Foundations Using Oracle
▼
Oracle 19c Architecture
Database Server & Instance
Process Architecture
Logical Storage Hierarchy
Lab: Explore Oracle architecture components
16
SQL – An Introduction
▼
SQL Overview
Lab: Run basic SQL queries
17
Database Objects
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
18
Data Types – ANSI
▼
Character, Numeric, Date/Time, Binary, Boolean
Lab: Define and test data types
19
Types of SQL Commands
▼
DDL, DML, DCL, TCL, DQL
Lab: Categorize SQL statements
20
DDL – Data Definition Language
▼
Create, Alter, Drop, Truncate
Rename, Index, View, Synonyms, Sequences
SQL Operators
Lab: Practice DDL operations
21
DML – Data Manipulation Language
▼
Insert, Update, Delete
Lab: Perform DML operations
22
DQL – Data Query Language
▼
SELECT
Aggregate, String, Miscellaneous Functions
GROUP BY, HAVING
Joins, Subqueries, Window Functions
Lab: Write and optimize complex queries
23
DCL – Data Control Language
▼
GRANT, REVOKE
Lab: Apply access control
24
TCL – Transaction Control Language
▼
COMMIT, ROLLBACK, SAVEPOINT
Lab: Simulate transactions
25
PL/SQL Programming
▼
PL/SQL Architecture
Operators, Data Types
Structure, Control Flow, Loops
Varray, Procedures, Functions
Cursor, Record Types
Exception Handling, Triggers
Lab: Build PL/SQL programs and test logic
26
Mini Project
▼
Lab: End-to-end DBMS project implementation