Oracle® 11g, Basics of PL/SQL Language

The course is an introduction to the Oracle PL/SQL procedural language. The language version used in DBMS 11g is considered in this training.
Code: DB-018
Duration: 24 hours

Description

The course is an introduction to the Oracle® PL/SQL procedural language. The language version used in DBMS 11g is considered in this training.

The course focuses on the basics of the PL/SQL language and its structures, such as anonymous blocks, procedures and functions, as well as on specifics of their operation on the Oracle® 11g R2 database server. The training talks about various types of data (including composite types and collections), control statements, as well as the mechanism of exceptions triggering and exceptions handling in EXCEPTION block. Oracle® SQL Developer is used for developing.

Roadmap

Introduction
  • Description of PL/SQL
  • Capabilities of PL/SQL
  • Advantages of using PL/SQL
Declaring Variables
  • Anonymous PL/SQL block and its sections
  • Types of PL/SQL programming constructs
  • Defining and using PL/SQL variables
  • Declaring PL/SQL variables and constants
  • Executing PL/SQL block
Writing executable commands
  • The executable section of the block
  • Rules for nested blocks
  • Executing and testing PL/SQL block
  • Using coding conventions
Interaction with Oracle® Server
  • Features of SELECT-statement in PL/SQL block
  • Dynamic declaration of data types
  • Writing data manipulation statements (DML) in PL/SQL block
  • Transaction management in PL/SQL
  • Defining the output of DML statements
The use of control structures
  • Types of control structures
  • Using the IF statement
  • Expressions and CASE statement
  • Various types of loops
  • Controlling handling using nested loops and labels
  • Using logical tables
Working with composite data types
  • Creating user-defined PL/SQL records
  • Adding and updating tables using PL/SQL records. Associative arrays
Using Cursors
  • Differences between implicit and explicit cursor
  • Statements for handling explicit cursor
  • Explicit cursor attributes
  • FOR loop for the cursor
  • Cursors with parameters
  • Using FOR UPDATE in the definition of the cursor
  • Cursors with subqueries
Exception handling
  • Defining PL/SQL exceptions
  • Propagation of unhandled exceptions
  • Types of PL/SQL exception handlers
  • Interception of non-predefined exceptions
  • Exception propagation in nested blocks
  • Generation of custom PL/SQL error messages
Creating stored procedures and functions
  • Creating and calling a procedure
  • Getting information about procedures and deleting procedures
  • Creating and calling functions
  • Getting information about the functions and deleting functions
Working with packages
  • Package structure
  • Package design: header and body
  • Creating packages
  • Advantages of using packages
Using Triggers
  • The principle of operation
  • Types of triggers
  • Creating table level triggers

Objectives

  • Reading and analyzing PL/SQL code
  • Creating anonymous blocks and stored executable PL/SQL code blocks
  • Using the basic algorithmic constructions of the language

Target Audience

  • Database administrators
  • System administrators
  • Application developers
  • Testers


Trainer in Krakow Bucharest
Pavel Abdyushev Test Automation Consultant
Pavel is a highly experienced specialist in test automation. Currently he is a head of Luxoft automation group supporting one of Deutsche Bank projects. He developed easily extensible framework for automatic testing of the records system. He plays active role in testers’ community (http://it4business.ru). Pavel is co-author of the report “Using frameworks in automated functional testing” presented at SQA-II conference.
Cosmin Vacaroiu Software Development Consultant
Cosmin is a fullstack developer with over 11 years of experience in more than 10 major projects, mainly in the area of software enterprise applications but start-ups as well. He is currently working the financial industry with tehcnologies like Artificial Intelligence, Machine Learning, Python, ELK Stack,Angular, Ionic, ReactiveX, Spring Boot, Java 8, Google Cloud, Apache Airflow si SSL Certificates.

In his previous role he worked as a Software Architect (Spring) where he used Java, Spring, SOAP WebServices (JAX-WS, Spring WS), Spring REST, JPA, JMX, JMS, Solr, JavaScript, JQuery, Weblogic, Ehcache, AOP, JUnit, EasyMock, JSP, SQL, Maven, Logstash, ElasticSearch, Kibana

Cosmin is passionate about technologies and likes to understand how they were developed so that he can use them as efficiently as possible. He has 9 Oracle certifications ( DB and Java) and one Scrum Master certification.
Course is scheduled in: Krakow, Bucharest
12.02.2020 - 14.02.2020
Time: 09:00-17:00
City: Krakow
Duration: 24 hours
Language: English
Trainer
Pavel Abdyushev
Test Automation Consultant
€415
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
14.10.2019 - 21.10.2019
Time: 09:30-13:30
City: Bucharest
Duration: 24 hours
Language: Romanian
Trainer
Cosmin Vacaroiu
Software Development Consultant
€415
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €415
Krakow €415
Wroclaw €415

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Recommended Reading:

Oracle® Database Online Documentation 11g Release 2 (11.2) - http://docs.oracle.com/cd/E11882_01/index.htm

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.