Alphatech School

Computer information system (CIS)

COMPUTER INFORMATION SYSTEM:  
690 clock hours
 18 clock hour/week   - 39 weeks
OBJECTIVES:  This program is designed to fill the basic needs of those students who are entering the computer field.  The students will be introduced to a board range of computer programming skills starting with computer QBASIC, Visual Basics, and C++, database, & Networking Certifications. 

Career Opportunities:  Students will be able to meet the demands of programming industry in the real world.  The entry-level opportunities are computer operator, computer programmer, network administration, PC help desk, and PC software installation.

Windows 7
        CIS 130                        40 Clock Hours
This course is designed for students and business professionals, or private individual who needs knowledge in operating systems and file management skills.  Upon successful completion of this course, students will be able to log on to Windows 7, explore its interface, and identify the different components present in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools and programs available in Windows 7, browse the Internet.  Also, students will be able to customize the Windows 7 environment, configure user accounts, work with applications in Windows 7, work with devices, manage networks, secure system data, enhance system performance and work with Internet Explorer 8. Prerequisites: Computer Fundamentals CIS 112   

Querying and Processing SQL Server Data with SQL Statements
        CIS 140                        32 Clock Hours
This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.  Student will learn how to write queries for use with Microsoft SQL Server. Non-technical “power users” will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.  Students will be able to write queries for use with Microsoft SQL Server.  Prerequisites:  CIS 120 or 130

Implementing a Microsoft SQL Server 2005 Database
        CIS 142                        40 Clock Hours
Students will be able to: - Create databases and database files. - Create data types and tables. - Use XML-related features in Microsoft SQL Server 2005. - Plan, create, and optimize indexes. - Implement data integrity in Microsoft SQL Server 2005 databases by using constraints. - Implement data integrity in Microsoft SQL Server 2005 by using triggers. - Implement views. - Implement stored procedures. - Implement functions. - Implement managed code in the database. - Manage transactions and locks. - Use Service Broker to build a messaging-based solution. - Use Notification Services to generate and send notifications.  Prerequisites:  CIS 140



Maintaining a Microsoft SQL Server 2005 Database
        CIS 144                        32 Clock Hours
After completing this course, students will be able to: - Install and configure SQL Server 2005 - Manage database files. - Manage security. - Perform administrative tasks. - Backup databases. - Restore databases. - Monitor SQL Server. - Troubleshoot SQL Server. - Transfer data. - Maintain high availability.
Prerequisites:  CIS 140 and CIS 142

Designing Microsoft SQL Server 2005 Server-Side Solutions
        CIS 146                        40 Clock Hours
After attending this course, students will be able to: - Select SQL Server services to support an organization's business needs. - Design a security strategy for a SQL Server 2005 solution. - Design a data modeling strategy. - Design a transaction strategy for a SQL Server solution. - Design a Notification Services solution. - Design a Service Broker solution. - Plan for source control, unit testing, and deployment to meet an organization's needs. - Evaluate advanced query techniques. - Evaluate advanced XML techniques.  Prerequisites:  CIS 140, CIS 142 and CIS 144

Designing the Data Tier for Microsoft SQL Server 2005
        CIS 148                        20 Clock Hours
After attending this clinic, students will be able to: - Choose data access technologies and an object model to support an organization's business needs. - Design an exception handling strategy. - Choose a cursor strategy. - Design query strategies using Multiple Active Result sets (MARS). - Design caching strategies for database applications. - Design a scalable data tier for database applications.
Prerequisites: CIS 140, CIS 142, CIS 144

Designing Microsoft SQL Server 2005 Infrastructure and Services
CIS 149                        20 Clock Hours
After completing this course, students will be able to: - Analyze storage, CPU, memory, and network capacity needs. - Design a strategy for data archiving. - Design a strategy for database server consolidation. - Design a strategy for data distribution. - Design a database server infrastructure. - Design a strategy for data recovery. - Establish database conventions and standards.  Prerequisites: CIS 140, CIS 142, CIS 144

Designing Security for Microsoft SQL Server 2005
        CIS 150                        20 Clock Hours
This course enables database administrator students in enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. It covers business needs, regulatory requirements and network systems, and database design considerations.
Prerequisites: CIS 140, CIS 142, CIS 144

Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
        CIS 152                        20 Clock HoursThe course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.  This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.
Prerequisites: CIS 140, CIS 142, CIS 144

Administering and Automating Microsoft SQL Server 2005 Databases and Servers
        CIS  154                        20 Clock Hours
This course provides students with the knowledge and skills to administer and automate Microsoft® SQL ServerT 2005 databases and servers. Elements of this syllabus are subject to change.  This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. 
Prerequisites: CIS 140, CIS 142, CIS 144

Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
        CIS 156                        20 Clock Hours
This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL ServerT 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.  Prerequisites: CIS 140, CIS 142, CIS 144

Tuning and Optimizing Queries Using Microsoft SQL Server 2005
        CIS  160                        32 Clock Hours
After completing this course, students will be able to: - Normalize databases. - Design a normalized database. - Optimize a database design by denormalizing. - Optimize data storage. - Manage concurrency - Manage concurrency by selecting the appropriate transaction isolation level. - Select a locking granularity level. - Optimize and tune queries for performance. - Optimize an indexing strategy. - Decide when cursors are appropriate. - Identify and resolve performance-limiting problems.
Prerequisites: CIS 140, CIS 142, CIS 144

Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
        CIS  166                        32 Clock Hours
After completing this course, students will be able to: - Describe SQL Server Integration Services and its tools. - Create an Integration Services package. - Implement control flow in an Integration Services package. - Implement data flow in an Integration Services package. - Implement logging in an Integration Services package. - Debug and implement error handling in an Integration Services package. - Implement checkpoints and transactions in an Integration Services package. - Deploy an Integration Services package. - Manage and secure an Integration Services package.
Prerequisites: CIS 140, CIS 142, CIS 144



Introduction to Oracle/SQL – Oracle Fundamentals I & II
        CIS 200                        40 Clock hours
Understanding the basic concepts of relational databases ensure refined code by developers. This course helps the participants to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Controlling privileges at the object and system level are also dealt with in detail.   This course covers creating indexes and constraints, and altering existing schema objects. Additionally, participants learn how to create and query external tables. In order to query and manipulate data within the database, to use the dictionary views to retrieve metadata and create reports about their schema objects, participants get to understand the advanced features of SQL. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL.  This course is a combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II courses.  For this course, the main development tool used is Oracle SQL Developer. SQL*Plus is available as an optional development tool.  This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features in SQL.  Prerequisites:  Familiarity with data processing concepts and techniques.

Oracle Database 11g: Administration Workshop I DBA Release 2
        CIS 202                        40 Clock HoursThis course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.  Prerequisites:  Oracle Database:  Introduction to SQL

Oracle Database 11g: Administration Workshop II DBA Release 2
        CIS 206                        40 Clock Hours
This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.  Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered.   Prerequisites:  Administration Workshop I

Oracle Database 11g: Performance Tuning DBA Release 2
        CIS 208                        40 Clock Hours
The course starts with an unknown database that requires tuning. The lessons will proceed through the steps a DBA will perform to acquire the information needed to identify problem areas, to diagnose common problems, and remedy those problems. The methodology used in the practices is primarily reactive. After configuring monitoring tools, and reviewing the available reports, the student will be presented with the Oracle architecture based on the SQL statement processing of SELECT and DML. The SQL tuning section assumes that the DBA has little or no ability to change the code. The DBA will influence the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning, and the diagnostic tools needed to find ways to change the performance. This will include the use of statistics, outlines, and profiles to influence the optimizer, adding and rebuilding indexes, and using the SQL Advisors. A major task of DBA’s is to maintain SQL performance across changes. This course introduces the DB Replay, and SQL Performance Analyzer tools to help the DBA test and minimize the impact of change.  Prerequisites: Administration Workshop I & II

Oracle Database 11g: SQL Tuning Workshop Release 2
        CIS 210                        40 Clock Hours
This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes of the inefficient SQL statements.   Students learn to interpret execution plans, and the different ways in which data can be accessed. They will learn how the optimizer chooses the path and how to influence the optimizer to ensure that the best method is used. This course covers Automatic SQL Tuning tools, and resources available in the Automatic Workload Repository, in addition to taking advantage of bind variables, trace files, and different types of indexes.  Prerequisites: Introduction to SQL

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2
        CIS 212                        40 Clock Hours
In this intensive course, students will learn about the Oracle Grid Infrastructure products. This includes Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. Students will also learn to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools. Administration of ASM and ACFS will be done using both command line and graphical user interface clients. Students will learn how to leverage the Oracle Clusterware to make applications highly available, supporting monitoring and failover to other nodes. Students will learn to troubleshoot the Oracle Clusterware by examining log files, enabling debugging, and enabling tracing for various utilities.   Students will learn about RAC database administration in the Oracle Grid Infrastructure environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied.  This is an accelerated course, covering seven days' worth of content in only five days. Because of the extra content to be accommodated each day, the duration of classes each day can be slightly longer than usual.
Prerequisites: Administration Workshop I, CIS 202




Oracle Database 11g: Data Guard Administration Release 2
        CIS 214                        32 Clock Hours
In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.  The course includes Data Guard architecture, the configuration of physical and logical standby databases, and role transitions. Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases are outlined. In addition, management of a Data Guard configuration and troubleshooting are discussed.  Prerequisites: Administration Workshops I & II, CIS 202, and CIS 206

Oracle Database 11g: Backup and Recovery Workshop
        CIS 216                        24 Clock Hours
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course reviews the backup and recovery techniques that are discussed in the Oracle Database 11g: Administration Workshop I and II courses, and examines various backup, failure, restore, and recovery scenarios. Students are expected to have some knowledge of Recovery Manager (RMAN) and Enterprise Manager, as they will use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are also described as an additional way to recover from various errors.  Extensive hands-on practices and workshops provide the student with experience in a realistic technical environment. This course includes interactive workshops that provide participants with the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.  Prerequisites: Administration Workshops I & II, CIS 202, and CIS 206

Oracle Database 11g: Oracle Secure Backup
        CIS 218                        16 Clock Hours
In this course, students learn how to use Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and it also provides general file system backup to tape. Students install Oracle Secure Backup and use it to back up and restore Oracle Database files, as well as file-system data. Students also learn how to perform advanced management tasks, such as, tape vaulting.  Prerequisites: Administration Workshop I

Oracle Database 11g: Implement Streams
        CIS 220                        40 Clock Hours
Oracle Streams allows students to share data, messages, and events between schemas, applications, and databases. This course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. The lessons are designed to give students practical experience in configuring and managing a Streams environment. The course covers enqueue and dequeue messages using Oracle Streams. Also included are best practice guidelines and troubleshooting practices.  This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirements.