Courses Minor: Data Management

Learners in this course evaluate and perform linear, exponential, logarithmic, and other mathematical functions that include algebraic, graphic, and numeric properties. Learners then apply these concepts to the social and natural sciences, business, and everyday life.

Learners build an understanding of mathematical analysis techniques. Learners apply number logic and set theory, functions and sequences, relations equivalence, partial order, digraphs, recurrence relations, counting techniques, logic and techniques of proof, graphs, and algorithms to the fields of business and information technology. Prerequisite(s): MAT1050.

Learners in this course use fundamental terminology, concept analysis, and practical knowledge of the components of computing systems to develop their understanding of the information technology field. Throughout the course, learners also build, demonstrate, and apply skills needed for professional communication. For BS in Information Technology learners only. Must be taken during the learner’s first quarter. Cannot be fulfilled by transfer or credit for prior learning.

This course is an introduction to the fundamental concepts of databases and database management systems (DBMS). Learners demonstrate vocabulary, component requirements, sorting and querying, and maintenance of simple databases using the fundamentals of database manipulation. Learners also apply Structured Query Language (SQL) and relational database management systems (RDBMS).

This course introduces learners to the programming discipline and prepares them to serve as Java programmers. Learners study and apply the fundamentals of the Java programming language such as data types, variables, expressions, statements, and methods. Learners also examine and practice the Java-object-oriented features of classes and objects. The course offers numerous opportunities for analyzing, designing, coding, testing, debugging, and evaluating Java programs in an authentic Java development environment.

Learners gain an understanding of the key concepts underlying Local Area Network (LAN), Metropolitan Area Network (MAN), and Wide Area Network (WAN). Learners examine the layered architecture of the network protocol stack, including the OSI and the TCP/IP models, and apply the principles of designing networks and implementing network protocols. Learners also apply topics of network topologies, cloud computing, networking devices, cabling, and basic network security.

Learners analyze core enterprise organizations, business processes, and information technology infrastructures. Learners apply their knowledge of the relationships between an enterprise organization’s business and information technology goals with IT operational models. IT ethical principles integrated throughout the class include examination of IT codes of ethics, ethical issues involving the use of employer resources, and examination of web technology and cybercrime.

In this course, learners build fundamental web design and development skills. Using a local development environment, learners develop websites using HTML and apply styling to each page using CSS. Learners develop client-side scripting using JavaScript to enable website interactivity and to enhance the user experience. Finally, learners deploy their websites to a cloud environment for testing. Prerequisite(s): Completion of or concurrent registration in IT1006.

In this course, learners evaluate the analysis and design of system industry standards and best practices. Learners research key components of system analysis including determining system objectives, business rules, and the identification of stakeholders. Learners also investigate human interface technologies and diverse human factors for a more engaging user experience. Learners apply their knowledge by creating a Software Development Plan (SDP) with components including identification of an agile methodology, system scope, technical standards, activity diagrams, logical process validation, and maintenance expectations.

In this course, learners demonstrate their knowledge of hardware and operating systems, focusing on peripherals and file management. Learners use modern operating systems, including Windows, Linux, and MacOS to demonstrate their skill with hardware and operating systems. Prerequisite(s): IT3170.

Learners apply features and techniques beyond the basics of the Java programming language to develop applications of moderate complexity. Learners analyze advanced object-oriented programming concepts like inheritance, polymorphism, interfaces, and abstract classes. Learners also investigate programming Graphical User Interface (GUI) applications with Java and the Java rich library of data structures like lists, stacks, and queues. Prerequisite(s): IT2249.

Learners in this course demonstrate their knowledge of information security fundamentals. Learners apply their understanding of the concepts of confidentiality, integrity, and availability to securing organizational assets.

In this course, learners build an understanding of the fundamental basics of project management and gain a broad overview of project management standards and their applicability to both business and IT projects. This course emphasizes management theories, concepts, tools and techniques defined by the Project Management Institute (PMI^®) including the Process Groups and Knowledge Areas. This course also introduces other project management methodologies and frameworks, with an emphasis on Agile.

This course presents material specific to the activities of identifying and collecting data that is required to accomplish business intelligence and data analytics projects. Learners examine factors used to identify and collect accurate data within the right context and for the right audience and purposes. Topics include strategies for minimizing errors and biases and managing limitations in data collection. Learners apply these factors in order to identify and collect data for business intelligence and data analytics projects.  Prerequisite(s): ACS1003 or BUS3007 or IT2230.

This course covers legal and ethical issues pertaining to information security and privacy. Learners demonstrate an understanding of core organizational processes and workflows and how these factors impact core data processes. Prerequisite(s): ACS1003 or BUS3007 or IT2230.

In this course learners identify the role data architects play in data and metadata design and management. Learners evaluate tools and strategies used by data architects in designing data and metadata solutions.  Prerequisite(s): IT2230

Learners evaluate the roles and responsibilities of database administrators and explore how they contribute to data management. Learners determine how database design, administration, regulations, and standards impact effective data management processes. Additionally, learners investigate the tools and strategies that allow a database administrator to support data management. Prerequisite(s): IT2230.

Learners in this course study data integration and the role it plays in data management. Topics include evaluation of legal and ethical environments that dictate the strategies and tools available for data integration within the data management context. Learners explore methodologies, tools, and strategies that enhance the ability for data integration to support data management. Prerequisite(s): IT2230.

Learners assess the role data quality plays in the creation of effective data management processes and workflows. Learners research and apply methodologies, strategies, and tools that play a role in measuring and applying data quality and data cleansing as part of an effective data management program. Prerequisite(s): IT2230.

In this course, learners evaluate the role data models, standards, and techniques play in an effective data management program. Topics include exploration of data structure options and how those options impact the creation of data models. Learners apply tools and techniques to demonstrate how they support data management. Prerequisite(s): IT2230.

Learners analyze the role that distributed, cloud-based, and virtualized environments play on processes and workflows related to the management and analysis of core data. Learners research and apply tools and strategies that allow effective data management and analysis of core data within the constraints of distributed and virtualized environments. Learners evaluate the impact that subjects of core data projects have on security and privacy. Prerequisite(s): IT2230.

In this course, learners apply knowledge and skills from other courses as they develop a project that benefits an organization, community, or industry. Learners prepare a proposal that includes a project description, deliverables, completion dates, and associated learning. Upon approval from the instructor, learners execute the proposal, record their progress weekly using a project tracking website, and produce a final project report. For BS in Information Technology learners only. Must be taken during the learner’s final quarter. Cannot be fulfilled by transfer or credit for prior learning.