This Oracle Database 12c: PL/SQL II - Intermediate: Develop Program Units students will apply the basics of the Oracle PL/SQL database programming language and its syntax, and employ the language in the development of database applications. In particular, the focus will be on the use of databaseresident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.

  Training schedule for "Oracle Database 12c: SQL II – Intermediate Course"

April
2024
15
Mon
16
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241061
2,400 $
April
2024
20
Sat
21
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241111
2,400 $
April
2024
24
Wed
25
Thu
One to One - Online
09:00-17:00 (EST)
AT7716V241151
2,400 $
29 April 2024 - 1 May
One to One - Online
09:00-17:00 (EST)
AT7716V241201
2,400 $
May
2024
4
Sat
5
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241251
2,400 $
May
2024
8
Wed
9
Thu
One to One - Online
09:00-17:00 (EST)
AT7716V241291
2,400 $
2,160 $
Early bird discount
May
2024
13
Mon
14
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241341
2,400 $
2,160 $
Early bird discount
May
2024
18
Sat
19
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241391
2,400 $
2,160 $
Early bird discount
May
2024
22
Wed
23
Thu
One to One - Online
09:00-17:00 (EST)
AT7716V241431
2,400 $
2,160 $
Early bird discount
May
2024
27
Mon
28
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241481
2,400 $
2,160 $
Early bird discount
June
2024
1
Sat
2
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241531
2,400 $
2,160 $
Early bird discount
June
2024
5
Wed
6
Thu
One to One - Online
09:00-17:00 (EST)
AT7716V241571
2,400 $
2,160 $
Early bird discount
June
2024
10
Mon
11
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241621
2,400 $
2,160 $
Early bird discount
April
2024
15
Mon
16
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241061
2,400 $
April
2024
20
Sat
21
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241111
2,400 $
29 April 2024 - 1 May
One to One - Online
09:00-17:00 (EST)
AT7716V241201
2,400 $
May
2024
4
Sat
5
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241251
2,400 $
May
2024
13
Mon
14
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241341
2,400 $
2,160 $
Early bird discount
May
2024
18
Sat
19
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241391
2,400 $
2,160 $
Early bird discount
May
2024
27
Mon
28
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241481
2,400 $
2,160 $
Early bird discount
June
2024
1
Sat
2
Sun
One to One - Online
09:00-17:00 (EST)
AT7716V241531
2,400 $
2,160 $
Early bird discount
June
2024
10
Mon
11
Tue
One to One - Online
09:00-17:00 (EST)
AT7716V241621
2,400 $
2,160 $
Early bird discount

Who Should Attend

  • Application designers and database developers
  • Database administrators
  • Web server administrators

Course Content

  • Introducing Database-Resident Program Units
  • Executing Stored Procedures & Functions
  • Maintaining Stored Program Units
  • Managing Dependencies
  • Creating & Maintaining Packages
  • Advanced Package Capabilities
  • Creating Stored Procedures & Functions
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Database Trigger Concepts
  • Creating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Event Triggers

Frequently Asked Questions

"Oracle Database 12c: SQL II – Intermediate Course" trainings are given in ("Group - One to one") two different  ways.
The one-to-one tuition fee is 2,160 $.

"Oracle Database 12c: SQL II – Intermediate Course" trainings are given in two different ways.

The tuition fee as a group is 2,180 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 2,160 $.

Our "Oracle Database 12c: SQL II – Intermediate Course" trainings are one-to-one 3 days,

Our "Oracle Database 12c: SQL II – Intermediate Course" trainings are group 2 days,
 

 

Exam & Certification

Participation Certificate

All trainees who participate in training will have an AcademyTech participation certificate.

Exam & Certification

Popular locations for Oracle Database 12c: SQL II – Intermediate Course in United States

Request more information for
"Oracle Database 12c: SQL II – Intermediate Course"

Prefered Mode of Contact