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 Personal Transformation Meditation Life Purpose Coaching Emotional Intelligence
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 Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Cleaning
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-12-28 22:34:36
30-Day Money-Back Guarantee

This course includes:

  • 24 hours on-demand video
  • 78 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
Development Database Design & Development Pl/SQL

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

A Full-Real Guide to Make You a Job-Ready PL/SQL Developer &Also covers "Oracle 1Z0-144 and 1Z0-149" PL SQL Exam Topics!
Bestseller
Rating: 4.4 out of 54.4 (4,030 ratings)
20,951 students
Created by Oracle Master Training • 80,000+ Students Worldwide, Code Star Academy
Last updated 11/2020
English
English [Auto], Polish [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
  • Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
  • Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
  • Every Subject is Explained from the Easiest to the Most Advanced.
  • Real-World Examples for Every Section
  • Some Advanced SQL Techniques
  • Use SQL Developer Efficiently for PL/SQL
  • Learn PL/SQL Architecture Very Well
  • Improve Performance of SQL& PL/SQL Codes
  • Create Your Dynamic SQL & PL/SQL Queries
  • Learn PL/SQL Object Oriented Programming
  • Learn PL/SQL Tuning for Performance
  • Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
  • Become a Job-Ready Oracle PL/SQL Developer Certified Professional!
Curated for the Udemy for Business collection

Course content

17 sections • 196 lectures • 24h 41m total length

  • Preview04:28
  • UDEMY 101: How to Use Udemy? +Some Useful Tips
    05:01
  • What is PL/SQL and Why to Use?
    Preview05:35
  • PL/SQL Architecture
    09:33
  • The Sample (HR) Schema Used in This Course
    07:14
  • Bonus Materials : Course Material & PL/SQL Cheatsheet
    00:29
  • Quiz 1
    5 questions

  • About the Database Installation
    Preview03:02
  • Which Option to Choose to Have a Database?
    09:09
  • Option 1: Having the Database with the Oracle Virtual Box
    16:29
  • Option 1: How to Install the Virtual Box on Mac OS X?
    01:41
  • What is Pluggable Database?
    03:13
  • Option 2: Downloading and Installing the Oracle Database
    18:18
  • Option 2: Unlocking the HR Schema
    07:34
  • Option 2: Configuring and Using the SQL Developer
    22:14
  • Option 3: Using Oracle Live SQL
    07:40
  • Option 3: About Oracle Live SQL Restrictions
    00:20

  • Anonymous Blocks
    13:42
  • PL/SQL Outputs
    08:19
  • Quiz 2
    6 questions

  • What are Variables and Why to Use Them?
    08:36
  • Naming Rules & Naming Conventions
    04:24
  • Declaring & Initializing & Using Variables - Part 1
    10:44
  • Declaring & Initializing & Using Variables - Part 2
    10:22
  • Declaring & Initializing & Using Variables (Code Samples)
    00:23
  • Using %TYPE Attribute
    07:07
  • Using %Type Attribute (Code Samples)
    00:06
  • PL/SQL Delimiters and Commenting Your Code
    05:36
  • PL/SQL Delimiters and Commenting (Code Samples)
    00:07
  • PL SQL Variable Scope
    11:15
  • PL SQL Variable Scope (Code Samples)
    00:09
  • Using Bind Variables
    10:53
  • Using Bind Variables (Code Samples)
    00:19
  • Quiz 3 - Variables
    10 questions

  • What are Control Structures & IF Statements
    13:57
  • What are Control Structures & IF Statements (Code Samples)
    00:27
  • Case Expressions
    14:48
  • Case Expressions (Code Samples)
    00:32
  • What are Loops - Basic Loops
    Preview10:11
  • Basic Loops (Code Samples)
    00:08
  • While Loops
    05:32
  • While Loops (Code Samples)
    00:06
  • For Loops
    09:54
  • For Loops (Code Samples)
    00:04
  • Nested Loops & Loop Labeling
    16:00
  • Nested Loops & Loop Labeling (Code Samples)
    00:21
  • Continue Statement
    10:23
  • Continue Statement (Code Samples)
    00:20
  • GOTO Statement
    13:30
  • GOTO Statement (Code Samples)
    00:26
  • Quiz 4 - Control Structures
    10 questions

  • Operating with Selected Database Data..
    18:26
  • Operating Wİth Selected Queries (Code Samples)
    00:27
  • DML Operations in PL/SQL
    12:46
  • DML Operations in PL/SQL (Code Samples)
    00:12
  • Using Sequences in PL/SQL
    12:37
  • Using Sequences in PL/SQL (Code Samples)
    00:57
  • Bonus - Enabling Server Outputs by Default.
    04:39
  • Quiz 5 - Using SQL in PL/SQL
    3 questions

  • Simple Data Types vs Composite Data Types
    07:52
  • PL/SQL Records - Part 1
    16:40
  • Preview16:30
  • PL/SQL Records (Code Samples)
    00:37
  • Easy DML With Records
    08:14
  • Easy DML With Records (Code Samples)
    00:18
  • What Are Collections?
    06:14
  • Varrays & Collection Methods
    22:59
  • Varrays (Code Samples)
    01:21
  • Nested Tables
    10:57
  • Nested Tables (Code Samples)
    00:41
  • PL&SQL Associative Arrays (Part 1)
    18:54
  • PL&SQL Associative Arrays (Part 2)
    14:53
  • Associative Arrays (Code Samples)
    02:12
  • Storing Collections in Tables - (Part 1)
    14:07
  • Storing Collections in Tables - (Part 2)
    11:15
  • Storing Collections in Tables (Code Samples)
    00:49
  • Quiz 6 - Composite Data Types
    15 questions

  • What are Cursors and Cursor Types in PL SQL?
    08:05
  • Using Explicit Cursors
    11:13
  • Using Explicit Cursors (Code Samples)
    00:21
  • Using Cursors with Records
    06:11
  • Cursors with Records (Code Samples)
    00:22
  • Looping with Cursors
    12:16
  • Looping with Cursors (Code Samples)
    00:46
  • PL SQL Cursors with Parameters
    13:33
  • PL SQL Cursors with Parameters (Code Samples)
    01:36
  • PL SQL Cursor Attributes
    08:28
  • PL SQL Cursor Attributes (Code Samples)
    00:14
  • For Update Clause
    20:32
  • For Update Clause (Code Samples)
    00:39
  • Where Current Of Clause
    09:52
  • Where Current Of Clause (Code Samples)
    00:31
  • Reference Cursors
    24:10
  • Reference Cursors - (Code Samples)
    02:00

  • What are the Exceptions?
    09:15
  • What are the Exceptions (Code Sample)
    00:03
  • Handling the Exceptions!
    17:55
  • Handling the Exceptions (Code Samples)
    01:26
  • Handling the Nonpredefined Exceptions
    06:24
  • Handling Nonpredefined Exceptions (Code Sample)
    00:10
  • Handling & Raising User-Defined Exceptions
    07:53
  • Handling & Raising User-Defined Exceptions (Code Samples)
    00:45
  • Using RAISE_APPLICATION_ERROR() Procedure
    Preview07:49
  • Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)
    00:33

  • What are Functions & Procedures and Why We Use?
    08:36
  • What are Functions & Procedures and Why We Use (Code Samples)
    00:33
  • Creating and Using Stored Procedures
    16:51
  • Creating and Using Stored Procedures (Code Samples)
    00:44
  • Using IN & OUT Parameters
    14:34
  • Using IN & OUT Parameters (Code Samples)
    00:57
  • Named & Mixed Notations and Default Option
    16:25
  • Named & Mixed Notations and Default Option (Code Samples)
    00:33
  • Creating and Using Functions (Part 1)
    16:31
  • Creating and Using Functions (Part 2)
    07:21
  • Creating and Using PL/SQL Functions (Code Samples)
    00:19
  • Local Subprograms
    14:48
  • Local Subprograms (Code Samples)
    00:48
  • Overloading the Subprograms
    13:11
  • Overloading the Subprograms (Code Samples)
    00:46
  • Handling the Exceptions in Subprograms
    19:42
  • Handling the Exceptions in Subprograms (Code Samples)
    00:52
  • Finding & Removing the Subprograms
    11:02
  • Regular & Pipelined Table Functions
    19:32
  • Regular & Pipelined Table Functions (Code Samples)
    00:32

Requirements

  • Basic knowledge of Oracle SQL

Description

★ Last Course Updates:

✔ (Nov, 2020): "Oracle-Supplied PL/SQL Packages" section is added!

✔ (Oct, 2020): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

✔ (Sep, 2020): Closed-Captions are added!

✔ (Jul, 2020): New Quiz Questions are added!

☞ Become an "Oracle Database PL/SQL Developer Certified Professional"!

This PL/SQL course is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a hero in PL/SQL will find everything that they are looking for. 

Students will learn and improve their:

  • PL/SQL Coding Skills

  • SQL & PL/SQL Performance

  • PL/SQL Scalability

  • Portability and Security about Database and PL/SQL

And also students will be prepared for:

  • Exam Number: 1Z0-149 | Oracle Database 19c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-148 | Oracle Database 12c: Advanced PL/SQL        | Oracle Certification Exam

  • Exam Number: 1Z0-144 | Oracle Database 12c: Program with PL/SQL | Oracle Certification Exam

  • Exam Number: 1Z0-144 | Oracle Database 11g: Program with PL/SQL | Oracle Certification Exam

Who this course is for:

  • Anyone who wants to learn PL/SQL Programming Language
  • Anyone who is looking for Beginner PL/SQL Subjects
  • Anyone who is looking for Advanced PL/SQL Subjects
  • Anyone who wants to pass "Oracle 1Z0-144 Program with PL/SQL" Exam
  • Anyone who wants to pass "Oracle 1Z0-148 Advanced PL/SQL" Exam
  • Anyone who wants to pass "Oracle 1Z0-149: Program with PL/SQL" Exam with Oracle Database 19c
  • SQL Developers (All Levels)
  • Beginner & Intermediate PL/SQL Developers
  • Database Administrators
  • Application Designers
  • Software Developers

Featured review

Ljubomir Colovic
Ljubomir Colovic
26 courses
11 reviews
Rating: 5.0 out of 59 months ago
I am senior PL/SQL developer and I find this course very useful for update/upgrade your knowledge. Also codes that are provided along with data in Database I find very useful and convenient for practicing in safe environment. I would recommend it to all who wants to learn and upgrade knowlege of PL/SQL

Instructors

Oracle Master Training • 80,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
Oracle Master Training • 80,000+ Students Worldwide
  • 4.4 Instructor Rating
  • 15,970 Reviews
  • 81,822 Students
  • 7 Courses

I have been working for more than 20+ years on software development on many programming languages (like C, C++, Java, C#, Python, PHP, etc.) and about 15+ years on SQL & PL/SQL programming using many different Oracle Technologies. And also I'm a software development manager for more than 15 years.

Currently, I work as a Project Manager on a huge database which has more than 20 million active-users, and at the same time, teaching SQL & PL/SQL and many programming languages such as Python, C, Java, PHP programming, etc.

Code Star Academy
Software Training Center | Over 80.000+ Successful Students
Code Star Academy
  • 4.4 Instructor Rating
  • 15,970 Reviews
  • 81,822 Students
  • 7 Courses

Hi, welcome to our courses.

'Code Star' Academy is a platform and community that teaches SQL & PL/SQL Development, SQL Tuning, Python Programming, Web Development and many Computer Science related topics. 

Through a passion for tech and what it means to be a Computer Scientist and Developer, Code Star Academy creates great courses, blog posts and videos to instruct, inspire and spread these topics across a large spectrum.

Our Mission, give others the opportunity to be part of an amazing field whilst teaching them the skills that will allow them to do so.

Our expertise areas are mainly:

★ Programming Languages (Python, SQL, PL&SQL, PHP, Java, etc.)

★ Database Development

★ Data Science

★ Big Data

★ Cloud Computing

★ Data Mining

★ Data Visualization

★ Data Security

★ Computer Security               

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

► Time is so precious so every second costs you money ($$$)

☞ Don't postpone your dreams ☜

✔ Enroll to our courses right now!

✔ Success is your destiny and we are waiting for you!

✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯✯

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