| 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 | ||
| FOR…LOOP 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 | ||
| Assessment | |||
| Order Your Certificate | |||
| Order Your Certificate New | 00:00:00 | ||
The Oracle 11g PL/SQL Beginner course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts. You’ll learn the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method.
Testimonial
