Advanced Database Management Concepts
The aim of this course is to introduce students to current techniques, methods, and results from the active field of database systems and data management. The course will define essential database terms and concepts and focus on the design, development, and use of a relational database. Typical topics include query planning and optimization; transaction processing and concurrency control; big data management; data warehousing and OLAP; theory of databases.
- Refresher on database concepts and modelling
- Query planning, evaluation and optimization
- Transaction processing, concurrency, ACID rules, OLTP
- Online analytical processing (OLAP), data warehouses
- Data storage and indexing, B-trees and hashing
- Database security and privacy, including anonymisation and release
- Big data, MapReduce, Pig Latin
- Special purpose databases, e.g. temporal, spatial, or multimedia databases
- Hands-on review and development of database systems
- Understanding database design, development, and implementation
Course typically offered: Online during our Spring and Fall academic quarters
Software: Students will use Microsoft SQL Server or MySQL. These tools are free and open-source.
Prerequisites: Solid understanding of SQL Programming and a basic understanding of relational database management systems (RDMS).
Next steps: Upon completion, consider additional coursework in our specialized certificate in Database Management to continue learning.
Contact: For more information about this course, please contact firstname.lastname@example.org.
Course Number: CSE-41332
Credit: 3.00 unit(s)
Related Certificate Programs: Database Management