Expert in Oracle PL SQL Training Crash Course
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
- Tesbo Courses
Slash Courses
Classic Courses
Elevate Academy stands as a trusted name in database education, offering a well-structured, in-depth program designed to equip learners with both theoretical understanding and practical expertise. This comprehensive course prepares participants to manage, optimize, and secure MySQL and MSSQL databases, ensuring they are ready for real-world challenges in data-driven environments.
This course is part of our curated collection of high-impact training programs selected by global companies for employee upskilling.
The Database Master – MySQL & MSSQL course at Elevate Academy is designed to provide learners with a complete understanding of database systems. From SQL querying and schema design to performance optimization and secure data management, the course is led by industry experts who guide learners through real-time projects and administrative tasks to prepare them for roles in database development and support.
This course focuses on building expertise in SQL querying, scalable database design, system performance tuning, data protection, and administration tasks such as backup and recovery using MySQL and MSSQL platforms.
MSSQL
What is MSSQL?
What is the difference between MSSQL and MYSQL?
Purpose of MSSQL
Versions of SQL
Advantages and drawbacks
Installation Setup
Database and Tables
What is database?
What is tables?
Create, Alter, and Drop database
Create, Alter, and Drop tables
Backup and restore a database
Common Terminologies in SQL
Data types
Constraints
Foreign key constraint
Unique and check constraint
Hands on data types and constraints
Normalization
What is normalization?
First Normal Form
Second Normal Form
Third Normal Form
Practically Normalizing Tables
Hands on Normalization
Data Definition Language
What is DDL?
Purpose of DDL
CREATE Table
ALTER Table
TRUNCATE Table
RENAME
DROP
Hands on DDL
Data Manipulation Language
What is DML?
SELECT
UPDATE
DELETE
INSERT
Hands on DML
Data Control Language
What is DCL?
Purpose of DCL
REVOKE
GRANT
Hands on DCL
MSSQL Clauses
DISTINCT
ORDER BY
GROUP BY
Hands on MSSQL Clauses
Conditions
AND
OR
NOT
Boolean
Key
Primary key
Foreign key
Unique key
Hands on key constraints
JOINS IN MSSQL
What are joins?
Advantages of JOINS
Types of Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
CROSS JOIN
Indexes and Views in MSSQL
What is Index?
CREATE Index
DROP Index
SHOW Index
UNIQUE Index
Functions in MSSQL
What is MSSQL?
What is the difference between MSSQL and MYSQL?
Purpose of MSSQL
Versions of SQL
Advantages and drawbacks
Installation Setup
Transactions in MSSQL
Transactions
What are transactions?
Hands on transactions
Aggregate Functions and Triggers
What are aggregate functions?
List of aggregate functions
Hands on aggregate functions
What are triggers?
Creating, Altering, Dropping triggers
FOR/AFTER/INSTEAD OF triggers
Hands on triggers
Working with Cursors
What are cursors?
Creating cursors
Cursors vs. SELECT
Types of cursors
Locks on cursors
Advantages of cursors
Hands on cursors
Backup and Restore
Generating SQL Script
Executing SQL Script
Generating Change Script
Taking database backup
Restoring database using backup
Attaching and Detaching database
Hands on backup and restore
Logistic Regression
What is Logistic Regression?
Problem: Heart Disease Prediction
Build Model
Performance Estimation
Analyse and create confusion matrix
Decision Tree
What is decision tree?
Decision Tree Parameters
Problem: IRIS Classification
Data Processing
Train and create model
Evaluate Model
Random Forest
What is random forest?
Ensemble Learning
Bagging and Boosting Classifiers
Problem: Cardio Vascular Disease
lmplementation
Evaluate Model
Class
Objects
Constructors
Constructors
Encapsulation
Inheritance
Polymorphism
Super and this Keyword
Abstraction
Inheritance
Nearest Neighbor
What is KNN?
KNN parameters
Problem: Cardio Vascular Disease
Data collection and preprocessing
lmplementation
Evaluate Model
Beginning Database
What is a Database
What is a good database engine
Types of data and storage
RDBMS
FIELD Concepts
Beginning of MYSQL
What is MYSQL?
5L VS MYSQL
Data types
Indexes
Environmental setup
Download and Install MYSQL Server
Data Types
String Data Types
Numeric Data Types
Date and Time Data Types
MYSQL Functions
String functions
Numeric functions
Date functions
Advanced functions
Creating Database and Tables
Connect and create database
Showing Database
Creating Database
Rename Database
Introducing Tables
Creating Tables
Dropping Tables
Hands on
Data Definition Language
What Is DDL?
Purpose of DDL
Create Database
Drop Database
Alter Database
Truncate Database
Comment
Rename
Data Query Language
What is DQL?
Purpose of DQL
Select
Data Manipulation Language
What is DML?
Purpose of DML
Insert Data
Update Data
Delete Data
Lock Data
Data Control Language
What is DCL?
Purpose of DCL
Grant Data
Revoke Data
Transaction Control Language
What is TCL?
Purpose of TCL
COMMIT
ROLLBACK
SAVEPOINT
Inserting Data
INSERT - Basic Data
SELECT
Hands on SELECT query
Multi Inserts
Hands on Multi Inserts
NOT NULL
Hands on NOT NULL
DEFAULT Values
Hands on DEFAULT Values
AUTO INCREMENT
Hands on AUTO INCREMENT
Basic Operators
ORDER BY
ALIASES
UNIONS
CONSTRAINTS
VIEWS
Primary Key
What is primary key?
Creating a primary key
Dropping a primary key
Foreign Key
What is foreign key?
Creating a foreign key
Dropping a foreign key
Composite Key
What is composite key?
Creating a composite key
Dropping a composite key
CRUD
What is CRUD?
Create Table
Insert Values
Hands on insert values
Read Table
Read Query
Hands on read query
Update Table
Hands on update table
Delete Tables
Hands on delete tables
JOINS
What is join?
Advantages of JOINS
Types of Joins
INNER JOIN
Hands on INNER JOIN
LEFT JOIN
Hands on LEFT JOIN
RIGHT JOIN
Hands on RIGHT JOIN
CROSS JOIN
Hands on CROSS JOIN
Aggregate Functions
What are aggregate functions?
Purpose of Aggregate functions
COUNT()
SUM()
Hands on SUM()
AVG()
Hands on AVG()
MIN()
Hands on MIN()
MAX()
Hands on MAX()
GROUP BY
What is GROUP BY?
Purpose of GROUP BY
GROUP BY with aggregate functions
GROUP BY with JOIN
HAVING Clause
EXISTS
Hands on EXISTS
Arithmetic Operators
Add
Subtract
Multiply
Divide
Modulo
Bitwise Operators
Bitwise AND
Bitwise OR
Bitwise XOR
Hands on
Comparison Operators
Equal to
Greater than
Less than
Greater than or equal to
Less than or equal to
Not equal to
Triggers
What are triggers?
Purpose of Triggers
Advantages and drawbacks
Types of MYSQL Triggers
Before update triggers
After update triggers
Before insert triggers
After insert triggers
After delete triggers
Views
What are views in MYSQL?
Purpose of views
Advantages and drawbacks
Create view
Update view
Replace view
Drop view
Tables
What are tables in MYSQL?
Create tables
Alter tables
Show tables
Rename table
Truncate tables
Drop tables
Temporary tables
Copy tables
Repair tables
Hands on tables
Queries
What are queries?
Constraints
INSERT Record
UPDATE Record
DELETE Record
SELECT Record
Hands on queries
Indexes
Create Index
Drop Index
Unique Index
Show Index
Clustered Index
Hands on Indexes
Common Functions
Date/Time functions
Math functions
String functions
Hands on functions
Explore the foundational principles of database management, including relational database structures, SQL syntax, and effective data modeling techniques.
Learn to craft advanced SQL queries using joins, subqueries, and indexing to retrieve, update, and manage data efficiently in MySQL and MSSQL databases.
Gain insights into designing efficient, scalable databases with a focus on indexing strategies and query performance tuning.
Develop hands-on experience in core administrative tasks, including backups, user access control, system recovery, and performance management for MySQL and MSSQL.
Understand how to apply robust security practices to maintain data integrity and meet regulatory compliance standards in database systems.
Strengthen your skills by working on real-world database scenarios and projects, preparing you for professional roles in data management and administration.
June 13, 2025In today’s fast-paced digital world, the demand for skilled software professionals is higher than ever. Whether you’re a student aiming…
Expert in Oracle PL SQL Training Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Master in Oracle DBA Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry…
Core MSSQL Training Crash Course By Elevate Academy Team DB Management Course World Class Instructor 1:1 with Industry Expert 400+…
Refer your friends or colleagues to Elevate and earn gift vouchers worth up to ₹1000 for each successful enrollment.
Help others upskill while you enjoy exclusive rewards—it’s a win-win!
