Database Programming with PL/SQL course @ Glasgow

When:
July 23, 2018 @ 1:00 pm – 5:00 pm
2018-07-23T13:00:00+01:00
2018-07-23T17:00:00+01:00
Where:
McCormick House
50 Darnely Street Glasgow
G41 2SE

This course is designed to provide the student with the necessary tools and skills required to attain following certifications:
Oracle PL/SQL Developer Certified Associate Certification(OCA PL/SQL)
Oracle certified Associate – SQL Database Programmer(OCA SQL)

This program offers entry-level credential and designed to ensure the knowledge and proficiency to build database-centric Internet applications for Oracle by preparing student toward OCA SQL & PL/SQL

SQL:
SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.

PL/SQL:
PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.

You Will Learn How To:

Develop efficient PL/SQL programs to access Oracle databases
Create stored procedures and functions for maximum reuse and easy code maintenance
Design modular applications using packages
Manage data retrieval for front-end applications
Invoke native dynamic SQL to develop high-level abstract code
Improve performance with collections and bulk operations

Hands-On Experience Includes:

Encapsulating data manipulation statements in stored procedures
Performing complex data manipulation with explicit cursors
Leveraging EXCEPTIONs for graceful handling of runtime errors
Creating triggers to handle data integrity and derivation
Utilising weak and strong cursor variables for dynamic SQL

Prerequisites:
Required
Ease with using a computer
General knowledge of databases and query activity

Course Schedule:
Days per week: 1
No of weeks:16
Class timings: 01:00pm to 5:00pm

Contact:
Phone: 0141 429 2922
Email: [email protected]

April 25, 2018

COPYRIGHT © 15-17 IT PROFESSIONAL TRAINING LTD REGISTERED IN SCOTLAND UNDER REGISTRATION NUMBER SC423952. VAT REGISTRATION NO 137653694.

X