Introduction To Oracle PL/SQL Programming

Duration: 3 Days


This course is aimed at application developers and database administrators. Delegates to the course will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will also learn programming, management and some of the security issues associated with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. The course is applicable to Oracle 9i, Oracle 10g and Oracle 11g users.


A solid understanding of SQL and 3GL programming is required. It is recommended that students have reasonable understanding of Oracle 10g SQL features.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Installing and Configuring SQL Server

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation
  • Configuration Manager
  • Management Studio Server Properties
  • sp_configure

Managing Databases and Files

  • Planning Databases
  • Creating Databases
  • File groups and Data Files
  • Transaction Log Files
  • Managing Databases
  • Options
  • Attaching and detaching

Disaster Recovery

  • Planning a Backup Strategy
  • Backing Up User & System Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Databases and Disaster Recovery

Managing Security

  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Protecting the Server Scope
  • Auditing Security

Establishing Client Connectivity

  • Network Libraries
  • ODBC & OLE-DB connections
  • SQL Native Client
  • Configuring Server Connectivity Settings

Automating Administrative Tasks

  • Automating Administrative Tasks in SQL Server
  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent security

Monitoring SQL Server

  • Viewing Current Activity
  • Using SQL Server Profiler

An Introduction To Troubleshooting and Performance Tuning

  • Troubleshooting SQL Server
  • Performance Tuning in SQL Server

An Overview of Other Services

  • An Overview of Replication Service
  • An Overview of High Availability Services
  • An Overview of Integration Services
  • An Overview of Service Broker
  • An Overview of Common Language Runtime

Live Chat

Course Dates

Location: just outside London

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Related Courses

"I have nearly thirty years experience as an information systems manager and I cannot recall meeting a trainer with the combination of teaching skill and subject knowledge that you displayed over the last two days. I am self employed and so time spent on a course is time spent not earning. This was worth the money and my time!"

Trinitas Consulting

"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "

Paresh Dudhaiya

"Staff were helpful and the course was relevant to my needs. A great course!"


© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy