Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Learning Oracle PL/SQL Programming

    Subscriber Reviews • Browse Similar Topics

    Overview

    In this training course by Lewis Cunningham on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry. Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there! By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

    Subscriber Reviews

    Average Rating: 4.875 out of 5 rating Based on 8 Ratings

    "Excellent " - by Anonymous on 01-MAY-2013
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    Lucid, to-the-point. Well done.
    Report as Inappropriate

    "good book" - by Anonymous on 04-MAY-2012
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    very good book
    Report as Inappropriate

    Table of Contents

    Chapter/Selection

    Time

    01. Introduction

    What Is PL/SQL

    Preview

    00:04:01

    Course Expectations

    Preview

    00:04:18

    Working File Updates

    Preview

    00:00:16

    02. An Overview Of PL/SQL

    The Difference Between SQL And PL/SQL

    Preview

    00:06:42

    Where To Access Oracle - Part 1

    Preview

    00:04:28

    Where To Access Oracle - Part 2

    Preview

    00:05:53

    Block Structure

    Preview

    00:07:03

    Functions Procedures Packages

    Preview

    00:09:45

    Data Types

    Preview

    00:07:19

    Complex Objects

    Preview

    00:07:11

    Variables Constants Parameters - Part 1

    Preview

    00:05:55

    Variables Constants Parameters - Part 2

    Preview

    00:07:30

    Flow Control

    Preview

    00:07:35

    Errors Exceptions

    Preview

    00:07:46

    Commenting Code

    Preview

    00:03:46

    03. Data Types In Detail

    Strings

    Play Video

    00:05:06

    Numbers

    Play Video

    00:04:27

    Date And Time

    Play Video

    00:03:46

    Booleans Lobs

    Play Video

    00:03:42

    04. Complex Data Structures

    Records

    Preview

    00:07:00

    Associative Array

    Preview

    00:06:35

    Nested Tables

    Play Video

    00:03:26

    Varrays

    Preview

    00:02:50

    Arrays Of Records

    Preview

    00:04:23

    05. Programming PL/SQL

    SQLplus

    Preview

    00:03:26

    SQL Developer - Part 1

    Preview

    00:04:45

    SQL Developer - Part 2

    Preview

    00:06:27

    06. A First Program

    Hello World

    Play Video

    00:04:06

    Create Assign Use Variables

    Preview

    00:05:33

    Create Procedure

    Preview

    00:05:50

    Autonomous Transactions

    Preview

    00:07:07

    07. Flow Control

    If Statements

    Preview

    00:04:50

    Case Statements

    Preview

    00:06:26

    Loops - Part 1

    Play Video

    00:05:20

    Loops - Part 2

    Preview

    00:07:24

    08. Functions

    Functions - Part 1

    Preview

    00:07:23

    Functions - Part 2

    Preview

    00:03:03

    Built in Functions

    Preview

    00:09:06

    09. Exception Handling

    What Are Exceptions - Part 1

    Preview

    00:06:28

    Predefined Exceptions

    Preview

    00:04:40

    Raising Exceptions

    Preview

    00:05:20

    Suggestions For Exception Handling

    Preview

    00:05:57

    User Defined Exceptions

    Preview

    00:07:38

    10. SQL In PL/SQL

    Inserting In PL/SQL

    Play Video

    00:07:09

    Updates And Deletes In PL/SQL

    Preview

    00:08:24

    Selecting Data In PL/SQL

    Preview

    00:06:07

    Cursors

    Preview

    00:05:21

    Cursor For Loops

    Preview

    00:02:07

    Bulk Operations

    Preview

    00:07:51

    11. Packages

    Package Specifications

    Preview

    00:04:45

    Package Bodies

    Preview

    00:03:59

    Public And Private Globals - Part 1

    Preview

    00:06:46

    Public And Private Globals - Part 2

    Preview

    00:03:04

    Package Initialization

    Preview

    00:05:00

    Forward Declarations

    Preview

    00:04:28

    Package Cursors

    Preview

    00:03:57

    Utl File

    Preview

    00:07:34

    Overloading

    Preview

    00:09:23

    12. Triggers

    DML Triggers

    Preview

    00:08:30

    Compound Triggers

    Preview

    00:02:42

    Instead Of Triggers

    Preview

    00:02:48

    Database Triggers

    Preview

    00:02:55

    13. PL/SQL Objects

    Object Types

    Preview

    00:05:54

    Constructors

    Play Video

    00:07:16

    Members

    Preview

    00:05:47

    Equality

    Preview

    00:06:49

    Inheritance

    Preview

    00:08:25

    14. Dynamic SQL

    Dynamic SQL

    Preview

    00:11:32

    DBMS SQL - Part 1

    Preview

    00:07:15

    DBMS SQL - Part 2

    Preview

    00:04:49

    DBMS SQL - Part 3

    Preview

    00:05:30

    DBMS SQL - Part 4

    Preview

    00:09:35

    NDS - Part 1

    Play Video

    00:08:12

    NDS - Part 2

    Preview

    00:13:34

    15. About The Author

    About Me

    Preview

    00:03:48

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    These files have been provided by the publisher.

    • Working_Files.zip