The objective of this training course is to deal with advanced topics and techniques pertaining to the SQL database language based upon the latest features available with the Oracle release.
Both beginners and experienced professionals in other implementations of the industry standard SQL language will benefit from the advanced and Oracle-specific features of SQL that will be discussed.
The objective of this training course is to provide an in-depth understanding of the architecture of the Oracle Enterprise Manager 12c Cloud Control platform. It guides one through a step-by-step installation and preliminary configuration of a Cloud Control instance. Operating system specific considerations that apply to installing the Cloud Control on a Linux, Unix or MS Windows host are provided along with numerous examples. Potential problems and pitfalls are discussed and troubleshooting solutions are offered.
The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database based upon the latest features available. You will have a good understanding of relational database design, queries and subqueries, Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL) and much more through hands-on lab exercises.
This objective of this training course is to bring database administrators beyond a basic understanding of their duties whereby they learn advanced skills needed to effectively administer an Oracle 11g database installation within a large-scale enterprise.
It includes topics such as advanced database configuration, performance monitoring and tuning, configuring for backup & recovery, troubleshooting, fault diagnosis and use of the extensive advisory framework. It addresses configuration and operational problems that arise within an Oracle database installation because important technologies are either not fully understood or not properly implemented.
The objective of this training course is to enable students to gain the necessary skills for the day-to-day administration of an Oracle 11g database. It provides a good understanding of database management which includes the installation, configuration and maintenance of databases. It is the starting point for Oracle database administration that sets the foundation for advanced administrator training and certification.