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