Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Oracle PL/SQL Fundamentals & Database Design--3course bundle
Rating: 4.5 out of 5(466 ratings)
2,473 students

Oracle PL/SQL Fundamentals & Database Design--3course bundle

The ultimate Oracle/database course bundle with over 20 hours and 100 videos!
Created byIntellezy Trainers
Last updated 1/2018
English

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

3 sections • 117 lectures • 21h 34m total length

  • Introduction3:06
  • Course Setup37:03
  • Selecting the Appropriate Database Tool30:45
  • Understanding PL SQL117:59
  • PL SQL Blocks15:19
  • Working with SQL Plus11:00
  • DECLARE Clause Objects16:25
  • PL SQL Available Data Types16:55
  • Declaring Simple Data Types and Assignments12:16
  • Declaring Complex Data Types and Assignments10:38
  • Declaring Complex RowTypes and Assignments7:02
  • Declaring Complex Tables7:44
  • Declaring Complex Records8:12
  • Creating and Declaring User-Defined Types8:48
  • What Can Be Included in the BEGIN Clause7:02
  • Working with CHAR and VARCHAR2 Variables7:30
  • Handling String Literals7:41
  • Working with Numeric Variables6:40
  • Working with Date Variables6:00
  • Assigning and Using Boolean Variables7:44
  • Using Comparison Operators7:24
  • Using SQL Functions6:04
  • SQL DML within PL SQL115:05
  • Using SELECT6:32
  • Exceptions and Embedded SQL11:16
  • Using Sequences14:28
  • Logic Control and Branching6:58
  • Using GOTO5:52
  • Working with LOOPS18:53
  • Creating and Using the Indefinite Loop6:59
  • Creating and Using the Conditional Loop8:48
  • Using Nested Loops11:33
  • Using the If-Then-Else18:54
  • Using the CASE Statement17:43
  • What Are the Types of Exceptions5:31
  • Trapping Exceptions5:32
  • Identify Exception Details10:57
  • Creating User-Defined Exceptions10:49
  • Using SQLCODE and SQLERRM Objects8:29
  • Understand the Implicit Cursor14:37
  • Creating User-Defined Events12:26
  • Understanding the Concept and Purpose of Explicit Cursors18:10
  • Learn about Cursor Attributes10:12
  • Using the Continue Statement5:44
  • Working with Updateable Cursors19:25
  • Creating and Using Cursor Parameters14:45
  • FOR...LOOP Cursors6:53
  • Understanding Nested Blocks10:46
  • Understanding the Difference between Global vs Local Objects and Exceptions12:35
  • What Are Subprograms and How Are They Different from Nested Blocks17:37
  • Course Recap3:52

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

Report abuse