Oracle Training

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 course series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

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.

The PL/SQL programming language is at the core of most Oracle database applications. This training 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.

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.

This course builds upon the prerequisite introductory volume from the Oracle Database 12c: SQL Expert Series 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.

This 5-day course is designed for WebLogic 12c Administrators and Operations staff whose roles include: server installation, application deployment, resource configuration, monitoring, tuning or troubleshooting. No prior knowledge of WebLogic server is necessary. For students with exposure to earlier versions of WebLogic or other JEE application servers, some sections can be accelerated.

This 5-day course is designed for WebLogic 12c Administrators and Operations staff that have a basic understanding of core WebLogic administration tasks. This class builds on the foundation of the Oracle WebLogic 12c System Administration class. Students should already know how to install WebLogic server and create a domain. Students need a basic understanding of service configuration (JDBC, JMS and JNDI) and application deployment. Students should also understand the key concepts of WebLogic clustering.