Book a Call 🏠 Home About Courses Services Corporate Events Contact
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.

⏱
Duration
45 Hours
🧪
Lab / Assignments
20 Hours
🎯
Format
Theory + Lab/Assignments
🏆
Certificate
Arich Certified
Enrol Now →
Course Code
DBMS-SQL
Click a Level to View its Syllabus
L1
DBMS-SQL · Certification
45 hrs · 10 Modules · Core SQL
›
L2
DBMS-SQL · Advanced
19 Modules · PL/SQL
›
L3
DBMS-SQL · Professional
~80 hrs · 26 Modules · Oracle + Project
›
📄 DBMS-SQL — Certification Level
L1
DBMS-SQL
Certificate Track — DBMS & SQL
Total Duration: 45 Hours (programme)  |  Module breakdown: 40 hrs  |  Theory: 20 hrs  |  Lab: 20 hrs
01
DBMS – Introduction
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
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
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
SQL Overview
Lab: Run basic SQL queries
03
Database Objects
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
04
Data Types – ANSI
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
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
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
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
Theory: 6 hrs  ·  Lab: 6 hrs  ·  Total: 12 hrs
▼
Create
Alter
Drop
Truncate
Rename
Index
View
Synonyms
Sequences
SQL Operators
Lab: Practice DDL operations on sample schema
07
DML – Data Manipulation Language
Theory: 6 hrs  ·  Lab: 6 hrs  ·  Total: 12 hrs
▼
Insert
Update
Delete
Lab: Perform DML operations on sample data
08
DQL – Data Query Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
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
Theory: 0.75 hrs  ·  Lab: 0.75 hrs  ·  Total: 1.5 hrs
▼
GRANT
REVOKE
Lab: Apply access control using DCL
10
TCL – Transaction Control Language
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
COMMIT
ROLLBACK
SAVEPOINT
Lab: Simulate transactions and recovery
40
Module Hours
20
Theory Hrs
20
Lab Hrs
📄 DBMS-SQL — Advanced Level
L2
DBMS-SQL
Advanced DBMS & SQL
Total Duration: 60 Hours (programme)  |  Module breakdown: 56 hrs  |  Theory: 28 hrs  |  Lab: 28 hrs
01
DBMS – Introduction
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
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
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
Three-Level Architecture
Database Functions
ACID Properties
Lab: Map architecture layers and test ACID compliance
03
Types of Database
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Base Model
New Model
Lab: Identify database types from use cases
04
Base Models
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Hierarchical
Network
Relational
Lab: Compare base model structures
05
New Models
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Object-Oriented
NoSQL
Lab: Explore NoSQL and object-oriented models
06
Cloud & NoSQL
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Types of Data
CAP Theorem
Document, Graph, Key-Value Models
Lab: Simulate CAP scenarios and NoSQL queries
07
Columnar & Normalization
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
Normalization
1NF, 2NF, 3NF, BCNF
Lab: Normalize sample datasets
08
Dimensional Modeling
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Specialization & Generalization
Lab: Design dimensional models
09
Support for Views & ACID
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Atomicity
Consistency
Isolation
Durability
Lab: Test ACID properties using views
10
SQL – An Introduction
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
SQL Overview
Lab: Run basic SQL queries
11
Database Objects
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
12
Data Types – ANSI
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Character, Numeric, Date/Time, Binary, Boolean
Lab: Define and test data types
13
Types of SQL Commands
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
DDL, DML, DCL, TCL, DQL
Lab: Categorize SQL statements
14
DDL – Data Definition Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
Create, Alter, Drop, Truncate
Rename, Index, View, Synonyms, Sequences
SQL Operators
Lab: Practice DDL operations
15
DML – Data Manipulation Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
Insert, Update, Delete
Lab: Perform DML operations
16
DQL – Data Query Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
SELECT
Aggregate, String, Miscellaneous Functions
GROUP BY, HAVING
Joins, Subqueries, Window Functions
Lab: Write and optimize complex queries
17
DCL – Data Control Language
Theory: 0.75 hrs  ·  Lab: 0.75 hrs  ·  Total: 1.5 hrs
▼
GRANT, REVOKE
Lab: Apply access control
18
TCL – Transaction Control Language
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
COMMIT, ROLLBACK, SAVEPOINT
Lab: Simulate transactions
19
PL/SQL Programming
Theory: 8 hrs  ·  Lab: 8 hrs  ·  Total: 16 hrs
▼
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
56
Module Hours
28
Theory Hrs
28
Lab Hrs
📄 DBMS-SQL — Professional Level
L3
DBMS-SQL
Professional DBMS & SQL
Total Duration: ~80 Hours (programme)  |  Module breakdown: 75.5 hrs  |  Theory: 37.75 hrs  |  Lab: 37.75 hrs
01
DBMS – Introduction
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
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
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
Three-Level Architecture
Database Functions
ACID Properties
Lab: Map architecture layers and test ACID compliance
03
Types of Database
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Base Model
New Model
Lab: Identify database types from use cases
04
Base Models
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Hierarchical
Network
Relational
Lab: Compare base model structures
05
New Models
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Object-Oriented
NoSQL
Lab: Explore NoSQL and object-oriented models
06
Cloud & NoSQL
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Types of Data
CAP Theorem
Document, Graph, Key-Value Models
Lab: Simulate CAP scenarios and NoSQL queries
07
Columnar & Normalization
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
Normalization
1NF, 2NF, 3NF, BCNF
Lab: Normalize sample datasets
08
Data Model Approach
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Top-Down
Bottom-Up
Lab: Apply modeling approaches to sample schema
09
Overview & Benefits of Data Models
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Role in Applications
Data Model Stages: Conceptual, Logical, Physical
Lab: Map stages to real-world scenarios
10
Logical & Physical Modeling
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Conversion Steps
Contents of Logical & Physical Models
Lab: Convert conceptual to logical and physical models
11
ERWIN Tool Demo
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
Data Model Categories
OLTP
Lab: Explore ERWIN interface and model types
12
Dimensional Modeling
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Specialization & Generalization
Lab: Design dimensional models
13
Rollup & Rolldown Concepts
Theory: 1.5 hrs  ·  Lab: 1.5 hrs  ·  Total: 3 hrs
▼
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
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Atomicity
Consistency
Isolation
Durability
Lab: Test ACID properties using views
15
RDBMS Foundations Using Oracle
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Oracle 19c Architecture
Database Server & Instance
Process Architecture
Logical Storage Hierarchy
Lab: Explore Oracle architecture components
16
SQL – An Introduction
Theory: 0.25 hrs  ·  Lab: 0.25 hrs  ·  Total: 0.5 hrs
▼
SQL Overview
Lab: Run basic SQL queries
17
Database Objects
Theory: 1 hr  ·  Lab: 1 hr  ·  Total: 2 hrs
▼
Database
Table
View
Index
Stored Procedure
Trigger
Lab: Create and manage database objects
18
Data Types – ANSI
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
Character, Numeric, Date/Time, Binary, Boolean
Lab: Define and test data types
19
Types of SQL Commands
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
DDL, DML, DCL, TCL, DQL
Lab: Categorize SQL statements
20
DDL – Data Definition Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
Create, Alter, Drop, Truncate
Rename, Index, View, Synonyms, Sequences
SQL Operators
Lab: Practice DDL operations
21
DML – Data Manipulation Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
Insert, Update, Delete
Lab: Perform DML operations
22
DQL – Data Query Language
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
SELECT
Aggregate, String, Miscellaneous Functions
GROUP BY, HAVING
Joins, Subqueries, Window Functions
Lab: Write and optimize complex queries
23
DCL – Data Control Language
Theory: 0.75 hrs  ·  Lab: 0.75 hrs  ·  Total: 1.5 hrs
▼
GRANT, REVOKE
Lab: Apply access control
24
TCL – Transaction Control Language
Theory: 0.5 hrs  ·  Lab: 0.5 hrs  ·  Total: 1 hr
▼
COMMIT, ROLLBACK, SAVEPOINT
Lab: Simulate transactions
25
PL/SQL Programming
Theory: 8 hrs  ·  Lab: 8 hrs  ·  Total: 16 hrs
▼
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
Theory: 4 hrs  ·  Lab: 4 hrs  ·  Total: 8 hrs
▼
Lab: End-to-end DBMS project implementation
75.5
Module Hours
37.75
Theory Hrs
37.75
Lab Hrs