Oracle

by Computeraid Ltd Claim Listing

The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.  

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Computeraid Ltd Logo

img Duration

3 Days

Course Details

The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language. Gain practical hands-on experience by completing guided exercises and examples throughout the course.

 

Oracle PL/SQL – Course Contents

  • Writing and running PL/SQL programs from SQL*Plus or SQL Developer
  • Declaring and using variables and constants
  • Assigning and manipulating values
  • Using SQL statements within PL/SQL
  • Implementing conditional execution and loop constructs
  • Declaring and using cursors with and without parameters
  • Updating data with cursors
  • Trapping and handling errors and exceptions in code
  • Implementing nested and labelled loops and blocks
  • Raising exceptions
  • Handling PL/SQL records and tables
  • Using PL/SQL table built-in functions
  • Swansea Branch

    4th Floor, 11 Wind Street, Swansea

Check out more Oracle courses in UK

Wise Owl Education Logo

Introduction To SQL

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.

by Wise Owl Education [Claim Listing ]
Seer Computing Limited Logo

Essential MySQL 8 Training Course

Make no mistake although MySQL is free to download and is a relatively simple Database to keep running it is a powerful tool for storing and accessing information, experienced Users of Oracle SQL or Microsoft will see similarities with their software, however MySQL stands on its own as a legitimate

by Seer Computing Limited [Claim Listing ]
Stay Ahead Logo

Oracle Database 19c Essential Administration

The Oracle Database 19c Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 19c database.

by Stay Ahead [Claim Listing ]
London IT Training (LIT) Logo

MTA Database Fundamentals SQL Certification Training

The Microsoft Technology Associate (MTA): Database Fundamentals SQL Certification is a go-to option for those looking for a SQL Server certification for beginners.

by London IT Training (LIT)
London IT Training (LIT) Logo

Oracle Certified Professional (Mysql 8. 0 Database Administrator Training)

Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL.

by London IT Training (LIT)

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy