Please note that this program requires that a Certificate Program application be filled out accompanied with a $10.00 non-refundable application fee before you can be accepted into the program. Download the Certificate Program application here.
This class is applicable to Oracle8i, Oracle9i, Oracle10g and Oracle11g users. This course introduces Oracle Database 11g technology and the relational database concepts and the powerful SQL programming language. This course provides you with the essential SQL skills of querying the database, the meta data and creating database objects. In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones. (4.0 CEUs).
Prerequisites: 1 programming course or 1 year of programming with an understanding of 2-dimensional arrays.
Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam. (4.0 CEUs)
Prerequisite: Introduction to SQL.
Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course advances your success as an Oracle professional in the area of database administration. In this class, you’ll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. You will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam. (4.0 CEUs)
Prerequisite: Administration Workshop I.