Virtual Box Installation

Ubuntu Installation

MySQL Installation

Data vs Information

Why do we need Data?

Different ways of Storing Data

Systems to store Data

History of RDBMS

What is RDBMS?

What is Database?

What is Database Components?

Database Components - Hands-On

What is Datatypes?

Datatypes - Hands-On

What is Database Object?

Database Object - Index

Database Object - Sequence

Database Object - View

Database Object - Views Hands-On

Database Design

ER Diagram Part 1

ER Diagram with Component Part 2

ER Diagram Part 3

Keys Introduction

SuperKey

Candidate Key

Primary Key

Unique, Surrogate, Alternate, Composite Keys

Foreign Key

Data Integrity Introductions

Domain Integrity Check Constraints Theory

Check Constraint Hands-On

Default Constraint

Not Null Constraint

Unique Constraint

Entity Integrity Constraint

Entity Integrity Constraint Hands-On

Referential Integrity

Referential Integrity Hands-On

Introduction - Normalization

Need for Normalization with Example

Dependencies

Normalization - First Normal Form

Second Normal Form

Third Normal Form

BCNF Normal Form

Transactions

Transactions - ACID Properties

Atomicity

Consistency

Isolation

Durability

Introduction to SQL

Types of SQL Commands

Create and Alter Theory and Hands-On

Rename Theory and Hands-On

Drop and Truncate Theory and Hands-On

Comment Theory and Hands-On

DML Commands Theory

DML Commands Hands-On

Ways of Inserting Data into Tables Theory

Ways of Inserting Data into Tables Hands-On

DCL Commands Theory

DCL Commands Hands-On

TCL Commands Theory

TCL Commands Hands-On

DQL Commands Theory

DQL Commands Hands-On

SQL Statements

Alias Theory and Hands-On

Distinct Theory and Hands-On

What are Operators?

Arithmetic Operators Theory

Arithmetic Operators Hands-On

Comparison Operators

Logical Operators - And & Between

Logical Operators - In & Not In

Logical Operators - Like & OR

Logical Operators - Exists & Not Exists

Aggregate Functions Theory

Aggregate Functions Hands-On

SQL Clauses

Where Clause Theory

Where Clause Hands-On

Order By Clause Introduction

Order By Clause - Ascending Order Theory and Hands-On

Order By Clause - Descending Order Theory and Hands-On

Order By Clause - Ascending & Descending Order Theory and Hands-On

Order By Clause - Ascending with Null Values Theory and Hands-On

Order By Clause - Descending with Null Values Theory and Hands-On

Group By Clause Theory

Group By Clause Hands-On Part-1

Group By Clause Hands-On Part-2

Having Clause Theory

Having Clause Hands-On

What is Null Value?

Inserting Null Values Theory

Inserting Null Values Hands-On

Null vs Empty Space Theory

Null vs Empty Space Hands-On

How to find Null Values Theory

How to find Null Values Hands-On

Null Values in Arithmetic Expressions Theory

Null Values in Arithmetic Expressions Hands-On

Subquery Theory

Subquery Hands-On

Subquery Types Theory Part 1

Subquery Types Theory Part 2

Subquery Types Hands-On Part 1

Subquery Types Hands-On Part 2

What are Joins?

How Joins work?

Inner Joins Theory

Inner Joins Hands-On

Outer Joins Theory

Outer Joins Hands-On

Self Joins Theory

Self Joins Hands-On

Cross Joins Theory

Cross Joins Hands-On

Set Operator Introduction

Union Set Operator Theory

Union Set Operator Hands-On

Union All Set Operator Theory

Union All Set Operator Hands-On

Intersect Set Operator Theory and Hands-On

Minus Set Operator Theory

Minus Set Operator Hands-On

Introduction to String Functions

Strings Case Manipulation Theory and Hands-On

Adding and Removing Spaces Theory Part 1

Adding and Removing Spaces Theory Part 2

Adding and Removing Spaces Theory Part 3

Adding and Removing Spaces Hands-On Parts 1, 2, & 3

Substring Theory Part 1

Substring Theory Part 2

Substring Hands-On

Substring Index Theory

Substring Index Hands-On

RDBMS Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

Why Should You Learn RDBMS Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches

DSP & Microcontrollers

Computer Hardware

Cisco

Cisco & Networking Certifications