Best PL-SQL Courses

Find the best online PL-SQL Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free PL-SQL Courses.

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!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 31256, Price: $129.99

Students: 31256, Price:  Paid

Last Course Updates:

(Jul 2021): "Oracle-Supplied PL/SQL Packages" section is added!

(Jun 2021): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!

(May 2021): Closed-Captions are added!

(Apr 2021): New Quiz Questions are added!

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

This Comprehensive PL/SQL Programming Bootcamp 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 Programming

And also our 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

Our PL/SQL Programming Bootcamp Covers:

  • PL/SQL Terminologies

  • PL/SQL Architecture

  • PL/SQL Variables

  • PL/SQL Control Structures

    • If-Then-Else Structure

    • Case Expressions

    • Loops

      • While Loop

      • For Loop

      • Nested Loop

      • Loop Labeling

      • Continue Statement

      • GOTO Statement

  • Using SQL inside PL/SQL

  • PL/SQL Cursors

  • Using PL/SQL Program Units (Functions & Procedures)

  • PL/SQL Packages

  • PL/SQL Exceptions & Exception Handling

  • PL/SQL Debugging

  • Dynamic SQL & PL/SQL

  • PL/SQL Composite Data Types (Collections)

    • Associative Arrays

    • Nested Tables

    • Varrays

    • Records

  • PL/SQL Triggers

  • Oracle-Supplied Packages

  • Using Large Objects in PL/SQL (LOBs)

  • Using PL/SQL Object Oriented

  • Using PL/SQL Compiler

  • PL/SQL Performance &Tuning

  • PL/SQL Caching

  • PL/SQL Security

  • PL/SQL Fine-Grained Access Control (VPD)

  • PL/SQL Hints

  • PL/SQL Object Dependencies

  • Designing Better PL/SQL(İlk slayt section 8 ve Advanced slayt section 3)

  • Using Java/C in PL/SQL(Advanced section 7)

  • Managing Dependencies

Final Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQL.

Oracle PL/SQL Fundamentals vol. I & II

A complete introduction to PL/SQL database programming language

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 23464, Price: $119.99

Students: 23464, Price:  Paid

In this Oracle 11g PL/SQL Bundle 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).

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

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 20969, Price: $124.99

Students: 20969, Price:  Paid

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

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

Created by Khaled Alkhudari - Sr Oracle Developer/ Sr system analyst

"]

Students: 8590, Price: $129.99

Students: 8590, Price:  Paid

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

Oracle Database 11g: Program with PL/SQL 4 Practice Tests

Oracle Database 11g: Program with PL/SQL(1Z0-144)

Created by Great Academy - Informations personnelles

"]

Students: 6066, Price: $19.99

Students: 6066, Price:  Paid

This practice test is designed to help you evaluate if you are ready to successfully complete the Oracle Database 11g: Program with PL/SQL | 1Z0-144 Certification exam.

Scenario based exam questions for Oracle Database 11g: Program with PL/SQL | 1Z0-144 Certification,

Online practice exam to be completed in Specified Time Duration.

Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam is related to Oracle Database 11g and Credits towards Oracle Advanced PL/SQL Developer Certified Professional and Oracle PL/SQL Developer Certified Associate. This exam validates the Candidates ability to Oracle Database 11g Procedural language, Structured Query Language PL/SQL fundamentals list the uses of variables declaring and initialized use bind variables, use built-in SQL functions in PL/SQL and sequences and PL/SQL expressions, describe when implicit and conversations take place and when explicit conversations have to be dealt with creating PL/SQL executable blocks using data manipulation language DML and Transaction Control Statements, declaring Control explicit cursor use simple loops and cursor for loops to fetch data lock rows with the for update clause and reference occurs in row with the Where current of clause. It also validates the ability to Oracle Database 11g like develop PL/SQL program units differentiate between anonymous blocks and subprograms manage persistent package data states for the life of a session and the warp utility. Senior Database Administrators, IT Directors, and IT Architects usually hold or pursue this certification and you can expect the same job role after completion of this certification

The Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam certification is an internationally-recognized validation that identifies persons who earn it as possessing skilled as an Oracle PL/SQL Developer Certified Associate. If a candidate wants significant improvement in career growth needs enhanced knowledge, skills, and talents. The Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam certification provides proof of this advanced knowledge and skill. If a candidate has knowledge of associated technologies and skills that are required to pass Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam then he should take this exam.

The benefit in Obtaining the 1Z0-144 Exam Certification

Oracle Advanced PL/SQL Developer Certified Professional are distinguished among competitors. Oracle Advanced PL/SQL Developer Certified Professional certification can give them an edge at that time easily when candidates appear for a job interview employers seek to notify something which differentiates the individual to another.

Oracle Advanced PL/SQL Developer Certified Professional have more useful and relevant networks that help them in setting career goals for themselves. Oracle Advanced PL/SQL Developer Certified Professional networks provide them with the right career direction than non certified usually are unable to get.

Oracle Advanced PL/SQL Developer Certified Professional will be confident and stand different from others as their skills are more trained than non-certified professionals.

Oracle Advanced PL/SQL Developer Certified Professional have the knowledge to use the tools to complete the task efficiently and cost effectively than the other non-certified professionals lack in doing so.

Oracle Advanced PL/SQL Developer Certified Professional Certification provides practical experience to candidates from all the aspects to be a proficient worker in the organization.

Oracle Advanced PL/SQL Developer Certified Professional Certifications provide opportunities to get a job easily in which they are interested in instead of wasting years and ending without getting any experience.

Oracle 11g PL/SQL Fundamentals I

An introduction to the PL/SQL database programming language

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 3389, Price: $89.99

Students: 3389, Price:  Paid

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

200+ PL/SQL Interview Questions

Prepare for an PL/SQL Developer Interview with these 200+ Real World PL/SQL Questions and Practical Answers

Created by Amarnath Reddy - Oracle Architect & Best Selling Instructor | 27000+ Students

"]

Students: 2747, Price: $89.99

Students: 2747, Price:  Paid

Are you ready for your PL/SQL Developer Interview?

I have about 15+ years of experience in the Database world and have Interviewed 100’s of PL/SQL Developers in my 15+ years span.

Learning how to answer the PL/SQL interview questions is a powerful skill which can make the difference between getting hired or not.

I have used all my experience to put together this 200+ Real World PL/SQL Questions and Practical Answers. 

I want to help each one of you to succeed in the PL/SQL Job Interview. As part of this, I am providing an opportunity to conduct a Mock Interview to each one of my students.

Become confident and ready to answer the most common PL/SQL interview questions asked during any PL/SQL Developer interview using the points and tips presented in this course.

Nowadays the competition for one job is quite high, many candidates for the same position, so if you want to get hired you cannot afford not being prepared to present yourself as the best fit candidate.

How to answer to the interview questions is one of the area where you can prepare the best, especially when it comes to the most common PL/SQL interview questions because this questions are asked during all job interviews.

By the end of this course, you will know all the great secrets to answer the most common PL/SQL interview questions during any job interview. We will analyse each question and make sure you include in your answer just what is important to present yourself as the best fit candidate.

Are you ready to prepare the best 200+ answers to the most common PL/SQL interview questions?

Take this course and join other 14000+ happy students who learnt to nail any job interview! 

See you inside the course!

Learn Oracle PL/SQL – A Comprehensive Training Course

A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills

Created by Infinite Skills - High Quality Training

"]

Students: 2188, Price: $49.99

Students: 2188, Price:  Paid

In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry.

Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there!

By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

Created by Adnan Waheed - Founder KlickAnalytics.com and ex-Bloomberg employee

"]

Students: 2063, Price: $89.99

Students: 2063, Price:  Paid

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more...

I've design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

  • Apply powerful SQL commands to store, update and retrieve information

  • Step-by-step walkthrough to perform simple to complex SQL queries

  • How to create a database from the scratch, Creating and modifying tables

  • Using UPSERT for INSERT and UPDATE at the same time

  • Query data with ORDER BY, Logical operators, and filters

  • Understand PostgreSQL various data types with examples

  • Data type conversions with CAST, and conversion functions

  • Create your own user-defined data types

  • Explore table and column constraints, create multiple composite constraints, see data integrity operations

  • Create your own custom sequences

  • Parsing data with queries using string functions

  • Aggregate data with aggregate functions

  • Date/Time data types, Intervals, and handling timezones

  • Grouping Data with GROUP BY, conditional filter with HAVING

  • Joining Multiple Tables with various joins techniques

  • Combining Queries together with UNION, INTERSECT, and EXCEPT

  • Understand and create PostgreSQL Schemas, ownership, security privileges

  • Constructing arrays and ranges, query array data with conditional filters

  • Storing data with JSONB objects and Indexing

  • Query performance optimization with indexes, understanding indexes nodes and outputs

  • Create and update regular and materialize views

  • Simple to advances step-by-step Subqueries

  • Creating Common Table Expressions (CTEs), and recursive CTEs queries

  • Making data into group sets

  • Simple to advanced Windows Functions

  • Using regular expressions for text patterns

  • Powerful text searches in PostgreSQL

  • Create and exploring table partitioning techniques

  • Server programming with SQL and PL/pqSQL

  • Creating Stores Procedures

  • Extending PostgreSQL echosystem with custom indexes, and aggregate functions

  • Creating, and executing Triggers

  • Using Cursors

  • pqsql Utility Commands

  • Creating Crosstab reports

  • Making our database for storing global language data - Internationalization

  • Running queries with PostgreSQL transactions

  • Crating, and Managing PostgreSQL Security

  • All about PostgreSQL internals on how data gets stored and much more

  • Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

This comprehensive course will teach you everything about PostgreSQL to use in your next big project!

Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

Oracle 11g PL/SQL Fundamentals II

An introduction to the PL/SQL database programming language

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 1776, Price: $89.99

Students: 1776, Price:  Paid

The objective of this Oracle 11g training course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. The areas covered include 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).

Oracle Database 11g: Program with PL/SQL 4 Practice Tests

Oracle Database 11g: Program with PL/SQL(1Z0-144)

Created by Training Academy - Sources of information

"]

Students: 1584, Price: $19.99

Students: 1584, Price:  Paid

This practice test is designed to help you evaluate if you are ready to successfully complete the Oracle Database 11g: Program with PL/SQL | 1Z0-144 Certification exam.

Scenario based exam questions for Oracle Database 11g: Program with PL/SQL | 1Z0-144 Certification,

Online practice exam to be completed in Specified Time Duration.

Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam is related to Oracle Database 11g and Credits towards Oracle Advanced PL/SQL Developer Certified Professional and Oracle PL/SQL Developer Certified Associate. This exam validates the Candidates ability to Oracle Database 11g Procedural language, Structured Query Language PL/SQL fundamentals list the uses of variables declaring and initialized use bind variables, use built-in SQL functions in PL/SQL and sequences and PL/SQL expressions, describe when implicit and conversations take place and when explicit conversations have to be dealt with creating PL/SQL executable blocks using data manipulation language DML and Transaction Control Statements, declaring Control explicit cursor use simple loops and cursor for loops to fetch data lock rows with the for update clause and reference occurs in row with the Where current of clause. It also validates the ability to Oracle Database 11g like develop PL/SQL program units differentiate between anonymous blocks and subprograms manage persistent package data states for the life of a session and the warp utility. Senior Database Administrators, IT Directors, and IT Architects usually hold or pursue this certification and you can expect the same job role after completion of this certification

The Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam certification is an internationally-recognized validation that identifies persons who earn it as possessing skilled as an Oracle PL/SQL Developer Certified Associate. If a candidate wants significant improvement in career growth needs enhanced knowledge, skills, and talents. The Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam certification provides proof of this advanced knowledge and skill. If a candidate has knowledge of associated technologies and skills that are required to pass Oracle Database 11g: Program with PL/SQL 1Z0-144 Exam then he should take this exam.

The benefit in Obtaining the 1Z0-144 Exam Certification

Oracle Advanced PL/SQL Developer Certified Professional are distinguished among competitors. Oracle Advanced PL/SQL Developer Certified Professional certification can give them an edge at that time easily when candidates appear for a job interview employers seek to notify something which differentiates the individual to another.

Oracle Advanced PL/SQL Developer Certified Professional have more useful and relevant networks that help them in setting career goals for themselves. Oracle Advanced PL/SQL Developer Certified Professional networks provide them with the right career direction than non certified usually are unable to get.

Oracle Advanced PL/SQL Developer Certified Professional will be confident and stand different from others as their skills are more trained than non-certified professionals.

Oracle Advanced PL/SQL Developer Certified Professional have the knowledge to use the tools to complete the task efficiently and cost effectively than the other non-certified professionals lack in doing so.

Oracle Advanced PL/SQL Developer Certified Professional Certification provides practical experience to candidates from all the aspects to be a proficient worker in the organization.

Oracle Advanced PL/SQL Developer Certified Professional Certifications provide opportunities to get a job easily in which they are interested in instead of wasting years and ending without getting any experience.

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

The ultimate Oracle/database course bundle with over 20 hours and 100 videos!

Created by Intellezy Trainers - Computer Training Specialists

"]

Students: 1476, Price: $109.99

Students: 1476, Price:  Paid

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.

Learning PL/SQL – Truly Basic to Advanced The Example Way

Rapid PL/SQL interview preparation - PL/SQL Cursors, Procedures, Functions, Packages & Triggers - Object Oriented PL/SQL

Created by Prashant Munshi - Distinguished Database Analyst and Oracle Corporate Trainer

"]

Students: 352, Price: $99.99

Students: 352, Price:  Paid

*****************************************************************************

Added lecture PL/SQL Object Table & Row Object *** Section - Object Oriented PLSQL (09 Jan 2020)

*****************************************************************************

After a successful study in SQL, now you need to know the PL/SQL thoroughly to make make you a genuine back end programmer. Even if you are an acclaimed front-end programmer, with the study of SQL coupled with PL/SQL through this course you will become virtually invincible in the field as database analyst/programmer, DBA and trainer.

If you have already wasted your time and money in hunting for a complete yet concise course in PL/SQL through random youtube videos mostly offered by inexperienced people and not certified for their authenticity and quality - then you are at the right place here. This course brings step-by-step lessons in its logical series of videos to help you master the programming in PL/SQL. Moreover this same channel brings to you a complete course in SQL to make a one stop shop for all your database side learning.

This course has been brought by an highly experienced faculty who have had 20+ years of experience in working as Oracle developer and DBA out of which 6 years onside in USA and UK. The faculty has been working in Oracle field ranging from Oracle version 6 to the latest 19C.

Who this course is for?

  • Students seeking database side prestigious career as Programmer Analyst

  • Working professionals who are next targeting to become a DBA must know the SQL & PL/SQL thoroughly

  • All UG students from Engineering, Science and Commerce streams stepping into the field of Information Technology

  • Project analysts, analysts and designers

  • All those who have studied SQL must learn PL/SQL to make the circle complete

PL/SQL Interview Questions with Examples

Oracle PL/SQL Interview preparation with Examples Complete Guide

Created by Kish Sat - Senior Software Enginner/Data Architect/Project Manager

"]

Students: 306, Price: $19.99

Students: 306, Price:  Paid

Now days it is very common that you will be asked Oracle PLSQL and performance tunning questions at any Interviews for ETL developer or Database Developer or any other positions related to ETL jobs.

You can take this course weather you want to learn PLSQL quickly but practical way or you preparing for Interviews. This course covers all PLSQL topics along with examples using real time development tools like SQL Developer. I have created all these important topics very carefully and after several years of experience in Database field which will bring you lot of confidence.

This course mainly includes various questions asked during Interview for Oracle SQL and PL SQL related positions.

Each session explains the concept by providing explanation and examples.

Course includes all questions with explanation using real world practical examples.

Also it includes explanation for inbuilt Oracle supplied packages and the subprograms provided by them. You can get the good understanding of topics which are explained with number of examples.

Also Course includes some performance tuning concepts like EXPLAIN_PLAN, Oracle hints etc.

Topics Covered -

  • Basic Interview Questions: This will present 18 most frequently asked questions will answers and examples.
  • These questions covers most of the main topics in SQL and PLSQL.
  • DBMS_JOB: This presents the main subprograms provided by package DBMS_JOB with examples.
  • DBMS_RANDOM: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • DBMS_OUTPUT: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • UTL_FILE: This presents the main subprograms provided by package DBMS_RANDOM with examples.
  • DBMS_SQL: It will provide you with basic understanding of Dynamic SQL and describe some of the subprograms with examples.
  • DBMS_PIPE:
  • DBMS_UTILITY
  • DBMS_LOB
  • CURSORS: This
    details on the use of cursors, types with examples
  • BULK
    OPERATIONS: This
    is majorly an important topic if you are preparing for an interview. You may
    find detailed explanation with examples in tutorial.
  • MATERIALISED VIEWS
  • AUTONOMOUS TRANSACIONS: This
    is a good topic frequently asked during interviews. You can understand it well
    while going through tutorial
  • TRIGGERS: This
    details on the use of Trigger, its types with examples
  • Performance Tuning: Last but not least, we will cover -DBMS_PROFILER, EXPLAIN
    PLAN & ORACLE
    HINTS

Oracle Database For Beginners

Learn how to store, manipulate, query and process data in Oracle Database using SQL and PL/SQL

Created by Srikanth Pragada - Trainer and Director, Srikanth Technologies

"]

Students: 202, Price: $54.99

Students: 202, Price:  Paid

Learn how to use Oracle Database to store, manipulate and query data.  It takes you from fundamentals of databases to creating program units to implement business logic and rules using PL/SQL.

The following are major topics covered:

  • What is DBMS and RDBMS

  • How to get started with Oracle Database 18c XE and Oracle SQL Developer

  • How to use SQL to retrieve, manipulate and create data

  • How to group data using GROUP BY and HAVING clauses

  • How to use different types of joins to get data from multiple tables

  • How to use subquery and correlated subquery to write complex queries

  • What is a view, advantages of view and how to manipulate base table through view

  • What is index and how index improves performance

  • Implementing object-level security using object privileges

  • How to create and use regular expressions

  • Writing PL/SQL blocks to process data

  • Various control structures in PL/SQL

  • Handling exceptions

  • Explicit and Implicit cursors

  • Creating procedures and functions to implement business logic

  • Creating database triggers to implement business rules

  • Dynamic SQL and collections

Mastering PL/SQL

Simplified way to learn PL/SQL

Created by Parteek Bhatia - Professor, CSED, TIET, Patiala, India

"]

Students: 147, Price: $19.99

Students: 147, Price:  Paid

Do words like Cursor, Function, Procedure and Trigger sound confusing to you? Have you been looking for a course that teaches you all the basics of PL/SQL in a fun relaxed manner? If so then you are going to find this course absolutely perfect for you.

This course has been selected in the list of Top 2% courses by CourseMarks

There is a growing demand for database experts all over the world. And this course is intended to fill this gap. This course on PL/SQL has been specially designed to better equip the learners for their academic and professional career.

This course is aimed at beginners, and it will guide you on a wonderful journey to transform you from naïve to expert of PL/SQL. In this course, you'll learn the PL/SQL using Oracle, i.e., the most widely used Database Software in the world.

In this course you will learn how to use PL/SQL statements to implement business logic with the use of Cursors, Procedures, Functions and Triggers. All these concepts are covered through lot of examples to make the learning fun and exciting. The main strength of the course is explanation with the practical examples so that learners can grasp the contents easily.

Bonus: All those learners who will complete this course will get chance to register for another Online Udemy Course Simplified Approach to DBMS completely free.

Do not miss this opportunity. On completion just send your course completion certificate at parteek.bhatia@gmail.com and get coupon code for Simplified Approach to DBMS as token of appreciation from the instructor and continue embark your journey on mastering databases.

Overview of Course Contents:

Section-1: Basics of PL/SQL

· Introduction to PL/SQL

· Architecture of PL/SQL

· PL/SQL Language Elements

· Structure of PL/SQL Block

Section-2: Variables and Constants

· Variables in PL/SQL

· Select into Statement of PL/SQL

· Constants in PL/SQL

· Variable Attributes

Section-3: Conditional, Looping and Sequential Statements

· Conditional Statements

· Simple Loop

· While Loop

· For Loop

· Sequential Control

· Assignments and Its Solution

Section-4: Exception Handling

· Major strengths of this course is as follows:

· Types of Exceptions

· Handling of Predefined and Non-Predefined Oracle Server Errors

· Explicit Exceptions

· Error Trapping Functions

· Exceptions raised in Declare Section

· Propagation of Exceptions

· Re-raising of Exceptions

· Demonstrations

· Assignment and Its Solution

Section-5: Cursor Handling

· Concept of Cursor

· Implicit Cursor

· Explicit Cursor

· Demonstrations

· Cursor For Loop

· Cursor with Parameters

· Cursor Assignments and Its Solutions

Section-6: Sub-Programs, Functions and Procedures

· Sub Programs & Its Types

· Local Functions

· Stored Functions

· Demonstrations

· Local Procedures

· Stored Procedures

· Assignments & Its Solutions

Section 7: Trigger

· Concept of Trigger

· Uses and Applications of Trigger

· Types of Trigger

· Before Statement & Row Level Trigger

· After Statement & Row Level Trigger

· Syntax of Trigger

· Old and New Keywords

· Raising Application Errors

· Assignments & Its Solutions

Strengths of Course

· More than 9 Hours of Video Contents

· More than 70 Video Sessions

· Enough Reading Material to Brain Map the Concepts

· Quizzes after each section to check your progress

· Every Section has Assignments to have learning by doing pedagogy

· Excellent course to prepare for DBMS 

· Excellent way to become expert of PL/SQL before placement and Interviews

Oracle PL/SQL- A Complete Interview and Certification Course

Easy Preparation for Oracle PL/SQL Interviews and Certification Exams with Solved Questions and Answers with Explanation

Created by Niraj Gupta - Senior Technology Lead

"]

Students: 40, Price: $19.99

Students: 40, Price:  Paid

Welcome to the world of PL/SQL Knowledge!!!

This course will offer you all what you required to clear any PL/SQL Interview or to Grab PL/SQL Certification Exams.

The Course Includes:

70 Solved PL/SQL Questions and Answers

55 Solved Multi-Choice Questions and Answers for PL/SQL Certification Exam Preparation with explanation

Covering All PL/SQL Topics: Procedures, Functions, Triggers, Cursors, Packages, Exceptions etc.

Oracle Database SQL and PLSQL Basics

Oracle Database SQL and PLSQL Basics

Created by Sreeram ERPTech - Oracle E-Business /Oracle Cloud ERP Technical Consutlant

"]

Students: 28, Price: $89.99

Students: 28, Price:  Paid

The course is for the Oracle Database Developers - which is designed for beginner level.

Starting with SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER by For Data Extraction Purpose

INSERT, UPDATE, DELETE for DML Operations

CREATE, ALTER , DROP For DDL Operations

In Procedural Language For SQL - Starting with Variable Declaration, Loops, CURSORS, API's etc are covered

OCP 1z0-146 Oracle Database 11g Advanced PL/SQL exams

Pass the ORACLE 1z0-146 certification on the first attempt. 132 questions

Created by Coby Miller - Senior Oracle DBA - (OCE RAC, OCP), AWS RDS, Cassandra, SQL

"]

Students: 19, Price: $24.99

Students: 19, Price:  Paid

Exam Content:

  • PL/SQL designing best practices.

  • Create PL/SQL applications that use collections.

  • Implement a virtual private database with fine-grained access control.

  • Write code to interface with external C and Java applications.

  • Write code to interface with large objects and use SecureFile LOBs.

  • Write and tune PL/SQL code effectively to maximize performance.

Benefits to You

Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

*** This course does not content the study material. This course contains 132 questions ***

Oracle 1Z0-144 Database 11g Program PL/SQL Certification

Oracle 1Z0-144 Oracle Database 11g Program with PL/SQL Certification Practice Test PL/SQL Certification Practice Test

Created by Muhammad Ismail - Software Engineer Front End Web Developer

"]

Students: 7, Price: $49.99

Students: 7, Price:  Paid

Oracle 1Z0-144 Oracle Database 11g Program with PL/SQL Certification Practice Test

PL/SQL Certification Practice Test Examination of Oracle 1Z0-144 Oracle Developer

Oracle 1Z0-144 Oracle Database 11g Oracle Developer Program with PL/SQL Certification Pl/SQL Oracle 1Z0-144 Practice Test Oracle 1Z0-144 Oracle Database 11g Program with PL/SQL Certification Practice Test PL/SQL Certification Practice Test Oracle 1Z0-144 Oracle Developer and Oracle 1Z0-148 the Pl/SQL can find best information about how pass easy the Pl/SQL certification examination there is few tips can help you and the certification practice exam of help you and give you idea about the real examination of Oracle trend of the Oracle 1Z0-144 Pl/SQL Oracle 1Z0-144 Practice Test

Oracle 1Z0-144 Oracle Database 11g Program with PL/SQL Certification Practice Test

The Oracle Developer is the some basic of online education tips it can help you learn about Oracle 1Z0-144 Oracle Developer and Oracle 1Z0-148 the Pl/SQL can find best information about how pass easy the Pl/SQL certification examination there is few tips can help you and the certification practice exam of help you and give you idea about the real examination of Oracle trend of the Oracle 1Z0-144 Pl/SQL Oracle 1Z0-144 Practice Test

PL/SQL Certification Practice Test Examination of Oracle 1Z0-144 Oracle Developer

Oracle 1Z0-144 Oracle Developer and Oracle 1Z0-148 the Pl/SQL can find best information about how pass easy the Pl/SQL certification examination there is few tips can help you and the certification practice exam of help you and give you idea about the real examination of Oracle trend of the Oracle 1Z0-144 oracle 1Z0-144 the PL/SQL test online examination

Oracle 1Z0-144 Oracle Database 11g Oracle Developer Program with PL/SQL Certification Pl/SQL Oracle 1Z0-144 Practice Test

Oracle 1Z0-144 Oracle Developer and Oracle 1Z0-148 the Pl/SQL can find best information about how pass easy the Pl/SQL certification examination there is few tips can help you and the certification practice exam of help you and give you idea about the real examination of Oracle trend of the Oracle 1Z0-144 PL/SQL Certification Practice Test Examination of Oracle 1Z0-144 Oracle Developer