Learning Oracle PL/SQL Training Video

Course

Online

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Learning Oracle PL/SQL Training Video A Practical PL/SQL Training Course That Teaches Real World Skills In this project-based Learning Oracle PL/SQL video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Learning Oracle PL/SQL Training Video course to get: Concise, informative and broadcast-quality Oracle PL/SQL  training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Oracle PL/SQL  subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Oracle PL/SQL  tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 7.5 hours to complete this course 74 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description In this Learning Oracle PL/SQL Training Video course by Lewis Cunningham, 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...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

System Requirements - Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do I need...

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database
  • SQL
  • PL/SQL
  • Database training
  • Skills and Training

Course programme

01. Introduction
  • 0101 What Is PL/SQL
  • 0102 Course Expectations
  • 02. An Overview Of PL/SQL
    • 0201 The Difference Between SQL And PL/SQL
    • 0202 Where To Access Oracle - Part 1
    • 0203 Where To Access Oracle - Part 2
    • 0204 Block Structure
    • 0205 Functions Procedures Packages
    • 0206 Data Types
    • 0207 Complex Objects
    • 0208 Variables Constants Parameters - Part 1
    • 0209 Variables Constants Parameters - Part 2
    • 0210 Flow Control
    • 0211 Errors Exceptions
    • 0212 Commenting Code
  • 03. Data Types In Detail
    • 0301 Strings
    • 0302 Numbers
    • 0303 Date And Time
    • 0304 Booleans Lobs
  • 04. Complex Data Structures
    • 0401 Records
    • 0402 Associative Array
    • 0403 Nested Tables
    • 0404 Varrays
    • 0405 Arrays Of Records
  • 05. Programming PL/SQL
    • 0501 SQLplus
    • 0502 SQL Developer - Part 1
    • 0503 SQL Developer - Part 2
  • 06. A First Program
    • 0601 Hello World
    • 0602 Create Assign Use Variables
    • 0603 Create Procedure
    • 0604 Autonomous Transactions
  • 07. Flow Control
    • 0701 If Statements
    • 0702 Case Statements
    • 0703 Loops - Part 1
    • 0704 Loops - Part 2
  • 08. Functions
    • 0801 Functions - Part 1
    • 0802 Functions - Part 2
    • 0803 Built in Functions
  • 09. Exception Handling
    • 0901 What Are Exceptions - Part 1
    • 0902 Predefined Exceptions
    • 0903 Raising Exceptions
    • 0904 Suggestions For Exception Handling
    • 0905 User Defined Exceptions
  • 10. SQL In PL/SQL
    • 1001 Inserting In PL/SQL
    • 1002 Updates And Deletes In PL/SQL
    • 1003 Selecting Data In PL/SQL
    • 1004 Cursors
    • 1005 Cursor For Loops
    • 1006 Bulk Operations
  • 11. Packages
    • 1101 Package Specifications
    • 1102 Package Bodies
    • 1103 Public And Private Globals - Part 1
    • 1104 Public And Private Globals - Part 2
    • 1105 Package Initialization
    • 1106 Forward Declarations
    • 1107 Package Cursors
    • 1108 Utl File
    • 1109 Overloading
  • 12. Triggers
    • 1201 DML Triggers
    • 1202 Compound Triggers
    • 1203 Instead Of Triggers
    • 1204 Database Triggers
  • 13. PL/SQL Objects
    • 1301 Object Types
    • 1302 Constructors
    • 1303 Members
    • 1304 Equality
    • 1305 Inheritance
  • 14. Dynamic SQL
    • 1401 Dynamic SQL
    • 1402 DBMS SQL - Part 1
    • 1403 DBMS SQL - Part 2
    • 1404 DBMS SQL - Part 3
    • 1405 DBMS SQL - Part 4
    • 1406 NDS - Part 1
    • 1407 NDS - Part 2
  • 15. About The Author
    • 1501 About Me

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download purchase?

Once you complete your purchase, you will receive an email with an Access Key, and instructions on how to download your purchase. You will enter that Access Key...

Learning Oracle PL/SQL Training Video

£ 98.75 + VAT

*Indicative price

Original amount in AUD:

$ 189