fbpx
  • Login
  • No products in the cart.

Database design & Programing in SQL/PL – ELearning/online Distance Learning

When:
October 31, 2020 all-day Europe/London Timezone
2020-10-31T00:00:00+00:00
2020-11-01T00:00:00+00:00

Course Introduction
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 in 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.

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

Course Description
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 towards OCA SQL & PL/SQL.

Prerequisites
Basic Database Knowledge or spreadsheet knowledge required

Course Objectives

1. Oracle certified Associate – SQL Database Programmer (OCA SQL)

* Retrieving Data Using the SQL SELECT Statement
* Restricting and Sorting Data
* Using Single-Row Functions to Customize Output
* Using Conversion Functions and Conditional Expressions
* Reporting Aggregated Data Using the Group Functions
* Displaying Data from Multiple Tables Using Joins
* Using Subqueries to Solve Queries
* Using the Set Operators
* Manipulating Data
* Using DDL Statements
* to Create and Manage Tables
* Creating Other Schema Objects
* Practices and Solutions

2. Oracle PL/SQL Developer Certified Associate Certification (OCA PL/SQL)

* Introduction to PL/SQL
* Declaring PL/SQL Variables
* Writing Executable Statements
* Interacting with Oracle Database Server: SQL Statements in PL/SQL Programs
* Writing Control Structures
* Introduction to PL/SQL
* Working with Composite Data Types
* Using Explicit Cursors
* Creating Procedures
* Creating Functions
* Creating Packages
* Working with Packages
* Using Oracle-Supplied Packages in Application
* Development Using Dynamic SQL
* Design Considerations for PL/SQL Code
* Creating Triggers
* Creating Compound, DDL, and Event Database
* Triggers

Mode of Learning:
ELearning/Online Distance Learning

What we will be providing?
1. Online integrated course materials
2. Assisted by Tutor
3. Moodle Access
4. Office 365 1TB of space for the course work

SAAS Course Funding:
This course is funded by SAAS part time fee agency which is available to eligible individuals only:
SAAS General funding eligibility requirement:
1. You have to be a resident of Scotland
2. Either employed and earning less than 25k a year or can be unemployed as well
3. Have not used the SAAS funding in this Academic Year.

For more information on this, please visit the following link:
https://www.saas.gov.uk/_forms/funding_guide.pdf

To check your funding eligibility:
Please follow the below link to check your course funding eligibility.

Check your SAAS part-time funding eligibility

How to apply?
Please post your application forms along with the required supporting documents at the following address:

IT Professional Training (ITPT) – Edinburgh Centre
62 West Harbour Road,
Granton,
Edinburgh
EH5 1PW

IT Professional Training (ITPT) – Glasgow Centre
McCormick House,
50 Darnley Street,
Pollokshields,
Glasgow,
G41 2SE

Contact us:

If you have any questions in regards to the above than please ask. Our Edinburgh office is open Monday to Saturday, 9:00am to 5:00pm.

Edinburgh: 0131 552 5558 – 552 5800
Glasgow: 0141 429 2922
Email: info@itpt.co.uk
Website: https://www.itpt.co.uk/all-courses/

Please follow and like us:
October 22, 2020
COPYRIGHT © IT PROFESSIONAL TRAINING LTD REGISTERED IN SCOTLAND UNDER REGISTRATION NUMBER SC423952. VAT REGISTRATION NO 137653694.
PearsonVUE testing at ITPT has reopened from 28th May 2020. Please bring a facemask and wear it while at our testing center.
HNC/HND classes will continue virtually and instructors will be in touch for assessments.
Part-time classes will still continue virtually, with exception to the courses where hands-on is necessary.
Please visit our eLearning course section to study online with us. You will get the instructor's support and all the learning materials.
Read our Covid - 19 notice here
close