Plsql online training in New York

1. PLSQL Online Training Course Contents Session I Introduction To Database Data Information Differences Between Data and Information Database Database Management System      Session 2 Introduction To DBMS Drawbacks of File System Advantages of DBMS Types of Databases    Session 3 Data Models Data Model Relational Data Model Schema    Session 4 Introduction To ER Diagram Entity Entity Set Attributes   

2. Session 5 ER Diagrams Relationship Relationship Set Entity-Relationship Diagrams    Session 6 Mapping Constraints One-One Mapping One-Many Mapping Many-Many Mapping    Session 7 Converting ER Diagrams To Tables Primary key Foreign key Relationship Between Tables    Session 8 Creating Relations Using SQL Integrity Constraints Key Constraints Foreign Key Constraints General Constraints     Session 9 Introduction To Views Definition of a View Need of a View Creating a View    Session 10 Views

3. Differences between Table and a View Complex Views   Session 11 DML Dropping a Table Deleting a Table Differences Between Dropping and Deleting Alter     Session 12 Introduction to Schema Refinement Problems caused by Redundancy Decomposition   Session 13 Normalization Atomic Domain First Normal Form Functional/ Partial Dependencies Second Normal Form     Session 14 Normalization Third Normal Form Candidate Key BCNF    Session 15 Basic Queries Retrieving data between specified range Retrieving data between a specific time period order by clause   

4. Session 16 Aggregate Operators Count sum avg max min      Session 17 Joins Inner Join Outer Join Retrieving data from multiple tables    Session 18 Group By and having Clause Retrieving data by using Group by and Having Clause aggregate operators in the select clause   Session 19 Nested Queries Query inside another query Null Values   Session 20 PL/SQL Introduction To PL/SQL Building Blocks of PL/SQL Block Structure of PL/SQL Variables and Constants Declaration Block Begin Block Exception Block Declaring Variables        

5. Set ServerOutput On  Session 21 PL/SQL Control Structures IF-THEN IF-THEN-ELSE IF-THEN-ELSEIF    Session 22 Iterative Control Structures LOOPS LABELLING LOOPS WHILE-LOOP FOR-LOOP     Session 23 PL/SQL Collections Introductionh Abstract Datatypes Creating Abstract Datatypes Inserting Data Into Tables with Abstract Datatypes Creating Nested Tables      Session 24 Cursors Implicit Cursors Explicit Cursors Opening a Cursor Deletion or Updation using Cursors     Session 25 Exception Handling PreDefined Exceptions User Defined Exceptions  

6. Handling Exceptions Raise_Application_Error Reraising Exceptions    Session 26 Sub Procedures Introduction to Sub-Procedures PL/SQL Subprograms Procedure Parameter Modes     Session 27 Functions Introduction to Functions PL/SQL Functions Function without Arguments Function with Arguments     Session 28 Database Triggers Introduction to Triggers Types of Triggers   Session 29 Packages Introduction to Packages Package Specification Package Body Private and Public Items in Packages Overloading Packages Subprogram     