Skip to content

Database Management - BADM 554

Welcome to the Database Management textbook for BADM 554 at the University of Illinois.

Course Overview

Databases play a critical role in today's business environment. Almost all modern organizations use database technologies to store and manage data in every functional area including operations, finance, accounting, and marketing. This course will equip you with one of the most marketable skills to help businesses better manage their data and discover new opportunities.

What You Will Learn

By the end of this course, you will be able to:

  1. Understand and articulate the data needs of a company (requirement analysis)
  2. Conceptually model the relationship of data (data modeling)
  3. Query databases using SQL to meet business requirements (structured and non-relational)
  4. Extract, Transform, and Load (ETL) data from/to multiple sources
  5. Understand infrastructure needs to handle Big Data and build BI and ML workflows

Tools You Will Use

  • SQL Databases: MySQL and PostgreSQL
  • Development: Jupyter Notebooks (Google Colab with Python)
  • Data Modeling: MySQL Workbench
  • ETL: Knime
  • NoSQL: MongoDB

Course Structure

This textbook is organized to follow the weekly progression of BADM 554:

Part 1: Database Fundamentals

  • Chapter 1: Database Environment
  • Chapter 2: Tables and Relational Algebra

Part 2: SQL Mastery

  • Chapter 3: SQL Fundamentals
  • Chapter 4: Advanced SQL

Part 3: Modern Data Integration

  • Chapter 5: JSON Data and APIs

Part 4: Database Design

  • Chapter 6: Database Design and Modeling
  • Chapter 7: Normalization

Part 5: Enterprise Data Management

  • Chapter 8: Data Warehousing and ETL
  • Chapter 9: NoSQL Databases

Hands-On Labs

Each chapter includes hands-on labs using real-world scenarios in: - Marketing (customer data management) - Supply Chain (vendor performance analysis) - Finance (macroeconomic research) - Accounting (fraud detection)

Interactive Features

  • Interactive Simulations (MicroSims) - Visualize database concepts
  • SQL Practice Environment - Try queries in your browser
  • Real-World Examples - Business scenarios from various industries
  • Step-by-Step Labs - Guided exercises with solutions

Getting Started

Start with Chapter 1: Database Environment or explore the Labs section to set up your development environment.

Instructor: Vishal Sachdev Email: vishal@illinois.edu Office: BIF 3030 A

Last updated: 2025-11-22