Certificate Course on

Database Programming with PL/SQL

Oracel programming make your future path smoother

Get things done with oracle

Choose the best productivity suite for your business

EXCLUSIVE

Course Objective:

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a project that challenges studentsto program, implement, and demonstrate a database solution for a business or organization.

Learning Tools

Payment

Target Audiences

Educators

  • College/university faculty who teach computer programming or a related subject
  • Secondary school teachers who teach computer programming

Students

  • Students who wish to learn the techniques and tools to automate database application tasks
  • Students who possess basic mathematical, logical, and analytical problem-solving skills
  • Novice programmers, as well as those at advanced levels, to learning the PL/SQL programming language to an advanced level

Prerequisites

Required

  • Previous experience with at least one programming language

Suggested

  • Previous Experience with a database application
  • Oracle Academy Course – Database Design and Database Programming with SQL

Suggested Next Courses

  • Getting Started with Java Using Alice
  • Creating Java Programs with Greenfoot
  • Java Fundamentals
  • Java Programming

Lesson-by-Lesson Topics

Fundamentals
3 section

Introduction to PL/SQLBenefits of PL/SQLCreating PL/SQL Blocks

Defining Variables and Datatypes
7 section

Using Variables in PL/SQLRecognizing PL/SQL Lexical UnitsRecognizing Data TypesUsing Scalar Data TypesWriting PL/SQL Executable StatementsNested Blocks and Variable ScopeGood Programming Practices

Using SQL in PL/SQL
4 section

Review of SQL DMLRetrieving Data in PL/SQLManipulating Data in PL/SQLUsing Transaction Control Statements

Program Structures to Control Execution Flow
5 section

Conditional Control: IF StatementsConditional Control: CASE StatementsIterative Control: Basic LoopsIterative Control: WHILE and FOR LoopsIterative Control: Nested Loops

Using Composite Datatypes
2 section

User-Defined RecordsIndexing Tables of Records

Using Cursors and Parameters
6 section

Introduction to Explicit CursorsUsing Explicit Cursor AttributesCursor FOR LoopsCursors with ParametersUsing Cursors for UPDATEUsing Multiple Cursors

 

Exception Handling
4 section

Handling ExceptionsTrapping Oracle Server ExceptionsTrapping User-Defined ExceptionsRecognizing the Scope of Exceptions

Using and Managing Procedures
3 section

Creating ProceduresUsing Parameters in ProceduresPassing Parameters

Using and Managing Functions
6 section

Creating FunctionsUsing Functions in SQL StatementsReview of the Data DictionaryManaging Procedures and FunctionsReview of Object PrivilegesUsing Invoker's Rights and Autonomous Transactions

Using and Managing Packages
3 section

Creating PackagesManaging Package ConceptsAdvanced Package Concepts

Getting the Best out of Packages
2 section

Persistent State of Package VariablesUsing Oracle-Supplied Packages

Improving PL/SQL Performance
2 section

Using Dynamic SQLImproving PL/SQL Performance

Using and Managing Triggers
5 section

Introduction To TriggersCreating DML Triggers, Part ICreating DML Triggers, Part IICreating DDL and Database Event TriggersManaging Triggers

Recognizing and Managing Dependencies
2 section

Introduction to DependenciesUnderstanding Remote Dependencies

Using the PL/SQL Compiler
4 section

Using PL/SQL Initialization ParametersDisplaying Compiler Warning MessagesUsing Conditional CompilationHiding Your Source Code
Translate »