Database Management Online for freshers by eQuadriga Finishing School

Basics of RDBMS
Entity
Attributes
ER Diagram
Normalization
1NF
2NF
3NF
BCNF
ER Diagram to Table Mapping.
Introduction to SQL
Writing SQL SELECT Statements
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Sub queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Manipulating Large Data Sets
Controlling User Access
Creating Other Schema Objects
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Searching Data Using Advanced Sub queries
Hierarchical Retrieval
Regular Expression Support
Introduction to PL/SQL
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Cursors and Records
Creating Stored Procedures
Types of Stored Procedure
Creating Stored Functions
Creating Packages
Dynamic SQL
Creating Triggers
Types of Trigger
Applications for Triggers