Home / MBS Course Catalog / Database and Data Warehousing (Cr. 3)

Database and Data Warehousing
(Cr. 3)

Course Description:

This course introduces the students to the principles of database design and management, as well as advanced concepts including database performance-tuning and query optimization, business intelligence and data warehouses, big data, and NoSQL.

Course Objectives:

Upon successful completion of this course, students will be able to:

  1. Examine and evaluate the ways a database, a DBMS, and the people who interact with them meet applied needs in technical, business, societal, and other contexts.
  2. Design, document, develop, and deploy a database and build a database user interface via standard practices and processes.
  3. Utilize standard processes and procedures to identify and resolve structural data integrity problems.
  4. Construct Structured Query Language (SQL) statements to define, manipulate, query, and control data in a relational database.
  5. Retrieve information from data stored in a relational database, perform data analysis, and generate reports.
  6. Compare data mining and mapping techniques, and critique their importance
  7. Examine and evaluate database performance tuning, distributed database management systems, and data warehousing.
  8. Critique the importance of big data analytics and NoSQL