Oracle Database: Introduction to SQL/PLSQL Accelerated

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This course is ideal for developers with basic SQL and PL/SQL language skills. This is a 5-day accelerated course specifically designed to give you an end-to-end training on programming with SQL and PL/SQL.

Learn To:

  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML) to update data.
  • Control database access to specific objects.
  • Create anonymous PL/SQL blocks of code.
  • Create triggers to solve business challenges.
  • Retrieve row and column data from tables.

Benefits To You:

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data with…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Database Management, PL/SQL, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

This course is ideal for developers with basic SQL and PL/SQL language skills. This is a 5-day accelerated course specifically designed to give you an end-to-end training on programming with SQL and PL/SQL.

Learn To:

  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML) to update data.
  • Control database access to specific objects.
  • Create anonymous PL/SQL blocks of code.
  • Create triggers to solve business challenges.
  • Retrieve row and column data from tables.

Benefits To You:

Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Extend the functionality of the SQL language with PL/SQL language to write application code.

Course Introduction

This course starts by introducing you to the Oracle Database technology, SQL and PL/SQL. It ends with a hands-on exploration of advanced concepts like developing stored procedures, functions, packages and database triggers.

Gain Essential SQL Skills

Oracle Database: SQL Fundamentals I is the first course of the bundle. It teaches you the essential SQL skills to do the following: write queries against single and multiple tables, manipulate data in tables, create database objects and query meta data.

Oracle Database: SQL Fundamentals II is the second course in the bundle where you'll learn the advanced querying and reporting techniques. This also discusses schema objects that are useful for data warehousing and other application areas.

The third course of this bundle is Oracle Database: PL/SQL Fundamentals. This course introduces you to PL/SQL and helps you understand the benefits of this powerful programming language. At this stage, you'll learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.

Oracle Database: Develop PL/SQL Program Units is the last course that teaches you to to develop, execute and manage PL/SQL stored program units like procedures, functions, packages and database triggers. You'll also learn to manage object dependencies and recompilation of invalid objects.

This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.


Audience
  • Application Developers
  • Business Intelligence Developer
  • Database Designers
  • Forms Developer
  • End Users
  • PL/SQL Developer
  • Technical Consultant
  • Database Administrators

Course Topics
Course Objectives
  • Design PL/SQL code for predefined data types, local subprograms, additional programs and standardized constants and exceptions
  • Design PL/SQL packages to group and contain related constructs
  • Design PL/SQL program units that execute efficiently
  • Handle run-time errors
  • Manage dependencies between PL/SQL subprograms
  • Manipulate large objects
  • Schedule PL/SQL jobs to run independently
  • Use PL/SQL programming constructs and conditional control statements
  • Write dynamic SQL for more coding flexibility
  • Run data manipulation statements (DML) to update data in the Oracle Database
  • Control user access and manage schema objects
  • Employ SQL functions to generate and retrieve customized data
  • Categorize the Oracle supplied PL/SQL packages
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create & describe stored procedures and functions

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.