The Oracle 11g PL/SQL Bootcamp Bundle
2 Courses & 19 Hours
Deal Price$19.99
Suggested Price$54.00
You save 62%
What's Included
$27.00 Value
Oracle 11g PL/SQL Part 1
Intellezy Learning
51 Lessons (9h)
Lifetime
- Experience level required: Beginner
- Access 51 lectures & 9 hours of content 24/7
- Length of time users can access this course: Lifetime
Course Curriculum
51 Lessons (9h)
- Your First Program
- IntroductionIntroduction3:06
- Preparing Your EnvironmentCourse Setup37:03
- Working with Oracle Database ToolsSelecting the Appropriate Database Tool30:45
- Language FeaturesUnderstanding PL SQL17:59PL SQL Blocks15:19Working with SQL Plus11:00
- The DECLARE ClauseDECLARE Clause Objects16:25PL SQL Available Data Types16:55Declaring Simple Data Types and Assignments12:16Declaring Complex Data Types and Assignments10:38Declaring Complex RowTypes and Assignments7:02Declaring Complex Tables7:44Declaring Complex Records8:12Creating and Declaring User-Defined Types8:48
- The BEGIN ClauseWhat Can Be Included in the BEGIN Clause7:02Working with CHAR and VARCHAR2 Variables7:30Handling String Literals7:41Working with Numeric Variables6:40Working with Date Variables6:00Assigning and Using Boolean Variables7:44Using Comparison Operators7:24Using SQL Functions6:04SQL DML within PL SQL15:05Using SELECT6:32Exceptions and Embedded SQL11:16Using Sequences14:28Logic Control and Branching6:58Using GOTO5:52Working with LOOPS18:53Creating and Using the Indefinite Loop6:59Creating and Using the Conditional Loop8:48Using Nested Loops11:33Using the If-Then-Else18:54Using the CASE Statement17:43
- The EXCEPTION ClauseWhat Are the Types of Exceptions5:31Trapping Exceptions5:32Identify Exception Details10:57Creating User-Defined Exceptions10:49Using SQLCODE and SQLERRM Objects8:29Understand the Implicit Cursor14:37Creating User-Defined Events12:26
- Explicit CursorsUnderstanding the Concept and Purpose of Explicit Cursors18:10Learn about Cursor Attribute10:12Using the Continue Statement5:44Working with Updateable Cursors19:25Creating and Using Cursor Parameters14:45FOR...LOOP Cursors6:53
- Nested BlocksUnderstanding Nested Blocks10:46Understanding the Difference between Global vs Local Objects and Exceptions12:35
- Declared SubprogramsWhat Are Subprograms and How Are They Different from Nested Blocks17:37
- ConclusionCourse Recap3:52
Oracle 11g PL/SQL Part 1
IL
Intellezy LearningIntellezy Learning
A professional delivery should be accompanied by an equally impressive presentation. While other video eLearning solutions utilize "at-home technology" to film and produce content, Intellezy’s video library is produced by professionals, in a studio, for professionals like you. Start watching and find out how valuable 3 minutes can be.
Description
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).
- Access 51 lectures & 9 hours of content 24/7
- Work with Oracle database tools
- Learn about the language features
- Use the DECLARE, BEGIN, & EXCEPTION clauses
- Understand the concept & purpose of explicit cursors
- Learn the difference between Global vs Local Objects and Exceptions
- Know what subprograms are & how they are different from nested blocks
Specs
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Experience level required: beginner
- Have questions on how digital purchases work? Learn more here
Requirements
- Any device with basic specifications
$27.00 Value
Oracle 11g PL/SQL Part 2
Intellezy Learning
46 Lessons (10h)
Lifetime
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...