Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions.


 
Course Outline
This CTES Certified course provides developers with a comprehensive overview of the powerful and flexible development language of PL/SQL. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction.

Course Outline

Module 1: Creating Oracle Database Tables
Topic 1: Learning Objectives
Topic 2: Working with Schemas
Topic 3: Security
Topic 4: Creating and Managing Table
Topic 5: Creating Tables
Topic 6: Dealing with Time Zones
Topic 7: Datetime SQL Functions
Topic 8: What We Have Learned and the Real World
Module 2: Constraints and Sequences
Topic 1: Learning Objectives
Topic 2: Database Integrity and Constraints
Topic 3: Integrity Constraints
Topic 4: Primary Key Constraints
Topic 5: Referential Integrity: Foreign Keys
Topic 6: Modifying Tables and Constraints
Topic 7: Sequence
Topic 8: Retrieving Table and Constraint Information
Topic 9: What We Have Learned and the Real World
Module 3: Advanced SQL Querying
Topic 1: Learning Objectives
Topic 2: Multiple-Table Join Strategies
Topic 3: Using Multi-Table Joins
Topic 4: Creating and Using Sub-Queries
Topic 5: Creating and Using Stored Views
Topic 6: What We Have Learned and the Real World
Module 4: PL/SQL Language Fundamentals
Topic 1: Learning Objectives
Topic 2: PL/SQL Programming Basics
Topic 3: Entering PL/SQL Using SQL*Plus
Topic 4: PL/SQL Script Development Basics
Topic 5: PL/SQL Blocks
Topic 6: PL/SQL Data Types
Topic 7: PL/SQL Variables
Topic 8: Controlling PL/SQL Program Flow
Topic 9: What We Have Learned and the Real World
Module 5: PL/SQL Procedures and Functions
Topic 1: Learning Objectives
Topic 2: Overview
Topic 3: Creating Procedures and Functions
Topic 4: Simple Stored Procedures
Topic 5: Stored Procedures with Parameters
Topic 6: What We Have Learned and the Real World
Module 6: PL/SQL Packages
Topic 1: Learning Objectives
Topic 2: Creating PL/SQL Packages
Topic 3: Oracle WRAP Utility
Topic 4: What We Have Learned and the Real World

Prerequisites & Certificates
Pre-Requisites

Previous relational database development experience.

Certificates offered


Cancellation Policy
All courses must be canceled more than 10 business days prior to the first day of the class.
Map & Reviews
SETC Training - Formation SETC
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 154 times.