The course introduces relational and object-oriented database concepts and SQL. Students design, implement and populate databases, and write simple queries using an industry-standard database such as MySQL, MSSQL Server or Oracle.
This course introduces the functional parts of a computer from a hands-on perspective. Students learn to identify computer components, disassemble machines, carry out common hardware and software maintenance tasks, install operating systems, select and install hardware upgrades, troubleshoot common hardware and firmware problems, and build computers.
Systems Analysis and Design
In this integrative course, students learn formal methods to gather requirements for a project, model an existing system or business process, develop solution concepts, and plan the engineering, development, rollout, timeline and training process for the introduction of a new technology or solution. A hands-on approach to systems analysis and design is used throughout the course, with specific attention paid to understanding and creating Unified Modeling Language (UML) diagrams.
This course introduces information security as a discipline and profession. Topics include information security fundamentals and security threats, defenses and countermeasures for personal, enterprise and network security. Assets such as desktops, laptops, network servers and removable media are analyzed for common security pitfalls. Students explore measures for protecting those assets and the information they contain. Best practices, policies and procedures for information security are discussed, analyzed and evaluated in terms of return on investment.
Students design and implement database solutions to meet end-users’ needs. Using an industry-standard database such as MySQL, MS-SQL Server or Oracle, students explore the syntax of SQL, with an emphasis on the development of queries and reporting. Additional topics include normalization and de-normalization of data, retaining history and managing transactions.