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+ Microsoft AZ-900
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 Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging 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
Office Productivity Oracle Pl/SQL

PL/SQL by Example - Beginner to Advanced PL/SQL

Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application
Rating: 4.5 out of 54.5 (3,846 ratings)
18,661 students
Created by Amarnath Reddy
Last updated 12/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Declare PL/SQL Variables
  • Conditionally control code flow (loops, control structures)
  • Use some of the Oracle supplied PL/SQL packages to generate screen output
  • Create anonymous PL/SQL blocks, functions and procedures
  • Use PL/SQL packages to group and contain related constructs
  • Catch run time errors using Exceptions
  • Perform Data processing using Records and Cursors
  • Manage data using Collections
  • Create triggers to solve business challenges
  • Peform Bulk Processing to improve performance
  • Execute SQL using Dynamic SQL
  • Pipelining the data as it is processed
  • Working with Large Objects (LOB's)
Curated for the Udemy for Business collection

Requirements

  • SQL Knowledge is needed and is a must!!!

Description

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Use the Oracle supplied PL/SQL packages to generate screen output
  • Create and debug Stored Procedures and Functions
  • Design PL/SQL packages to group related constructs
  • Use PL/SQL programming constructs and conditionally control code flow
  • Create overloaded package subprograms for more flexibility
  • Handle runtime errors using Exceptions
  • Writing manageable code using Records
  • Storing and processing data using Collections
  • Processing data using Implicit and Explicit Cursors

Softwares used

  • Oracle Database 11g
  • SQL Developer

Who this course is for:

  • This PL/SQL course is meant for students who want to learn Procedure Language to control SQL Statements.
  • This course is not for you if you're looking to learn more advanced concepts of PL/SQL

Course content

16 sections • 103 lectures • 5h 41m total length

  • Preview03:15
  • How to make best use of the Program...
    1 page

  • Installing Oracle
    03:08
  • Installing Java SDK
    02:00
  • Installing SQL Developer
    03:50
  • Running scripts necessary for the course
    02:12
  • Scripts for our Lab Exercises
    4 pages

  • What is PL/SQL
    02:59
  • PL/SQL Advantages
    02:34
  • PL/SQL Structure
    01:51
  • First Example
    01:22
  • Declaring Variables
    05:03
  • Comments in PL/SQL
    01:44
  • Scope of Variables
    01:54
  • IF then ELSE statement
    05:16
  • CASE Statemet
    01:58
  • WHILE Loop
    02:10
  • FOR Loop
    02:09
  • Exercise #1
    3 pages

  • Preview04:18
  • What is %TYPE
    Preview02:12
  • Inserting data into database
    03:09
  • Exercise #2
    3 pages

  • Anonymous Blocks
    02:46
  • What are Procedures?
    03:07
  • Creating a Procedure
    02:35
  • Calling a Procedure
    03:16
  • Procedure with OUT Mode
    02:54
  • Procedure with IN OUT Mode
    02:17
  • What are Functions?
    03:32
  • Calling a Function
    02:31
  • Exercise #3
    4 pages

  • What are Exceptions
    Preview02:46
  • Exceptions Example
    08:26
  • User Defined Exceptions
    03:12
  • System Defined Exceptions list
    2 pages
  • Exercise #4
    5 pages

  • What are Packages
    04:01
  • Package Specification
    04:11
  • Package Body
    03:36
  • Executing sub programs present in Packages
    01:34
  • Exercise #5
    4 pages

  • What are Records?
    02:27
  • Records Example
    03:44
  • Working with Record data
    03:51
  • Passing Records as parameters
    01:59
  • Inserting data using Records
    02:05
  • Updating data using Records
    02:19
  • User defined Record Types
    01:25
  • User defined Record Example
    02:28
  • Exercise #6
    5 pages

  • What are Cursors?
    01:50
  • Implicit Cursor
    04:37
  • Explicit Cursor
    01:21
  • Retrieving 1 row using Explicit Cursor
    03:11
  • Retrieving more than 1 row using Explicit Cursor
    02:39
  • Using Records in Cursors
    02:42
  • Cursor FOR Loop
    03:42
  • Cursor Variable and Reference Cursor
    05:48
  • Exceptions for Cursors
    01:01
  • Exercise #7
    4 pages

  • What are Collections
    01:55
  • Collection Terminology
    01:34
  • Associative Arrays
    04:21
  • Nested Tables
    05:17
  • What are VARRAYS
    02:48
  • Collection Methods
    02:34
  • MULTISET Operators
    04:06
  • Collections Summary
    01:51
  • Exercise #8
    4 pages

Instructor

Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Amarnath Reddy
  • 4.4 Instructor Rating
  • 16,070 Reviews
  • 71,813 Students
  • 9 Courses

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

  • 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.