Database Technology and Administration
The Certificate Program in Database Technology and Administration is a course of study that seeks to ground the student in the fundamentals of Database Management Systems (DBMS) prior to certification as either an MCDBA or Oracle 9i DBA. All students must first complete both CSCU 0017 and CSCU 0018 before electing to specialize in either the Oracle 9i DBA or Microsoft MCDBA track.
CSCU 0017: Introduction to Database Management Systems
This course introduces students to techniques of data analysis involved in designing relational databases and how to apply them effectively. Students will learn how to design an efficient relational database by creating relational constructs, normalizing tables, creating joins and views, optimizing the database's physical design, and avoiding common database design mistakes.
CSCU 0018: Advanced Database Management Systems
Prerequisites: CSCU 0117. This course provides new users of relational databases with a solid introduction to SQL. Students are required to build a database and access stored information by performing queries. By the end of the course, students will have the requisite skills to retrieve, add, and delete data from an SQL-compliant database.
Oracle 9i
This is a hands-on program that helps the student prepare for both a new career in database administration and Oracle's certification as an Oracle 9i Certified Database Administrator. In the Oracle 9i training you will learn the skills needed to become a DBA and learn how to manage, administer, backup and tune an Oracle 9i database.
CSCU 0019: Introduction to Oracle 9i: SQL (Exam 1Z0-007)
This course introduces the student to basic SQL select statements, displaying data from multiple tables, single row functions, controlling user access, conducting sub-queries and producing readable output with iSQL Plus.
CSCU 0020: Oracle 9i: DBA Fundamentals I (Exam 1Z0-031)
Topics include Oracle architectural components, Oracle Server, managing an Oracle instance; data dictionary content and usage, maintaining redo log files and the control file.
CSCU 0021: Oracle 9i: DBA Fundamentals II (Exam 1Z0-031)
Topics include an overview of Oracle Net Architecture, Net Server-Side configuration, usage and configuration of the Oracle Shared Server and Oracle Net Services Client-Side configuration, RMAN backup and recovery, transporting and loading data, recovery and catalog creation.
CSCU 0022: Oracle 9i: Performance Tuning (Exam 1Z0-033)
This course provides an overview of diagnostic and tuning tools including sizing the buffer cache, tuning rollback segments, monitoring and detecting lock contention, tuning Oracle Shared Server and application tuning.
Microsoft Certified Database Administrator (MCDBA)
The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server™ databases. This certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.
CSCU 8827: Managing and Maintaining a Microsoft Windows Server 2003 Environment
This course provides students with the knowledge and skills that are required to manage accounts and resources, maintain server resources, monitor server performance, and safeguard data in a Microsoft Windows Server™ 2003 environment. This is the first course in the Systems Administrator and Systems Engineer tracks for Windows Server 2003 and serves as the entry point for other courses in the Windows Server 2003 curriculum.
CSCU 8828: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
This course provides students with the knowledge and skills to implement, manage, and maintain a Microsoft Windows Server™ 2003 network infrastructure. Course topics include implementing routing; implementing, managing, and maintaining Dynamic Host Configuration Protocol (DHCP), Domain Name System (DNS), and Windows Internet Name Service (WINS); securing Internet Protocol (IP) traffic with Internet Protocol security (IPSec) and certificates; implementing a network access infrastructure by configuring the connections for remote access clients; and managing and monitoring network access.
CSCU 8072: Administering a Microsoft SQL Server 2000 Database
(Exam 70-228)
Prerequisites: Network+ Certification or equivalent experience. This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000.
CSCU 8073: Programming a Microsoft SQL Server 2000 Database
(Exam 70-229)
Prerequisites: CPSC 8151, 8152, or equivalent of experience. This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server™ 2000.