Managed Business & IT Training Solutions

MBIT Training Ltd

New Products

Free event - CompTIA Security+ primer

MBIT Training Ltd are pleased to offer a 'CompTIA Security+ primer'. This event features s...
£0.00 (GBP)

Implementing and Managing Windows 10 (20697-1 part of MCSA Windows 10)

This course provides students with the knowledge and skills required to install and config...
£1,950.00 (GBP)

Course: Supporting and Troubleshooting Windows 10 (10982)

This course is designed to provide students with the knowledge and skills required to supp...
£1,950.00 (GBP)

Introduction to Oracle 12c PL/SQL Programming

A Relational Database Management System (RDBMS) is a software system that allows you to cr...
£1,690.00 (GBP) £1,200.00 (GBP)

Oracle 11g Database Administration

This class will develop the key fundamental skills necessary to be an Oracle® DBA. Student...
£2,990.00 (GBP) £2,000.00 (GBP)

Microsoft Security Development Lifecycle (SDL)

The Security Development Lifecycle (SDL) is a software development process that helps deve...
£1,150.00 (GBP) £900.00 (GBP)

ITIL Foundation Certification - IT Service Management

The Information Technology Infrastructure Library (ITIL), is a set of detailed practices f...
£1,995.00 (GBP) £1,570.00 (GBP)

Course: Querying Microsoft SQL Server® 2014 (20461) part of MCSA SQL Server 2012 / 2014

This 5-day instructor led course provides students with the technical skills required to w...
£1,690.00 (GBP)

Course: Core Solutions of Skype for Business 2015 (20334 part of MCSE Communication)

This course provides students with the knowledge and skills that are required to plan, dep...
£1,790.00 (GBP)

Designing and Deploying Microsoft Exchange Server 2016 (20345-2 part of MCSE Messaging)

This course provides experienced Exchange Server administrators with the knowledge to desi...
£1,690.00 (GBP)

Administering Microsoft Exchange Server 2016 (20345-1 part of MCSE Messaging)

This 5-day instructor-led course teaches IT professionals how to administer and support Ex...
£1,690.00 (GBP)

Enabling and Managing Office 365 (20347 part of MCSA Office 365)

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professi...
£1,990.00 (GBP) £1,690.00 (GBP)

Course: Developing SQL Data Models (20768 part of MCSA SQL 2016 BI)

This three-day instructor-led course is aimed at database professionals who fulfil a Busin...
£1,950.00 (GBP) £995.00 (GBP)

Course: Implementing a SQL Data Warehouse (20767 part of MCSA SQL 2016 BI)

This 5-day instructor led course describes how to implement a data warehouse platform to s...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Administering a SQL Database Infrastructure (20764 part of MCSA SQL 2016 DA)

This five-day instructor-led course provides students who administer and maintain SQL Serv...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Provisioning SQL Databases (20765 part of MCSA SQL 2016 DA)

This five day course is designed to teach students how to provision SQL Server databases b...
£1,950.00 (GBP)

Course: Developing SQL Databases (20762 part of MCSA SQL 2016)

This four-day instructor-led course provides students with the knowledge and skills to dev...
£1,950.00 (GBP) £1,290.00 (GBP)

Course: Querying Microsoft SQL Server (20761 part of MCSA SQL 2016)

The main purpose of this 3 day instructor led course is to give students a good understan...
£1,950.00 (GBP) £995.00 (GBP)

Identity with Windows Server 2016 (20742 part of MCSA Windows Server 2016)

This five-day instructor-led course teaches IT Pros how to deploy and configure Active Dir...
£1,790.00 (GBP)

Networking with Windows Server 2016 (20741 part of MCSA Windows Server 2016)

This 5-day classroom-based course provides the fundamental networking skills required to d...
£1,790.00 (GBP)

Installation, Storage, and Compute with Windows Server 2016 (20740 part of MCSA Windows Server 2016)

This five-day course is designed primarily for IT professionals who have some experience w...
£1,790.00 (GBP)

MCSA: Windows Server 2012

MCSA: Windows Server 2012 certification qualifies you for a position as a network or compu...
£3,275.00 (GBP) £2,695.00 (GBP)

Course: Automating Administration with Windows PowerShell (10961)

In this five day course you will learn to execute and monitor scripts more efficiently thr...
£1,550.00 (GBP)

Course: Automating Administration with Windows PowerShell 2.0 (10325)

This course 'Automating Administration with Windows PowerShell 2.0' provides students with...
£1,550.00 (GBP)

Introduction to Oracle 12c PL/SQL Programming

A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle’s Procedural Language for SQL. It is Oracle’s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs. Oracle 12c focuses on Oracle’s cloud-based offerings with a new architecture – Plugable Databases (PDBs) – designed for rapid deployment and migration in a multi-tenant environment.
SKU: O12cPL
Manufacturer: Oracle
£1,690.00 (GBP)
£1,200.00 (GBP)

A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle’s Procedural Language for SQL. It is Oracle’s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs.

Oracle 12c focuses on Oracle’s cloud-based offerings with a new architecture – Plugable Databases (PDBs) – designed for rapid deployment and migration in a multi-tenant environment. This courseware is designed to teach both end-users and developers accessible but powerful SQL query and data manipulation (DML) skills, then teach critical programming and optimization techniques using advanced PL/SQL features.

Audience: Application developers and database administrators.

Prerequisites: A good working knowledge of Oracle 11g SQL features is required. Programming experience in a high-level language, such as COBOL™, Java™, or Perl is also required.

Course content:

1. Course Introduction

Course Objectives

Course Overview

Using the Workbook

Suggested References

Sample Database

2. Triggers

Beyond Declarative Integrity

Triggers

Types of Triggers

Trigger Sequencing

Row-Level Triggers

Trigger Predicates

Trigger Conditions

Using SEQUENCEs

Cascading Triggers and Mutating Tables

Generating an Error

Maintaining Triggers

3. PL/SQL Variables and Datatypes

Anonymous Blocks

Declaring Variables

Datatypes

Subtypes

Character Data

Dates and Timestamps

Date Intervals

Anchored Types

Assignment and Conversions

Selecting into a Variable

Returning into a Variable

4. PL/SQL Syntax and Logic

Conditional Statements – IF/THEN

Conditional Statements – CASE

Comments and Labels

Loops

WHILE and FOR Loops

SQL in PL/SQL

Local Procedures and Functions

5. Stored Procedures and Functions

Stored Subprograms

Creating a Stored Procedure

Procedure Calls and Parameters

Parameter Modes

Named Parameter Notation

Default Arguments

Creating a Stored Function

Stored Functions and SQL

Invoker’s Rights

6. Exception Handling

SQLCODE and SQLERRM

Exception Handlers

Nesting Blocks

Scope and Name Resolution

Declaring and Raising Named Exceptions

User-Defined Exceptions

7. Records, Collections, and UserDefined Types

Record Variables

Using the %ROWTYPE Attribute

User-Defined Object Types

VARRAY and Nested TABLE Collections

Using Nested TABLEs

Using VARRAYs

Collections in Database Tables

Associative Array Collections

Collection Methods

Iterating Through Collections

8. Cursors

Multi-Row Queries

Declaring and Opening Cursors

Fetching Rows

Closing Cursors

The Cursor FOR Loop

FOR UPDATE Cursors

Cursor Parameters

The Implicit (SQL) Cursor

9. Bulk Operations

Bulk Binding

BULK COLLECT Clause

FORALL Statement

FORALL Variations

Bulk Returns

Bulk Fetching with Cursors

10. Using Packages

Packages

Oracle-Supplied Packages

The DBMS_OUTPUT Package

The DBMS_UTILITY Package

The UTL_FILE Package

The DBMS_METADATA Package

XML Packages

Networking Packages

Other Supplied Packages

11. Creating Packages

Structure of a Package

The Package Interface and Implementation

Package Variables and Package State

Overloading Package Functions and Procedures

Forward Declarations

Strong REF CURSOR Variables

Weak REF CURSOR Variables

12. Working with LOBs

Large Object Types

Oracle Directories

LOB Locators

Internal LOBs

LOB Storage and SECUREFILEs

External LOBs

Temporary LOBs

The DBMS_LOB Package

13. Maintaining PL/SQL Code

Privileges for Stored Programs

Data Dictionary

PL/SQL Stored Program Compilation

Conditional Compilation

Compile-Time Warnings

The PL/SQL Execution Environment

Dependencies and Validation

Maintaining Stored Programs

Appendix A: Dynamic SQL

Generating SQL at Runtime

Native Dynamic SQL vs. DBMS_SQL Package

The EXECUTE IMMEDIATE Statement

Using Bind Variables

Multi-row Dynamic Queries

Bulk Operations with Dynamic SQL

Using DBMS_SQL

DBMS_SQL Subprograms

Appendix B:

PL/SQL Versions, Datatypes and Language Limits