Introduction to Relational Databases
In this course, students learn to appreciate the exponentially increasing amounts of user data and the resulting databases required to support the integral functions expect in today’s web applications. This course serves as an introduction to database management systems and how they serve as the necessary tools to collect, store, manage, disseminate, and mine datasets to extract useful data in a timely manner, avoiding data from becoming a liability where the cost of its acquisition and management far exceeding the derived value. Starting with a historical overview of the evolution of data management models and following up by a focus on the design and development of specific databases adhering to the relational model, students are given the opportunity to design and implement relational databases in a Microsoft Access environment.
Advanced Database Systems
The course helps students to develop advanced skills in database design, implementation, and management. Students will learn the differences between the SQL-based systems and the new and emerging NoSQL systems that offer more scalability and performance improvements standard SQL systems, and increasingly important factor when dealing with companies that churn out vast amounts of data daily. The course utilizes case studies and real-world examples to compare the pros and cons of both systems. Students will also learn to build on Entity-Relationship modeling concepts taught in the prerequisite course; Introduction to Relational Databases, as well as being introduced to emerging NoSQL concepts using the popular MongoDB suite of applications.
Information Systems Analysis
This three-unit course provides students with the tools and techniques for analyzing information systems requirements. In systems analysis fundamentals stresses the basics that students need to know about what an analyst does; how information systems fit into organizations; how to determine whether a systems project is worthy of commitment; and how to manage a systems project. Information requirements analysis emphasizes the use of systematic and structured methodologies for conducting such requirements analysis. The final unit deals with the analysis process and building on the previous two units, moving students into the data flow analysis and decisions, but structured and semi-structured, through the use of data flow diagrams.
Introduction to Network Technology
The course is intended for the administer networks and support filed. Through a combination of lectures, demonstrations, discussion, and hands-on labs, students are given an introduction To technology in order to acquire a foundation in current network technologies for the internet, local area networks (LANs), and wide area networks (WANs). Additionally, the course give student an introduction into hardware, software, terminology, components, design, and connections of a network, as well as the topologies and protocols for LANs. It will cover LAN-user concepts and the basic functions of system administration and operation, although the course emphasis would be on hardware and protocols. Special attention will be given to MAC addressing and ports, and IP sub-netting.
Management Support Systems
This course relates to the use of information Technology to support management in the decision-making process. Furthermore, it focuses on Recognizing Types of decision support, the use of big data for decision support, analytics, and business intelligence.
Systems Design and Implementation
This course is designed to provide students with appropriate tools and techniques for information design and implementation by covering topics such as: Information design methods and techniques; Input and output design; File and database design; User interface design; Data-entry procedures design; Quality Assurance; System implementation; and Object-oriented design