Introductory Concepts Of DBMS 4 Lessons Data & DBMS Start The need of DBMS and related concepts Start E-R codd's Rule Start Database users & DBA Start RDBMS concept 4 Lessons Relation Start Tuple Start Relational Model Start Structure of Relational Database Start Normalization 5 Lessons Introduction of Database Normalization Start First Normal Form – ( 1 NF) Start Second Normal Form – ( 2 NF) Start Third Normal Form – ( 3 NF) Start Boyce-Codd Normal Form (BCNF) Start Entity-Relationship Model 6 Lessons Entities & Relationships Start E-R diagram Start One-to-One Start One-to-Many Start Many-to-One Start Many-to-Many Start Introduction To SQL 2 Lessons Introduction to SQL Start Datatypes in SQL (Oracle/MySQL) Start Data Definition Language (DDL) 5 Lessons Create Start Alter Start Drop Start Rename Start Truncate Start Data Manipulation Language (DML) 3 Lessons Insert Start Update Start Delete Start Data Query Language (DQL) 6 Lessons Select Start Where clause Start Group by clause Start Having clause Start Order by clause Start distinct Start Operators 4 Lessons Logical operators Start Relational operators Start Arithmetic Operators Start In,between,like,is null Start Functions 4 Lessons Group/Aggregate functions Start Character function Start Number function Start Date function Start Constraint 3 Lessons Domain (not null,default,check) Start Integrity (Unique, Primary key) Start Referential integrity (Foreign Key) Start Joins 5 Lessons Equi join /Inner Join Start Outer join Start Self join Start Natural Join Start Cross join Start Sub query 6 Lessons Nested subquery Start Co-related subquery Start Create table using subquery Start Exists Operator Start DML using subqueries Start Multiple column subquery Start Views 5 Lessons Simple View Start Complex View Start Rules of view with example Start Using with check option Start Drop view Start Index 2 Lessons Creating index Start Drop index Start Sequence 3 Lessons Create SEQUENCE Start next val, currval , modifying sequence Start Drop sequence Start Introduction to PL/SQL 3 Lessons What Is PL/SQL Start PLSQL Block Structure Start Block Types Start PLSQL Variable 4 Lessons Declaring and Initializing PL/SQL Variable Start Types of Variables Start Substitution variable(&) Start %type, %rowtype Start Control Structures 5 Lessons IF Statement, IF then else statement Start Case Expressions Start iterative Control:loop Statement Start For Loop Start While Loop Start Cursors 3 Lessons Cursor Start Cursor FOR loop Start Cursor with Parameter Start Stored procedure and functions 5 Lessons Intro to Procedures and Functions Start Procedure Syntax, Example Start Invoking the Functions Start Passing a Parameter to the Functions Start Invoking the Functions with a Parameter Start Package 6 Lessons Creating the Package Specification Start Example of Package Specification Start Creating the Package Body Start Example of Package Body Start Invoking Package Subprograms Start Removing Packages Start Triggers 6 Lessons Types of Triggers Start Creating DML Triggers Start Types of DML Triggers Start Trigger Timing Start INSTEAD OF Triggers Start Creating an INSTEAD OF Trigger Start
