Search Results

This is an archived copy of the 2020-2021 catalog. To access the most recent version of the catalog, please visit https://catalog.nmc.edu.

CIT 178 Relational Databases

CIT 178 -  Relational Databases  

Credit Hours: 3, Contact Hours: 4

Division: Business

This course introduces students to core database concepts including data, data types, and relationships. Students will interpret and create relational data structures and use SQL language to perform basic create, read, update, and delete operations. Students will perform, administrative, backup and security functions. Students will recognize the value of optimized data and produce normalized designs. Course content is mapped to the MTA 98-364 Database Fundamentals learning objectives and students enrolled in this course will take the certification exam. Group 2 course. Critical Thinking - Direct.

CIT 178 - Relational Databases

https://catalog.nmc.edu/course-outlines/cit-178/

Course Description This course introduces students to core database concepts including data, data types, and relationships. Students will interpret and create relational data structures and use SQL language to perform basic create, read, update, and delete operations. Students will perform, administrative, backup and security functions. Students will recognize the value of optimized data and produce normalized designs. Course content is mapped to the MTA 98-364 Database Fundamentals learning objectives and students enrolled in this course will take the certification exam. Group 2 course. Credit Hours 3 Contact Hours 4 Lecture Hours 2 Lab Hours 2 General Education Outcomes supported by this course Critical Thinking - Direct Course Learning Outcomes Knowledge: Distinguish DML, DDL and DCL commands. Application: Create a normalized database with multiple tables, relationships, views, procedures, user-defined functions and triggers. Integration: Design relational databases: construct tables, relationships, fields and keys. Human Dimension: Give and receive feedback in an appropriate manner. Caring - Civic Learning: Explain the legal and ethical issues of data sharing. Learning How to Learn: Engage in self-directed learning.

CIT 228 - Advanced Database Systems

https://catalog.nmc.edu/course-outlines/cit-228/

Course Description This course builds upon database knowledge gained in CIT178 by extending into other data sources and connection technologies. Students will be able to identify and evaluate data options and access data via code. Group 2 course. Credit Hours 3 Contact Hours 4 Lecture Hours 2 Lab Hours 2 Required Prerequisites CIT 110 , CIT 180 and either CIT 178 or CIT 248, all with a grade of 2.0 or higher. General Education Outcomes supported by this course Critical Thinking - Direct Course Learning Outcomes Knowledge: Describe how to connect and update database files through code. Application: Use scripts to modify database files. Integration: Use scripting languages to code a series of complex database tasks. Human Dimension: Give and receive feedback in an appropriate manner. Caring - Civic Learning: Describe security problems with modifying database files in server-side web programming. Learning How to Learn: Engage in self-directed learning.

CIT 255 - Object-Oriented Programming

https://catalog.nmc.edu/course-outlines/cit-255/

Course Description The student builds on object-oriented fundamentals learned in CIT 195 , focusing on implementing SOLID Principles throughout the course. Projects will explore design patterns, UI/UX considerations, multiple forms of desktop and online persistence, and the integration of various technologies to form a complete solution. Group 2 course. Credit Hours 3 Contact Hours 4 Lecture Hours 2 Lab Hours 2 Required Prerequisites CIT 178 with a grade of 2.0 or higher, CIT 195 with a grade of 2.0 or higher General Education Outcomes supported by this course Critical Thinking - Direct Course Learning Outcomes Knowledge: Explain the SOLID Principles of object-oriented programming. Application: Demonstrate the application of the SOLID Principles object-oriented programming. Choose a design pattern based the initial application requirements, maintenance, and expendability. Integration: Develop a complex application. Deploy a complex application. Human Dimension: Demonstrate interpersonal communication skills while relating design decisions. Demonstrate the ability to effectively critique their peer's work. Construct a functional user interface (UI) and experience (UX). Caring - Civic Learning: Identify how the quality of code effects our daily experience and interaction with technology. Learning How to Learn: Select professional development resources that support their learning styles. Develop a set of professional resources to maintain throughout their career.