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:

    • Ease with using a computer
    • General knowledge of databases and query activity

    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

    FEE

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

     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.


    I give my consent to IT Professional Training to get in touch with me using the details I have provided in this form for the purpose of my inquiry, updates and upcoming courses.

    Course Curriculum

    No curriculum found !

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 10 Days

    Request Call Back!









    I give my consent to IT Professional Training to get in touch with me using the details I have provided in this form for the purpose of my inquiry, updates and upcoming courses.

    Our Partners

    SAAS Bio Certification Certiport CompTIA Microsoft PearsonVUE SQA CIW Android ATC Authorized Training Center Logical operations Nextec Testing

    Facebook

    FREE Professional IT Certification Training @ ITPT EdinburghCompletely Free Funded IT Courses at ITPT EdinburghWould you like to start your career in IT?Would you like to get free training which prepares you getting certified to get a job in IT and computing field?Would you like to get hands on experience to gain experience in IT to qualify for jobs?If YES then please get in touch with us...Who are we?We are IT Training academy based in Edinburgh & Glasgow providing free funded training to individuals who like to secure their career in IT.We offer free funded training which is available from beginner to advance level.What courses we offer and what are the next available dates?Below is the list of some of the upcoming courses at our Edinburgh centre. All these courses will be delivered once a week. Check our website for all scheduled start dates.1. CISCO Certified Network Professional (CCNP) Routing & Switching:(All Modules: Routing, Switching & Troubleshooting)Recommended Knowledge: Student should have either attended CCNA R&S/ICND1 Course OR have either gained CCNA or CCENT qualification.Starting date: 10th November 2018Classes: One day a week – Every Saturday 09:30 - 16:30 HrsNo of weeks: 202. CompTIA A+(Gateway to IT - IT Technician Course)(Beginner's Level Course) A. Start Date: 12 December 2018Classes per week: 1 day a weekClasses timings: 13:30 - 17:00Day(s) of the week: Wednesday (only)Duration of the course: 18 weeksB.Start Date: 16 January 2019Classes per week: 1 day a weekClasses timings: 09:00 - 12:30Day(s) of the week: Wednesday (only)Duration of the course: 18 weeksC.Start Date: 03 February 2019Classes per week: 1 day a weekClasses timings: 13:30 - 17:00Day(s) of the week: Sunday (only)Duration of the course: 18 weeksD.Start Date: 10 March 2019Classes per week: 1 day a weekClasses timings: 09:00 - 12:30Day(s) of the week: Sunday (only)Duration of the course: 18 weeks3. Database Programming with PL/SQL (OCA SQL & PLSQL)Days per week: 1No of weeks:18Class timings: 01:00pm to 05:00pmStart Date: Saturday 19 January 2018Day of Classes: Saturday4. Word Press(Website Development Course)(No Coding Experience Required)Starting date: 02 Dec 2018Classes: One day a week – Every Sunday 09:00 - 12:00 HrsNo of weeks: 165. JAVA SE 8 Level 1 – Associate(OCA)Days per week: 1No of weeks:16Class timings: 01:00pm to 05:00pmStart Date: 02 Dec 2018Day of Classes: Sunday 6. Microsoft Office Specialist 2013(Word 2013, Excel 2013, Powerpoint 2013, Access 2013)Starting date: 26th January 2018Classes: One day a week – Every Saturday 13:00 - 17:00 HrsNo of weeks: 16-207. CISCO Certified Network Associate (CCNA) Routing & Switching(IT Support Technician/Network Engineer Course)(ICND1 + ICND2)A.Starting date: 15 January 2019Classes: One day a week – Every Tuesday 09:30 - 16:30 HrsNo of weeks: 16B.Starting date: 16 February 2018Classes: One day a week – Every Saturday 13:00 - 17:00 HrsNo of weeks: 188. CISCO Certified Network Associate (CCNA) Security: Recommended Knowledge: Student should have either attended CCNA R&S/ICND1 Course OR have either gained CCNA or CCENT qualification.Starting date: 16 February 2019Classes: One day a week – Every Saturday 09:00 - 12:30 HrsNo of weeks: 169. Microsoft Server 2012 – MCSA 2012(Server Engineer/2nd line/IT Support/Infrastructure)Modules included:70-410 = MCP: Installing & Configuring Windows Server 201270-411 = Administering Windows Server 201270-412 = Configuring Advanced Windows Server 2012 ServicesStudents can enrol towards all OR individual modulesStarting Date: 28th April 2019Classes: One day a week – Every Sunday 09:30 - 16:30 HrsNo of weeks: 8-9 weeks for an individual ; (upto) 26 weeks for all ModulesAnd many more free fully funded IT courses can be found on our website...Who is eligible for the free funded course?This course is funded by SAAS and in general individuals who are unemployed or having income less than £25,000 are eligible. Contact us to get more details.How to apply?Best way to apply and register for this course is by booking an appointment at our centre for course registration. To enrol in any course please reply to this ad with a preferred date and time and we’ll book you in for an enrolment appointment.The appointment can also be booked for course consultancy only, this helps the applicants to discuss and explore more regarding the courses with help of course advisor.All upcoming course starting dates can be found on our Website.IT Professional Training62 West Harbour RoadEdinburghEH5 1PW ... See MoreSee Less

    View on Facebook

    *=ITPT Glasgow Brings Weekend Special Courses=*On a high demand of the weekend courses at our Glasgow centre. We have brought Saturday and Sunday Courses. All of these courses are part-time, FREE (Fully SAAS funded) and once a week.=CompTIA A+(Gateway to IT)The CompTIA A+ course provides necessary competencies for an entry-level IT professional with the equivalent knowledge of at least 12 months of hands-on experience in the lab or field.Starting: Saturday 4th November 2018Timings: 9:00 am - 1:30pm for 20 weeks=CISCO's CCNA R&SCisco Certified Network Associate (CCNA) Routing and Switching teach networking based on technology. It covers protocols and theory at deeper levels to help students succeed in networking-related degree programs and a range of professions. Starting: Saturday 1st December 2018Timings: 9:30 am - 4:30pm for 16 weeks=Oracle's SQL & PL/SQLThe course is designed for those students interested in both designing databases and then implementing them to a professional standard using Oracle 11g Server.This course is designed to provide the student with the necessary tools and skills required to attain the 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/SQLStarting: Sunday 20th January 2019Timings: 1:30 pm - 5:00pm for 20 weeksFor more details about a specific course please contact us.Phone: 0141 429 2922Email: info@itpt.co.ukWebsite: www.itpt.co.uk ... See MoreSee Less

    View on Facebook

    We have following existing new Part-Time courses starting soon in Glasgow. CISCO's CCNA Security:Start Date : Saturday 25th August 2018Time : 1:30pm to 5:00pmDay : Every Saturday for 16 weeks.Prerequisites : To join this course, individual must have completed a CCNA Routing & Switching training or IT Security relevant work experience, suggested by Cisco.Oracle Java SE8 LEVEL 1 -Associate Course:Start Date : Monday 17th September 2018Time : 9:00am to 1:00pmDay : Every Monday for 16 weeksPrerequisites : No Entry Requirement and no prior programming skills required to go into Level I certificationDatabase Design & Programming with SQL & PL/SQL Course:Start Date : Monday 3rd August 2018Time : 2:00pm to 5:00pmDay : Every Monday for 16 weeks.Prerequisites : Ease with using a computer and general knowledge of databases and query activity.CompTIA A+ (Gateway to IT):Start Date : Tuesday 4th September 2018Time : 9:00am to 1:00pmDay : Every Tuesday for 16 weeks.Prerequisites : Basic Computer understanding- No prerequisite set up by CompTIA.CCNA Routing & Switching:Start Date : Friday 5th October 2018Time : 9:00am to 1:00pmDay : Every Friday for 16 weeks.Prerequisites : Basic Networking KnowledgeFor a complete list of all our upcoming courses please visit: www.itpt.co.uk/course-scheduleIf you would like to make an appointment to discuss this face-to-face with a course advisor or to enrol in any course please reply to this ad with a preferred date and time and we’ll book you in for an enrolment appointment. ... See MoreSee Less

    View on Facebook

    Upcoming Courses

    Dec
    19
    Wed
    11:30 am CompTIA A + (IT Essential- Gatew... @ ITPT Edinburgh (62 West Harbour Road)
    CompTIA A + (IT Essential- Gatew... @ ITPT Edinburgh (62 West Harbour Road)
    Dec 19 @ 11:30 am – 5:00 pm
    Course Introduction: The CompTIA A+ certificate is widely recognized and prepares the individual to enter the market as PC Technician. The CompTIA A+ certification is the industry standard for validating[...]
    Jan
    12
    Sat
    9:30 am CISCO Certified Network Professi...
    CISCO Certified Network Professi...
    Jan 12 @ 9:30 am – 4:30 pm
    [Book Appintment Now] Course Description: CCNP Routing: This course covers routing protocols and related technologies at the professional level. The backbone of the course is focused on EIGRP, OSPF, BGP,[...]
    Jan
    15
    Tue
    9:30 am CCNA Routing & Switching V3 Cour... @ ITPT Edinburgh (62 West Harbour Road)
    CCNA Routing & Switching V3 Cour... @ ITPT Edinburgh (62 West Harbour Road)
    Jan 15 @ 9:30 am – 4:30 pm
    Introduction Cisco Certified Network Associate (CCNA) Routing and Switching is a certification program for entry-level network engineers that helps maximize your investment in foundational networking knowledge and increase the value[...]
    Jan
    16
    Wed
    11:30 am CompTIA A + (IT Essential- Gatew... @ ITPT Edinburgh (62 West Harbour Road)
    CompTIA A + (IT Essential- Gatew... @ ITPT Edinburgh (62 West Harbour Road)
    Jan 16 @ 11:30 am – 5:00 pm
    Course Introduction The CompTIA A+ certificate is widely recognized and prepares the individual to enter the market as PC Technician. The CompTIA A+ certification is the industry standard for validating[...]
    Jan
    19
    Sat
    9:00 am Free Funded – Database Design & ...
    Free Funded – Database Design & ...
    Jan 19 @ 9:00 am – 1:00 pm
    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[...]
    Jan
    20
    Sun
    1:30 pm Free Fully Funded – Database Des...
    Free Fully Funded – Database Des...
    Jan 20 @ 1:30 pm – 5:00 pm
    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[...]

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

    X