Realistic Software Training

Author / Training Specialist / Developer

Oracle SQL & PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

On-site Course Syllabus

Course Description

Day 1

This outline is based upon the five day SQL and PL/SQL offering

Day 3 Morning - The Data Definition and Data Control Languages

Database Objects that Store Data Tablespaces            Creating and Modifying Tables   Indexes Maintaining the Integrity of the database Synonyms and other nice things Oracle Object-Oriented Features   User-Defined Data Types   Collection Types Creating User Accounts The Data Control Language   Using the INSERT Command   Inserting Records from Another Table   Using the UPDATE Command   Deleting Records   The COMMIT and ROLLBACK Commands   The TRUNCATE Command Oracle's Data Dictionary   The USER_OBJECTS and ALL_OBJECTS Views   Reviewing PL/SQL Code Blocks with User_source   Using the NVL and the NVL2 Functions

Day 3 Afternoon -  SQL Performance Tuning, Using Business Objects, Understanding Relational Databases, and using SQL*Plus as a report writer

Indexes Which Columns Should Be Indexed? Multicolumn indexes Indexes Optimization The Rule-Based Optimizer The Cost-Based Optimizer Setting the Optimizer      Another Word or Two on Access Paths Join Operations Nested-loop Join Sort-Merge Join Hash Join Explain Plan Statement Plan_table Populating Plan_table Reading the EXPLAIN PLAN Results Dynamic Performance Views Trace   Running and Viewing the Trace Statistics   Hints Performance Odds and Ends Using Business Objects   Data Warehouses   Business Objects   Drilling Down and Exceptions   Oracle Discoverer 4.0: The OLAP Tool of Choice Using SQL*Plus as a Report-Writing tool   Title and Footer Settings   Formatting Columns   Breaks   Subtotals   Sending the Output to the Printer   SET commands

Day 1          Day 2          Top          Day 4          Day 5