DATABASE PROGRAMMING WITH PL/SQL

Database Programming with PL/SQL This course covers PL/SQL, a procedural language extension to SQL. Through an innovative project-based approach, students learn procedural logic constructs such as variables, constraints, conditional statements and iterative controls. Students have the opportunity to sit for the second of two exams required to earn the Oracle Certifified Associate. Section 1 Fundamentals This section provides an introduction to PL/SQL and explains the difference between SQL and the PL/SQL block structure. Students explore some of the limitations of

SQL and learn why PL/SQL is needed. PL/SQL key words and definitions and appropriate usages are introduced. The students learn the characteristics of the PL/SQL programming language including how it compares to other programming languages like C and Java. Finally, students learn about the PL/SQL block structure, the basic unit in PL/SQL. They begin coding anonymous blocks in Oracle Application Express, a browser-based development environment. Lesson 1: Introduction to PL/SQL • Describe PL/SQL • Differentiate between SQL and PL/SQL • Explain the need for PL/SQL Lesson 2: Benefits of PL/SQL • List and explain the benefits of PL/SQL • List differences between PL/SQL and other programming languages • Give examples of how PL/SQL can be used in other Oracle products Lesson 3: Creating PL/SQL Blocks • Describe the structure of a PL/SQL block • Identify the different types of PL/SQL blocks • Identify PL/SQL programming environments • Create and execute an anonymous PL/SQL block • Output messages in PL/SQL Section 2 Defining Variables and Datatypes Section two explains how PL/SQL extends SQL by adding program structures and subroutines. This section introduces students to the syntax, vocabulary, and parts of speech or lexical units of the PL/SQL programming language. Students learn...

Website: academy.oracle.com | Filesize: 101kb
No of Page(s): 10
Download DATABASE PROGRAMMING WITH PL/SQL.pdf