Oracle PL/SQL Fundamentals & Database Design--3course bundle
What you'll learn
- Over 100 lectures and 20 hours of content
- Understand different types of databases
- Relate tables with IDs
- Understand normalization
- Introducing Database Program Units
- Creating and Maintaining Packages
- Work with DECLARE, BEGIN & EXCEPTION clause
- Understand and use nested blocks
- Use explicit cursors
Course content
- Preview03:06
- 37:03Course Setup
- 30:45Selecting the Appropriate Database Tool
- 17:59Understanding PL SQL1
- 15:19PL SQL Blocks
- 11:00Working with SQL Plus
- 16:25DECLARE Clause Objects
- 16:55PL SQL Available Data Types
- 12:16Declaring Simple Data Types and Assignments
- 10:38Declaring Complex Data Types and Assignments
- 07:02Declaring Complex RowTypes and Assignments
- 07:44Declaring Complex Tables
- Preview08:12Declaring Complex Records
- 08:48Creating and Declaring User-Defined Types
- 07:02What Can Be Included in the BEGIN Clause
- 07:30Working with CHAR and VARCHAR2 Variables
- 07:41Handling String Literals
- 06:40Working with Numeric Variables
- 06:00Working with Date Variables
- 07:44Assigning and Using Boolean Variables
- Preview07:24Using Comparison Operators
- 06:04Using SQL Functions
- 15:05SQL DML within PL SQL1
- 06:32Using SELECT
- 11:16Exceptions and Embedded SQL
- 14:28Using Sequences
- 06:58Logic Control and Branching
- 05:52Using GOTO
- Preview18:53Working with LOOPS
- 06:59Creating and Using the Indefinite Loop
- 08:48Creating and Using the Conditional Loop
- 11:33Using Nested Loops
- 18:54Using the If-Then-Else
- 17:43Using the CASE Statement
- 05:31What Are the Types of Exceptions
- 05:32Trapping Exceptions
- 10:57Identify Exception Details
- 10:49Creating User-Defined Exceptions
- 08:29Using SQLCODE and SQLERRM Objects
- 14:37Understand the Implicit Cursor
- 12:26Creating User-Defined Events
- 18:10Understanding the Concept and Purpose of Explicit Cursors
- 10:12Learn about Cursor Attributes
- 05:44Using the Continue Statement
- 19:25Working with Updateable Cursors
- 14:45Creating and Using Cursor Parameters
- 06:53FOR...LOOP Cursors
- 10:46Understanding Nested Blocks
- 12:35Understanding the Difference between Global vs Local Objects and Exceptions
- 17:37What Are Subprograms and How Are They Different from Nested Blocks
- 03:52Course Recap
Requirements
- Basic Microsoft Windows training or equivalent experience and familiarity with database and programming principles
Description
Over 20 hours and 100 videos are included in this bundle.
Save 20% by purchasing 3 Oracle/Database courses. This bundle includes:
- Oracle PL/SQL Fundamentals vol. I
- Oracle PL/SQL Fundamentals vol. II
- Database Design Instruction
In this Oracle 11g PL/SQL vol I & II courses, you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).
The Database Design Instruction course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project. Information in this course is a must for anyone responsible for building and maintaining a database.
Who this course is for:
- Application designers and developers
- Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design
Instructor
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.