| Course Name |
Hours |
CEUs |
Content |
| OR5480: Oracle SQL Optimization for Developers and DBAs |
21.00 |
2.10 |
|
Description: This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMSSTATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented.
Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures.
This course can be taught for any Oracle version.
# of Days:
Setting:
|
| Oracle Database 12c: Administration Workshop |
35.00 |
3.50 |
|
Description: The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
Learn To:
Manage an Oracle Database instance.
Configure the Oracle Network environment.
Create and manage storage structures.
Manage and move data.
Create and manage users.
Monitor the database and manage performance.
Create and manage Database as a Cloud Service database deployments.
# of Days:
Setting:
|
| Oracle Database 12c: PL/SQL I - Introduction |
14.00 |
1.40 |
|
Description: This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.
PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.
# of Days:
Setting:
|
| Oracle Database 12c: PL/SQL II - Intermediate: Develop Program Units |
21.00 |
2.10 |
|
Description: This course is intended for those who have already learned the basics of the Oracle PL/SQL database programming language and its syntax, and who are now ready to employ the language in the development of database applications. In particular, the focus of this course will be on the use of database-resident 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.
# of Days:
Setting:
|
| Oracle Database 12c: PL/SQL III - Advanced Programming Tuning |
35.00 |
3.50 |
|
Description: The PL/SQL programming language is at the core of most Oracle database applications. This course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. First, we will explore the advanced features of the language that allow powerful and adaptable database applications to be built. Next, we will discuss performance tuning techniques that allow these applications to run efficiently. Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats.
# of Days:
Setting:
|