Database and Data Warehousing (Cr. 3)
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.
Upon successful completion of this course, students will be able to:
- 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.
- Design, document, develop, and deploy a database and build a database user interface via standard practices and processes.
- Utilize standard processes and procedures to identify and resolve structural data integrity problems.
- Construct Structured Query Language (SQL) statements to define, manipulate, query, and control data in a relational database.
- Retrieve information from data stored in a relational database, perform data analysis, and generate reports.
- Compare data mining and mapping techniques, and critique their importance
- Examine and evaluate database performance tuning, distributed database management systems, and data warehousing.
- Critique the importance of big data analytics and NoSQL