|
|
|
| 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
|
|
|
|
|
|
|
