My Account
|
Français
| Search:
Home
Programming
Training
Microsoft
Training
Server
Training
Network
Training
Management
Training
About
Us
Contact
Us
Oracle Training
1. Title
The Complete PL/SQL Programming Course (ORASQLCP, 5 days) -
View PDF
2. Course Description
This intensive CTES-SETC certified course provides a comprehensive and detailed exploration of the PL/SQL language and it many nooks and crannies. Starting with the basic concepts of the SQL language, the course quickly accelerates to coverage of advanced SQL techniques and PL/SQL programming fundamentals. This is followed by modules covering the concepts of cursors, triggers, procedures and functions and packages. An no course on PL/SQL would be complete in the absence of object oriented programming, Java integration and XML processing. So we do that too. Finally, we conclude our grand tour of PL/SQL with a look at performance and an introduction to performance tuning concepts. If you want to learn PL/SQL, this is the course for you.
3. Course Pre-requisites
Previous experience with SQL syntax
4. Target Audience
Programmers who want to learn PL/SQL
5. Outline
Module 1: The Oracle Development Environment
Topic 1: Learning Objectives
Topic 2: The Oracle RDBMS
Topic 3: Oracle Server Product Overview
Topic 4: PL/SQL Overview
Topic 5: Oracle Application Development Tools
Topic 6: What We Have Learned and the Real World
Module 2: Configuring and Creating Oracle Databases
Topic 1: Learning Objectives
Topic 2: Oracle Relational DB Management System
Topic 3: Tablespaces, Datafiles and Control Files
Topic 4: Using the Oracle SQL*PLUS Utility
Topic 5: Optimizing Table Storage
Topic 6: What We Have Learned and the Real World
Module 3: 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 4: Structured Query Language (SQL) Basics
Topic 1: Learning Objectives
Topic 2: Retrieving Records
Topic 3: Retrieving Aggregate Values
Topic 4: Adding Table Records Using INSERT INTO
Topic 5: Advanced Sub-Queries
Topic 6: Deleting Data
Topic 7: What We Have Learned and the Real World
Module 5: 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 6: 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 7: 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 8: 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 9: 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
Module 10: Oracle Database Triggers
Topic 1: Learning Objectives
Topic 2: Triggers
Topic 3: Creating Triggers
Topic 4: Using Triggers for Logging
Topic 5: System Triggers
Module 11: Working with PL/SQL Records
Topic 1: Learning Objectives
Topic 2: PL/SQL Records
Topic 3: Defining Record Types in PL/SQL
Topic 4: Defining Record Types as Object Types
Topic 5: What We Have Learned and the Real World
Module 12: PL/SQL Collections
Topic 1: Learning Objectives
Topic 2: Introduction
Topic 3: PL/SQL Collections Overview/Types
Topic 4: Working with Varrays
Topic 5: Using Nested Tables
Topic 6: Using Associative Arrays
Topic 7: Collection Reference
Module 13: PL/SQL Error Handling
Topic 1: Learning Objectives
Topic 2: Oracle Errors
Topic 3: Custom Errors
Topic 4: Exception Handling
Topic 5: Raising Exceptions
Topic 6: Handling User Exceptions
Topic 7: Handling PL/SQL Exception
Topic 8: Propagating Exception
Topic 9: What We Have Learned and the Real World
Module 14: Object Oriented Programming with PL/SQL
Topic 1: Learning Objectives
Topic 2: PL/SQL and Object Oriented Programming
Topic 3: Creating Objects
Topic 4: Methods
Topic 5: Object Table
Topic 6: Using DML with Objects
Topic 7: What We Have Learned and the Real World
Module 15: XML Processing
Topic 1: Learning Objectives
Topic 2: Processing XML Data
Topic 3: Creating XML Documents
Topic 4: Validating XML Data against a Schema
Topic 5: A Few Examples
Topic 6: What We Have Learned and the Real World
Module 16: Oracle and Java
Topic 1: Learning Objectives
Topic 2: Preparing the Environment
Topic 3: Using loadjava and dropjava
Topic 4: Managing Java
Topic 5: Using DBMS_JAVA and DBMS_JAVA_TEST
Topic 6: Publishing and Using Java
Topic 7: A Few Useful Examples
Topic 8: What We Have Learned and the Real World
Module 17: Best Practices and Performance Tuning
Topic 1: Learning Objectives
Topic 2: Overview
Topic 3: Optimization and Performance Tuning
Topic 4: Using Indexes
Topic 5: Common Mistakes and their Solutions
Topic 6: What We Have Learned and the Real World
Date and Price
1-2 People for
Guaranteed Delivery
$2,500.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
