Course Information
Course Overview
An introduction to the PL/SQL database programming language
The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.This Oracle 11g course will prepare students for the Oracle certification exams (OCP).
Course Content
- 10 section(s)
- 51 lecture(s)
- Section 1 Introduction
- Section 2 Preparing Your Environment
- Section 3 Working with Oracle Database Tools
- Section 4 Language Features
- Section 5 The DECLARE Clause
- Section 6 The BEGIN Clause
- Section 7 The EXCEPTION Clause
- Section 8 Explicit Cursors
- Section 9 Nested Blocks
- Section 10 Declared Subprograms
What You’ll Learn
- Prepare your environment
- Work with Oracle database tools
- Understand and work with language features
- Work with the DECLARE clause
- Work with the BEGIN clause
- Work with the EXCEPTION clause
- Use explicit cursors
- Understand and use nested blocks
- Understand the difference between nested blocks and subprograms
Skills covered in this course
Reviews
-
FFatema Husain
clear language
-
EEzinwa Kingsley Aguwa
The course was really interesting, I enjoyed how the instructor presented the concepts which has really helped me a lot in refreshing my earlier studies. Now how can I face the numerous job markets out there as there are so many job invitations which I receive on daily basis and moreover now that new oracle versions like 23c which is the latest version which is of cloud computing. I really to lay hands on a job to make my dreams come true, I love oracle a lot and wants to be a program developer. When will the certificate of completion get to me.
-
JJoão Pedro Martins Dos Santos
There should be more practical examples and I can't find the files the instructor uses to practice. There's no point in just listening and not practicing.
-
TTisha Choudhuri
I am happy with the explanation, but unable to find the scripts, the instructor asks us to download. I have already looked in places where I should find it and also cross verified with a friend who was using to the same tutorial but could not find the scripts he keeps referring us to. hence, the 3 stars.