Database Programming with PL/SQL

The course is designed for those students interested in both designing databases and then implementing them to a professional standard using Oracle 11g Server.






0 STUDENTS ENROLLED

    Database Programming with PL/SQL

    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:

    Oracle Certified Exam

    • Oracle Certified Associate Database Administrator (OCA DA) – Part 1 =>1z0-051
    • Oracle Certified Associate – SQL (OCA SQL) => 1z0-071
    • Oracle Certified Associate – PL/SQL (OCA SQL) => 1z0-071 & 1z0-0144

     

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

    Module

    Title

    1Retrieving Data Using the SQL SELECT Statement
    2Restricting and Sorting Data
    3Using Single-Row Functions to Customize Output
    4Using Conversion Functions and Conditional Expressions
    5Reporting Aggregated Data Using the Group Functions
    6Displaying Data from Multiple Tables Using Joins
    7Using Subqueries to Solve Queries
    8Using the Set Operators
    9Manipulating Data
    10Using DDL Statements

    to Create and Manage Tables

    11Creating Other Schema Objects
    12Practices and Solutions

     

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

    Module

    Title

    1Introduction to PL/SQL
    2Declaring PL/SQL Variables
    3Writing Executable Statements
    4Interacting with Oracle Database Server: SQL Statements in PL/SQL Programs
    5Writing Control Structures
    6Introduction to PL/SQL
    7Working with Composite Data Types
    8Using Explicit Cursors
    9Creating Procedures
    10Creating Functions
    11Creating Packages
    12Working with Packages
    13Using Oracle-Supplied Packages in Application
    14Development Using Dynamic SQL
    15Design Considerations for PL/SQL Code
    16Creating Triggers
    17Creating Compound, DDL, and Event Database

    Triggers

     

    Funding Available:

    This course is FREE (SAAS part-time funding) to anyone who is on benefits or earning £25,000 or less, given that they have not used SAAS/ILA funding towards any other course/training in the last 12 months.

    Those in receipt of following benefits are automatically eligible:

    • Jobseekers allowance
    • Income support
    • Incapacity Benefit/Employment Support Allowance
    • Child Tax Credit (minimum rate)
    • Pension Credit

    Apply for course funding 

    Our Courses are fully funded by SAAS: Student Awards Agency for Scotland

    Please visit the SAAS website www.saas.gov.uk to see your eligibility.

    Download: SAAS Part Time Funding Guide, Part Time Forms

    Read: Part Time Students Eligibility Criteria, Disabled students’ allowance (DSA)


    For Students who don’t qualify for the above fundings:

    How much this course will cost?

    If for any reason you do not qualify for SAAS funding our fees are as follows for students living  in UK or the European Union:

    Database Programming

    2016-17

    Vender Neutral (can be paid in instalments) £600+ VAT
    SQA Accredited (PDA) (can be paid in instalments) £600

     Fees are payable in advance at the start of course unless otherwise agreed.

    We also provide flexible fee instalments to help students in paying their fee.

    There are a number of other funding opportunities available to UK and EU students to help them to pay for their studies. Contact the college for more details.


    Course Reviews

    No Reviews found for this course.

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