|
Provided by: Bidw Solutions Oracle Developer Track 11gOracle PL/SQL |
 |
This course is for people either new to Oracle database or are trying to learn the new Oracle 11g database version.
This instructor led course will take you from Basics to Advanced level of training. At the end you get experience certificate from us.
This instructor led course will take you from Basics to Advanced level of training. At the end you get experience certificate from us.
Related Software Programs or Products: Oracle Database
Related Awards, Degrees or Certifications: OCP
Related Jobs or Careers: Oracle Developer 11g
|
|
||||||||
Training
Provided by Bidw Solutions
Oracle Developer Track 11g
Course topics:
SQL
The Structure of a Relational Database
The Basic SQL Select Statement
Selecting Data from Multiple Tables
Using Inner Joins, Outer Joins and Self Joins
Using Standard Oracle and ANSI Standard Joins
Sub-Queries
Grouping and Sorting Output
Advanced Group Functions
Character, Date and Numeric Functions
Oracle Datatypes and Functions
Run-Time Parameters and Variables
SQL Control Parameters
Producing Reports with SQL*Plus
Creating and Changing Tables and Views
Inline Views
Constraints and Indexes
Inserting, Updating and Deleting Data
Inserting Rows into Multiple Tables
Simple and Searched CASE Expressions
Merging Data into Tables
External Tables
Controlling Access to the Database
Creation of User, Profiles and Roles
Related Data Dictionary Tables and Views
PLSQL
What is PL/ SQL
The Structure of a PL/ SQL Block
Variables and Constants
Record Types, PL/ SQL Tables and Sub-types
Inserting, Updating and Selecting Data within a PL/ SQL Block
Conditional Processing Constructs
Loop Constructs
Nested Block Processing
Cursors
Cursor Variables and Functions
Exceptions and Error Handling
Introduction to Procedures and Functions
Introduction to Packages
Useful PreDefined Packages
SQL
The Structure of a Relational Database
The Basic SQL Select Statement
Selecting Data from Multiple Tables
Using Inner Joins, Outer Joins and Self Joins
Using Standard Oracle and ANSI Standard Joins
Sub-Queries
Grouping and Sorting Output
Advanced Group Functions
Character, Date and Numeric Functions
Oracle Datatypes and Functions
Run-Time Parameters and Variables
SQL Control Parameters
Producing Reports with SQL*Plus
Creating and Changing Tables and Views
Inline Views
Constraints and Indexes
Inserting, Updating and Deleting Data
Inserting Rows into Multiple Tables
Simple and Searched CASE Expressions
Merging Data into Tables
External Tables
Controlling Access to the Database
Creation of User, Profiles and Roles
Related Data Dictionary Tables and Views
PLSQL
What is PL/ SQL
The Structure of a PL/ SQL Block
Variables and Constants
Record Types, PL/ SQL Tables and Sub-types
Inserting, Updating and Selecting Data within a PL/ SQL Block
Conditional Processing Constructs
Loop Constructs
Nested Block Processing
Cursors
Cursor Variables and Functions
Exceptions and Error Handling
Introduction to Procedures and Functions
Introduction to Packages
Useful PreDefined Packages
About The Training Provider: Bidw Solutions
Bidw Solutions - BIDW Solutions provides Online interactive IT training with live Trainer. Trainers are all senior professionals working in leading companies in US and India. Get the best training at most affordable price from anywhere. Flexible timings. No traffic hassle, learn from the comforts of your home. Learn as little or as much and pay for what exactly you need to learn. online labs, practice sessions,...
