My Account
|
Français
| Search:
Home
Programming
Training
Microsoft
Training
Server
Training
Network
Training
Management
Training
About
Us
Contact
Us
Oracle Training
1. Title
An Introduction to PL/SQL Development for Professional Developers (PLIDEV, 3 days) -
View PDF
2. Course Description
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.
3. Course Pre-requisites
Previous relational database development experience.
4. Target Audience
Professional developers who want to use PL/SQL
5. 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
Date and Price
1-2 People for
Guaranteed Delivery
$2,000.00
Programming Training
Overview
UML Training
HTML Training
.NET Training
Java Training
PL/SQL Training
Shell Scripting
C++ Training
Web Dev Training
Microsoft Training
Overview
Windows 8 Training
Server 2012 Training
SQL Server Training
Exchange Server
SharePoint Training
BizTalk Training
TFS Training
Server Training
Overview
UNIX Training
Linux Training
VMWare Training
Oracle Training
Apache Training
Citrix Training
Network Training
Overview
Wireless Training
Cisco Training
VOIP Training
IPv6 Training
Security Training
Management Training
Overview
ITIL® Training
Project Management
Business Analysis
Agile Training
Testing and QA
Risk Management
ITIL® is a registered trademark of the Cabinet Office
IT Infrastructure Library® is a registered trademark of the Cabinet Office
