Oracle Plsql Fundamentals Database Design 3 Bundle

  1. Home
  2. Plsql
  3. Oracle Plsql Fundamentals Database Design 3 Bundle

Tags: Pl/SQL

The ultimate Oracle/database course bundle with over 20 hours and 100 videos!

Last updated 2022-01-10 | 4.7

- Over 100 lectures and 20 hours of content
- Understand different types of databases
- Relate tables with IDs

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

* 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

Course content

3 sections • 117 lectures

Oracle 11g PL/SQL Fundamentals I 51 lectures

Introduction Preview 03:06

Course Setup Preview 37:03

Selecting the Appropriate Database Tool Preview 30:45

Understanding PL SQL1 Preview 17:59

PL SQL Blocks Preview 15:19

Working with SQL Plus Preview 11:00

DECLARE Clause Objects Preview 16:25

PL SQL Available Data Types Preview 16:55

Declaring Simple Data Types and Assignments Preview 12:16

Declaring Complex Data Types and Assignments Preview 10:38

Declaring Complex RowTypes and Assignments Preview 07:02

Declaring Complex Tables Preview 07:44

Declaring Complex Records Preview 08:12

Creating and Declaring User-Defined Types Preview 08:48

What Can Be Included in the BEGIN Clause Preview 07:02

Working with CHAR and VARCHAR2 Variables Preview 07:30

Handling String Literals Preview 07:41

Working with Numeric Variables Preview 06:40

Working with Date Variables Preview 06:00

Assigning and Using Boolean Variables Preview 07:44

Using Comparison Operators Preview 07:24

Using SQL Functions Preview 06:04

SQL DML within PL SQL1 Preview 15:05

Using SELECT Preview 06:32

Exceptions and Embedded SQL Preview 11:16

Using Sequences Preview 14:28

Logic Control and Branching Preview 06:58

Using GOTO Preview 05:52

Working with LOOPS Preview 18:53

Creating and Using the Indefinite Loop Preview 06:59

Creating and Using the Conditional Loop Preview 08:48

Using Nested Loops Preview 11:33

Using the If-Then-Else Preview 18:54

Using the CASE Statement Preview 17:43

What Are the Types of Exceptions Preview 05:31

Trapping Exceptions Preview 05:32

Identify Exception Details Preview 10:57

Creating User-Defined Exceptions Preview 10:49

Using SQLCODE and SQLERRM Objects Preview 08:29

Understand the Implicit Cursor Preview 14:37

Creating User-Defined Events Preview 12:26

Understanding the Concept and Purpose of Explicit Cursors Preview 18:10

Learn about Cursor Attributes Preview 10:12

Using the Continue Statement Preview 05:44

Working with Updateable Cursors Preview 19:25

Creating and Using Cursor Parameters Preview 14:45

FOR...LOOP Cursors Preview 06:53

Understanding Nested Blocks Preview 10:46

Understanding the Difference between Global vs Local Objects and Exceptions Preview 12:35

What Are Subprograms and How Are They Different from Nested Blocks Preview 17:37

Course Recap Preview 03:52

Oracle 11g PL/SQL Fundamentals II 46 lectures

Introduction Preview 02:40

Installing Oracle XE1 Preview 10:59

SQL Developer Installation Preview 19:47

Workstation Setup Preview 12:14

Introducing the Database Program Unit Preview 19:05

Creating Stored Procedures and Functions Preview 18:44

Understanding the Parameter Specification Preview 22:57

Executing Procedures and Functions Preview 26:11

Calling Functions from within SQL Preview 13:05

Handling Compilation Errors Preview 08:19

Recompiling and Dropping Programs Preview 16:06

Data Dictionary Storage Preview 24:47

Managing Dependencies Preview 12:52

Tracking Dependencies Preview 08:25

Using the Dependency Tracking Utility Preview 09:25

What is a Package? Preview 10:02

Creating a Package Preview 19:03

Package Definition Information Preview 07:52

Advanced Programming Techniques Preview 06:06

Using Persistent Global Objects Preview 03:36

Including Initialization Logic Preview 15:17

Object Oriented Support within Packages Preview 13:44

Package Maintenance Preview 17:47

Learning to Use Cursor Variables Preview 23:38

Weak Cursor Definitions Preview 16:10

REFCURSOR Cursor Definition Preview 05:06

Using Cursor Expressions Preview 13:36

Using the DBMS OUTPUT () Packages Preview 11:38

Using the UTL_FILE() Package Preview 29:29

Understanding the Database Trigger Preview 23:18

Statement-Level Triggers Preview 22:35

Row-Level Triggers Preview 12:04

Row Level Trigger Example Preview 11:08

Row Level Trigger Example Preview 07:24

Row Level Trigger Example Preview 07:35

Working with the INSTEAD OF Trigger Preview 10:53

Using Triggers within an Application Preview 08:47

Using the CALL Statement Preview 09:08

Trigger Maintenance Tasks Preview 12:15

Working with Multiple Triggers for a Single Table Preview 10:46

Handling Mutating Table Issues Preview 22:09

Using the Compound Trigger Preview 05:34

What is a System Event Trigger? Preview 05:25

Defining Scope Preview 03:36

Identifying Available System Events Preview 12:12

Conclusion Preview 01:31

Database Design Introduction 20 lectures

Introduction Preview 03:19

Overview Preview 00:50

What is a Database? Preview 02:47

Different Types of Databases Preview 11:40

The Process of Database Design Preview 07:58

Normalizing Overview Preview 01:04

What is Normalization? Preview 02:16

Basic Steps to Normalization Preview 04:38

A. Brainstorm Preview 01:08

B. Organize Preview 03:13

C. Eliminate Repetition Preview 11:34

D. Assign Relationships Preview 00:22

D-1. One to One Relationship Preview 06:01

D-2. One to Many Relationship Preview 04:19

D-3. Many to Many Relationship Preview 05:29

Relating Tables with IDs Preview 01:46

Examples of Bad Design Preview 15:20

Examples of Good Design Preview 05:53

Design Rules Preview 05:09

Course Recap Preview 04:17