plsql online training in uk,london

1. eGlobalSystems Offering pl /sql Real-time Online Training Classes For Weekend And Regular Batches For Individuals And Professionals. eGlobalSystems Offering Free DEMO/ Seminar On pl /sql Access Control By Real Time Expert. Once Experience Our Free Sessions And Decide Further. Locations: Hyderabad, India, USA, UK, Australia, New Zealand, UAE, Saudi Arabia,Pakistan, Singapore, Kuwait Etc… SQL – PL/SQL Sql 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

2. Introduction To ER Diagram Entity Entity Set Attributes 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

3. Foreign Key Constraints General Constraints Session 9 Introduction To Views Definition of a View Need of a View Creating a View Session 10 Views 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

4. 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 Session 16 Aggregate Operators Count

5. 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

6. Declaration Block Begin Block Exception Block Declaring Variables 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 Introduction Abstract Datatypes Creating Abstract Datatypes Inserting Data Into Tables with Abstract Datatypes Creating Nested Tables Session 24

7. Cursors Implicit Cursors Explicit Cursors Opening a Cursor Deletion or Updation using Cursors Session 25 Exception Handling PreDefined Exceptions User Defined Exceptions 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

8. 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 Subprograms For more details plzz go through the link: https://eglobalsystems.wordpress.com/pl-sql/ info@eglobalsystems.com +91-9948557100 +1 (201)448 1409