Skip to main content
NounStudy
Back to Course Catalog
CIT844Sciences2 Unitsintermediate

Advanced Database Management Systems

This course introduces advanced concepts in Database Management Systems. It covers relational database design, implementation, and advanced SQL. Students will explore query processing, transaction management, security, and distributed databases. The course also delves into emerging database models, XML integration, data warehousing, and data mining techniques. Practical examples using PostgreSQL and Oracle are included to enhance understanding of real-world DBMS architectures.

Take a Practice TestGenerate AI Study Notes

Take a practice test or generate AI study notes to help you excel in this course.

208h
Study Time
13
Weeks
16h
Per Week
basic
Math Level
Course Keywords
Database ManagementSQLDistributed DatabasesData MiningXML

Course Overview

Everything you need to know about this course

Course Difficulty

Intermediate Level
Builds on foundational knowledge
65%
intermediate
➕
Math Level
Basic Math
🔬
Learning Type
Hands-on Practice

Course Topics

Key areas covered in this course

1

Relational Database Design

2

Advanced SQL

3

Transaction Management

4

Distributed Databases

5

Data Warehousing

6

Data Mining

Total Topics6 topics

Requirements

Knowledge and skills recommended for success

Basic database concepts

SQL fundamentals

💡 Don't have all requirements? Don't worry! Many students successfully complete this course with basic preparation and dedication.

Assessment Methods

How your progress will be evaluated (3 methods)

assignments

Comprehensive evaluation of course material understanding

Written Assessment

tutor-marked assessments

Comprehensive evaluation of course material understanding

Written Assessment

final examination

Comprehensive evaluation of course material understanding

Written Assessment

Career Opportunities

Explore the career paths this course opens up for you

Database Administrator

Apply your skills in this growing field

Data Analyst

Apply your skills in this growing field

Data Scientist

Apply your skills in this growing field

SQL Developer

Apply your skills in this growing field

GIS Analyst

Apply your skills in this growing field

Industry Applications

Real-world sectors where you can apply your knowledge

FinanceHealthcareE-commerceLogisticsGovernment

Study Schedule Beta

A structured 13-week journey through the course content

Week
1

Module 1: Database Design and Implemental

4h

Unit 1: Relational Database Design

4 study hours
  • •Understand relational database model concepts
  • •Study domains, attributes, tuples, and relations
  • •Explore characteristics of relations
  • •Practice relational constraints
Week
2

Module 1: Database Design and Implementation

4h

Unit 2: Database Implementation

4 study hours
  • •Learn conceptual, logical, and physical database design phases
  • •Study database creation, loading, and conversion
  • •Explore system procedures and security measures
  • •Practice testing and evaluation techniques
Week
3

Module 1: Database Design and Implementation

4h

Unit 3: Advance SQL

4 study hours
  • •Understand SQL statements and their usage
  • •Practice SQL queries on relational databases
  • •Explore advanced SQL features
  • •Complete Tutor Marked Assignment
Week
4

Module 1: Database Design and Implementation

4h

Unit 4: Database System Catalog

4 study hours
  • •Learn the purpose and structure of database system catalogs
  • •Study metadata management
  • •Complete Tutor Marked Assignment
Week
5

Module 2: DBMS Advance Features

4h

Unit 1: Query Processing & Evaluation

4 study hours
  • •Study query interpretation and equivalence of expressions
  • •Explore selection and natural join operations
  • •Learn estimation of query-processing costs
  • •Study join strategies
Week
6

Module 2: DBMS Advance Features

4h

Unit 2: Transaction Management and Recovery

4 study hours
  • •Understand transactions and their properties
  • •Study transaction management with SQL
  • •Explore concurrency control and locking methods
  • •Learn database recovery management
Week
7

Module 2: Advanced Features and DBMS

4h

Unit 3: Database Security & Authorization

4 study hours
  • •Study security and integrity violations
  • •Explore authorization and views
  • •Learn integrity constraints and encryption
  • •Understand statistical databases
Week
8

Module 3: Distributed Databases

4h

Unit 1: Enhanced Database Models

4 study hours
  • •Study distributed databases and their structure
  • •Explore trade-offs in distributing databases
  • •Learn design of distributed databases
  • •Understand transparency and autonomy
Week
9

Module 3: Distributed Databases

4h

Unit 2: Object Oriented Database

4 study hours
  • •Study features of object-oriented DBMS
  • •Explore object-oriented database design
  • •Learn how OO concepts influenced the relational model
Week
10

Module 3: Distributed Databases

4h

Unit 3: Database and XML

4 study hours
  • •Define the purpose of XML
  • •Study XML trees and syntax rules
  • •Explore XML elements and attributes
Week
11

Module 3: Distributed Databases

8h

Unit 4: Introduction to Data Warehousing

4 study hours
  • •Learn data warehousing concepts
  • •Study data warehouse architectures
  • •Explore logical versus physical design
  • •Learn data warehousing schema and objects

Unit 5: Introduction to Data Mining

4 study hours
  • •Learn data mining uses and functions
  • •Study data mining technologies
Week
12

Module 4: Emerging Trends and Example of DBMS Architecture

4h

Unit 1: Emerging Database Models

4 study hours
  • •Study limitations of conventional databases
  • •Explore multimedia and temporal databases
  • •Learn temporal data semantics and modeling temporal data
Week
13

Module 4: Emerging Trends and Example of DBMS Architecture

8h

Unit 2: The Major Application Domains

4 study hours
  • •Study database on the World Wide Web
  • •Explore GIS applications
  • •Learn GENOME data management
  • •Understand digital libraries

Unit 3 PostgreSQL

4 study hours
  • •Study PostgreSQL and its features
  • •Explore open source software

This study schedule is in beta and may not be accurate. Please use it as a guide and consult the course outline for the most accurate information.

Course PDF Material

Read the complete course material as provided by NOUN.

Access PDF Material

Study Tips & Exam Preparation

Expert tips to help you succeed in this course

1

Review all SQL syntax and practice writing complex queries (Units 3, 4)

2

Create diagrams illustrating transaction management concepts (Unit 6)

3

Study distributed database design principles and replication strategies (Unit 7)

4

Focus on data warehousing schemas and their applications (Unit 8)

5

Practice identifying data mining techniques for different scenarios (Unit 9)

6

Understand the characteristics of emerging database models (Unit 10)

7

Review the major application domains and their database requirements (Unit 11)

Related Courses

Other courses in Sciences that complement your learning

CIT891

Advanced Multimedia Technology

3 Units
CIT811

User Interface Design And Ergonomics

3 Units
CIT832

Operating Systems Concepts And Networking Management

2 Units
View All Sciences Courses