The class is about operating system administration of Oracle RAC and DB components and it is intended to serve both UNIX administrators and Oracle DBAs. Currently, UNIX administrators have very little insight on Oracle RAC, CRS and ASM components; and DBAs do not have much liberty to administer these components since they do not have privileges at the Linux/UNIX level. This course covers Oracle RAC and all of the associated components to manage and maintain a high-performance environment to provide multiple interconnected computers or servers that appear as if they are one server to end users and Oracle applications. The course covers Oracle Clusterware for the infrastructure to bind multiple servers so they operate as a single system. We also cover Oracle ASM that automatically maximizes I/O performance by managing the storage configuration across the SAN disks.
This course provides participants with a 12 hour-per-day immersion into the world of MySQL database administration. The program is an accelerated course that provides those individuals who want to learn how to administer MySQL servers along with the know-how to ensure that their servers perform optimally through performance monitoring and tuning. Participants will learn from a MySQL/Database expert through a combination of lab exercises, lectures, and presentations. This is an intense immersion learning experience for MySQL administration and advanced performance tuning for one week.
This course provides practical, safe, highly efficient ways to optimize performance for the MySQL Server. This course will prepare each participant with the skills needed to utilize tools for monitoring, evaluating and tuning. Participants will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.
This course provides the foundation for database administrators and developers who want to use this powerful database. In this course you will learn how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.