Oracle PLSQL Programming Fundamentals LiveLessons

[ken_uit_9x 0]

 

Oracle PL/SQL Programming Fundamentals LiveLessons

English | 2015 | .FLV | h264, yuv420p, 1280x720, 30.00 fps® | aac, 44100 Hz, stereo | 4.95 GB

Genre: E-learning

 

Oracle PL/SQL Programming Fundamentals LiveLessons covers the basics of Oracle's language extension for SQL and the Oracle relational database. The focus is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and packages using the PL/SQL language.

In this LiveLessons course, Oracle ACE Director Dan Hotka will teach you how to work with existing code and create new programs. Along the way, you will learn both conditional and looping syntax and techniques, error handling and error processing, plus how to work with script files, procedures, functions and packages (a collection of procedures and functions). This hands-on course also covers how to use the PL/SQL Debugger and the PL/SQL profiler and how to apply PL/SQL performance tips.

Contents

 

Lesson 1: PL/SQL Course Overview

Learning objectives

1.1 Understand the course pre-requisites

1.2 Learn the Oracle database objects to be used in this course

1.3 Review the command-line SQL*Plus tool

1.4 Review SQL Developer tool

1.5 Review TOAD tool

Put it all together

Lesson 2: Oracle PL/SQL Overview

Learning objectives

2.1. Review Oracle architecture

2.2. Review PL/SQL overview

Put it all together

Lesson 3: PL/SQL Basics and Variables

Learning objectives

3.1 Explore PL/SQL basics

3.2 Use PL/SQL variables

Put it all together

Lesson 4: Logic Flow

Learning objectives

4.1 Understand IF/THEN/ELSE logic

4.2 Explore the CASE statement

4.3 Utilize looping syntax

Put it all together

Lesson 5: PL/SQL Cursors

Learning objectives

5.1 Introduce PL/SQL cursors and the implicit cursor

5.2 Explore explicit cursors

Put it all together

Lesson 6: PL/SQL Exception Handling

Learning objectives

6.1 Introduce PL/SQL exceptions

6.2 Explore PL/SQL exception basic syntax

6.3 Discover implicit vs explicit exceptions

6.4 Work with SQLCODE and SQLERRM features

6.5 Understand user defined exceptions

6.6 Use application defined exceptions

Put it all together

Lesson 7: PL/SQL Procedures and Functions

Learning objectives

7.1 Introduce PL/SQL procedures and functions

7.2 Explore PL/SQL procedures

7.3 Understand PL/SQL functions

7.4 Work with parameter passing

Put it all together

Lesson 8: PL/SQL Packages

Learning objectives

8.1 Introduce PL/SQL packages

8.2 Explore the package syntax

8.3 Review executing code in packages

Put it all together

Lesson 9: PL/SQL Triggers

Learning objectives

9.1 Introduce PL/SQL triggers

9.2 Explore the trigger syntax

9.3 Review the order of trigger processing and other restrictions

9.4 Work with useful examples

Put it all together

Lesson 10: PL/SQL New Features

Learning objectives

10.1 Introduce PL/SQL new features

10.2 Explore the new features with tips and techniques

Put it all together

Lesson 11: PL/SQL Collections

Learning objectives

11.1 Introduce PL/SQL collections

11.2 Explore the collection syntax

11.3 Review code examples

11.4 Explore bulk binding techniques

Put it all together

Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips

Learning objectives

12.1 Introduce PL/SQL debugging, PL/SQL profiling, PL/SQL coding tips

12.2 Explore the TOAD debugger

12.3 Explore the SQL developer debugger

12.4 Review the PL/SQL profiler

12.5 Use the PL/SQL profiler with SQL*Plus

12.6 Use the TOAD PL/SQL profiler

12.7 Review PL/SQL coding tips

Put it all together

Summary

 

 

Buy Premium Account To Get Resumable Support & Max Speed

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

 

Links are Interchangeable - No Password