LOS ANGELES CITY COLLEGE | 07-08 CATALOG [REV. 07/07] csit Computer Science/Information Technology     Chair: Roger Wolf (323) 953-4000 ext. 2680 • AD321 www.lacitycollege.edu/academic/departments/math/csitdept/   CATALOG  INDEX  |  RETURN TO LACC HOME PAGE  |   CATALOG / CLASS SCHEDULE

Associate of Science:

Computer Science/Information Technology

Computer Information Systems

Certificates:

Applications Software

Programming Languages

Skill Certificates:

Computer Networking

Database Administration

Operating Systems

UNIX Operating System

Web Client Technologies

Web Server Technologies

NOTE: The official abbreviation for Computer Science/Information Technology (CSIT) is "CO SCI".

If you have a talent for math and science our programs will prepare you to enter more advanced university programs or directly enter careers related to Computer and Information Systems, System Analysis, Computer Science, Database Administration, Computer Operations, Information Processing Services, Computer Software Engineering, Telecommunications, and Web Development and Technologies.

According to the Department of Labor median hourly earnings for high demand occupations in technology and other computer fields at the entry levels range from nearly $12/hour to $26/hour. With advance training and or a Bachelors degree, salaries can exceed $42/hour.

The Computer Science Information Technology discipline program at Los Angeles City College offers two Associate degrees that students can choose from depending on their career and educational goals.  The first, Associate of Science in Computer Science, is designed for students with transfer goals to the Computer Science program at four-year universities.  The second, an associate of science in Computer Information Systems, is designed to prepare students for careers in exciting Information Technology fields such as programming, software engineering, database administration, computer networking, multimedia, and web technologies.  Students with interest in transferring to the Information Systems program at four-year universities should consult with the Computer Science department for needed course work. The following tables list the requirements for each degree. For information on general education courses, students are encouraged to see a counselor for advisement.

Click Here for DEGREE SEQUENCE CHART

computer science

Associate of Science Degree

Transfer Program

First Semester              

CO SCI 104...................................................................................... 3

CO SCI 107...................................................................................... 3

(CO SCI 103 is a prerequisite to required CO SCI courses
 and can be used to fulfill a general education requirement)

Second Semester

CO SCI 134...................................................................................... 3

CO SCI 139...................................................................................... 3

Suggested Major Preparation:

    Physics 1...................................................................................... 4

    Math 261....................................................................................... 5

Third Semester

CO SCI  140 or 141........................................................................... 3

CO SCI 186...................................................................................... 3

Suggested Major Preparation:

    Philosophy 7, 8, or 9....................................................................... 3

Fourth Semester

CO SCI 136...................................................................................... 3

CO SCI 158...................................................................................... 3

Total Major Units........................................................................... 24

Note:  On approval by the Computer Science/Information Technology discipline, students may use Math 262, 263 and Physics 2, 3 as substitute to any of the CO SCI requirements except CO SCI 139, CO SCI 140 (or 141), and CO SCI 136 as long as a minimum of 18 CO SCI units is met.

To complete general education requirements in this area of study, Plan A for the AA/AS Degree is required.

PLAN A: Please consult with a counselor about specific courses needed or see the college catalog "Graduation Requirements" section.  Plan A is designed for transfer to a four-year college or university. However, requirements vary depending upon the individual institution. Please consult with a counselor for the specific requirements of the university you plan to attend.

3-6 Units          English Composition                    

6-9 Units          Communication/Analytical Thinking

3 Units             ................................................................... Natural Sciences                        

3 Units             ............................................................................. Humanities                                

9 Units             Social/Behavioral Sciences (including American History & Governments)

3-4 Units          Health/Physical Education          

3-5 Units          Math Competency                    

(Math 115 or higher or passing score on Los Angeles Community College District Math competency exam)

computer information systems

Associate of Arts Degree

Career Program

First Semester              

CO SCI 104...................................................................................... 3

CO SCI 107...................................................................................... 3

(CO SCI 103 is a prerequisite to required CO SCI courses
 and can be used to fulfill a general education requirement)

Second Semester

CO SCI 134...................................................................................... 3

CO SCI 139 or 141............................................................................ 3

CO SCI 158...................................................................................... 3

CO SCI 181...................................................................................... 3

Third Semester

CO SCI 136...................................................................................... 3

CO SCI 156...................................................................................... 3

CO SCI 182...................................................................................... 3

CO SCI 186...................................................................................... 3

Fourth Semester

CO SCI 138, 140, or 142 ................................................................... 3

CO SCI 187...................................................................................... 3

Suggested Electives:

     CO SCI 167................................................................................. 3

     CO SCI 168................................................................................. 3

Total Major Units............................................................................ 36

To complete general education requirements in this area of study, Plan B for the AA/AS Degree is required.

PLAN B: Please consult with a counselor about specific courses needed or see the college catalog "Graduation Requirements" section. Plan B is not designed for transfer to a four-year college.

3 Units             ............................................................. English Composition

3 Units             ..................................... Communication/Analytical Thinking

3 Units             ................................................................... Natural Sciences

3 Units             ............................................................................. Humanities

3 Units             Social/Behavioral Sciences (including American History & Governments)

3-4 Units          Health/Physical Education

3-5 Units          Math Competency
 

Certificates in Computer Science-Information technology will be issued by the Computer Science/Information Technology discipline upon application to the department by the student and successful completion of one or more of the following sequences.

Applications Software

Certificate

This sequence of courses prepares students for careers in applications software development and usage in fields related to databases, networking,  web technologies, business analysis, and/or programming.  Students successfully completing this program will find opportunities for employment in various industries depending on the track chosen for the electives.

CO SCI 103 or 101 and 108................................................................ 4-7

CO SCI 104...................................................................................... 3

CO SCI 107...................................................................................... 3

CO SCI 134...................................................................................... 3

CO SCI 138...................................................................................... 3

CO SCI 148...................................................................................... 3

CO SCI 186...................................................................................... 3

Electives........................................................................................... 6

Total Units...................................................................................... 28-31

Acceptable Electives:

Database Track:  2 courses from CO SCI 187, 188, 189, 198, and 199

Networking Track:  2 courses from CO SCI 181, 182, and 183

Operating Systems Track: 2 courses from CO SCI 167, 168, and 169

Programming Track: 2 courses from CO SCI 136, 139, 140, 141, and 142

Web Technologies Track:  2 courses from CO SCI 144, 155, 156, 158, and 159.

Programming Languages

Certificate

This course sequence provides students with comprehensive training in high-demand programming languages and tools such as Visual Basic, C++, Java, Perl, XML, ASP, and others.  Students can choose electives from three exciting tracks: Databases, Web Development, and Operating Systems.  Successful completion of the program will prepare students for an exciting career in software analysis, design, and development. 

CO SCI 103 or 101 and 108 ............................................................... 4-7

CO SCI 104...................................................................................... 3

CO SCI 107...................................................................................... 3

CO SCI 134...................................................................................... 3

CO SCI 136...................................................................................... 3

CO SCI 138...................................................................................... 3

CO SCI 139 or 141............................................................................ 3

CO SCI 140 or 142............................................................................ 3

CO SCI 186...................................................................................... 3

Electives........................................................................................... 9

Total............................................................................................... 37-40

Acceptable Electives:

Databases Track:  3 courses – CO SCI 187, 188, 189, 198, and 199

Web Development Track: 3 courses from CO SCI 144, 155, 156, 158, and 159

Operating Systems Track: 3 courses – CO SCI 167, 168, and 169

Computer Networking

Skill Certificate

This course sequence offers state of the art hands-on training in designing, configuring, and maintaining basic networks using Cisco routers and switches.  The program also prepares students for the Cisco Certified Networking Associate (CCNA) exam.

CO SCI 181...................................................................................... 3

CO SCI 182...................................................................................... 3

CO SCI 183...................................................................................... 3

CO SCI 184...................................................................................... 3

Total Units..................................................................................... 12

DATABASE ADMINISTRATION

Skill Certificate

This course sequence offers state of the art hands-on training in setting up and administering Oracle relational databases and prepares students for the Oracle professional certification in database administration.

CO SCI 186..................................................................................... 3

CO SCI 187...................................................................................... 3

CO SCI 188..................................................................................... 3

CO SCI 189...................................................................................... 3

Total Units...................................................................................... 12

operating systems

Skill Certificate

This program provides hands-on training in the use of UNIX and WINDOWS operating systems and prepares students for Microsoft Certificate Professional (MCP) examination.

CO SCI 134...................................................................................... 3

CO SCI 167...................................................................................... 3

CO SCI 168..................................................................................... 3

CO SCI 169...................................................................................... 3

Total Units...................................................................................... 12

UNIX operating systems

Skill Certificate

The UNIX operating system is very widely used in education, business, science, and industry both in servers and in desktop applications.  Almost 70% of the Internet’s World-Wide Web servers are driven by some version of UNIX or LINUX. UNIX is used in specialty desktop systems that require complex graphics or scientific processing. In servers, UNIX supports web services, database systems, advanced scientific computing,  and vast communications networks.  UNIX can be used in cluster systems requiring thousands of processors or in small embedded systems involved in simple robotic applications. It is the system of choice for the vast majority of university applications.

CO SCI 144...................................................................................... 3

CO SCI 168...................................................................................... 3

CO SCI 169..................................................................................... 3

CO SCI 170...................................................................................... 3

CO SCI 171...................................................................................... 3

Total Units...................................................................................... 15

WEB client technologies

Skill Certificate

Program provides training in the use of client-side web technologies for design and development of interactive web sites. Skills include use of HTML, DHTML, XML, Java, Java Script, Dreamweaver and Flash in web site development.

CO SCI 141..................................................................................... 3

CO SCI 151...................................................................................... 3

CO SCI 152...................................................................................... 3

CO SCI 156...................................................................................... 3

CO SCI 158..................................................................................... 3

Total Units..................................................................................... 15

WEB server technologies

Skill Certificate

The Web Server Technologies program provides training in the use of server-side web technologies for the design and development of E-Commerce web sites.  These include the use of CGI scripts, Active Server Pages, and Database Servers to create realistic e-commerce sites.  Server-side concepts related to the Windows and Unix operating systems are covered.  Students will also get introduction to the Oracle’s database technology and how to develop dynamic, interactive and scalable database-driven Web applications.

CO SCI 134...................................................................................... 3

CO SCI 155...................................................................................... 3

CO SCI 159...................................................................................... 3

CO SCI 167 or 168............................................................................ 3

CO SCI 186...................................................................................... 3

Total Units...................................................................................... 15
 

NOTE: Not every class is offered each semester. Refer to the current class schedule for current class offerings.

PREREQUISITES: Specified prerequisites must be completed with a satisfactory grade or equivalent.

The official abbreviation for Computer Science/Information Technology (CSIT)  is “CO SCI”.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 100

Workshop Laboratory

1 UNIT -  (RPT 3) (A)

This course is designed to supplement and enhance learning experience in other computer-related courses by providing tutorial and self-help assistance with computers, programs, software, hardware and other learning aids.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 101

Introduction to Computers and Their Uses

4 UNITS -  (UC:CSU)

Advisory: English 73.

Credit not allowed if student has credit for CO SCI 103.

A general computer literacy course open to all students. Presents computer hardware, software, terminology, ethics, and societal impact. Students will  overview operating systems, word processing, spreadsheets, database management systems, telecommunications, and networks.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 103

Introduction to Computer Systems for MIS

4 UNITS -  (UC:CSU)

Advisory: English 73.

An introduction to computers for a one-semester transfer course or for certificates or a degree in CSIT. Topics include computers, programming and systems design, programming languages and flowcharting. Laboratory includes word processing, spreadsheets, database concepts and extensive programming in BASIC.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 104

Mathematics for Programmers

3 UNITS -  (CSU)

Advisory: CO SCI 103 or equivalent.

Development of the specialized mathematical concepts necessary for writing computer programs, including the internal representation of numeric data, logical operators, set theory, vector and matrix operations, and linear equations.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 107

Programming Logic

3 UNITS -  (UC:CSU)

Prerequisite: CO SCI 103 with a satisfactory grade or better or equivalent.

Advisory: Mathematics 125 or equivalent.

Introduces the discipline of computer science using a high level language; provides an overview of computer organization and an introduction to software engineering. Includes program design, development, style, testing, documentation, algorithms, control structures, sub-programs, and elementary data structures.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 108

Beginning Visual Basic Programming

3 UNITS -  (UC:CSU)

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.

A beginning programming course in the Visual Basic Programming Language.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 133

Microcomputer Data Base Programming

3 UNITS -  (CSU)

Prerequisite: CO SCI 103 with a satisfactory grade or better or equivalent.

This course focuses on the essential principles and concepts of a microcomputer data base environment. A comprehensive examination of the functions of a data base command language is included.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 134

Operating Systems

3 UNITS -  (CSU)

Prerequisite: CO SCI 101 or 103 with a satisfactory grade or better or equivalent.

Fundamental principles functions, application and use of operating systems such as DOS, UNIX, Windows 98/NT/2000, and Netinase and related applications software. Analysis of capabilities and limitations of the different operating systems and environments. Applicable to A+ certification software preparation.    

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 136

Introduction to Data Structures

3 UNITS -  (UC:CSU)

Prerequisite: CO SCI 140 with a satisfactory grade or better or equivalent.

Principles and applications of data structures. Design implementation, and analysis of algorithms to manipulate arrays, lists, stacks, queues, trees, graphs, and other objects. Examination of sorting and searching methods. Recursive and object-oriented programming techniques.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 138

Advanced Visual Basic Programming

3 UNITS -  (UC:CSU)

Prerequisite: CO SCI 108 with a satisfactory grade or better or equivalent.

An advanced programming course in the Visual Basic .Net programming language with objects, classes, exception handling, GUI, DBMS, SQL, ASP .NET, Data Structures, and Recursion.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 139

Programming in C

3 UNITS -  (UC:CSU)

Prerequisite: CO SCI 104 and CO SCI 107 with satisfactory grades or better or equivalent.

The course provides students the ability to write computer programs in a language used by professional programmers and software developers.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 140

Programming in C++

3 UNITS - (UC:CSU)

Prerequisite: CO SCI 139 with a satisfactory grade or better or equivalent.

This course addresses class construct, an extension of C Structure. The course emphasizes superiority of C++ to C as a general purpose programming language because of its new features and C++ as an object oriented programming language.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 141

Programming in JAVA

3 UNITS - (UC:CSU)

Prerequisite: CO SCI 101 or CO SCI 103 with a satisfactory grade or better or equivalent.

Advisory: CO SCI 107 and CO SCI 104.

An introductory university-level course of a leading-edge programming paradigm object-oriented programming that is truly portable and therefore appropriate for implementing internet-based and World-Wide Web based applications.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 142

Advanced JAVA

3 UNITS - (A)

Prerequisite: CO SCI 141 with a satisfactory grade or better or equivalent.

This is a sequel to CO SCI 141.  It covers numerous topics beyond the introductory Java course.  Topics included are: (1) UML, (2) Multithreading, (3) Networking, (4) Exception handling, (5) Recursion, (6) Files & Streams, (7) JDBC, and (8) Generics.  This course will prepare a student to tackle the Sun Certified Java Programmer industry certification Exam.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 144

Practical Extraction and Report Language (PERL)

3 UNITS - (UC:CSU)

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.

An introductory university-level course in Practical Extraction and Report Language (PERL), a standard tool for UNIX server administration and server side support of interactive World Wide Web pages.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 148

Advanced Spreadsheet Applications

3 UNITS -  (CSU)

Prerequisite: CO SCI 101 or 103 with a satisfactory grade or better or equivalent.

A course in advanced spreadsheet operations, including nested functions, data tables, exporting/importing data, what-if analysis, macro development, macrologic, printing enhancements and spreadsheet systems development.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 151

Macromedia Dreamweaver

4 UNITS -  (A)

Prerequisite: CO SCI 103 or CO SCI 108 with a satisfactory grade or better or equivalent.

This course provides an extensive practical and theoretical framework for using Macromedia’s Dreamweaver to develop web sites. It includes enhancements for web page layout, coding, and webmaster-user interactivity.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 152

Macromedia Flash

3 UNITS -  (A)

Prerequisite: CO SCI 151 with a satisfactory grade or better or equivalent.

This course covers Macromedia’s Flash; a state-of-the-art Web animation software for creating highly compact, vector-based content for transmission over the Internet.  Topics include introduction to ActionScript, Event Handlers, objects and Dynamic Data.

COMPUTER SCIENCE INFORMATION TECHNOLOGY 153

Macromedia Director

1.5 UNITS

Prerequisite:  CO SCI 151 with a satisfactory grade or better or equivalent.

This course is designed for multimedia Webmasters interested in learning Macromedia Director to develop Web-based Shockwave projects, create interactive learning modules, design interactive kiosks and catalogs, program with Lingo, and create animated presentations and projects.

COMPUTER SCIENCE INFORMATION TECHNOLOGY 154

Macromedia Authorware

1.5 UNITS

Prerequisite:  CO SCI 151 with a satisfactory grade or better or equivalent.

Media Convergence and the Internet have created a need for multi-model instructional material in the Web.  Macromedia Authorware is the professional’s choice fore developing E-learning material.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 155

Electronic Commerce (E-Commerce) Technologies

4 UNITS -  (A)

Prerequisite: CO SCI 101 and CO SCI 103 with satisfactory grades or better or equivalent.

This course offers hands-on experience in designing and implementing business-to-consumer and business-to-business web commerce sites.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 156

XML Programming

3 UNITS -  (CSU)

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.

This course offers hands-on experience in designing and programming XML documents that enable the structured delivery of data and information over a corporate intranet, the internet, or for simple XML messaging between HTTP servers. The course also provide skills to build business-to-business E-commerce applications.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 158

Hyper-Text Markup Language (HTML)

3 UNITS -  (CSU)

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.

Covers Hyper-Text Makeup Language, including formatting concepts of hypermedia composition, lists, tables, graphics, maps, frames, forms and form processing. CGI, web site management, and an overview of more advanced features.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 159

Web Projects

3 UNITS - (CSU) (RPT 2)

Prerequisite: CO SCI 158 with a satisfactory grade or better or equivalent.

Covers more complex topics in rapidly changing technology of web pages construction including multimedia developments, plug-ins, helper applications, CSS, DHTML and new developments. Students will complete web projects with emphasis placed upon recent developments in students and software.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 160

Business Systems Design

3 UNITS -  (CSU)

This course covers the fundamentals of business systems analysis and design. It defines the core of the systems analyst, and describes experience in screen and form design, implementation and project management.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 167

Microcomputer Operating Environments - Windows

3 UNITS - (CSU)

Prerequisite: CO SCI 101 or 103 and CO SCI 134 with satisfactory grades or better or equivalent.

Advanced course focusing on graphical user interface theory and operating system environment maintenance, contrasting DOS interface with graphical user interface, reviewing DOS fundamentals, introducing Windows applications use and installation and covering communications, macro generation, object embedding, memory management and network configurations.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 168

The UNIX Operating System

3 UNITS - (CSU)

Prerequisite: CO SCI 101 with a satisfactory grade or better or equivalent.

Covers basic features of the UNIX operating system including commands and concepts for running, application handling files, directories, permissions, networking, and scripting.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 169

Apache Web Server

3 UNITS - (CSU)

Prerequisite: CO SCI 168 with a satisfactory grade or better or equivalent.

A course covering the tasks involved in administering an Internet web server running Apache web server software under UNIX.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 170

UNIX System Administration

3 UNITS

Covers advanced topics in UNIX system administration including user addition and management, system disk drive installation and preparation, application installation, network installation and configuration, printer attachment, booth procedures and scripting, and management of event logging. The student builds a UNIX server from scratch and configures it to required specifications.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 171

UNIX System Security

3 UNITS

Covers both theoretical and practical aspects of UNIX system security, including UNIX password systems, file system hardening, crytography basics, physical security for hardware, protocol security, network authentication methods, secure programming and account defense.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 172

Web Services

3 UNITS - (A)

Prerequisite: CO SCI 151 with a satisfactory grade or better or equivalent.

Students completing this course will be able to develop applications referred as Web services.  Web services let computers talk to one another over the Internet, allowing computer programs to exchange information by eliminating barriers such as different hardware platforms, software languages, and operating systems that usually make different programs incompatible.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 181

Computer Networking I - CISCO

3 UNITS -  (CSU)

Prerequisites: CO SCI 101 or 103 with a satisfactory grade or better or equivalent.

This course covers fundamentals of computer networking.  Topics include evolution of networking, seven layers of the OSI reference model, and networking devices such as bridges, hubs, switches, and routers.  Internet protocol, IP addressing, subnetting, network topology, and cabling will also be covered.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 182

Computer Networking II - CISCO

3 UNITS -  (CSU)

Prerequisite:  CO SCI 181 with a satisfactory grade or better or equivalent.

This course covers a wide area of internetworking fundamentals. Topics include router fundamentals, router setup and configuration, network management, routing and routed protocols, and network troubleshooting.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 183

Computer Networking III - CISCO

3 UNITS - (A)

Prerequisite: CO SCI 182 with a satisfactory grade or better or equivalent.

This course covers routers configuration for various industry standard protocols. Topics include segmentation of LAN’s using bridge, routers and switches. Virtual LAN”s (Local Area Network), Fast Ethernet, cut-through and store-and-forward LAC switching are also discussed.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 184

Computer Networking IV - CISCO

3 UNITS - (A)

Prerequisite: CO SCI 183 with a satisfactory grade or better or equivalent.

This course covers Wide Area Network design and configuration. Various techniques and terms used to configure Wide Area Network include Frame Relay, ISDN (type of A network connection), and Point-to-Point protocol are discussed.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 186

Introduction to Oracle: SQL and PL/SQL

4 UNITS - (A)

An extensive introduction to data server technology. The class covers the concepts of both relational and object relational database and the powerful SQL and PL/SQL programming languages. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 187

Oracle DBA (Database Administration) Part 1A: Architecture and Administration

4 UNITS - (A)

Prerequisite: CO SCI 186 with a satisfactory grade or better or equivalent.

This course is designed to give the students a firm foundation in basic administrative tasks and the necessary knowledge and skills to set up, maintain, and troubleshoot an oracle database. The students learn to use an administration tool to startup and shutdown a database, manage file and database storage, and manage users and their privileges.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 188

Oracle DBA (Database Administration) Part 1B:

Backup and Recovery

3 UNITS - (A)

Prerequisite: CO SCI 187 with a satisfactory grade or better or equivalent.

This course focuses on planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various database backup, failure, restore and recovery scenarios. In hands-on exercises, students examine backup methodologies based on mission critical requirements of business enterprises.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 189

Oracle DBA (Database Administration) Part 2:

Performance and Tuning

3 UNITS - (A)

Prerequisite: CO SCI 187 with a satisfactory grade or better or equivalent.

This course will introduce students to a series of tuning steps, which can be used to improve the performance of the Oracle Server. The focus is on database rather than specific operating system performance issues. Using a variety of tools, students also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 191

Programming Laboratory

1 UNIT -  (RPT 3) (A)

Co-requisite:  Concurrent enrollment in any CSIT course other than CO SCI 100, 191, 192.

This is a programming laboratory is designed to provide the student an opportunity to apply the computer concepts being studied in a concurrent CSIT lecture/discussion class section.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 192

Programming Laboratory

1 UNIT -  (RPT 3) (A)

Prerequisite: Open to students who have repeated CO SCI 191 three times.

Co-requisite:  Concurrent enrollment in any CSIT course other than CO SCI 100, 191, 192.

This is a programming laboratory is designed to provide the student an opportunity to apply the computer concepts being studied in a concurrent CSIT lecture/discussion class section.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY  195

Computer Networking V:CCNP Cisco Networking Academy Program, Advanced Routing

Corrections Institutions

3 UNITS -  (A)

Prerequisite: CO SCI 184  with a satisfactory grade or better or equivalent.

This course covers configuration of various routing protocols that include Open Shortest Pass First (OSPF), Enhanced Interior Gateway Routing Protocol (EIGRP), and Border Gateway Protocol (BGP).  Route optimization and security are also discussed.  This course also provides students with the knowledge and skills to pass the CCNP Routing Exam and further the students’ career opportunities in computer networking.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 196

Computer Networking VI:CCNP Cisco Networking Academy Program, Remote Access

3 UNITS -  (A)

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.

This course will provide students with an overview of remote access technologies and their relationship to the Cisco Internet network Operating System.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 197

Computer Networking VII: CCNP Cisco networking Academy Program, Switching

3 UNITS -  (A)

Prerequisite: CO SCI 195 with a satisfactory grade or better or equivalent.

This course covers all the major topics on the Cisco Switching exam, including switched Ethernet, trunking, multicasting, multilayer switching, Virtual Local Area Networks (VLANs), inter VLAN routing, Hot Standby Routing Protocol, network traffic control, monitoring, and troubleshooting techniques.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 198

PL/SQL Programming for Oracle

3 UNITS - (A)

Prerequisite: CO SCI 186 with a satisfactory grade or better or equivalent.

The Oracle PL/SQL language provides for programming logic features not contained within SQL.  The grammar, .syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.  Create and manage user defined packages and Oracle supplied packages.  Create functions and procedures to encapsulate business functionality.  Enables skills to sit for Oracle Developer Certification.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 199

Oracle Forms and Reports

3 UNITS - (A)

Prerequisite: CO SCI 198 with a satisfactory grade or better or equivalent.

To enable the creation, manipulation, extraction of data from an Oracle database using the Oracle Forms & Reports Interfaces. The course takes you through creating basic forms and reports and enhancing them to create the basis of complex applications incorporating formatting techniques and images, logos and objects. This course will enable the student to take the Oracle developer