Course Description
The [course_title] course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts.
Initially, you’ll learn how to start programming in Oracle PL/SQL. You’ll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable.
Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career.
From beginners to expert learner can benefit from this course. So enrol today and see what else is in the [course_title] course.
What Will I Learn?
- Prepare your environment
- Work with Oracle database tools
- Understand and work with language features
- Work with the DECLARE clause
- Work with the BEGIN clause
- Work with the EXCEPTION clause
- Use explicit cursors
- Understand and use nested blocks
- Understand the difference between nested blocks and subprograms
Requirements
- Familiarity with database and programming principles
Who is the target audience?
- Application designers and developers
- Database administrators
- Business users and non-technical senior end users
-
Introduction 00:03:00
-
Course Setup 00:37:00
-
Selecting the Appropriate Database Tool 00:31:00
-
Understanding PL/SQL 00:18:00
-
PL/SQL Blocks 00:15:00
-
Working with SQL Plus 00:11:00
-
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
-
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:08:00
-
Using Nested Loops 00:12:00
-
Using the If-Then-Else 00:19:00
-
Using the CASE Statement 00:18:00
-
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
-
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
-
Understanding Nested Blocks 00:11:00
-
Difference between Global vs Local Objects and Exceptions 00:13:00
-
Subprograms: How They Differ from Nested Blocks 00:18:00
-
Conclusion 00:04:00
Course Reviews
No Reviews found for this course.
or
Get all courses for only £492000+ Globally Recognised Premium Courses
This course includes:
