ORACLE DATABASE

  1. Home
  2. Courses
  3. ORACLE DATABASE

ORACLE DATABASE (11g/12c)

Length: I Class (1 Hour)

Duration – 30 days

This Oracle training course is designed for students new to writing SQL queries and learn PL/SQL programmig to write sophisticated queries against an Oracle database.The SQL learned in this course is standard to all modern databases, but Oracle will be used in class and syntax and functionality specific to Oracle will be pointed out.

Student will learn the essentials of oracle database programming using SQL/PLSQL.., including the skills and knowledge to design, query, and pogram the database. Upon completion of this course, student will have the foundation necessary in implementing oracle 11g database across various technologies.

Audience:

  • Software Professionals
  • Support Engineer
  • Technical Consultant
  • Database Programmers

Student Location– To students from around the world

Delivery Method: Instructor-Led – Live online Training

Introduction to RDBMS

  • File Management System, Disadvantages
  • Database Models, Terminology & Features- Hierarchal Model, Network Model, Relational Model

Introduction to Oracle

  • Oracle Versions
  • SQL & SQL*PlUS

Classification of SQL Commands

  • Data Definition Language (DDL)
  • Data Retrieval Language (DRL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database Security and Privileges (DCL)

SQL

  • Data Types
  • Data Definition Language Commands(DDL)
  • Integrity Constraints
    • Not Null
    • Unique
    • Primary Key
    • Foreign Key
    • Check Constraint
  • Creating Integrity Constraints, Accessing Constraints with SELECT statement, enable/Disable & Dropping.

Data Retrieval Command SELECT

  • SELECT Syntax
  • Basic Select / Columns
  • Arithmetic Expressions,Concatenation Operator, Column Aliases
  • Predicate clause(Where Clause), Logical Operators
  • SQL Operators
  • Order By Clause
  • SQL Functions
    • Single-Row Functions
      • Character Functions
      • Numeric Functions
      • Date Functions
      • Conversion Functions
      • Functions that can accept any type
    • Group Functions
  • Group By Clause/ Having Clause
  • SQL Joins, Types
  • Set Operators
  • SubQueries, Operators
  • Data Base Objects

DCL/TCL COMMANDS

PL/SQL

  • Introduction to PL/SQL
  • PL/SQL DATA Types
  • Variable & Constants
  • Conditional Statements
  • Iterative Statements
  • Cursors and its types
  • Exception Handling
  • Stored Procedures & Functions
    • Purpose, creation & dropping
  • Packages
  • Database Triggers(Creation, Types(Row Level/Statement Level))
  • File Input & Output
Fee : 500 USD
Batch Starts : March 29th 2018
Timings : 7:00PM EST to 8:00PM EST

* Please contact for weekend classes & Fast track training.

Techinical/Application Architect, Technical Lead in a Leading MNC

M.Tech

VA, USA

  • Trainer is a real time certified expert with vast experience in implementing oracle database
  • He has Strong Theoretical & Practical Knowledge
  • Has experience in training Oracle database
  • He has the passion to share his toughts, reaches students requirement and explains the concepts in a
    way that students can grasp.

How can we help?