Description
Learn the principles of database design and database management. Examine advanced database concepts such as database performance tuning and query optimization, business intelligence and data warehouses, big data, NoSQL, and more.
Course Objectives
Upon successful completion of this course, 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.
Technical Skills
- SQL
- Amazon Web Services
- Microsoft office suite
Transferable Skills
- Teamwork
- Communication