Description

Description

PL/SQL is program units which are composed by the Oracle Database server and stored in the database. The main function of PL/SQL is to hold SQL proclamation within its syntax. If you are interested to know more about SL/SQL function, and how it brings optimal competence in terms of 'procedural language', you may have a look at the Oracle 11g PL/SQL Beginner course.

The course is designed in such a way that will assist the learners to know how it works with various strings, numbers, table row record, and error management. It also teaches the learner how to use different key data lexicon to synopsize and maintain the data. The learners will also be able to know about portability, productivity, and manageability of this most widely manipulative language.

Assessment:

This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Oracle 11g PL/SQL Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Oracle 11g PL/SQL Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Introduction
	Introduction	FREE	00:03:00
Preparing Your Environment
	Course Setup		00:37:00
Working with Oracle Database Tools
	Selecting the Appropriate Database Tool		00:31:00
Language Features
	Understanding PL/SQL		00:18:00
	PL/SQL Blocks		00:15:00
	Working with SQL Plus		00:11:00
The DECLARE Clause
	DECLARE Clause Objects		00:16:00
	PL/SQL Available Data Types		00:17:00
	Declaring Simple Data Types and Assignments		00:12:00
	Declaring Complex Data Types and Assignments		00:11:00
	Declaring Complex RowTypes and Assignments		00:07:00
	Declaring Complex Tables		00:08:00
	Declaring Complex Records		00:08:00
	Creating and Declaring User-Defined Types		00:09:00
The BEGIN Clause
	What Can Be Included in the BEGIN Clause		00:07:00
	Working with CHAR and VARCHAR2 Variables		00:08:00
	Handling String Literals		00:08:00
	Working with Numeric Variables		00:07:00
	Working with Date Variables		00:06:00
	Assigning and Using Boolean Variables		00:08:00
	Using Comparison Operators		00:07:00
	Using SQL Functions		00:06:00
	SQL DML within PL/SQL		00:15:00
	Using SELECT		00:07:00
	Exceptions and Embedded SQL		00:11:00
	Using Sequences		00:14:00
	Logic Control and Branching		00:07:00
	Using GOTO		00:06:00
	Working with LOOPS		00:19:00
	Creating and Using the Indefinite Loop		00:07:00
	Creating and Using the Conditional Loop		00:09:00
	Using Nested Loops		00:12:00
	Using the If-Then-Else		00:19:00
	Using the CASE Statement		00:18:00
The EXCEPTION Clause
	What Are the Types of Exceptions		00:06:00
	Trapping Exceptions		00:06:00
	Identify Exception Details		00:11:00
	Creating User-Defined Exceptions		00:11:00
	Using SQLCODE and SQLERRM Objects		00:09:00
	Understand the Implicit Cursor		00:15:00
	Creating User-Defined Events		00:12:00
Explicit Cursors
	Understanding the Concept and Purpose of Explicit Cursors		00:18:00
	Learn about Cursor Attributes		00:10:00
	Using the Continue Statement		00:06:00
	Working with Updateable Cursors		00:19:00
	Creating and Using Cursor Parameters		00:15:00
	FORLOOP Cursors		00:07:00
Nested Blocks
	Understanding Nested Blocks		00:11:00
	Difference between Global vs Local Objects and Exceptions		00:13:00
Declared Subprograms
	Subprograms: How They Differ from Nested Blocks		00:18:00
Conclusion
	Conclusion		00:04:00
Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

Oracle 11g PL/SQL Beginner

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews