Oracle® 11g, Basics of PL/SQL Language | | Software Development
Oracle® 11g, Basics of PL/SQL Language
Duration
24 hours
Location
Online
Language
English
Code
DB-018
13.10.2023 - 20.10.2023
600.00 *
Training for 7-8 or more people? Customize trainings for your specific needs
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.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
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
Roadmap
a:2:{s:4:"TEXT";s:2885:"Introduction
- Description of PL/SQL
- Capabilities of PL/SQL
- Advantages of using PL/SQL
- 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
- The executable section of the block
- Rules for nested blocks
- Executing and testing PL/SQL block
- Using coding conventions
- 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
- 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
- Creating user-defined PL/SQL records
- Adding and updating tables using PL/SQL records. Associative arrays
- 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
- 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 and calling a procedure
- Getting information about procedures and deleting procedures
- Creating and calling functions
- Getting information about the functions and deleting functions
- Package structure
- Package design: header and body
- Creating packages
- Advantages of using packages
- The principle of operation
- Types of triggers
- Creating table level triggers
Schedule and prices
View:
13.10.2023 -
20.10.2023
10:00-14:00
Location:Online
Duration:24 hours
Language:English
Time:10:00-14:00
Timezone:UTC +2
Trainer:
Malakshinov Bair
Trainer
Malakshinov Bair
600.00
Trainers
Malakshinov Bair
Oracle PL/SQL Developer & Consultant
Bair is an expert in Oracle database design and development, having spent more than 10 years in the IT industry, nine of them working with Oracle Database. He has strong PL/SQL and SQL development skills, system analyst experience and data architecture abilities. As well as expertise in OLTP systems (telecom, investment banking, financial), ETL processes, data warehouse, database design and performance tuning.
His current project involves design database, PL/SQL development, performance tuning and optimization responsibilities. Bair is an Oracle Database PL/SQL Developer Certified Professional and Oracle Database SQL Certified Associate. For Luxoft Training he delivers courses on various Oracle subjects.
His technology experience includes:
Bair is an expert in Oracle database design and development, having spent more than 10 years in the IT industry, nine of them working with Oracle Database. He has strong PL/SQL and SQL development skills, system analyst experience and data architecture abilities. As well as expertise in OLTP systems (telecom, investment banking, financial), ETL processes, data warehouse, database design and performance tuning.
His current project involves design database, PL/SQL development, performance tuning and optimization responsibilities. Bair is an Oracle Database PL/SQL Developer Certified Professional and Oracle Database SQL Certified Associate. For Luxoft Training he delivers courses on various Oracle subjects.
His technology experience includes:
- Databases: Oracle 10g/11g/12c, MySQL, MS Access, MS SQL Server
- Languages: PL/SQL, SQL, Java, Delphi, PHP, Perl, Python
- Banking: TSYS PRIME software, New Athene Banking system, CVA/XVA calculations
- Billing software: CBoss
- Tools: PL/SQL Developer, Eclipse, GIT, SVN, JIRA, Redmine, TortoiseSVN, SQL*Plus, SQL Loader, TOAD, TeamCity, JIRA, Confluence, ServiceNow
- Operating systems: Windows (2000 and upper), Solaris, Linux, FreeBSD, UNIX
Courses you may be interested in
Basics of .NET Development and C# Language
The course covers specifics of Microsoft .NET 4.0, program structure, syntax of C# 4.0 language, as well as development skills in Visual Studio® 2010.
Project Estimation: Size, Efforts and Duration
During the training we will discuss the process of estimating software development projects and all related activities - problems and errors. Based on Luxoft's experience in various projects we will discuss techniques for estimating project size, efforts and duration, the main challenges of estimation and the role of metrics in estimation.
