Oracle Sql & Plsql Online Training

Go Training’s offers the best Oracle Sql/Plsql Online Training Course is designed by IT Professionals with the IT Industry Specialists as our trainers are experienced and certified trainers. They share their experience, tips and tricks in the Oracle Sql/Plsql Online Training course. We are also delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.

Oracle SQL PLSQL Course Content

Introduction About Oracle SQL PLSQL Online Training 

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

SQL Subqueries

  • Introduction
  • Using a Subquery with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs. Correlated Subqueries
  • Correlated Subquery Example
  • Predicate Operators

Groups

  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement

More Database Objects

  • Relational Views
  • Updating a View
  • Create or Replace
  • Forcing a View
  • The Data Dictionary Revisited
  • Indexes
  • Synonyms

Reports

  • Report Features
  • Session Control
  • The SET Command
  • The COLUMN Command
  • The BREAK Command
  • The COMPUTE Command

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

Declarations and Data Types

  • Declarations
  • Standard Data Types
  • Initialization
  • Variable Names
  • Specialized Data Types – %TYPE
  • Specialized Data Types – %ROWTYPE
  • Building Your Own Data Types – Records
  • A Quick look at Loops
  • Arrays
  • Tables
  • Nested Blocks

Language Components

  • Introduction
  • Assignments
  • Decision Making Statements
  • Simple Loops
  • Loops – for
  • Loops – indefinite
  • Loops – while
  • Simple Loops
  • Nested Loops
  • Boolean Variables
  • PL/SQL Relational Operators
  • PL/SQL Logical Operators
  • The CASE Construct

Cursors

  • Introduction
  • Cursor Manipulation
  • Using the Cursor
  • For Loops Cursors
  • Cursor Attributes
  • Cursor Parameters
  • Nested Cursors
  • Cursor Exceptions

 

Exceptions

  • Errors in Programs
  • Run Time Exceptions
  • Oracle Built In Exceptions
  • Unnamed Exceptions
  • Built in Exception Functions
  • Creating Your Own Exceptions
  • Building Non Terminating Exceptions

 

Functions and Procedures

 

  • Introduction
  • Creating a Procedure
  • Example Procedure
  • Using Parameters
  • Functions
  • Procedures and Exceptions
  • Appendix A: An SQL and SQL*Plus Reference
  • DDL Statements
  • DML Statements
  • Transaction Control Statements
  • Operators
  • Common SQL*Plus Commands

 

Reviews

SQL & PLSQL Online Training Overall rating: ★★★★☆ 4.2 based on 103 reviews
5 1

Devops Online Training

★★★★★
5 5 1
"The Devops course at GO Trainings was very good. The Trainers are well experienced had a good hands on knowledge about the subject. They answer all the questions asked and sort out the doubts. The support team is also very active . In case of any issue they solve it as soon as possible.”

Good Online Training Institute

★★★★☆
4 5 1
I appreaciate GO Trainings for the excellent teaching methodology.All instuctors are well experienced.coming to the support team, hats off to their excellent support.

Best Online Training

★★★★★
5 5 1
The serivce of GO Trainings mainly focus on working professionals as they dont have time to attend classes during weekdays the faculty is excellent most of the faculty members are highly skilled corporate trainers they are very well versed with latest technology.they provide 24/7 service to clear doubts and they offer latest technology courses like salesforce and big data hadoop all courses are offered online.

Best Coaching Institute From India

★★★★★
5 5 1
"Good experience with GO Training Institute, it is one of the best source to learn Oracle Golden Gate online, very detailed explanation each and every doubt clarified very well.”

Oracle dba

★★★★★
5 5 1
I have received training in Oracle dba from Go Trainings and everything worked out well for me. Great trainer and training material and a really good... ”
Supported By: Nuanced Media
Name
Email
Review Title
Rating
Review Content

 

Enquiry
Please enter your email, so we can follow up with you.