Oracle Server (Certificate)

CBIT Canadian Beaver Training Ottawa
Ottawa, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

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

Elements of this syllabus are subject to change.

Phone:613 742-6800

School Address/Venue(s):

CBIT Canadian Beaver Training Ottawa
214 Montreal Rd
Suite 100
Ottawa, Ontario
K1L 8L8
Canada

Jobs & Resumes: Ottawa
Houses & Roommates: Ottawa
Travel Agencies: Ottawa

Search other schools for Oracle Server training resources.

Team Building and Workplace Efficiency
SQL Server Programming
SQL Server Administration
SQL Server 2008
Building a Data Warehouse with Oracle
Oracle Core Administration Skills
PL-SQL Programming for Oracle Professionals

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.