San Jose City College

Students will study the principles and protocols of the Internet. Students learn methods used to move data from one location to another over the Internet including TCP/IP, Internet security, routing, DHCP, DNS, and VPN.

Students acquire skills installing, planning, implementing, configuring and maintaining the Windows operating system. Students are introduced to remote desktop and virtual mode, printing, managing data storage, network services, speech recognition, remote access services, and network monitoring. The course also includes information on virtualization support, backup and data recovery, and managing system reliability and availability.

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.

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.

This is the first of three courses for the Cisco Certified Network Associate (CCNAv7) Program. 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, IPv4, IPv6, subnet masks, networking components, and basic network design. Students will learn the architecture, structure, functions, and components of the Internet and other computer networks. Students achieve a basic understanding of how networks operate and how to build simple local area networks (LAN), perform basic configurations for routers and switches, and implement Internet Protocol (IP).

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.

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.)

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

Students will learn the essential concepts of XML technologies by creating XML documents, using Document Type Definitions (DTDs) and Schemas to validate XML documents, and creating their own DTDs and Schemas thereby defining the rulebook for the structure and content of XML documents. Students will also learn the basics of XPath to locate and extract content from an XML data file, use XLink and XPointer to link content, use SVG to create graphics and icons using XML, and the basics of XSL to transform an XML document into other types of objects, such as web pages, computer scripts, emails, and books. Students will also learn how to use Cascading Style Sheets (CSS) to render XML documents using nothing but a text editor and a web browser.

Students will increase their knowledge and expertise in the essential concepts of XML technologies. Students will experience an in-depth deep dive into DTDs and Schemas to validate and analyze programmatically the structure of XML data. Students will learn the basics of computer programming, and build XML parsers to process and analyze XML files. Using XSLT, students will convert XML files into other files, such as computer scripts, and will build RESTful web applications using XML, PHP, and APIs.

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 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.

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 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.

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 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.

Students learn to use and integrate the technologies that form the foundation of Web 2.0 to produce rich web applications such as podcasts, blogging tools, XML, HTML, HTTP, and user interface.

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 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 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 will study how to manage 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 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.

Students will 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.

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.

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.

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.

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 current CompTia A+ certification exams.

Students will acquire skills to diagnose, load and setup 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, and disaster recovery. The Cloud, Virtualization, and hard disk imaging solutions will be discussed. This class prepares students for CompTIA's A+ certification exams.

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 apply effective data management and administration of SQL data environment.

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

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

As the third course in the Technest Coding Academy, students are exposed to the emerging platform called the Internet of Things (IoT). Topics include: exploration of the convergence of multiple disciplines leading to modern smartphones; exploring the emerging IoT platform, enabling unprecedented, innovative products and services; learn how information from physical devices in the real world gets communicated to smartphone processors; interfacing common sensors and actuators to hardware; developing software to acquire sensory data, process the data and actuate stepper motors, LEDs, etc. for use in mobile-enabled products.

Students will learn basic information security (Cyber-Security) 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.

This course is part of a series that aims to prepare students for a role as an entry-level IT Support Specialist. In this course, students will learn infrastructure services that keep all organizations, big and small, up and running, typical cloud infrastructure setups and how to manage cloud resources, how to manage and configure servers and how to use industry tools to manage computers, user information, and user productivity, and how to recover your organization's IT infrastructure in the event of a disaster.

This course is part of a series that aims to prepare students for a role as an entry-level IT Support Specialist. In this course, students will learn about IT security concepts, tools, and best practices. Topics will include: the manner in which threats and attacks manifest, an overview of encryption algorithms and how they're used to safeguard data, the three As of information security (authentication, authorization, and accounting), network security solutions ranging from firewalls to Wifi encryption options, and a multi-layered, in-depth understanding of security architecture followed by recommendations on how to integrate a culture of security into your organization or team.

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 study the concepts of Linux system administration. Topics include Linux installation, Unix/Linux file systems, managing user accounts, user shells, security, system resources, 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.

Students are introduced to the fundamental principles and topics of Information Technology Security and Risk Management at the organizational level. They will gain knowledge in hardware, software, processes, communications, applications, and policies and procedures with respect to organizational Cybersecurity and Risk Management. This course prepares students for the CompTIA Security certification exams.

Students will be introduced to the various methodologies for attacking a network. They will learn the concepts, principles, and techniques, as well as gain supplemental hands-on experience attacking and disabling a network within the context of properly securing a network. The course will emphasize network attack methodologies with the emphasis on student use of network attack techniques and tools, and appropriate defenses and countermeasures. Students will receive course content information through a variety of methods including lectures and demonstration of hacking tools in addition to a virtual environment.

Students will be introduced to the methods used to properly conduct a digital forensics investigation beginning with a discussion of ethics, while mapping to the objectives of the International Association of Computer Investigative Specialists (IACIS) certification. Topics covered include an overview of computer forensics as a profession; the computer investigation process; understanding operating systems boot processes and disk structures; data acquisition and analysis; technical writing; and a review of familiar digital forensics tools.

Description: This course introduces relational database concepts, design and administration. Students will learn the syntax and use of Structured Query Language (SQL) and how to install and run a relational database server such as MySQL and how to design relational database for applications.