Database and Data Warehousing
SEMESTER AVAILABLE: Spring
This course introduces the students to the principles of database design and database management. The course also examines advanced database concepts such as database performance tuning and query optimization, business intelligence and data warehouses, big data and NoSQL, etc.
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
Database Systems: Design, Implementation, & Management , 13th Edition
Carlos Coronel; Steven Morris