"Aim to help our customers achieve the end result they need in whatever is the most effective way for them. "

- Anonymous

RDBMS Program with Oracle

Quick Stats

RDBMSs provide data access using a natural structure and organization of the data.
Multiple database users can access a database simultaneously.
Professionals with a certification in RDMBS earn anywhere between 3 - 11lac INR per annum.

Benefits

Oracle Database 11g
Master designing and programming skills of Oracle Database 11g
Database Schema
Identify the abnormalities in a Database Schema
Oracle database
A step-by-step guide on how to work with Oracle database
Robust databases
Learn about the most user friendly and robust databases in the world
Normalization
Implement Database Normalization to enhance the design and performance of the schema
Find opportunities
Find opportunities as Software Engineer, Lead Software Engineer, Senior Software Engineer, Project Manager, Information Technology (IT) etc. Professionals with a certification in RDMBS earn anywhere between 3 - 11lac INR per annum.

Who Should Attend

  • Software Engineers
  • Software Analysts
  • Aspiring Database Developers
  • Engineering Graduates
  • BSc - IT Graduates
  • MCA Graduates
  • MBA (IT) Graduates
  • PGDBA (IT) Diploma Graduates

Course Outcome

After completing this course, the learners will be able to:

  • Implement the course knowledge to design and create a Normalized Relation Schema.
  • Knowledge to design a requested Database and create an ER Model.
  • Write SQL commands to retrieve and modify the data using Oracle DML and DDL commands.
  • Have a good understanding of the basics and importance of Transaction management.
  • Define Database Indexes, Database views and Database sequences.
  • Handle Exceptions in you PL/SQL programs, and solve complex modular programs.
  • Implement PL/SQL optimization techniques to enhance the performance.

Curriculum

  • Overview of RDBMS Concepts
    • RDBMS - Analysis, Design and Construction
    • ER Modeling, Keys, Cardinality
    • Anomalies and Normalization
    • Database Constraints
    • SQL Constructs - DML, DDL, TCL
  • Data Retrieval, Transformation and Grouping
    • Oracle 11g Basics
    • Retrieving and Sorting data
    • Single-row Functions
    • Aggregate Functions
    • Grouping and Filtering the data
  • Joins and Subqueries
    • INNER JOINs
    • OUTER JOINs
    • SELF JOINS Independent Subqueries
    • Correlated Subqueries
  • DDL, DML and TCL
    • Creating and Managing the Database
    • Manipulating Database Tables
    • Transaction Management Basics
  • DB Objects
    • Database Indexes
    • Database Views
    • Oracle Data Dictionary Views
    • Database Sequences
  • PL/SQL Programming
    • PL/SQL Program Structure
    • Querying in PL/SQL Programs
    • Using CURSORs in PL/SQL
    • Exception Processing in PL/SQL
    • Subprograms in PL/SQL
    • PL/SQL Optimization

 

Website Designed by © 2012 SMIIT. All Rights Reserved