SQL PL/SQL Online Training in Hyderabad

SQL PL/SQL Online Training in Hyderabad

SQL Online Training in Hyderabad

Oracle SQL Online Training in Hyderabad

Interested candidates can contact +91-8008814567 

For Online Training: SHIVA RAM- +91 80088 14567 

Whats App: 918008814567

email: shivaitonline@gmail.com

Introduction to Oracle SQL and PL/SQL
Course Objectives: By the end of this course the student should be able to formulate advanced
SQL queries including correlated sub queries and outer joins. The student will also become
familiar with the internals of Oracle9i SQL and will be able to use the explain utility to tune
SQL statements. Topics also include SQL constructs, using SQL, advanced SQL operators and
PL/SQL structures and tables.

Syllabus Topics:
 Review of Basic SQL Syntax
 Restricting Row Returns (WHERE)
 Complex Boolean Logic in SQL
 ROWID Restrictions
 Using SQL*Plus
 Creating Basic Reports
 Joining Oracle Tables
 Using Cursor Multi-row SQL query
 Iteration (loops) in PL/SQL
 Hiding Joins by Creating Views
 IN, NOT IN, EXISTS, NOT EXISTS
 Sub Queries
 Non-correlated Sub Queries
 Advanced SQL Operators
 Aggregation in SQL
 Intro to Cost Based Optimization
 Collecting Table & Index Statistics
 Using Column Histograms
 Library Cache SQL Reusability
 Using Hints for SQL Performance
 Parallel Query for Performance
 Tuning Sub Queries
 Basic PL/SQL Block and Sections
 Declaring Variables and Constants
 Executing a PL/SQL Block
 Error Check – Exception Handling
 Define & Populate PL/SQL Tables
 Bulking in PL/SQL (forall)



Oracle SQL Programming and Tuning
Course Objectives: By the end of this course the student should be able to formulate advanced
SQL queries including correlated subqueries and outer joins. The student will also become
familiar with the internals of Oracle SQL and will be able to use the Explain utility to tune SQL
statements.

 Syllabus
 The Oracle Relational Database
 Inside the Oracle Architecture
 Data storage
 Flat-file data storage (BFILE, external tables)
 Spreadsheet file access
 Introduction to Oracle Tables
 Index organized tables
 Introduction to Oracle Indexes
 Using SQL*Plus
 Using SQL*Worksheet
 Procedural programs with PL/SQL
 SQL Processing
 Oracle data dictionary
 The DBA Views
 The v$ views
 Running dictionary scripts
 Syntax of SQL
 Report generation with SQL*Plus
 Views: encapsulation of complex queries
 Using the DBA_VIEWS view
 Problems combining views
 Introduction to DDL and DML
 Oracle Schema components
 Referential Integrity
 Read consistency, locking & DML
 The X$ fixed tables


Oracle PL/SQL Programming
Course Objectives: By the end of this course the student should be able to write advanced
PL/SQL code blocks, and use advanced features such as ref cursors and bulk fetches. The
student will also become familiar with the internals of Oracle9i PL/SQL and compiling PL/SQL
for super fast performance.
 PL/SQL Tables
 PL/SQL Structures
 Dynamic SQL in PL/SQL
 Nested Blocks in PL/SQL
 Stored Procedures, Functions, Packages
 Iteration in PL/SQL
 PL/SQL Wrapper Utility
 Simple Blocks
 Control Structures
 PL/SQL Records
 Declaring Variables & Constants
 Executing a PL/SQL Block
 Defining Exceptions
 Using the WHEN OTHERS Clause
 Ensuring Complete Error Checking
 Pass Error Messages to Call Routine
 Boolean Logic in PL/SQL
 Using Control Structures
 Constructing & Identifying Loops
 Controlling Block Flow
 If-then-else Structures
 Cursor for a Multi-row SQL Query
 Dynamic SQL in PL/SQL
 Intro to the dbms_sql Package
 Creating a Dynamic SQL Statement
 Basics of Stored Procedures
 Pinning Packages in the SGA
 Bulking in PL/SQL (forall)