| |A Comprehensive Introduction To Oracle Server
| |
ID: ORINTR | Course Length: 2 |  |
|
| | |
Module 0: Creating Oracle Database Tables |
| | | - Tablespaces, Datafiles & Control Files
- Modifying Tables & Constraints
- Retrieving Table & Constraint Information
- Creating & Using Constraints – Examples
- Using Oracle Utilities
- Using & Creating Table Field Datatypes
- Creating Tables Overview
- Building Table Examples
- Database Integrity & Constraints
- Integrity Constraints
- Primary Key Constraints
- Referential Integrity: Foreign Keys
|
 |
| | |
Module 1: Structured Query Language (sql) - Overview |
| | | - Sql/querying Overview
- The Select Statement
- Retrieving Aggregate Values
- Adding Table Records Using Insert Into
- Deleting Data
- Multiple-table Join Strategies
- Using Multi-table Joins
- Creating & Using Sub-queries
- Creating & Using Stored Views
|
|
| | |
Module 2: Pl/sql Language Fundamentals |
| | | - Pl/sql Programming Basics
- Using Built-in Pl/sql Functions
- Entering Pl/sql Using Sql*plus
- Pl/sql Script Development Basics
- Pl/sql Blocks
- Pl/sql Data Types
- Pl/sql Variables
- Controlling Pl/sql Program Flow
- Retrieving Sql Data
- Pl/sql Cursors
|
|
| | |
Module 3: Working With Pl/sql Records |
| | | - Pl/sql Records
- Defining Record Types In Pl/sql
- Defining Record Types As Object Types
- Defining & Using Record Types As Parameters
- Defining & Using Object Types As Parameters
- Returning Record Types From Functions
- Using Record Types As Return Values
|
|
| | |
Module 4: Pl/sql Procedures & Functions |
| | | - Pl/sql Procedures Vs. Functions
- Creating Functions & Procedures
- Function/procedure Parameters
- Calling Functions/procedures
- Stored Vs. Local Functions/procedures
- Using Shared Pools
|
|