Home > Training > Introduction to Oracle:SQL & PL/SQL

Introduction to Oracle: SQL & PL/SQL

Description:
This 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 are taught to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Demonstrations and hands-on practice reinforce the fundamental concepts. This class is preparation for both the Oracle Application Developer and Database Administrator certification exam.

This course is designed to prepare you for the corresponding Oracle Certified Professional exam: Exam #1Z0-001.

Prerequisites:
Familiarity with data processing concepts and techniques
Ability to use a graphical user interface (GUI)

Course Objectives:
Control data/user access
Control transactions
Create and maintain database objects
Describe the features and syntax of PL/SQL
Retrieve, insert, update, and delete data
Handle runtime errors
Describe relational database concepts
Conditionally control code flow (loops, control structures, and explicit cursors)
Use basic SQL*Plus commands

Course Topics:

Introduction
Describing the Lifecycle Development Phases
Defining a Database
Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database
Describing How a Relational Database Management System (RDBMS) Is Used to Manage a Relational Database.
Describing the Oracle Implementation of the RDBMS
Describing How SQL Is Used in the Oracle Product Set
Describing PL/SQL
Describing the Use of PL/SQL for the Developer and the DBA

Writing a Basic SQL Statement
Describing the SQL Select Capabilities
Executing a Basic Select Statement with the Mandatory Clauses
Differentiating Between SQL and SQL*Plus Commands

Restricting and Sorting Data
Limiting the Rows Retrieved by a Query
Sorting the Rows Retrieved by a Query

Single Row Functions
Describing Various Types of Functions Available in SQL
Using a Variety of Character, Number, and Date Functions in SELECT Statements
Explaining What the Conversion Functions Are and How They Are Used

Next >>