wpe1.jpg (5401 bytes)

LOS ANGELES CITY COLLEGE | 08-09 CATALOG [REV. 11/08]

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
 

 PROGRAMS OFFERED

 

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.

 

 DEGREE PROGRAMS 

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

 

COURSES                                                                               UNITS

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 disci-pline, students may use Math 262, 263 and Physics 2, 3 as substitute to anyof the CO SCI requirements except CO SCI 139, CO SCI 140 (or 141), andCO 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 univer-sity. However, requirements vary depending upon the individual institution. Please consult with acounselor 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 competencyexam)

 

COMPUTER INFORMATION SYSTEMS

Associate of Arts Degree

Career Program

 

COURSES                                                                               UNITS

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/ASDegree 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

3Units           Humanities

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

3-4 Units    Health/Physical Education

3-5 UnitsMath Competency
 

 CERTIFICATE PROGRAMS 


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

APPLICATIONS SOFTWARE

Certificate

This sequence of courses prepares students for careers in applications soft-ware development and usage in fields related to databases, networking, webtechnologies, business analysis, and/or programming. Students success-fully completing this program will find opportunities for employment in variousindustries depending on the track chosen for the electives.

COURSES                                      UNITS

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 excit-ing tracks: Databases, Web Development, and Operating Systems. Successfulcompletion of the program will prepare students for an exciting career in soft-ware analysis, design, and development.

COURSES                                       UNITS

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, and169

 

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 Asso-ciate (CCNA) exam.

COURSES                                                                                         UNITS

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 upand administering Oracle relational databases and prepares students for theOracle professional certification in database administration.

COURSES                                                                               UNITS

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

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

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

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

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

 

Use Oracle Developer Suite 10g and deploy applications on the Web withOracle Application Server 10g. The students learn how to build forms andreports and use the web to access them.

 

 

 

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.

COURSES                                                                                             UNITS

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, sci-ence, and industry both in servers and in desktop applications. Almost 70%of the Internet’s World-Wide Web servers are driven by some version ofUNIX or LINUX. UNIX is used in specialty desktop systems that require com-plex graphics or scientific processing. In servers, UNIX supports web ser-vices, database systems, advanced scientific computing, and vast commu-nications networks. UNIX can be used in cluster systems requiring thou-sands of processors or in small embedded systems involved in simple ro-botic applications. It is the system of choice for the vast majority of universityapplications.

 

COURSES                                       UNITS

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

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

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

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

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

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

Total Units.............................................................................................18

 

WEB client technologies

Skill Certificate

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

 

COURSES                                       UNITS

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 websites. These include the use of CGI scripts, Active Server Pages, and Data-base Servers to create realistic e-commerce sites. Server-side conceptsrelated to the Windows and Unix operating systems are covered. Studentswill also get introduction to the Oracle’s database technology and how todevelop dynamic, interactive and scalable database-driven Web applica-tions.

 

COURSES                                                                               UNITS

 

COURSES UNITS

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

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

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

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

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

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


 

 

 COURSE DESCRIPTIONS 

 

NOTE: Not every class is offered each semester. Refer to the current classschedule for current class offerings.PREREQUISITES: Specified prerequisites must be completed with a satis-factory 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 inother computer-related courses by providing tutorial and self-help assistancewith 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 computerhardware, software, terminology, ethics, and societal impact. Students willoverview operating systems, word processing, spreadsheets, database man-agement systems, telecommunications, and networks.

 

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 103

Introduction to Computer Systems for MIS

4 UNITS -  (UC:CSU)

Advisory: English 73.

Advisory: English 73.An introduction to computers for a one-semester transfer course or for cer-tificates or a degree in CSIT. Topics include computers, programming andsystems design, programming languages and flowcharting. Laboratory in-cludes word processing, spreadsheets, database concepts and extensiveprogramming 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 writ-ing 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 soft-ware engineering. Includes program design, development, style, testing,documentation, algorithms, control structures, sub-programs, and elemen-tary 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 micro-computer 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 orequivalent.

Fundamental principles functions, application and use of operating sys-tems such as DOS, UNIX, Windows 98/NT/2000, and Netinase and re-lated applications software. Analysis of capabilities and limitations of thedifferent operating systems and environments. Applicable to A+ certifica-tion 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, andanalysis 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 programminglanguage 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 bet-ter or equivalent.The course provides students the ability to write computer programs in alanguage 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. Thecourse emphasizes superiority of C++ to C as a general purpose program-ming language because of its new features and C++ as an object orientedprogramming 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 betteror equivalent.Advisory: CO SCI 107 and CO SCI 104.An introductory university-level course of a leading-edge programming para-digm object-oriented programming that is truly portable and therefore ap-propriate for implementing internet-based and World-Wide Web based ap-plications.

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 theintroductory 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 tacklethe 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 ReportLanguage (PERL), a standard tool for UNIX server administration and serverside 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 equiva-lent.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)

Advisory: CO SCI 103 or CO SCI 108 with a satisfactory grade or better orequivalent.This course provides an extensive practical and theoretical framework forusing Macromedia’s Dreamweaver to develop web sites. It includes en-hancements for web page layout, coding, and webmaster-user interactivity.

 

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 152

Macromedia Flash

3 UNITS -  (A)

Advisory: CO SCI 151 with a satisfactory grade or better or equivalent.This course covers Macromedia’s Flash; a state-of-the-art Web animationsoftware for creating highly compact, vector-based content for transmis-sion over the Internet. Topics include introduction to ActionScript, EventHandlers, objects and Dynamic Data.

 

 

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 bet-ter or equivalent.

This course offers hands-on experience in designing and implementingbusiness-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 XMLdocuments that enable the structured delivery of data and information overa corporate intranet, the internet, or for simple XML messaging betweenHTTP servers. The course also provide skills to build business-to-busi-ness 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 ofhypermedia composition, lists, tables, graphics, maps, frames, forms andform processing. CGI, web site management, and an overview of moreadvanced 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 pagesconstruction including multimedia developments, plug-ins, helper applica-tions, CSS, DHTML and new developments. Students will complete webprojects with emphasis placed upon recent developments in students andsoftware.

 

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 160

Business Systems Design

3 UNITS -  (CSU)

This course covers the fundamentals of business systems analysis anddesign. It defines the core of the systems analyst, and describes experi-ence 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 gradesor better or equivalent.Advanced course focusing on graphical user interface theory and operat-ing system environment maintenance, contrasting DOS interface withgraphical user interface, reviewing DOS fundamentals, introducing Win-dows applications use and installation and covering communications, macrogeneration, object embedding, memory management and network configu-rations.

 

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 commandsand 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 serverrunning 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 ad-dition and management, system disk drive installation and preparation,application installation, network installation and configuration, printer at-tachment, booth procedures and scripting, and management of event log-ging. The student builds a UNIX server from scratch and configures it torequired specifications.

COMPUTER SCIENCE/INFORMATION TECHNOLOGY 171

UNIX System Security

3 UNITS

Covers both theoretical and practical aspects of UNIX system security, in-cluding UNIX password systems, file system hardening, crytography basics,physical security for hardware, protocol security, network authenticationmethods, secure programming and account defense.

 

 

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 equiva-lent.This course covers fundamentals of computer networking. Topics includeevolution of networking, seven layers of the OSI reference model, and net-working devices such as bridges, hubs, switches, and routers. Internet pro-tocol, IP addressing, subnetting, network topology, and cabling will also becovered.

 

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 in-clude router fundamentals, router setup and configuration, network man-agement, 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 proto-cols. 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. Varioustechniques and terms used to configure Wide Area Network include FrameRelay, ISDN (type of A network connection), and Point-to-Point protocol arediscussed.

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 theconcepts of both relational and object relational database and the powerfulSQL and PL/SQL programming languages. Students are taught to createand 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 ad-ministrative tasks and the necessary knowledge and skills to set up, main-tain, and troubleshoot an oracle database. The students learn to use anadministration tool to startup and shutdown a database, manage file anddatabase 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 andrecovery strategies. The class addresses backup and recovery techniquesand examines various database backup, failure, restore and recovery sce-narios. In hands-on exercises, students examine backup methodologiesbased 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 beused to improve the performance of the Oracle Server. The focus is on data-base rather than specific operating system performance issues. Using a va-riety of tools, students also learn how to recognize, troubleshoot and resolvecommon 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 SCI100, 191, 192. This is a programming laboratory is designed to provide thestudent an opportunity to apply the computer concepts being studied in aconcurrent 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 SCI100, 191, 192.This is a programming laboratory is designed to provide the student an op-portunity to apply the computer concepts being studied in a concurrent CSITlecture/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 includeOpen Shortest Pass First (OSPF), Enhanced Interior Gateway Routing Pro-tocol (EIGRP), and Border Gateway Protocol (BGP). Route optimizationand security are also discussed. This course also provides students withthe knowledge and skills to pass the CCNP Routing Exam and further thestudents’ 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 tech-nologies and their relationship to the Cisco Internet network Operating Sys-tem.

 

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, includ-ing switched Ethernet, trunking, multicasting, multilayer switching, VirtualLocal Area Networks (VLANs), inter VLAN routing, Hot Standby Routing Pro-tocol, 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 notcontained within SQL. The grammar, .syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. Cre-ate 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 data-base using the Oracle Forms & Reports Interfaces. The course takes youthrough creating basic forms and reports and enhancing them to create thebasis of complex applications incorporating formatting techniques and im-ages, logos and objects. This course will enable the student to take theOracle developers exam.Chair: Roger Wolf

  

 

RETURN TO TOP OF PAGE

 

 

C A T A L O G   I N D E XR E T U R N  T O  L A C C   H O M E   P A G E  |   C A T A L O G  /  C L A S S  S C H E D U L E 

 

An Urban Oasis of Learning