| 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: 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:
|
| Oracle Database 12c: SQL Fundamentals I |
21.00 |
2.10 |
|
Description: Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This course introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform.
Since SQL is an industry standard language, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms, such as Microsoft SQL Server, IBM DB2, the open-source databases MySQL and PostgreSQL, and others.
This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
# of Days:
Setting:
|
| Oracle Database 12c: SQL Fundamentals II |
21.00 |
2.10 |
|
Description: This course builds upon the prerequisite introductory course Oracle Database 12c: SQL Fundamentals I and considers intermediate-level SQL topics such as writing database queries using the SQL-99 syntax and exploiting the power of built-in functions that extend the capabilities of SQL.
You will learn how to complete of an application schema definition by creating database objects such as relational views, sequences, synonyms, indexes and others to compliment the table definitions. The crucial topic of data integrity and how this is protected using declarative constraints is covered.
With this course we will also leave the idyllic realm of the learning environment and begin to explore such practical real-world considerations as database object security and database performance.
# of Days:
Setting:
|