purusingh2004@gmail.com
call +91-9347045052  /   09032803895
skype purnendu_ranjan
php new batch started
php training courses
seo Training Institute
php Training Institute
request for quote
request for quote for website
Joomla Training Hyderabad
Wordpress Training Hyderabad
Online Joomla Training
Online Wordpress Training
Online Web Designing Training
Online Drupal Training institute
 
 

Questions? Comments? Contact us.

Address Inquiries

Sai Datta apartment, 4th Floor
Dilsukhnagar , Near Vasan Eye Care Hospital
Beside Tirumala Music Center,Dilsukhngar, HYD

Call me at: +91-9347045052  /   09032803895 | 08500679873

Course Inquiries

New Batch Timing

PHP and CMS website Help??

Send us a message
professional Freelance web designer company hyderabad
 
My Services
List Of Services

oracle sql Training

oracle sql TRAINING ONLINE AND CLASSROOM

This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.

oracle sql Course Modules

Database Design

  • Database Models
  • Beginnings
  • Some Introductory Terminology

 
  • Codd's 12 Rules
  • Normalization

 
  • First Normal Form
  • Higher Order Normal Forms

 

Oracle Standard Interfaces

  • SQL
  • SQL*Plus
  • Oracle Architecture
  • Interfaces to Oracle
  • Command Line Interface
  • Viewing a Sample Table
  • The Graphical User Interface
  • The SQL Buffer
  • The Web-Based Interface
  • Describe

The Sample Database

  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • ER Diagram for Sample Database
  • Creating the Sample Data
  • Viewing Sample Data
  • Data Types of the Sample Data

Data Definition Language

  • Categories of SQL Statements
  • Oracle Datatypes
  • The CREATE Statement
  • The DROP Command

 
  • The ALTER Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints

 
  • Modifying Table to Use Constraints
  • Checking Constraints
  • The Data Dictionary

 

Data Manipulation Language

  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • More SQL*Plus Commands

Transaction Control

  • Transactions
  • Command Classification

 
  • Savepoints

 
  • The SET TRANSACTION Command

 

SQL Operators

  • Simple Selects
  • Comparison Operators
  • IN and NOT IN Operators

 
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL

SQL FUNCTIONS

  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions

 
  • Date Functions
  • Conversion Functions
  • Pseudo Columns

 

Joining Tables

  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for Outer Joins

Set Operators

  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus

Introduction

  • SQL vs. PL/SQL
  • A Few Simple Examples
  • Saving Procedures
  • A More Complete Picture
  • Comments
  • Variable Substitution
  • Simple Exception Handling
  • Advantages of PL/SQL
  • Assignments


Call on 9347045052 for complete details about the course
courseCourse Enquiry
CONTACT FOR COURSE FEE ENQUIRY
Name
Email
Phone
Course
Batch Timing?
Training Type?
Country ?
Message