HOUSTON (Sept. 25, 2012) – Lone Star Corporate College will present three Oracle Database Administration seminars as part of the Lone Star Corporate College Seminar Series.
The seminars, which begin in October, take place on Mondays and Thursdays from 6 to 10 p.m. at Lone Star College-University Park, located at 20515 State Highway 249 at Louetta Road in Houston.
The seminars will be presented in partnership with the University of Houston.
Seminars can be taken in sequence or as individual courses. Seminar dates are as follows:
Oracle Database: Introduction to SQL, Oct. 15 to Nov. 15
Oracle Database: Administration Workshop I, Jan. 28 to Feb. 28; and
Oracle Database: Administrative Workshop II, March 18 to April 25.
The cost of each seminar is $1,500.
Introduction to SQL will teach students the concepts of relational database and control privileges at the object and system level, as well as the essential SQL skills to write queries against single and multiple tables, manipulate data in tables, and create database objects. Course topics include managing schema objects, managing data in different time zones and retrieving data using sub-queries. This seminar is designed for application developers, business analysts, data warehouse administrators, developers, forms developers, PL/SQL developers, and system analysts.
Administration Workshop I will give students a foundation in basic database administration and the Oracle database architecture. Students will create an operational database and manage structures such as performance monitoring, database security, user management, and backup/recovery techniques. Course topics include installing Oracle software, creating an Oracle database and managing the ASM Instance. This seminar is designed for database administrators, Java developers, support engineers, technical administrators, and technical consultants.
Administration Workshop II takes the database administrator beyond the basic tasks of Administration Workshop I to gain a deeper understanding of one of the most important jobs of a database administrator: backup and recovery. Students will learn how to automate scheduler tasks, diagnose and repair data failures with Flashback technology, and manage space to optimize database storage. Course topics include configuring for recoverability, using the RMAN recovery catalog, and monitoring and turning RMAN.This seminar is designed for administrators, engineers and consultants preparing to take their Oracle Certified Associate exam.
With 78,000 students in credit classes, and a total enrollment of more than 90,000, Lone Star College System is the largest institution of higher education in the Houston area and the fastest-growing community college system in the nation. Dr. Richard Carpenter is the chancellor of LSCS, which consists of six colleges including LSC-CyFair, LSC-Kingwood, LSC-Montgomery, LSC-North Harris, LSC-Tomball and LSC-University Park, five centers, LSC-University Center at Montgomery, LSC-University Center at University Park, Lone Star Corporate College, and LSC-Online. To learn more visit LoneStar.edu.