School of Computer Science,
                  Telecommunications, and Information Systems

                                 Link to CTI Homepage

                         Link to DePaul Homepage

   Marco T. Chou MCDBA, MCSE, MCT, OCP

   (O):847-402-2720 (C):847-226-2263
   E-mail : mchou@cs.depaul.edu

   Courses Taught in DePaul (Instructor)

   DePaul IPD (The Institute for Professional Development) Database Program (Associate Director/Instructor)

   ProAct Consulting, Inc. (DB Training/Consulting, Chinese Language/Painting)     

2006-2007 IPD363 SQL Server 2005 DBA  

2006-2007  CSC454 Database Administration and Management: Oracle10g R2

Summary of the course: Oracle DBAs manage the industry's most advanced information systems. Career opportunity and higher income are great reasons to start learning database administration. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Oracle. Students will gain a conceptual understanding of Oracle server, instance, and database architecture. Students will use administration tools to start and shut down an instance, create a database, manage database storage, and manage database security. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well designed and operational database. Loading and transporting for databases, backing up and recovering database objects, and the utilities used to perform these activities are described.

• Prerequisites: CSC449: Database Technologies
• Textbook: Oracle10g DBA Handbook (McGraw Hill - Osborne) www.osborne.com  ISBN 0072231459
• Reference: Oracle10g on-line documentation
• Hardware: Windows 2000 or XP with minimum 600 MHz, 512 RAM, and 3GB free disk
• Software: Oracle10g Release 2 Enterprise Edition (Evaluation Copy)      

• HW/Lab: 4 homework assignments and 3 hands-on lab exercises     

 Class Agenda:

• Week 1: Database Administration introduction.  Oracle Overview. 
• Week 2: Oracle Architecture. Managing an Oracle Instance.
• Week 3: Oracle installation and configuration. Creating a Database.
• Week 4: Managing database files and storage. Creating database objects. 
• Week 5: SQL Loader, External Table
• Week 6: Take Home Midterm
• Week 7: Control File, Redo Log File, UNDO Tablespace, Security.
• Week 8: Backup and Recovery
• Week 9: Import/Export and DataPump
• Week 10: Tools (Oracle Enterprise Manager), iSQL, Network 

2004  CSC454 Database Administration and Management: Oracle9i

2003  CSC589 Topics in Database: Oracle9i Database Administration

Summary of the course: Oracle DBAs manage the industry's most advanced information systems. Career opportunity and higher income are great reasons to start learning database administration. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Oracle. Students will gain a conceptual understanding of Oracle server, instance, and database architecture. Students will use administration tools to start and shut down an instance, create a database, manage database storage, and manage database security. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well designed and operational database. Loading and transporting for databases, and the utilities used to perform these activities are described.

• Prerequisites: CSC449: Database Technologies
• Textbook: Oracle9i DBA Handbook (McGraw Hill - Osborne) www.osborne.com  ISBN 0-07-219374-3
• Reference: Oracle9i on-line documentation
• Hardware: Windows 2000 or XP with minimum 500 MHz, 256 RAM, and 3GB free disk

• Software: Oracle9i  Rel. 2 Enterprise Edition (Evaluation Copy)             

 Class Agenda:

• Oracle Overview - DBA, Products, Training/Certification.
• Oracle Architecture. 
• Oracle installation and configuration.
• Managing Oracle Instances and Databases. 
• Managing database files and storage. Creating database objects. 
• SQL Loader
• Control File, Redo Log File, UNDO Tablespace.
• Index and Partitioning
• Tools (Oracle Enterprise Manager, iSQL), Security.

2002  CSC589 Topics in Database: SQL Server 2000 Database Administration

Summary of the course: This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the SQL Server database management system. Students will gain a conceptual understanding of both database architectures. Students will use administration tools to start and shut down a database, create a database, manage database storage, and manage database security. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well- designed and operational database. Loading and transporting for databases, and the utilities used to perform these activities are described. This course also addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios.

• Prerequisites: CSC449: Database Technologies
• Textbook: SQL Server on-line documentation CD will be available for students at class.

• Software: Microsoft SQL Server 2000 Personal Edition (Evaluation Copy)                                                                              

Class Agenda:

• SQL Server 2000 overview
• SQL Server installation and configuration.
• Managing database files, creating objects, and security.
• Transferring Data (DTS) and performing Administrative Tasks.
• Backup & Recovery
• Performance monitoring and tuning
• Cluster, Standby, Replication
• High Availability

2001  CSC449 Database Technologies

Class Agenda: 

• Overview of Database Management and architectures of database management systems.
• Relational query languages: algebra.
• ER Model and Relational Data Model.
• Data Definition and Data Manipulation (DDL, DML). SQL: using Oracle.
• Data integrity, Views and System Catalogs.
• Design of relational databases: functional dependencies, normal forms, decomposition, normalization.