DBM-201: Database Systems

Learn to design and manage databases in this Database Systems course. Gain hands-on skills with SQL, ER modeling, normalization, and platforms like Oracle, Access, MongoDB, and Neo4j.

Course Description

The Database Systems course introduces students to the essential principles and practices of designing, implementing, and managing databases in business and enterprise environments. Using Coronel and Morris’s Database Systems: Design, Implementation, & Management, 14th Edition, students will gain a foundation in database theory, relational models, entity-relationship (ER) modeling, normalization, and SQL.

The course begins with database concepts and relational structures before advancing into database design, query optimization, and administration. Students will practice modeling and implementing databases using industry tools and platforms, including Oracle, MS Access, MongoDB, and Neo4j. Advanced topics such as distributed databases, data warehousing, business intelligence, NoSQL, and cloud-based solutions are also explored.

Emphasis is placed on practical, real-world applications through case studies and tutorials that prepare learners to design efficient data structures, write optimized queries, and manage database systems for scalability, security, and performance. Designed for students pursuing careers in database administration, software development, or data management, this course provides the technical and applied skills needed to support organizational decision-making and modern data environments.

Textbook: Database Systems: Design, Implementation, & Management by Carlos Coronel, Steven Morris | 14th Edition | Copyright 2023

Course Objectives

Explain core database concepts and the role of databases in organizations.

Apply relational database design principles, including ER modeling and normalization.

Implement databases using SQL and evaluate advanced query techniques.

Compare relational, hierarchical, network, and object-oriented database models.

Analyze advanced topics such as distributed databases, data warehousing, and cloud-based solutions.

Demonstrate practical database design and administration using tools and platforms such as Oracle, Access, MongoDB, and Neo4j.

Starting is Easy

Want to learn more about earning your accredited high school diploma? Just enter your name and email below, and we’ll send you a series of helpful emails to guide you through the process.

Course Contents

Part 1. Database Concepts

Database Systems

Data Models

The Relational Database Model

The Relational Database Model

Entity Relationship (ER) Modeling

Advanced Data Modeling

Normalization of Database Tables

Part 3. Advanced Design and Implementation

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Part 4. Advanced Database Concepts

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data and NoSQL

Part 5. Databases and the Internet

Database Connectivity and Web Technologies

Part 6. Database Administration

Database Administration and Security

Single Course or Program Option

This course may be purchased individually or as part of the certificate programs listed below.

Database Management
Software Development

Recommended Prerequisites

Accreditation You Can Trust

Washington Technical Institute is fully accredited by the Middle States Association Commissions on Elementary and Secondary Schools (MSA-CESS)—a regional accrediting agency recognized for setting high standards in education. This accreditation affirms that our programs, operations, and outcomes meet rigorous academic and institutional benchmarks. MSA-CESS accreditation is a mark of quality that ensures our students receive an education that is both credible and respected. It also means WTI is committed to continuous improvement, student success, and accountability at every level.