RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
ITBiz
columtop
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
BootCamps
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
columnbottom
ITBiz
columnbottom
Oracle PL/SQL
Oracle PL/SQL
Oracle SQL and PL/SQL
 
Software Version Oracle Developer Tools 6i and 9i
Course Duration 2 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview Introduction to SQL and PL/SQL is an intensive course designed to give the student maximum exposure to Oracle SQL and PL/SQL. The student will be guided from very simple SQL commands to increasingly complex PL/SQL coding techniques. The topics start with the basics of SQL and progress into increasingly complex queries, including table joins, subqueries and creating Oracle views.
Intended Audience for this course This course is designed for Office Staff, End Users, Office Secretaries, Analysts, IT management and Staff, Business Analysts, Functional Implementers, Project Managers, Students and also those who want to become use this Software for managing their day to day business operations.
Course Topics
SQL Section
  • Introduction to SQL Constructs
  • Using SQL*Plus
  • Joining Oracle Tables
  • Advanced SQL Operators
  • Aggregation in SQL
  • SQL access methods
  • SQL Tuning
    • Introduction to rule-based optimization
    • Introduction to cost-based optimization
    • Collecting table and index statistics
    • Changing the default optimizer modes
    • Using TKPROF
    • Using SQL*Trace
    • SQL reusability within the library cache
    • Table striping and table partitions
    • EXPLAIN PLAN
    • Using indexes to improve performance
    • Identifying full-table scans
    • Re-writing SQL queries
    • Using hints to improve SQL performance
    • Using parallel query to improve performance
    • Tuning sub-queries
PL/SQL Section
  • Basics of PL/SQL
  • PL/SQL Structures
  • Error Checking – Exception Handling
  • Boolean Logic in PL/SQL
  • Cursors in PL/SQL
  • Iteration in PL/SQL
  • PL/SQL Tables
  • Dynamic SQL in PL/SQL
  • Nested Blocks in PL/SQL
  • Triggers n PL/SQL
  • Stored Procedures, Functions and Packages
  • Bulking in PL/SQL

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Testimonials
ITBiz
columtop
columnbottom
ITBiz
Follow us on .....
ITBiz
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.