Welcome To Eazygurus

SQL /PLSQL

Course Name         :   SQL, PL/SQL Online Training
Duration                 :  30 hrs

0 STUDENTS ENROLLED

    • Data Base Management System (DBMS)
      • Concepts of DBMS
      • Importance and Need
      • Database Models and Normalization
      • Hierarchical
      • Network
      • Relational
      • Object
      • Normalization Techniques
    • Relational Data Base Management System (RDBMS)
      • Concepts of RDBMS
      • Comparison with DBMS
      • CODD rules
      • Normalization Revisited
      • Concepts of ORDBMS & OODBMS
      • Introduction to ORDBMS
      • Introduction to OODBMS
      • Comparison and analysis
    • Introduction to Oracle
      • Versions
      • Editions
      • Installation, Uninstallation
      • Directory Structure
    • Structured Query Language (SQL)
      • Introduction to SQL
      • Predefined Data Types
      • Introduction to database Objects
      • Table, view
    • Commands in SQL
      • Data Definition Language (DDL)
      • Data Manipulation Language (DML)
      • Data Control Language (DCL)
      • Transaction Control Language (TCL)
      • Database Security and Privileges (DCL)
    • Working with DDL, DML, TCL Commands
    • Operators
      • Conditional
      • Logical
      • Comparison
      • SET
    • Functions
      • Date
      • Number
      • Character
      • String
      • Group
      • Group by ,Having clause
      • NVL
      • Aggregate Functions
    • Integrity Constraint
      • Different Types of Integrity Constraint
      • Use of Integrity constraint in table
    • Joins
      • Usage of Joins
      • Different Types of Joins
      • Equip join
      • Cartesian join
      • Outer join
    • Sub queries
      • Need of sub queries
      • Nested sub queries
      • Co-related sub quires
    • Data Base Objects
    • Tables
      • Dictionary Tables
      • User Defined Tables
      • Temporary Tables
      • Table Partitions
      • Large Objects(LOBs)
    • Constraints
      • Normalization And Denormalization
      • Views
      • Synonyms
      • Sequences
      • Index
      • Clusters
    • PL/SQL
      • Introduction to PL/SQL
      • Advantages of PL/SQL
      • Data types in PL/SQL
      • Variable and constants
      • Using built in Functions
      • Conditional and Iterative Statements
      • SQL in PL/SQL
      • Composite data types
      • Cursors
      • Exception:-predefined, user-defined
    • Advanced PL/SQL
      • Introduction to Triggers
      • Before and after, instead of Triggers
      • Procedures, functions in PL/SQL
      • Argument modes
      • User defined packages
      • Dropping triggers, procedures, functions

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 1 day

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.