Page 168 - Course_Catalog_2020-2021
P. 168
CIS 64B Introduction to SQL 4 1/2 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 64A.
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter). Introduction to Oracle SQL (Structured Query Language), DML (Data Manipulation Language) processing techniques, DDL (Data Definition Language) techniques, selecting and sorting data, joins, SQL functions, Oracle objects, Oracle data processing concepts to maintain large database systems.
CIS 64C Introduction to PL/SQL 4 1/2 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 64B.
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter). This course covers Oracle PL/SQL features including data definition and data manipulation using expressions, control structures, and Oracle objects. Error handling, predefined packages, triggers, transactions, and advanced PL/SQL features are also covered.
CIS 64D Database Tuning 3 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 64C.
Three hours lecture (36 hours total per quarter).
Emphasis on importance of Performance Tuning, techniques for tuning several Oracle components, optimizing database for high volume transactions and Data Warehouses.
Coverage of systems programming in the Unix/Linux/Posix environments, with emphasis on low-level Unix/Linux/Posix system calls from C programs and Shell C scripts. Discussion of differences in major Unix/Linux/Posix environments.
CIS 74 Software Quality Assurance 4 1/2 Units
Advisory: CIS 40 and CIS 89A.
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter). Software testing basics - equivalence classes, boundary values, edge cases, corner cases, positive vs. negative tests, verification vs. validation, black-box testing, white-box testing, gray-box testing, smoke testing, alpha vs. beta testing, requirements documents and traceability matrices; justification for testing software; types of testing - accessibility, functional, security, performance, visual; breaking software and defect reporting; test-driven development; test case management (TCM) tools; and automating tests for web applications.
CIS 75A Internet Concepts and TCP/IP Protocols 5 Units
Prerequisite: CIS 66.
Advisory: CIS 22A, 26A, 36A or 40; EWRT 211 and READ 211, or ESL 272 and 273. Five hours lecture (60 hours total per quarter).
The architecture and underlying protocols of the Internet. The Internet will be examined as a layered product. Layers discussed will include mid-level packet delivery and address computation and high-level client/server applications using the TCP/IP Protocol Suite.
CIS 75B Internet Programming with TCP/IP 4 1/2 Units
Prerequisite: CIS 26B or CIS 26BH.
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 75A.
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter). This course covers writing client/server applications using the TCP/IP protocol suite. All server classes - “well known”, iterative, concurrent, and polling - will be explored and used. Typical Internet programming problems will be addressed including resource availability, machine addressing, and differences in data representation between communicating computers.
CIS 75D Enterprise Security Policy Management 3 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 75A or equivalent experience.
Two hours lecture, three hours laboratory (60 hours total per quarter).
Concepts of how to secure an enterprise by creating a security policy and developing procedures to maintain that security policy. Perform risk analysis and assessment on enterprise security. System Administrators, IT Managers, and Analysts would benefit from this course, as well as Technologists wanting to broaden their impact.
CIS 75E Enterprise Emergency Response 2 Units Planning
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Two hours lecture (24 hours total per quarter).
An exploration of how to plan for emergency response, recover from a disaster and how to mitigate risks. System Administrators, IT managers and Analysts would benefit from this course, as well as Technologists wanting to broaden their impact.
CIS 64E
Fundamentals of Large Scale Cloud
4 Units
Computing
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Four hours lecture (48 hours total per quarter).
This course addresses the fundamental challenges in the design, implementation, and deployment of large-scale distributed systems. Concepts covered include concurrency, synchronization, connection establishment, event handling, inter process communication, storage management, and service registration, discovery, and lookup. It also covers issues related to distributed objects such as life cycle management, mobility, security, naming, location, evolution, and autonomy.
CIS 64F Introduction to Big Data and Analytics 4 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Four hours lecture (48 hours total per quarter).
Introduction to Big-Data deluge, management of unstructured and structured data and design of large scale database systems. Concepts covered include Map-reduce parallel processing algorithms, Real-time analytics, classification, and predictive analytics, attributes of Big-Data and related issues. Introduction to large scale file systems and operations and parallel processing algorithms.
CIS 64G Data Visualization Methodology 4 1/2 Units and Tools
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Four hours lecture, one and one-half hours hours laboratory (66 hours total
per quarter).
This course is an introduction to the strategies and technologies used in business intelligence reporting and dashboards for making data-driven decisions.
CIS 64H R Programming 4 1/2 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273; CIS 22A or CIS 36A or CIS 40.
Four hours lecture, one and one-half hours hours laboratory (66 hours total per quarter).
This course is an introduction to the R programming language and its utility in big data analytics. Topics covered include data objects, data cleansing, merging and sorting, statistical analysis of data, data graphics and visualization, and working with R-Studio.
CIS 77
CIS 77X
CIS 77Y
Prerequisite: Consent of instructor and division dean.
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Three hours laboratory for each unit of credit (36 hours total for each unit of credit per quarter). (Hours to be individually arranged.)
Design, implement, and document a special computer programming project.
CIS 79 Managing Technology Projects 4 1/2 Units
Advisory: EWRT 211 and READ 211, or ESL 272 and 273.
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter). Introduction to the theory and practice of the design and management of technology projects, including planning, performing, and monitoring of projects. Subjects explored are estimating costs and schedules, analyzing client expectations, guiding diverse groups of people toward a common goal, while earning a profit. Use of common software packages for project management.
CIS 66 Introduction to Data Communication and Networking
5 Units
Advisory: EWRT 200 and READ 200, or ESL 261, 262 and 263; CIS 3 or CIS 93. Five hours lecture (60 hours total per quarter).
Concepts of communication, data communications, and networks. Overview of connectivity options, common protocols, local and wide area networks.
CIS 67A Local Area Networks
4 Units
Advisory: CIS 66.
Four hours lecture (48 hours total per quarter).
Fundamental concepts of Local Area Network architecture and protocols. Emphasis on basic concepts needed to design, configure, and implement Local Area Networks. Emphasis on the evolution of Fast Traditional Ethernet, Fast Ethernet, Gigabit Ethernet, Ten-Gigabit Ethernet, ATM, and wireless LANs.
CIS 82W
Current Topics in Computer Information Systems
CIS 67B Introduction to Wide Area Networking
4 Units
CIS 82X
CIS 82Y
CIS 82Z
Credit course - Does not apply to De Anza associate degree. Requisite/Advisory: None.
Advisory: CIS 67A.
Four hours lecture (48 hours total per quarter).
Fundamental concepts of telephony, telecommunication, and wide area networking. Emphasis on analog and digital transmission techniques. Emphasis on circuit- switching and packet-switching. Exploration of optimization in telecommunication.
CIS 73 Unix/Linux Systems Programming 4 1/2 Units
Prerequisite: CIS 18A and CIS 26B (or CIS 26BH).
Four hours lecture, one and one-half hours laboratory (66 hours total per quarter).
2O20-2O21 DE ANZA COLLEGE CATALOG
167
All courses are for unit credit and apply to a De Anza associate degree unless otherwise noted.
Special Projects in Computer Information Systems
1 Unit
1 Unit
2 Units 3 Units 4 Units
One hour lecture for each unit of credit (12 hours total for each unit of credit
per quarter).
A planned program of exposure to fundamental concepts and applications of selected Computer Information Systems topics. Concepts and theories as applied to the specific topic.
2 Units 3 Units