San Jose City College

Students will learn how to create a database, implement using SQL (Structured Query Language), and create access to the Internet. Students will study database concepts, structure, access methods, and design considerations. The class will focus on object-relational databases.

Students acquire the hands-on skills needed to diagnose hardware problems, configure PC components, and replace defective computer parts. Students learn how to install boards, configure multiple hard drives, add peripheral devices, work with network adapters, solve basic printer problems, and modify CMOS setups. Other topics include diagnostic software, hardware procedures, virtualization and hard drive imaging. This class prepares students for the CompTia A+ certification exam.

Prerequisite: CIS 062A with C or better

Students will study how to use JavaScript to create dynamic web pages, and how to add animation and interactivity to make Web pages come alive. Students will learn how to use Document Object Model (DOM), Browser Object Model (BOM), and Dynamic HTML (DHTML) to be able to develop well-formed web pages.

Recommended: CIS 041 or CIT 010

Students acquire the hands-on skills to diagnose, load and set up a wide array of operating systems. Topics include the use of the command prompt, essential utilities, boot files, file systems, OS installation procedures, Windows configuration, hard disk partitioning, backup, disaster recovery, virtualization, and hard disk imaging solutions. This class prepares students for the CompTia A+ certification exam.

Prerequisite: CIS 062A with C or better

Students study advanced JavaScript techniques to develop code for real applications. Topics include forms, validation, cookies, hierarchical menus, XML, security, style sheets, browsers, and DOM (Document Object Model) programming.

Students acquire skills needed to install and upgrade Microsoft SQL database. Topics include database storage configuration, database backup and restore, data security, disaster recovery, data replication, high availability, and troubleshooting. Students study guidelines for effective data management and administration of SQL server environment.

Prerequisite: CIS 017B with C or better

Students will study Perl, the leading web-server dynamic language used in the industry. Knowledge of Perl will prepare students to use this leading web technology to develop, create, and maintain industry standard web sites across all computing platforms.

Visual Basic is a programming language that allows rapid development of the Microsoft Windows graphical user interface. Students will learn to use Visual Basic .NET concepts, tools, and programming methodology to create user friendly Microsoft Windows applications.

Students will learn PHP programming to develop, create, and maintain industry-class web sites. Topics include mixing PHP and HTML, building web pages, and developing web browsers.

Students are introduced to the Java programming language, data types, and control structures using an object-oriented approach. Topics include problem solving, classes, methods argument passing, Graphical User Interface (GUI), input/output, Java libraries, applets, and exception Handling.

Recommended: CIS 041 or equivalent

Students will study the use of Python, a programming language, to create stand-alone and web-based applications. Students will acquire skills necessary to locate, evaluate, and utilize open source web materials.

Recommended: CIS 041 or CIT 010

Students are introduced to the Unix/Linux operating systems. Topics covered include a basic editor, shells, directory and file structure, file permissions, passwords, security, redirection, pipes, filters, regular expressions and shell programming. Additional topics include the use of I/O devices, Internet access, and an introduction to system Administration.

Students learn to use and integrate the technologies that form the foundation of Web 2.0 (such as HTML, CSS, HTTP, JavaScript, XML, Server-Side Programming, etc.) to produce rich web applications.

Students study the concepts of Linux system administration. Topics include Linux installation, Unix/Linux file systems, managing user accounts, user shells, security, system resources, device administration, system and file backup and restore, printers and print spooling systems, TCP/IP network configuration and/or management, network access using telnet and ftp, ssh (secure shell), interface to networks using NFS 3 and SAMBA, electronic mail systems, system kernel builds, and system tuning. Students use shell scripts to demonstrate system administration.

Prerequisite: CIS 157 with C or better

Students will acquire skills installing, planning, implementing, configuring and maintaining the Windows Server operating system. Students are introduced to Active Directory and account management, printing, managing data storage, network services, deploying Internet Information Server (IIS) services and Certificate Authority, remote access services, server and network monitoring. The course also includes information on virtualization, application services, data provisioning, backup and data recovery, and managing system reliability and availability.

Prerequisite: CIS 017A with C or better

Students learn and apply SQL (Structured Query Language), to access and manipulate relational databases. Topics include simple and multiple queries, database creation, dynamic and embedded SQL, and data warehousing.

Students learn various aspects of planning, implementing, configuring, and maintaining Microsoft Windows Active Directory infrastructure. Students will acquire skills of active directory design and security concepts, account management, and group policy configuration. Students will also learn new features of Windows Active Directory such as active directory federation services, active directory certificate services, and read only domain controllers.

Students learn to create effective and rich application experiences for mobile web browsers. Students also learn how to create offline applications that will be installed in the mobile device.

Students acquire in-depth knowledge of Windows Server, TCP/IP
networking, Domain Name System (DNS), Dynamic Host Configuration
Protocol (DHCP), Active Directory Domain services, file services, printers
and print services, network policy and access service, security, and
managing the Windows server network infrastructure.

Prerequisite: CIS 017B with C or better

Students will learn basic computer concepts with an emphasis on both the personal computer and enterprise computing. Students cover topics including hardware, application and system software, the internet and World Wide Web, communications, e-commerce, societal issues, database management, systems analysis and design, programming, information systems, career opportunities, certifications in the computer field, and computer trends. Student get hands-on practice of introductory level skills in word processing, spreadsheets, database, presentation graphics, and use of the internet. Students will be exposed to a programming language.

Students are introduced to the fundamentals of networking concepts and technologies. Students acquire the skills necessary to plan and implement small networks across a range of applications. Topics include the OSI model and industry standards, network topologies, IP addressing, subnet masks, networking components, and basic network design.

Recommended: CIS 041 or equivalent

Students will study how to build and maintain industry-class websites. Students will study the basics of open-source web-server (Apache). Students will gain knowledge to use and implement the most widely used open-source server-side scripting language (PHP) along with the most popular open-source relational database (MySQL).

Students acquire knowledge of how a router "learns" about remote networks and determines the best path to those networks. Students study topics including both static routing and dynamic routing protocols. Students acquire the skills necessary to plan and implement small networks using Cisco IP routers and basic switches.

Prerequisite: CIS 018A with C or better

Students will study C, a general-purpose programming language that features brevity of expression, modern control flow and data structures, and a rich set of operators. Students will also study C++, an object oriented programming language that is built using the C language as a base. Students will learn the importance of portability and efficiency through a variety of programming assignments. This course includes application programs and/or systems software.

Recommended: CIS 041 or equivalent

Students learn the design of a Local Area Network (LAN) and prepare for the Cisco Certified Network Associate (CCNA) test. Students will design and configure an actual network for a typical LAN. Topics covered include IPX addresses and access lists, advantages of LAN segmentation using bridges, routers, and switches. The course also covers features and benefits of Fast Ethernet connections and Virtual Local Area Networks (VLANs). (The course is a part of the CISCO Academy.)

Prerequisite: CIS 018B with C or better

Students learn a language-independent treatment of topics including computer organization, data formats, recursion, and abstract data types. Data structures covered include abstract data types, arrays, pointers, link lists, stacks, queues, trees, heaps, hash tables, and graphs. Applications of recursion are discussed in detail. Techniques for sorting and searching, as well as measuring algorithm performance and data structure efficiency using Big-O notation, are presented.

Prerequisite: CIS 054 or CIS 084, both with C or better

Students acquire knowledge of (Wide Area Network) WAN technology used to provide network access to resources across large geographical locations. Students study topics including network security and dynamic IP addressing services that are necessary to implement small networks for a range of applications. Students learn to implement WAN using Cisco networks.

Prerequisite: CIS 018C with C or better

Students learn the fundamentals and techniques of Object Oriented Programming (OOP). Topics covered include the elements of OOP, classes and objects, inheritance, polymorphism, overloading, overriding, member functions, member access, virtual functions, constructors, derived classes, dynamic objects, and exception handling. Modern programming and debugging techniques will be stressed throughout the course. Design Patterns and UML will also be introduced.

Prerequisite: CIS 054 or CIS 084 both with C or better

Students will create their own XML documents, XML document type definitions, and schemas to describe their structure and content in building dynamic web pages. Students will also discover how to use cascading style sheets (CSS) to render XML documents using an ordinary web browser.

Students apply the concepts of the systems analysis development cycle which includes problem definition; data collection, and analysis, analysis of system alternatives, determination of feasibility, development of the system proposal, pilot or prototype systems development, systems design, program development, systems implementation, systems review, and evaluation.

Recommended: CIS 041 or equivalent

Students will study XML markup language to develop advanced, real world applications. Topics will include XML schema languages, web services, APIs, and databases.

Students acquire basic hands-on skills to operate and support today's personal computer (PC) hardware. Students study the hardware architecture and major components of the PC including diagnostic tests, processors, motherboards, memory, storage devices, peripherals, and video. This class is the first step towards acquiring the skills needed for the CompTia A+ certification.