Skip to Content
Home /  Courses And Programs / Advanced Database Management Concepts

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.

Key topics:

  • 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

Practical experience:

  • 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 unex-techdata@ucsd.edu.

Course Number: CSE-41332
Credit: 3.00 unit(s)
Related Certificate Programs: Database Management

+ Expand All