CS 281: Database Fundamentals

You will learn the fundamental concepts and technologies relating to database development and administration. Learn about relational databases, SQL, create/manipulate a database, stored procedures, administering a database: database security, & more.

Enroll Today to Save Tuition Free Preview

Course Curriculum

1. Course Overview and Learning Outcomes
  FREE PREVIEW
1. Introduction
2. Ch 1.1: Evolution of Data Management: From File-based Systems to Database Systems
3. Quiz 1.1
4. Ch 1.2: The Evolution and Importance of the Database Approach in Modern Data Management
5. Quiz 1.2
6. Summary
1. Introduction
2. Ch 2.1: Overview of databases and their fundamental components.
3. QUIZ 2.1
4. Ch 2.2: The Strategic Importance of Data as an Organizational Asset
5. Quiz 2.2
6. Ch 2.3: Data as a Strategic Asset
7. Quiz 2.3
8. Ch 2.4: Key Components of Database Systems
9. QUIZ 2.4
10. Ch 2.5: Key Objectives and Benefits of Database Systems
11. QUIZ 2.5
12. Ch 2.6: Challenges and Considerations in Adopting Database Systems
13. QUIZ 2.6
14. Reference Videos
15. Summary
1. Introduction
2. Ch 3.1: The Advantages and Key Features of Database Management Systems (DBMS)
3. QUIZ 3.1
4. Ch 3.2: Key Objectives and Advantages of a Database Management System
5. QUIZ 3.2
6. Ch 3.3: Balancing Effectiveness and Efficiency in Database Systems
7. QUIZ 3.3
8. Reference Videos
9. Summary
1. Introduction
2. Ch 4.1: Types of Data Models in Database Systems
3. QUIZ 4.1
4. Ch 4.2: Comprehensive Framework for Developing a Database System Master Plan
5. QUIZ 4.2
6. Ch 4.3: Structuring and Phased Development of Database Systems: The Role of Entity Charts in the Master Plan
7. QUIZ 4.3
8. Ch 4.4: Comprehensive Approach to Database System Development and Design
9. QUIZ 4.4
10. Reference Videos
11. Summary
1. Introduction
2. Ch 5.1: Comprehensive Overview of Data Modeling and Database Design
3. Quiz 5.1
4. Ch 5.2: Critical Phases and Importance of Database Design
5. QUIZ 5.2
6. Ch 5.3: Entity-Relationship (E-R) Model in Data Modeling
7. QUIZ 5.3
8. Ch 5.4: Advanced Relationships and Constraints in Entity-Relationship (E-R) Models
9. QUIZ 5.4
10. Reference Videos
11. Summary
1. Hands-on Lab: Designing a Simple ER Model
1. Introduction
2. Ch 6.1: Types and Classifications of Database Management Systems (DBMS)
3. QUIZ 6.1
4. Ch 6.2: Comprehensive Techniques and Procedures for Effective Database Management
5. QUIZ 6.2
6. Ch 6.3: The Role of Database Management Systems in Organizational Information Systems
7. QUIZ 6.3
8. Reference Videos
9. Summary
1. Introduction
2. Ch 7.1: Overview of the Relational Data Model and Its Fundamental Concepts
3. QUIZ 7.1
4. Ch 7.2: Fundamental Principles of the Relational Database Model
5. QUIZ 7.2
6. Ch 7.3: Keys, Relationships, and Integrity in the Relational Database Model
7. Quiz 7.3
8. Ch 7.4: Overview of Relational Algebra Operations in Databases
9. QUIZ 7.4
10. Reference Videos
11. Summary
1. Hands-on Lab: Implementing a Relational Database in MS SQL Server
1. Introduction
2. Ch 8.1: Installing and Configuring MySQL Server on Windows, macOS, and Linux
3. Ch 8.2: Introduction to Structured Query Language (SQL) and Database Creation
4. QUIZ 8.2
5. Ch 8.3: Understanding SQL: DDL, Data Types, and Table Creation
6. Quiz 8.3
7. Ch 8.4: Overview of Structured Query Language (SQL) and Its Relational Operations
8. Quiz 8.4
9. Ch 8.5: Advanced SQL Joins and Query Techniques
10. QUIZ 8.5
11. Reference Videos
12. Summary
1. Hands-on Lab: Writing Basic SQL Queries (DDL Commands - CREATE, ALTER, DROP)
1. Introduction
2. Ch 9.1: Comprehensive Guide to SQL Data Manipulation Language (DML)
3. QUIZ 9.1
4. Ch 9.2: Comprehensive Guide to the SQL INSERT Statement
5. QUIZ 9.2
6. Ch 9.3: Modifying and Deleting Data in SQL: Understanding the UPDATE and DELETE Statements
7. QUIZ 9.3
8. Ch 9.4: SQL Server Built-in Functions: Aggregate, Conversion, Date, and Mathematical Functions
9. QUIZ 9.4
10. Ch 9.5: Understanding SQL Joins: Inner, Outer, and Cross Joins
11. QUIZ 9.5
12. Ch 9.6: Advanced SQL Query Techniques: Sorting, Grouping, and Set Operations
13. QUIZ 9.6
14. Ch 9.7: Query Optimization Techniques in SQL
15. Reference Videos
16. Summary
1. SQL Data Manipulation (DML) and Query Optimization
1. Query Optimization in a Large Database System
1. Introduction
2. Ch 10.1: Understanding the Entity-Relationship (ER) Data Model
3. QUIZ 10.1
4. Ch 10.2: Understanding Attributes, Keys, and Relationships in ER Modeling
5. QUIZ 10.2
6. Ch 10.3: Converting ER Models to Data Structure Diagrams: A Practical Approach
7. QUIZ 10.3
8. Summary
1. Converting ER Models to SQL Tables
1. Introduction
2. Ch 11.1: Ensuring Data Integrity Through Constraints in Relational Databases
3. QUIZ 11.1
4. Ch 11.2: Advanced Relationships and Constraints in Relational Database Design
5. QUIZ 11.2
6. Ch 11.3: Understanding Functional Dependencies (Essential for Normalization)
7. Summary
1. Implementing Constraints & Data Integrity in SQL
1. Real-World Case Studies on Database Constraints and Data Integrity
1. Introduction
2. Ch 12.1: Understanding Functional Dependencies and Armstrong's Axioms in Database Design
3. Quiz 12.1
4. Ch 12.2: Understanding Modification Anomalies in Database Design
5. QUIZ 12.2
6. Ch 12.3: Understanding and Avoiding Data Dependence Issues in Database Design
7. QUIZ 12.3
8. Summary
1. Introduction
2. Ch 13.1: Understanding Redundancy in Database Design and Its Impact
3. QUIZ 13.1
4. Ch 13.2: Avoiding Anomalies Through Normalization and Functional Dependencies
5. QUIZ 13.2
6. Summary
1. Introduction
2. Ch 14.1: Understanding Normalization in Database Design: A Step-by-Step Guide
3. QUIZ 14.1
4. Ch 14.2: Understanding Normalization: First, Second, Third, and Boyce-Codd Normal Forms
5. QUIZ 14.2
6. Ch 14.3: Handling Multivalued Dependencies and Achieving Fourth Normal Form in Database Design
7. QUIZ 14.3
8. Ch 14.4: Understanding Decomposition and Advanced Normal Forms in Database Design (5NF)
9. QUIZ 14.4
10. Ch 14.5: Side Effects and Considerations of Database Normalization
11. QUIZ 14.5
12. Reference Videos
13. Summary
1. Normalization & Decomposition
1. Introduction
2. Ch 15.1: Comprehensive Overview of the Software and Database Development Life Cycle
3. QUIZ 15.1
4. Ch 15.2: Key Phases of Database Design in a Database Environment
5. QUIZ 15.2
6. Ch 15.3: Database Administration and Maintenance Procedures
7. QUIZ 15.3
8. Summary
1. Introduction
2. Ch 16.1: Types of Database Users
3. QUIZ 16.1
4. Ch 16.2: The Role of People and User Concerns in Database Systems
5. QUIZ 16.2
6. Ch 16.3: Key Roles in Database System Development and Management
7. QUIZ 16.3
8. Reference Videos
9. Summary
1. Managing User Roles & Permissions in SQL Server
1. Introduction
2. Ch 17.1: Comprehensive Overview of Data Dictionary Systems
3. QUIZ 17.1
4. Ch 17.2: Comprehensive Database Security: Ensuring Protection Through Logical, Physical, and Disaster Preparedness Measures
5. QUIZ 17.2
6. Ch 17.3: Comprehensive Database Recovery Techniques
7. QUIZ 17.3
8. Ch 17.4: Managing Concurrent Access in Database Systems
9. QUIZ 17.4
10. Summary
1. Implementing Database Backup & Recovery Strategies
1. Introduction
2. Ch 18.1: Distributed Database Management Systems and Client/Server Architectures
3. QUIZ 18.1
4. Ch 18.2: Overview of Network Topologies and Data Transmission in Distributed Database Systems
5. QUIZ 18.2
6. Ch 18.3: Data Distribution and Concurrency Management in Distributed Database Systems
7. QUIZ 18.3
8. Ch 18.4: Recovery and Data Management in Distributed Database Systems
9. QUIZ 18.4
10. Ch 18.5: Advantages and Challenges of Distributed Database Environments
11. QUIZ 18.5
12. Ch 18.6: Fragmentation, Allocation, and Replication in Distributed Databases
13. Summary
1. Configuring a Distributed Database
1. Introduction
2. Ch 19.1: The Evolution and Challenges of Organizational Computing: From Mainframes to Personal Computers
3. QUIZ 19.1
4. Ch 19.2: Data Security Challenges in Personal Computer Environments
5. QUIZ 19.2
6. Ch 19.3: Evaluating Types of Personal Computer Database Systems
7. QUIZ 19.3
8. Summary
1. Introduction
2. Ch 20.1: Efficient Data Access and Representation in Database Systems
3. QUIZ 20.1
4. Ch 20.2: Efficient Data Retrieval and Management Using Linked Lists
5. QUIZ 20.2
6. Ch 20.3: Optimizing Data Retrieval with Inverted Lists in Database Systems
7. QUIZ 20.3
8. Ch 20.4: Efficient Data Management Using B-Trees
9. QUIZ 20.4
10. Summary
1. Ch 21.1: Introduction to Database Programming
2. Ch 21.2: Writing Stored Procedures, Triggers, and Views in SQL
3. Ch 21.3: Interacting with Databases through Programming Languages (Python, Java, etc.)
4. Ch 21.4: Database Connectivity: JDBC, ODBC, and Web Applications
5. Reference Videos
1. Writing Stored Procedures & Triggers
1. Assignment
2. Rubric for assignment
1. Final Exam Instructions
2. Final Exam: 100 MCQ

About this course

223 lessons
1750+ Transfer Colleges
ACE & NCCRS Approved
Globally Recognized

Answers You Didn't Know You Needed!

General Questions

Is there any time commitment we have to give?

With UPI, you determine your own level of time commitment. You can move through coursework quickly or slow down your pace.
Are there exams? How is the course grading done?
YES, there are exams—held online on our platform and are proctored. Your course grade distribution is:

25% Attendance

25% Quiz

25% Assignments

25% Final Exam

Content Questions

How to check if your university will accept credits from UPI study?

To ensure your UPI Study courses transfer to your university, check two things:

1) Is your university listed? If it's one of the 1,500 universities listed with NCCRS, you're all set.

OR

2) Check your university's credit policy. If it says they accept credits from "regionally accredited" universities, you're good to go! As long as you meet one of these criteria, your courses should transfer without a hitch.

Check the list of colleges here.

Membership Questions

Will there be hand holding to help transfer courses?

Yes, that is what differentiates UPI. With each student their advisor will guide them on how to move forward.

Computer Science 281: Database Fundamentals

CHAPTER 1: The Advantages of Databases Over Traditional Data Storage Methods

CHAPTER 2: Key Concepts, Objectives, and Challenges of Database Systems

CHAPTER 3: Key Objectives, Advantages, and Features of Database Management Systems (DBMS)

CHAPTER 4: Database System Development: Models, Planning, and Design Frameworks

CHAPTER 5: Key Concepts and Phases in Effective Database Design

Lab 1: Designing a Simple ER Model

CHAPTER 6: Comprehensive Database Management System (DBMS) Planning, Design, and Integration

CHAPTER 7: Core Concepts and Operations in the Relational Database Model

Lab 2: Implementing a Relational Database in MS SQL Server

CHAPTER 8: Introduction to SQL: History, Functions, and Key Operations

Lab 3: Writing Basic SQL Queries (DDL Commands - CREATE, ALTER, DROP)

CHAPTER 9: Advanced SQL Querying Techniques: Sorting, Grouping, and Using Joins, Functions, and Subqueries

Lab 4: SQL Data Manipulation (DML) and Query Optimization

Real-World Case Study: Query Optimization in a Large Database System

CHAPTER 10: Comprehensive Overview of the Entity-Relationship (ER) Model and Its Application in Database Design

Lab 5: Converting ER Models to SQL Tables

CHAPTER 11: Understanding Constraints and Relationships in Relational Database Design

Lab 6: Implementing Constraints & Data Integrity in SQL

Real-World Case Studies on Database Constraints and Data Integrity

CHAPTER 12: Understanding and Resolving Data Dependence and Modification Anomalies in Database Design

CHAPTER 13: Understanding Functional Dependencies and Avoiding Anomalies in Database Design

CHAPTER 14: Key Concepts and Challenges in Database Normalization

Lab 7: Normalization & Decomposition

CHAPTER 15: Comprehensive Database Management and Design: Techniques, Procedures, and Maintenance

CHAPTER 16: The Roles and Responsibilities in Database System Development and Management: From Top Management to Technical Staff

Lab 8: Managing User Roles & Permissions in SQL Server

CHAPTER 17: Database Administration and Data Dictionary Systems

Lab 9: Implementing Backups & Recovery Strategies

CHAPTER 18: Distributed Database Management Systems

Lab 10: Configuring a Distributed Database

CHAPTER 19: Personal Computer Database Systems

CHAPTER 20: Advanced Data Structures for Efficient Database Management

CHAPTER 21: Database Programming & Application Development

Lab 11: Writing Stored Procedures & Triggers

Assignment

FINAL EXAM

About this course

Answers You Didn't Know You Needed!