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"

June
2023
10
Sat
11
Sun
12
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231611
2,180 $
June
2023
14
Wed
15
Thu
16
Fri
One to One - Online
09:00-17:00 (EST)
AT7716V231651
2,180 $
June
2023
19
Mon
20
Tue
21
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231701
2,180 $
June
2023
24
Sat
25
Sun
26
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231751
2,180 $
June
2023
28
Wed
29
Thu
30
Fri
One to One - Online
09:00-17:00 (EST)
AT7716V231791
2,180 $
1,960 $
July
2023
3
Mon
4
Tue
5
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231841
2,180 $
1,960 $
July
2023
8
Sat
9
Sun
10
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231891
2,180 $
1,960 $
July
2023
12
Wed
13
Thu
14
Fri
One to One - Online
09:00-17:00 (EST)
AT7716V231931
2,180 $
1,960 $
July
2023
17
Mon
18
Tue
19
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231981
2,180 $
1,960 $
July
2023
22
Sat
23
Sun
24
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V232031
2,180 $
1,960 $
July
2023
26
Wed
27
Thu
28
Fri
One to One - Online
09:00-17:00 (EST)
AT7716V232071
2,180 $
1,960 $
31 July 2023 - 2 Aug
One to One - Online
09:00-17:00 (EST)
AT7716V232121
2,180 $
1,960 $
August
2023
5
Sat
6
Sun
7
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V232171
2,180 $
1,960 $
June
2023
10
Sat
11
Sun
12
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231611
2,180 $
June
2023
19
Mon
20
Tue
21
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231701
2,180 $
June
2023
24
Sat
25
Sun
26
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231751
2,180 $
July
2023
3
Mon
4
Tue
5
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231841
2,180 $
1,960 $
July
2023
8
Sat
9
Sun
10
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V231891
2,180 $
1,960 $
July
2023
17
Mon
18
Tue
19
Wed
One to One - Online
09:00-17:00 (EST)
AT7716V231981
2,180 $
1,960 $
July
2023
22
Sat
23
Sun
24
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V232031
2,180 $
1,960 $
31 July 2023 - 2 Aug
One to One - Online
09:00-17:00 (EST)
AT7716V232121
2,180 $
1,960 $
August
2023
5
Sat
6
Sun
7
Mon
One to One - Online
09:00-17:00 (EST)
AT7716V232171
2,180 $
1,960 $

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 1,960 $.

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

The tuition fee as a group is 1,970 $. To create a group, you must be at least  3 people.
The one-to-one tuition fee is 1,960 $.

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

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

Prefered Mode of Contact