Oracle 8i DBA: SQL and PL/SQL
Description
This Oracle8i DBA: SQL and PL/SQL course offers students an extensive introduction to data server technology. The class covers the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students enrolled in this course will learn to create and maintain database objects; to store, retrieve, and manipulate data; and to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This class is preparation for both the Oracle Application Developer and Database Administrator certification exam.
Objectives
This course is designed to prepare you for the Oracle Certified Professional exam (Exam #1Z0-001.) The key topics covered in this class include: - Controlling data/user access
- Controlling transactions
- Creating and maintaining database objects
- Describing the features and syntax of PL/SQL
- Retrieving, inserting, updating, and deleting data
- Handling runtime errors
- Describing relational database concepts
- Conditionally controlling code flow (loops, control structures, and explicit cursors)
- Using basic SQL*Plus commands
Audience
This course is designed for IT professionals serving roles as Designers, Developers, Application Developers, System Analysts, or Database Administrators.
Prerequisites
Students enrolling in PL/SQL should have a working understanding of data processing concepts and techniques and the ability to use a graphical user interface (GUI).
Included Materials
Interactive Self-Paced courses provide:
- Unlimited 24 x 7 access to Campus for the entire program (all courses are launched from a personalized web site that organizes and manages your training experience).
- Hands-on Labs - a perfectly simulated, real-world environment to test skills without risk. Based on availability.
- Engaging course demos and real-world examples
- Access to a variety of training resources and certification information.
Included Labs
- Using the SELECT Statement
- Using JOINs and Local Variables
- Creating and Managing Tables
- Creating and Altering Procedures
Outline
Oracle 8i DBA: SQL and PL/SQL
- Data Retrieval
- SQL Fundamentals
- Storage System Development
- Oracle System Components
- Basic SQL Statements
- Data Manipulation
- Row Data Manipulation
- Single-Row Functions
- Using the SELECT Statement
- Advanced Data Retrieval
- Multiple Table Data Display
- Fundamental Queries
- Advanced Queries
- Group Functions
- Subqueries
- Subquery Uses
- Subquery Types
- Multiple-Column Subqueries
- Readable Output through SQL*Plus
- Variables
- SQL*Plus Environment Customization
- Using JOINs and Local Variables
- Database Object Creation
- Oracle Tables
- Table Creation
- Datatypes and Columns
- Table Definitions
- Creating and Managing Tables
- Oracle Constraints
- Constraint Inclusion
- Constraint Modification
- Oracle Data
- Oracle Data Dictionary
- Oracle Data Manipulation
- Transaction Control
- Additional Database Objects
- View Creation
- Fundamentals
- Functionality
- Additional Database Objects
- Using Sequences
- Using Indexes
- Using Synonyms
- User Access Control
- Fundamentals
- Privileges and Roles
- The PL/SQL Language
- PL/SQL Fundamentals
- Using PL/SQL
- Writing Executable Statements
- Writing Control Structures
- Data and Datatypes
- Database Interaction
- Composite Datatypes
- Cursor and Error Handling
- Explicit Cursor Handling
- Error Handling
  |
