There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Language: English
Instructors: Blismos Academy
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 |
After successful purchase, this item would be added to your courses.You can access your courses in the following ways :