Database Admin school training courses in Columbia, SC (public, in-house or online)

Earn your database administration certification at American Career Institute.

Students here learn how to perform the major tasks needed to administer and support Oracle database systems on both Microsoft Windows and Linux. And once you learn, there’s an opportunity to earn. Oracle is the most widely used database management system in the business field today. That creates a demand for skilled Oracle database administrators.

Where you’ll take your Oracle training matters too, especi...

Full archival course description>>

This course provides students with the skills needed to administer and maintain an Oracle 10g database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery. The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create awareness among participants of the wealth of system information availa...

Full archival course description>>

The course provides participants with a comprehensive overview of the new features and enhancements of Oracle10g �the database for grid computing. Features no longer supported will be identified and explained benefiting those impacted by an Oracle10g upgrade. Learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. Th...

Full archival course description>>

Plan and implement an effective database backup and recovery strategy using Recovery Manager (RMAN). Develop a strategy to support 24-hour operations. Develop a recovery plan to minimize down time. Recover the database, using RMAN, SQL, and Flashback technology. Use Oracle10g tools to monitor troubleshoot and tune database performance. Students will gain hands-on experience using Oracle10g technologies, such as Resource Manager, Scheduler, and Automatic Storage Management (ASM). Exercises and la...

Full archival course description>>

The course provides foundation skills in database administration for the Oracle professional. Students develop skills to effectively install, configure and maintain an Oracle10g Relational Database Management System. Students gain an understanding of the Oracle architectural framework and how the components perform and work together. Students configure and start up the Oracle instance and memory components and create the Oracle database repository. Students create physical and logical database o...

Full archival course description>>