Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Pl/SQL

Oracle PL/SQL is My Game: EXAM 1Z0-149

Become Oracle PL/SQL Developer / Covers ORACLE university track 100%. All the presentations & scripts are attached
Bestseller
Rating: 4.5 out of 54.5 (1,238 ratings)
7,574 students
Created by Khaled Alkhudari
Last updated 1/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • The full track of Oracle university Exam 1Z0-144 : Program with PL/SQL
  • Oracle Database 12c Architecture
  • Downloading and installing oracle database 12c in details
  • Overview of PLSQL
  • Declaring PLSQL Variables
  • Writing executable statements
  • Interacting with Oracle DB Server
  • Writing Control structure
  • Working with Composite Data Types
  • Using explicit cursors
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Creating Packages
  • Working with Packages
  • Using oracle-supplied Packages in Application Development
  • Using dynamic SQL
  • Design consideration for PLSQL Code
  • Creating triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Using the PLSQL Compiler
  • Managing PLSQL Code
  • Managing Dependencies
Curated for the Udemy for Business collection

Course content

22 sections • 220 lectures • 21h 53m total length

  • Preview05:31
  • Course Setup Notes / 4 Options
    04:32
  • Option 2- creating the HR Schema
    07:34
  • Option 3- Part 1 : Oracle Database 12c Architecture
    04:27
  • Option 3- Part 2 : Downloading Oracle DB 12c
    03:42
  • Option 3- Part 3 : Installing Oracle DB 12c
    09:16
  • Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
    10:39
  • Option 3- Part 5: Unlock HR Account Part 1
    04:30
  • Option 3- Part 6 : Unlock HR Account Part 2
    11:49
  • Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
    03:33
  • Option 4- Installing Oracle 11g express Edition + Unlock HR
    10:21
  • About Oracle 18c express edition
    00:20
  • HR Schema in this Course
    04:34
  • Navigate HR schema
    07:05

  • What is PL/SQL? What is the benefits?
    08:11
  • PL/SQL Block Structure & Types of Blocks
    05:45
  • Preview07:52
  • Using SQL*plus to run anonyms block
    02:35
  • Creating Script and run it
    04:50
  • Chapter 2 Quiz
    6 questions

  • About Variables and the syntax
    07:02
  • Defining Variables exercise
    06:46
  • Guidelines for declaring & initializing variables
    03:33
  • Delimiters in string literals (the q' Notation)
    05:32
  • Types of variables and data types 1
    05:53
  • Types of variables and data types 2
    05:26
  • Data Types exercise
    Preview05:58
  • Define Variables Using %TYPE
    05:34
  • Understating the SELECT statement in PL/SQL
    04:33
  • Bind Variables
    06:08
  • Chapter 3 Quiz
    6 questions

  • Inside PL/SQL Block
    06:20
  • Inside PL/SQL Block (exercise)
    06:13
  • Nested Blocks
    07:19
  • SQL & PL/SQL programing Guidelines
    04:07
  • Chapter 4 Quiz
    5 questions

  • SELECT statement & DML in PL/SQL
    04:13
  • SELECT statement & DML in PL/SQL exercise
    06:20
  • Understanding Implicit SQL cursor/ SQL Attributes
    03:24
  • Implicit SQL cursor exercise
    05:17
  • Chapter 5 Quiz
    5 questions

  • IF Statement Part 1
    06:15
  • IF Statement Part 2
    06:44
  • Handling nulls in IF statement
    03:58
  • CASE expression & CASE Statement
    08:10
  • Preview06:15
  • While Loop
    04:14
  • FOR Loop
    04:47
  • Nested Loops
    06:14
  • Nested Loops and Labels
    04:49
  • Continue Statement
    04:47
  • Chapter 6 Quiz
    8 questions

  • PL/SQL Records: Programmer method part 1
    07:21
  • PL/SQL Records: Programmer method part 2
    06:58
  • PL/SQL Records: %ROWTYPE method
    08:37
  • Nested PL/SQL Records
    05:20
  • INDEX BY tables (Associative arrays)
    10:40
  • INDEX BY tables Methods
    07:30
  • INDEX BY tables of Records
    07:24
  • nested table
    10:40
  • Varray
    05:23
  • Chapter 7 Quiz
    9 questions

  • Understanding Explicit Cursor
    12:26
  • Explicit Cursor exercise
    08:34
  • Explicit Cursor Attributes
    06:10
  • FOR LOOP Cursor
    04:17
  • Cursor with Parameters
    04:41
  • FOR UPDATE Clause & CURRENT OF Clause
    05:32
  • Chapter 8 Quiz
    10 questions

  • Understanding Exceptions
    06:24
  • Predefined Oracle Server Error Exception
    07:25
  • Common mistakes when dealing with exceptions
    03:39
  • Non-Predefined Oracle Server Error Exception
    06:22
  • User-Defined Error Exception
    05:40
  • Group Functions and exceptions
    04:15
  • Many blocks and many exceptions
    04:06
  • Chapter 9 Quiz
    9 questions

  • Understanding Procedures and subprograms
    08:07
  • Understanding Procedures Syntax
    05:01
  • Creating Procedure (IN parameter)
    Preview09:09
  • Creating Procedure (OUT parameter)
    07:53
  • Creating Procedure (IN OUT parameter)
    04:31
  • Comparing the Paramter Modes
    02:39
  • Available notations for passing parameters
    08:26
  • Using the default option for Parameters
    03:37
  • Exception handling in multiple blocks
    08:45
  • Using Boolean and PL/SQL records as parameters
    05:05
  • Chapter 10 Quiz
    10 questions

Requirements

  • You should know Oracle SQL ( 11g or 12c)
  • You should have strong knowledge in (SELECT statement, DML, DDL, DCL, creating views, indexes, and synonyms)
  • Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database on other OS
  • Downloading oracle database and this will be covered in details on Windows OS.
  • No need for any previous experience in PL/SQL, this Course starts from zero in PL/SQL

Description

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-149 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amount of exercises and examples.

Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam. 

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

Simply this course is the best….


Who this course is for:

  • Students who wants to be expert in PL/SQL programming
  • Students who wants to be certified in PL/SQL
  • Fresh and junior programmers who need to find better jobs by gaining oracle certification
  • Students who already know Oracle SQL and they need to move to next level which is PL/SQL

Featured review

Sarah Funtanilla
Sarah Funtanilla
289 courses
51 reviews
Rating: 5.0 out of 5a year ago
Best PL/SQL Training but I hope you can add additional exercises in the last section for every chapters to be solve by student so that we can practice more. Thumbs Up, please create Advance PL SQL course.

Instructor

Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst
Khaled Alkhudari
  • 4.5 Instructor Rating
  • 8,176 Reviews
  • 30,592 Students
  • 7 Courses

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft  and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.



  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.