Software Development / Programming Languages
Oracle 11g PL/SQL Part 1
An introduction to the PL/SQL database programming language.
Instructor
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).
Instructor: Timothy Miles
Curriculum
- IntroductionIntroduction3:07
- Preparing Your EnvironmentCourse Setup37:04Course Exercise Files
- Working with Oracle Database ToolsSelecting the Appropriate Database Tool30:46
- Language FeaturesUnderstanding PL SQL18:00PL SQL Blocks15:20Working with SQL Plus11:01
- The DECLARE ClauseDECLARE Clause Objects16:26PL SQL Available Data Types16:56Declaring Simple Data Types and Assignments12:17Declaring Complex Data Types and Assignments10:39Declaring Complex RowTypes and Assignments7:03Declaring Complex Tables7:45Declaring Complex Records8:13Creating and Declaring User-Defined Types8:49
- The BEGIN ClauseWhat Can Be Included in the BEGIN Clause7:03Working with CHAR and VARCHAR2 Variable7:31Handling String Literals7:42Working with Numeric Variables6:41Working with Date Variables6:01Assigning and Using Boolean Variables7:45Using Comparison Operators7:25Using SQL Functions6:05SQL DML within PL SQL15:06Using SELECT6:33Exceptions and Embedded SQL11:17Using Sequences14:29Logic Control and Branching6:59Using GOTO5:53Working with LOOPS18:54Creating and Using the Indefinite Loop7:00Creating and Using the Conditional Loop8:49Using Nested Loops11:34Using the If-Then-Else18:55Using the CASE Statement17:44
- The EXCEPTION ClauseWhat Are the Types of Exceptions5:32Trapping Exceptions5:33Identify Exception Details10:58Creating User-Defined Exceptions10:50Using SQLCODE and SQLERRM Objects8:30Understand the Implicit Cursor - No Animation14:38Creating User-Defined Events12:27
- Explicit CursorsUnderstanding the Concept and Purpose of Explicit Cursors18:11Learn about Cursor Attributes10:13Using the Continue Statement5:45Working with Updateable Cursors19:26Creating and Using Cursor Parameters14:46FOR...LOOP Cursors6:54
- Nested BlocksUnderstanding Nested Blocks10:47Understanding the Difference between Global vs Local Objects and Exceptions12:36
- Declared SubprogramsSubprograms: How They Differ from Nested Blocks17:38
- ConclusionCourse Recap3:53
Skills
- Oracle
- Structured Query Language (SQL)
