Free

FREE (Fully SAAS Funded) Database Programming with PL/SQL course

Event Information

Share this event

Date and Time

Location

Location

IT Professional Training (ITPT)

SUITE 2-5

50 DARNLEY STREET

Glasgow

G41 2SE

United Kingdom

View Map

Event description

Description

This course is designed to provide the student with the necessary tools and skills required to attain following certifications:

  1. Oracle PL/SQL Developer Certified Associate Certification(OCA PL/SQL)
  2. 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


Ticket Description:

This ticket logs your interest to join this course.
To study this course free, ITPT requires all interested students to complete SAAS PTFG application and ITPT course registration form. Please contact us to book your appointment to enrol you in the course.

Note: This course is fully funded by SAAS part-time funding and only eligible students will be able to join this course for free, please see below for the eligibility. If you are not eligible to get the SAAS part-time funding please contact us to discuss other options.

To check your eligibility click on this link( Check your eligibility ).
To request for application forms contact us( itpt.co.uk/contact-us/ ) and write your message mentioning the Eventbrite's event.


Contact:

Phone: 0141 429 2922
Email: info@itpt.co.uk
website: www.itpt.co.uk

Share with friends

Date and Time

Location

IT Professional Training (ITPT)

SUITE 2-5

50 DARNLEY STREET

Glasgow

G41 2SE

United Kingdom

View Map

Save This Event

Event Saved