Oracle PLSQL Fundamentals Database Design3course bundle_1

Oracle PL/SQL Fundamentals & Database Design–3course bundle, available at $69.99, has an average rating of 4.2, with 117 lectures, based on 429 reviews, and has 2328 subscribers.

You will learn about 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 This course is ideal for individuals who are Application designers and developers or Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design It is particularly useful for Application designers and developers or Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design.

Enroll now: Oracle PL/SQL Fundamentals & Database Design–3course bundle

Summary

Title: Oracle PL/SQL Fundamentals & Database Design–3course bundle

Price: $69.99

Average Rating: 4.2

Number of Lectures: 117

Number of Published Lectures: 117

Number of Curriculum Items: 117

Number of Published Curriculum Objects: 117

Original Price: $149.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Oracle 11g PL/SQL Fundamentals I

Lecture 1: Introduction

Lecture 2: Course Setup

Lecture 3: Selecting the Appropriate Database Tool

Lecture 4: Understanding PL SQL1

Lecture 5: PL SQL Blocks

Lecture 6: Working with SQL Plus

Lecture 7: DECLARE Clause Objects

Lecture 8: PL SQL Available Data Types

Lecture 9: Declaring Simple Data Types and Assignments

Lecture 10: Declaring Complex Data Types and Assignments

Lecture 11: Declaring Complex RowTypes and Assignments

Lecture 12: Declaring Complex Tables

Lecture 13: Declaring Complex Records

Lecture 14: Creating and Declaring User-Defined Types

Lecture 15: What Can Be Included in the BEGIN Clause

Lecture 16: Working with CHAR and VARCHAR2 Variables

Lecture 17: Handling String Literals

Lecture 18: Working with Numeric Variables

Lecture 19: Working with Date Variables

Lecture 20: Assigning and Using Boolean Variables

Lecture 21: Using Comparison Operators

Lecture 22: Using SQL Functions

Lecture 23: SQL DML within PL SQL1

Lecture 24: Using SELECT

Lecture 25: Exceptions and Embedded SQL

Lecture 26: Using Sequences

Lecture 27: Logic Control and Branching

Lecture 28: Using GOTO

Lecture 29: Working with LOOPS

Lecture 30: Creating and Using the Indefinite Loop

Lecture 31: Creating and Using the Conditional Loop

Lecture 32: Using Nested Loops

Lecture 33: Using the If-Then-Else

Lecture 34: Using the CASE Statement

Lecture 35: What Are the Types of Exceptions

Lecture 36: Trapping Exceptions

Lecture 37: Identify Exception Details

Lecture 38: Creating User-Defined Exceptions

Lecture 39: Using SQLCODE and SQLERRM Objects

Lecture 40: Understand the Implicit Cursor

Lecture 41: Creating User-Defined Events

Lecture 42: Understanding the Concept and Purpose of Explicit Cursors

Lecture 43: Learn about Cursor Attributes

Lecture 44: Using the Continue Statement

Lecture 45: Working with Updateable Cursors

Lecture 46: Creating and Using Cursor Parameters

Lecture 47: FORLOOP Cursors

Lecture 48: Understanding Nested Blocks

Lecture 49: Understanding the Difference between Global vs Local Objects and Exceptions

Lecture 50: What Are Subprograms and How Are They Different from Nested Blocks

Lecture 51: Course Recap

Chapter 2: Oracle 11g PL/SQL Fundamentals II

Lecture 1: Introduction

Lecture 2: Installing Oracle XE1

Lecture 3: SQL Developer Installation

Lecture 4: Workstation Setup

Lecture 5: Introducing the Database Program Unit

Lecture 6: Creating Stored Procedures and Functions

Lecture 7: Understanding the Parameter Specification

Lecture 8: Executing Procedures and Functions

Lecture 9: Calling Functions from within SQL

Lecture 10: Handling Compilation Errors

Lecture 11: Recompiling and Dropping Programs

Lecture 12: Data Dictionary Storage

Lecture 13: Managing Dependencies

Lecture 14: Tracking Dependencies

Lecture 15: Using the Dependency Tracking Utility

Lecture 16: What is a Package?

Lecture 17: Creating a Package

Lecture 18: Package Definition Information

Lecture 19: Advanced Programming Techniques

Lecture 20: Using Persistent Global Objects

Lecture 21: Including Initialization Logic

Lecture 22: Object Oriented Support within Packages

Lecture 23: Package Maintenance

Lecture 24: Learning to Use Cursor Variables

Lecture 25: Weak Cursor Definitions

Lecture 26: REFCURSOR Cursor Definition

Lecture 27: Using Cursor Expressions

Lecture 28: Using the DBMS OUTPUT () Packages

Lecture 29: Using the UTL_FILE() Package

Lecture 30: Understanding the Database Trigger

Lecture 31: Statement-Level Triggers

Lecture 32: Row-Level Triggers

Lecture 33: Row Level Trigger Example

Lecture 34: Row Level Trigger Example

Lecture 35: Row Level Trigger Example

Lecture 36: Working with the INSTEAD OF Trigger

Lecture 37: Using Triggers within an Application

Lecture 38: Using the CALL Statement

Lecture 39: Trigger Maintenance Tasks

Lecture 40: Working with Multiple Triggers for a Single Table

Lecture 41: Handling Mutating Table Issues

Lecture 42: Using the Compound Trigger

Lecture 43: What is a System Event Trigger?

Lecture 44: Defining Scope

Lecture 45: Identifying Available System Events

Lecture 46: Conclusion

Chapter 3: Database Design Introduction

Instructors

Intellezy Trainers
Multi-Award-Winning eLearning Specialists

Rating Distribution

1 stars: 9 votes

2 stars: 8 votes

3 stars: 42 votes

4 stars: 142 votes

5 stars: 228 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!