In this course, students explore concepts, design, documentation, and implementation of various database systems, including proprietary and open source technologies. Students implement Structured Query Language (SQL) to store, retrieve, and manipulate data. Students create queries, normalize database structures, and create stored procedures. Upon completion of this course, students will be prepared to develop and maintain databases used in application development.

In this course, students explore the Gateway Technical College community. They examine college resources and services, investigate skills that lead to academic success, and identify strategies for achieving educational and personal goals.

Focus will be on project management from the information systems professional perspective while keeping a customer-based orientation and business focus. Cooperative team-based business strategies will be stressed. Students will develop written and oral communications, as necessary, to complete the steps within the project management process. Project management software will be utilized, within all phases of the systems development as the students progress through a team-based project simulation.

This course introduces students to some of the major theories and topics of psychology, including the physiological basis of behavior, personality and learning theories, memory, states of consciousness, stress, research methods, intelligence, human development, psychopathology, and social behavior.

This capstone class will provide students with opportunities to apply knowledge and concepts acquired in program coursework. Students will develop proficiency while resolving issues in a simulated, scenario-based environment. In addition to reinforcement of concepts previously covered in the curriculum, the course will include employment seeking skills (resumes, portfolios, interviewing), image creation and deployment, and remote desktop diagnostics/troubleshooting.

Students will research, explore and evaluate new and future hardware and software advancements and trends. Areas to investigate may include contemporary package development applications, collaboration tools, reporting software, and innovative equipment and hardware, as well as new versions of current standards in software and applications.

In this course, learners are introduced to the interconnection of data, people, processes and things that forms the Internet of Things (IoT). Learners will differentiate among smart devices, connected devices, and Internet of Things (IoT) devices. Machine-to-machine (M2M), machine-to-people (M2P), and people-to-people (P2P) connections in an IoT solution will be examined. Security concerns that must be considered when implementing IoT solutions will be investigated. Upon completion of the course, learners will be able communicate with data over networks to IoT frameworks.

This capstone class broadens the students' customer service skill set. The course continues to build on end user communication methods, both oral and written. Students will be exposed to Information Technology Infrastructure Library (ITIL) methodology and Help Desk Institute (HDI) best practices.

Focus will be on desktop data security, data retention and recovery. Students will be introduced to computer forensics / data recovery tools, local security issues, disaster recovery plans and legal data requirements (i.e. HIPPA requirements, Sarbanes-Oxley Act, etc.).

Students will learn to resolve operating system and application issues by telephone, remote access, or by visiting an end user's desktop. Students will gain a working knowledge of operating in a workgroup and a client/server environment. NOTE: This course will help prepare the student to take the Microsoft Certified Desktop Technician Exam 70-272.