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

ALX Logo

MS SQL Server For Programmers

The course provides students with knowledge and skills to create, manage and programmatically control database on MS SQL Server platform. Basing on relational database theory students get to know Transact SQL (T-SQL) language.

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

Mysql 8. 0 Database Developer Oracle Certified Professional

MySQL 8.0 Database Developer Oracle Certified Professional course is offered by Oracle that evaluates your capacity to design both the Web and Console Application using MySQL, including other high-level Programming Languages.

by London IT Training (LIT)
Learning Tree Logo

SQL Server Database Administration

Help protect your organization by using the knowledge gained in this course to correctly manage business databases. With this training, you learn the essential skills for administering SQL Server databases, and gain extensive experience using SQL Server tools to perform real-world administrative ta...

by Learning Tree [Claim Listing ]
Pitman Training Logo

Database Fundamentals

In this course, you’ll learn the core concepts of relational databases, and you’ll get your feet wet with structured query language (SQL), which is used to manage data in a relational database management system.

by Pitman Training [Claim Listing ]
Insight Logo

Microsoft SQL Fundamentals Of Querying

You will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.

by Insight [Claim Listing ]

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