• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

Oracle-Fundamentals-and-PL-SQL-for-beginners

The training is designed to cover the basic concept of writing PL/SQL Code to write professional PL/SQL code for complex business problems. The course also talks about writing optimized PL/SQL Code. The course is going to cover many real-time case studies in various scenarios. Implementing the PL/SQL code for business rules, Data Quality Checks, working in Enterprise Data Warehousing and data transformation rules.


Duration : 30 hours


Fee: 299


Job Trends

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

You will get recordings of each training session that you attended

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

Oracle Fundamentals and PL SQL for beginners Download  

Oracle Fundamentals and PL SQL for beginners

Course Overview

Brief Introduction to PL/SQL

  • What is PL/SQL

  • SQL Versus PL/SQL
  • PL/SQL Architecture
  • Advantages of PL/SQL

Working with a different type of Datatypes

  • Date, Time and Interval Types
  • Boolean Types
  • Characters, String and National Character Types
  • Number Types
  • LOB Types
  • Composite data types

Exception Handler

  • What is Exception Handling
  • How to Handle Exception
  • Structure of Exception Handling
  • Types of Exception Handling
  • SAVE Exception in Bulk Collect
  • PRAGMA init Exception

Cursors in PL/SQL

  • Why cursor is used
  • Declaring Cursors
  • Different Types of a cursor
  • Cursor Attributes
  • Sending parameter to a cursor
  • Different ways of using the cursor
  • Cursor Variable (Reference Cursor)
  • Advantage of using cursor variable over a normal cursor
  • Passing Cursor variable as the parameter
  • Restriction on Cursor Variables

Working with Procedures, Functions, and Packages

  • Basic of stored procedure
  • Basics of functions
  • Basics of packages
  • Advantage of using procedures, function, and packages
  • Passing cursor variables to procedures, function, and packages
  • Recompiling functions and stored procedures
  • Forward declaration
  • Declaring and using persistent global variables in packages
  • Creating table Function
  • Function overloading
  • Restrict Reference Pragma
  • Pinning packages in the SGA with dbms_shared_pool.keep

Overview of some advanced PL/SQL topics

  • Table Function
  • Pipelined table function
  • Error log tables
  • Hints in PL/SQL

Writing PL/SQL blocks using tools

  • PL/SQL Developers
  • Toad
  • SQL Plus
  • SQL Developers etc.

Control Structures

  • IF-THEN-ELSE Statement
  • Case Statement
  • GOTO Statement
  • NULL Statement

Working with Objects & Collection

  • Describing Object
  • Constructor method on objects
  • Nested Table
  • VARRAY
  • Associative Array
  • Collection Methods
  • Manipulate Collection
  • Distinguish between the different types of collections and when to use them

Dynamic SQL and PL/SQL

  • When to use
  • Declaring dynamic SQL and PL/SQL by using DBMS_SQL package
  • Declaring dynamic SQL and PL/SQL by using Execute Immediate
  • Using Dynamic SQL in the FORALL statement
  • A dynamic statement using binding variables
  • Advantage of using Dynamic SQL and PL/SQL

Debugging and Error tracking of PL/SQL code

  • Using Error log message tables
  • Using some built-in packages
  • Using tools like PL/SQL developers

Tuning of PL/SQL program

Language Fundamentals

  • identifiers
  • literals
  • Executable and Non Executable statement
  • Anonymous Block Structure
  • Nested Block
  • Named Block
  • PRAGMA
  • Scope & Visibility of variables

Different types of loops

  • Simple Loop
  • WHILE- Loop
  • FOR- Loop
  • Labels in Loop
  • Scope Rules
  • Exit Statement

Working with Records

  • Declaring Records
  • The benefit of using the record
  • Passing Values To and From Record
  • Comparing two records

Bulk processing of data using Bulk Collect

  • What is Bulk collect operation
  • How does it impact performance
  • Declaring BULK COLLECT operation with simple select statement
  • BULK COLLECT with cursors
  • BULK COLLECT using FORALL statement
  • Catching exception in Bulk collect using SAVE EXCEPTION

Working with Triggers.

  • Describe Triggers
  • Identify the Trigger Event Types and Body
  • Business Application Scenarios for Implementing Triggers
  • Create DML Triggers using the CREATE TRIGGER Statement
  • Identify the Trigger Event Types, Body, and Firing (Timing)
  • Differences between Statement Level Triggers and Row Level Triggers
  • Create Instead of and Disabled Triggers
  • How to Manage, Test and Remove Triggers?

 

 

 

Who should Learn Oracle Fundamentals and PL SQL for beginners?

Fresh Graduates

Prerequisite to learn Oracle Fundamentals and PL SQL for beginners

Both SQL and PL/SQL is easy to learn, However having some basic idea about RDBMS and basic idea about some programming language will be an advantage.

Delivery Methodology used to deliver the Oracle Fundamentals and PL SQL for beginners

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Oracle Fundamentals and PL SQL for beginners FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 786-629-6893 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?