arrow_back
Welcome to the Course
Introduction to RDBMS
Installation Videos
Oracle_VirtualMachine_Installation
How to install Ubuntu operating system on Virtual box
MySQL Installation in Ubuntu
RDBMS
Data vs information
Data vs Information Study Material
Why do we need Data?
Why do we need Data Study Material
Different ways of storing the Data
Different ways of storing the Data Study Material
Systems to Store Data
Systems to Store Data Study Material
RDBMS
History of RDBMS
History of RDBMS Study Material
What is RDBMS?
What is RDBMS Study Material
What is Database?
What is Database Study Material
RDBMS Assessment
Database Components
Database Components - Hands on (Create database & Table)
Database Components Study Material
Database Components Assessment
Datatypes Theory
Dataypes - Hands On
Datatypes Study Material
Datatypes Assessment
Database objects Introduction
Database objects Introduction Study Material
Index Concepts Theory and Hands on
Index Concepts Study Material
Database Object Sequence
Database Object Sequence Study Material
Database objects Views Theory
Database Objects Views-Hands on
Database Object Views Study Material
Database Objects Assessment
Database Design
Database Design Study Material
ER Diagram Part1
ER Diagram Part1 Study Material
ER Diagram with component part2
ER Diagram with Component Part2 Study Material
ER Diagram Parrt3
ER Diagram Part3 Study Material
Database Design Assessment
Keys
Keys Introduction
Keys Introduction Study Material
SuperKey
Super key Study Material
Candidatekey
Candidate Keys Study Material
PrimaryKey
Primary Key Study Material
Unique-Surrogate-Alternate-CompositeKeys
Unique-Surrogate-Alternate-Composite Keys Study Material
ForeignKey
Foreign Key Study Material
Keys Assessment
Constraints
Data Integrity Introductions
Data Integrity Introductions Study Material
Domain Integrity Check Constraints Theory
Check Constraint Hands-on
Domain Integrity Check Constraints Study Material
Default Constraint
Default Constraint Study Material
Not Null Constraint
Not Null Constraint Study Material
Unique Constraint
Unique Constraint Study Material
Entity Integrity Constraint
Entity Integrity Constraint Hands-on
Entity Integrity Constraint Study Material
Referential Integrity
Referential Integrity Hands-on
Referential Integrity Study Material
Constraints Assessment
Normalization
Introduction - Normalization
Introduction - Normalization Study Material
Need for Normalization with example
Need for Normalization with example Study Material
Dependencies
Dependencies Study Material
Normalization - First Normal Form
Second Normal Form
Third Normal Form
BCNF Normal Form
Normalization - First Normal Form to BCNF Normal Form Study Material
Normalization Assessment
Transactions and ACID Properties
Transactions
Transactions Study Material
Transactions - ACID Properties
Transactions - ACID Properties Study Material
Atomicity
Atomicity Study Material
Consistency
Consistency Study Material
Isolation
Isolation Study Material
Durability
Durability Study Material
Transaction Assessment
SQL
Introduction to SQL
Introduction to SQL Study Material
Types of SQL Commands
Types of SQL Commands Study Material
SQL Introduction Assessment
DDL Commands
Create and Alter Theory and Hands-on
Create and Alter Study Material
Rename Theory and Hands-on
Rename Study Material
Drop and Truncate Theory and Hands-on
Drop and Truncate Study Material
Comment Theory and Hands-on
Comment Study Material
DDL Assessment
DML Commands
DML Commands Theory
DML Commands Hands-on
DML Commands Study Material
DML Assessment
Ways of Inserting Data into Tables Theory
Way of Inserting Data into Tables Hands-on
DCL Commands
DCL Commands Theory
DCL Commands Hands-on
DCL Commands Study Material
DCL Assessment
TCL Commands
TCL Commands Theory
TCL Commands Hands-On
TCL Commands Study Material
TCL Assessment
DQL Commands
DQL Commands Theory
DQL Commands Hands-On
DQL Assessment
DQL Commands Study Material
SQL Statements
SQL Statements Study Material
SQL Statements Assessment
Alias Theory and Hands-on
Alias Study Material
Alias Assessment
Distinct Theory and Hands-on
Distinct Study Material
Distinct Assessment
Operators and its Types
What are Operators?
What are Operators Study Material
Arithmetic Operators Theory
Arithmetic Operators Hands-on
Arithmetic Operators Study Material
Arithmetic Operators Assessment
Comparison Operators
Comparison Operators Study Material
Comparison Operator Assessment
Logical Operators-And & Between
Logical Operators-And & Between Study Material
Logical Operators-In & Not In
Logical Operators-In & Not In Study Material
Logical Operators-Like & OR
Logical Operators-Like & OR Study Material
Logical Operators - Exists & Not Exists
Logical Operators - Exists & Not Exists Study Material
Logical Operators Assessment
Aggregate Functions Theory
Aggregate Functions Hands-On
Aggregate Functions Study Material
Aggregate Assessment
SQL Clauses and Types
SQL Clauses
SQL Clauses Study Material
Where Clause Theory
Where Clause Hands-On
Where Clause Study Material
Where Clause Assessment
Order By Clause Introduction
Order By Clause Introduction Study Material
Order By Clause -Ascending Order Theory and Hands-On
Order by - Ascending Order Study Material
Order By Clause -Descending Order Theory and Hands-On
Order By Clause -Descending Order Study Material
Order By Clause - Ascending & Descending Order Theory and Hands-On
Order By Clause - Ascending & Descending Order Study Material
Order By Clause - Ascending with Null Values Theory and Hands-On
Order By Clause - Ascending with Null Values Study Material
Order By Clause - Descending with Null Values Theory and Hands-On
Order By Clause-Descending with Null Values Study Material
Order By Assessment
Group By Clause Theory
Group By Clause Hands-On Part 1
Group By Clause Hands-On Part 2
Group By Clause Study Material
Group By Assessment
Having Clause Theory
Having Clause Hands-On
Having Clause Assessment
What is Null Value?
What is Null Value? Study Material
Inserting the Null Values Theory
Inserting the Null Values Hands-on
Inserting the Null Values Study Material
Null vs Empty Space Theory
Null vs Empty Space Hands-on
Null vs Empty Space Study Material
How to find Null Values Theory
How to find Null Values Hands-on
How to find Null Values Study Material
Null Values in Arithmetic Expressions -Theory
Null Values in Arithmetic Expressions Hands-on
Null Values in Arithmetic Expressions Study Material
Null Assessment
Sub Query
SubQuery Theory
SubQuery Hands-on
Sub Query Study Material
SubQuery Types Theory Part1
SubQuery Types Hands-On Part1
SubQuery Types Theory Part2
SubQuery Types Hands-On Part2
SubQuery Types Study Material
Sub Queries Assessment
Joins
What are Joins?
What are Joins? Study Material
How Joins Work?
How Joins Work ? Study Material
Inner Joins Theory
Inner Joins Hands-On
Inner Joins Study Material
Outer Joins Theory
Outer Joins Hands-on
Outer Joins Study Material
Self Join Theory
Self Joins Hands-on
Self Joins Study Material
Cross Joins Theory
Cross Joins Hands-On
Cross Join Study Material
Joins Assessment
Set Operators
Set Operator Introduction
Set Operators Study Material
Union Set Operator Theory
Union Set Operator Hands-On
Union Set Operators Study Material
Union All Set Operators Theory
Union All Set Operators Hands-On
Union All Set Operators Study Material
Intersect Operators Theory and Hands-on
Intersect Set Operators Study Material
Minus Operator Theory
Minus Operator Hands-On
Minus Set Operators Study Material
Set Operators Assessment
String Functions
Introduction to String Functions
Introduction to String Functions Study Material
Strings Case Manipulation Theory and Hands-On
Strings Case Manipulation Study Material
Adding and Removing Spaces Part 1
Adding and Removing Spaces Part2
Adding and Removing Spaces Part3
Adding and Removing Spaces Hands-On
Substring Theory Part 1
Substring Theory Part 2
Substring Hands-On
Substring
Substring Index Theory
Substring Index Hands-On
Substring Index Study Material
Instring & Locate Theory
Instring & Locate Hands-on
Instring & Locate Study Material
Strings Functions Assessment
What Next?
Assessment 1
Assessment 2
SQL Classes recording2024
RDBMS class recording
Sql class 5th mar
SQL class recording 7th mar
Alias,Distinct and Arithmetic operators
14sqlclass
19thsqlclass
SQL class 28th march