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.

"An essential course that helped me understand databases deeply, while also adding to my college credits 🙌" — Kenji

Which universities accept transfer credits?

Our students have sent UPI transcripts to over 1,500 esteemed colleges and universities in the US, UK & Canada, earning credits up to two years of study.

How many credits can I transfer from this course?

The NCCRS recommends this course for 3 semester hours, and supporting it with transcripts from regionally accredited universities ensures recognized academic value.

Who can take UPI Courses?

Anyone wanting to have a headstart - whether you are in high school, about to join college, or currently pursuing a bachelor's degree.

Importance of taking college courses early?

College-level courses on your application demonstrate your motivation & readiness to tackle advanced education head-on + you save a lot of money on your higher education.

Course Curriculum

1. Introduction
1. Data Defined
2. Analog vs. Digital Data
3. Types of Data
4. Databases
5. Data vs. Information
6. Lesson Summary
7. Data Terms & Definitions
8. Learning Outcomes
9. Quiz 1.1
1. What is a Database?
2. What is Structured Query Language (SQL)?
3. Evolution of a Database
4. Database Management and Types of Database Management
5. Relational Databases
6. Object-Oriented Databases
7. SQL Databases
8. Network Databases
9. Graph Databases
10. Diagrams: How Different Databases Connect
11. What Are Databases Used For?
12. Differences Between Databases and Spreadsheets
13. Database Software
14. Using Database Software to Improve Business Performance
15. Database Challenges
16. Lesson Summary
17. Quiz 1.2
1. What are Data?
2. Database Structure
3. Data vs. Information
4. Lesson Summary
5. Learning Outcome
6. Quiz 1.3
1. Database Background
2. Data Basics
3. Database Management
4. Relationships Between Tables
5. Lesson Summary
6. Quiz 1.4
1. What Is a Record?
2. Records in the Database
3. Example of a Database Record
4. Fields
5. Data Types
6. Lesson Summary
7. Quiz 1.5
1. Overview of Database Fields
2. Example
3. Database Field Types
4. Example
5. Lesson Summary
6. Quiz 1.6
1. Purpose of Database Management Systems
2. Functions of a DBMS
3. Pros and Cons of DBMS
4. Multi-User Databases
5. Lesson Summary
6. Learning Outcomes
7. Quiz 1.7
1. DBMS Models
2. Flat File
3. Hierarchical DBMS
4. Network DBMS
5. Relational DBMS
6. Object-Oriented DBMS
7. Lesson Summary
8. Learning Outcomes
9. Quiz 1.8
1. What Is DBMS All About?
2. Advantages of DBMS
3. Lesson Summary
4. Quiz 1.9
1. Introduction
1. Entities
2. Entity Attributes
3. Entity or Attribute?
4. Relationships
5. Lesson Summary
6. Quiz 2.1
1. The Need for Databases
2. Relational Databases
3. Functional Dependency
4. Lesson Summary
5. Quiz 2.2
1. The ER Diagram
2. Entities and Tables
3. Keys
4. Cardinality
5. Lesson Summary
6. Quiz 2.3
1. Database Relationships
2. Rules for Relational Databases
3. Primary and Foreign Keys
4. Cardinality of Relationships
5. Lesson Summary
6. Learning Outcomes
7. Quiz 2.4
1. What Is a Relational Database?
2. Relational Database Uses
3. Relational Database Functions
4. Lesson Summary
5. Quiz 2.5
1. Introduction
1. We Need Information
2. What Is a Database?
3. What is SQL?
4. What Is the History of SQL?
5. Lesson Summary
6. Quiz 3.1
1. Manipulating a Database
2. Structured Query Language
3. SQL Statements
4. SQL Syntax
5. SQL Operators
6. Boolean Logic
7. Lesson Summary
8. Learning Outcomes
9. Quiz 3.2
1. Database Query
2. Example of a Query
3. Using Semicolons
4. Other Operations
5. Microsoft Access Example
6. Lesson Summary
7. Quiz 3.3
1. Structured Query Language
2. How to Build a Query
3. Example: Two Tables
4. Lesson Summary
5. Quiz 3.4
1. Query Concepts
2. What is Syntax?
3. What is a Relational Database?
4. What is Structural Query Language (SQL)?
5. SQL Clauses
6. SQL Statements
7. SQL Syntax Notes
8. SQL Commands and Syntax
9. Lesson Summary
10. Quiz 3.5
1. Subqueries
2. WHERE
3. FROM
4. SELECT
5. MySQL: Subquery Update
6. Lesson Summary
7. Quiz 3.6
1. A Common Join
2. Example
3. SELECT
4. FROM
5. INNER JOIN
6. ON
7. Results of the Query
8. Lesson Summary
9. Quiz 3.7
1. Introduction
2. Full Outer Join Syntax
3. Lesson Summary
4. Quiz 3.8
1. What is SQL?
2. Grouping Without an Order
3. Grouping With an Order
4. Lesson Summary
5. Quiz 3.9
1. Creating Simplicity
2. What is SQL?
3. What is a SQL Script?
4. Creating a SQL Script
5. Running a SQL Script
6. Lesson Summary
7. Quiz 3.10
1. Dealing with the Information Glut
2. What is SQL?
3. What is a SQL Query?
4. What is a SQL Script?
5. Lesson Summary
6. Quiz 3.11
1. Reducing Repetition
2. SQL Script
3. Script Uses
4. Sample Scripts
5. Lesson Summary
6. Quiz 3.12
1. Introduction
1. Naming Data Types in SQL
2. CHAR
3. VARCHAR
4. Lesson Summary
5. Quiz 4.1
1. Different Types of Numbers
2. INT
3. SMALLINT
4. Others
5. Lesson Summary
6. Quiz 4.2
1. Data Types for Numbers
2. NUMERIC and DECIMAL
3. How Are They Different from Other Data Types?
4. Explaining the Syntax
5. Lesson Summary
6. Quiz 4.3
1. SQL Data Types
2. The Real & Float Data Types
3. The Double Data Type
4. Lesson Summary
5. Quiz 4.4
1. What is BOOLEAN?
2. Yes or No?
3. The Use of Boolean Logic
4. Example
5. Lesson Summary
6. Quiz 4.5
1. Knowing When in SQL
2. Why Use a Specific Data Type?
3. The TIME Data Type
4. The DATE Data Type
5. The TIMESTAMP Data Type
6. Lesson Summary
7. Quiz 4.6
1. What's a BLOB?
2. MySQL
3. Oracle
4. SQL Server
5. Lesson Summary
6. Qui 4.7
1. Introduction
1. Information is Not Enough
2. What Is SQL?
3. What Is T-SQL?
4. Differences Between SQL and T-SQL
5. Lesson Summary
6. Quiz 5.1
1. What Is PL/SQL?
2. The PL/SQL Environment
3. Syntax of PL/SQL
4. Declaration:
5. Commands:
6. Null Statement
7. Handling Exceptions or Errors:
8. PL/SQL Delimiters:
9. PL/SQL Statements:
10. PL/SQL Comments:
11. Lesson Summary
12. Quiz 5.2
1. Dynamic SQL
2. Dynamic SQL In Action
3. SQL Injection
4. Lesson Summary
5. Quiz 5.3
1. Introduction
1. The Need for Simplification
2. What is a Data Model?
3. What is Abstraction?
4. What is an Abstract Data Model?
5. What is the Purpose of Using an Abstract Data Model?
6. Lesson Summary
7. Quiz 6.1
1. Parents, Children, and Objects
2. Object Diagrams
3. Building a Diagram
4. The Importance of Object Diagrams
5. Lesson Summary
6. Quiz 6.2
1. Class Diagram Definition
2. Class Diagram Example
3. Symbols and Notation
4. Class Diagram Importance
5. Lesson Summary
6. Quiz 6.3
1. What Is a Database Schema?
2. Schema Theory
3. A Simple Database
4. A Better Database
5. A Useful Database
6. Lesson Summary
7. Quiz 6.4
1. Database Schemas
2. Designing a Schema
3. Map it Out
4. Lesson Summary
5. Quiz 6.5
1. Introduction
1. Using SQL's Primary Keys
2. How Are They Used?
3. Example in Use
4. Lesson Summary
5. Quiz 7.1
1. What is a Foreign Key?
2. Primary vs. Foreign Keys
3. Linking Tables
4. Example of a Foreign Key
5. Lesson Summary
6. Learning Outcomes
7. Quiz 7.2
1. SQL Databases & Relationships
2. Relationship Types & Representation
3. SQL Relationships Examples
4. Lesson Summary
5. Quiz 7.3
1. The Database Table
2. Design and Conventions
3. Field
4. Unique Identifier
5. Database Language
6. Lesson Summary
7. Quiz 7.4
1. What Is a Database?
2. Relational Database Design Steps
3. Lesson Summary
4. Quiz 7.5
1. Database Management System Design
2. Why Do We Go to This Length?
3. What Is Normalization?
4. The Normal Forms
5. Types of Normal Forms
6. Quiz 7.6
7. Lesson Summary
1. The Prevalence of Databases
2. What is SQL?
3. What is Normalization?
4. Example
5. What are the Rules for Normalization?
6. Lesson Summary
7. Quiz 7.7
1. First Normal Form
2. General Rules
3. Examples of 1NF
4. Lesson Summary
5. Quiz 7.8
1. Normalization
2. Transitive Dependence
3. 3NF: Examples
4. Practical Concerns
5. Lesson Summary
6. Quiz 7.9
1. Introduction
1. Constraining Data
2. Where Does the Constraint Go?
3. Types of Constraints
4. Lesson Summary
5. Quiz 8.1
1. DBMS & SQL
2. Basic SQL Commands
3. SELECT SQL Statements
4. JOIN SQL Statements
5. UPDATE, INSERT, and DELETE Statements
6. Lesson Summary
7. Quiz 8.2
1. Creating a Database
2. Create Database command options in Transact SQL
3. Create Database command options in MySQL
4. Create Database options summary
5. Deleting a Database
6. Drop Database command in Transact SQL
7. Drop Database command in MySQL
8. Lesson Summary
9. Quiz 8.3
1. Data Manipulation Language
2. SELECT
3. INSERT
4. UPDATE
5. DELETE
6. Lesson Summary
7. Quiz 8.4
1. How Do We Add Information to the Table?
2. Insert Multiple Records
3. SQL INSERT Examples
4. Insert Single Record
5. Inserting Without All Columns
6. Lesson Summary
7. Quiz 8.5
1. What is SQL?
2. Lesson Summary
3. Quiz 8.6
1. SQL?
2. Lesson Summary
3. Quiz 8.7
1. DROP Columns & Rows
2. Remove a Column
3. Some Examples
4. Delete a Row of Data
5. Lesson Summary
6. Quiz 8.8
1. Cleaning House
2. What is SQL?
3. What is a Database?
4. What is an Index?
5. What do the DROP Index and DROP Database Commands do in SQL?
6. Lesson Summary
7. Quiz 8.9
1. Oracle databases and database objects
2. Prerequisites
3. Topics covered in this lesson
4. Test Data to be used for this lesson
5. Exercises
6. Question 1
7. Question 2
8. Question 3
9. Indexes
10. Other CONSTRAINTS
11. Question 5
12. Question 6
13. Lesson Summary
1. Introduction
1. Database Administration
2. Administrator Responsibilities
3. Case Study
4. Importance of DBA
5. Lesson Summary
6. Quiz 9.1
1. Database Concurrency, Locking and Transactions Concurrency
2. Transactions and locks
3. Side effects of database concurrency
4. Lesson Summary
5. Quiz 9.2
1. Definition of Persistence
2. Types of Persistence
3. Object Persistence in Databases
4. Persistent Data: Importance
5. Persistent Databases: Examples
6. Lesson Summary
7. Quiz 9.3
1. Data Integrity
2. Two-Phased Locking Protocol
3. Lesson Summary
4. Quiz 9.4
1. Database Transactions
2. Transaction Properties
3. Atomicity
4. Consistency
5. Isolation
6. Durability
7. Lesson Summary
8. Quiz 9.5
1. The Use of Information
2. What is SQL?
3. What is a Cursor?
4. What is a Cursor Used for?
5. What Does SQL Cursor Syntax Look Like?
6. Lesson Summary
7. Quiz 9.6
1. What Is Database Security Management?
2. Threats to Database Security
3. Forms
4. Lesson Summary
5. Quiz 9.7
1. Roles and Responsibilities of a Database Administrator
2. Documentation of Databases
3. Helpful Tools to Assist in Documentation
4. Lesson Summary
5. Quiz 9.8
1. Databases in Organizations
2. Distributed Databases
3. Lesson Summary
4. Learning Outcomes
5. Quiz 9.9
1. Introduction
1. What Is a Database Application?
2. How Databases Work
3. How Databases Work
4. Advantages Over Spreadsheets
5. Lesson Summary
6. Quiz 10.1
1. Database Programs
2. Types of Database Programs
3. Single File / Flat File Database Programs
4. Relational Database Management System (RDMS)
5. Lesson Summary
6. Quiz 10.2
1. Microsoft SQL Server: What is it?
2. History
3. SQL Server Products
4. Microsoft SQL Server in Action
5. Features
6. Transact-SQL (T-SQL)
7. Lesson Summary
8. Quiz 10.3
1. Overview of the Oracle Database
2. Oracle Products
3. Accessing the Oracle Database
4. Structured Query Language (SQL)
5. PL/SQL
6. Conclusion
7. Quiz 10.4
1. MySQL Introduction
2. History of MySQL
3. MySQL Advantages and Usage in Web Projects
4. Lesson Summary
5. Quiz 10.5
1. Overview of Microsoft Access
2. Comparing Access with Other Databases
3. History of Access
4. Jet Database Engine
5. SQL Server
6. Lesson Summary
7. Quiz 10.6
1. The Technology Behind the Scenes
2. What is a Database?
3. What is a Database Reporting Tool?
4. What are Some Examples of Database Reporting Tools?
5. Lesson Summary
6. Quiz 10.7
1. What Is Markup Language?
2. Markup Languages Over the Years
3. Browser Battles
4. Lesson Summary
5. Learning Outcomes
6. Quiz 10.8
1. Introduction to XML
2. What can an XML file do?
3. What is an XML Schema?
4. Example of XML Schema
5. Lesson Summary
6. Quiz 10.9
1. The Importance of Information
2. What is a Web Application?
3. Web Application Categories
4. Effects of These Applications on Business Information Systems
5. Lesson Summary
6. Quiz 10.10
1. Website Design Defined
2. Planning Your Website
3. Building Your Website's Foundation
4. Decorating Your Website
5. Finalizing Your Website
6. Lesson Summary
7. Lesson Objectives
8. Quiz 10.11
1. Displaying Web Pages on the Internet
2. Using MySQL to Store and Display Web Data
3. Extensible Markup Language (XML) for Storing Websites' Data
4. How is XML Used to Markup Data?
5. Example
6. Reading XML and Displaying it in Webpages using PHP
7. Lesson Summary
8. Quiz 10.12
1. Introduction
1. What Is Business Intelligence?
2. Steps for Starting a New BI System
3. Business Analytics
4. Lesson Summary
5. Quiz 11.1
1. The History of Keeping Information
2. Definition
3. Uses
4. Lesson Summary
5. Quiz 11.2
1. The Lure of Big Data
2. What Is Big Data?
3. Analyzing Big Data
4. Big Data Example
5. Lesson Summary
6. Quiz 11.3
1. The Four Vs of Big Data
2. Volume
3. Velocity
4. Variety
5. Veracity
6. Lesson Summary
7. Quiz 11.4
1. The Ever-Increasing Presence of Data
2. What is Big Data?
3. What Are Its Advantages?
4. What Are Its Challenges?
5. Lesson Summary
6. Quiz 11.5
1. Different Applications
2. Healthcare
3. Education
4. Business
5. Lesson Summary
6. Quiz 11.6
1. Data Warehouses
2. Distributed DBMS
3. Data Mining
4. Lesson Summary
5. Learning Outcomes
6. Quiz 11.7
1. Definition of Data Mart
2. Implementing a Data Mart
3. Data Mart Benefits
4. Lesson Summary
5. Quiz 11.8
1. What is a Data Warehouse?
2. What is Quality Data?
3. What Makes Good Quality Data?
4. When is Poor Quality Data Likely to Be Injected?
5. Quality Data: The Bottom Line
6. Lesson Summary
7. Quiz 11.9
1. The Ever-Growing Thirst for Knowledge
2. What is Big Data?
3. What is a Data Warehouse?
4. What Are the Differences Between Big Data and Data Warehouses?
5. Lesson Summary
6. Quiz 11.10
1. Research and Data
2. Methods of Data Collection
3. The Process of Data Analysis
4. Lesson Summary
5. Learning Outcomes
6. Quiz 11.11
1. An Introduction to Data Analytics (DA)
2. Tools Used for Data Analytics
3. Lesson Summary
4. Quiz 11.12
1. Introduction
1. Spreadsheet Software
2. Database Software
3. Lesson Summary
4. Learning Outcomes
5. Quiz 12.1
1. What Is a Flat File Database?
2. Flat File Database Examples
3. Flat File Database Drawbacks
4. Lesson Summary
5. Quiz 12.2
1. Different Databases
2. Flat File Database
3. Uses of Flat File Databases
4. Relational Databases
5. Uses of a Relational Database
6. Lesson Summary
7. Quiz 12.3
1. What is a Hierarchical Database?
2. Hierarchical Databases: Uses
3. How a Hierarchal Database Works
4. Lesson Summary
5. Quiz 12.4
1. Data Is Everywhere!
2. What Is a Database?
3. Hierarchical Database
4. Relational Database
5. Why One Over the Other?
6. Lesson Summary
7. Quiz 12.5
1. Subject Databases Defined
2. Bibliographic Databases
3. Subject Databases vs. Internet
4. Creation of Subject Databases
5. Lesson Summary
6. Quiz 12.6
1. What is a Database Object?
2. Visualizing Database Objects
3. Examples of Database Objects
4. Lesson Summary
5. Quiz 12.7
1. Object-Oriented Databases
2. Fundamental Features
3. Advantages
4. Challenges & Solutions
5. Some Applications
6. Lesson Summary
7. Quiz 12.8
1. An Alternative to SQL
2. Why NoSQL?
3. Types of NoSQL
4. Lesson Summary
5. Quiz 12.9
1. Assignment
2. Final Exam Instructions
3. Final exam

About this course

663 lessons
1750+ Transfer Colleges
Available for College Credit
Globally Recognized

Explore Similar Courses

Download Curriculum: Curriculum - Computer Science Courses.pdf

Schedule a Free Call Whatsapp Us

College Credits

Explore credit transfer programs or you could miss out on saving up to 50% on your college fees

FAQ

With UPI, you determine your own level of time commitment. You can move through course work quickly or slow down your pace.

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

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.

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

YES!! Consider us your family abroad. We have a strong community, we will make sure to support you in anyway we can. There is a reason why we have students from 30+ countries - it is because of our promising customer experience.

There are no additional fees for material, textbooks or eBooks. Everything is included as part of your membership.

Yes, there is! If you take these courses for college credits and they do not transfer, you are eligible for a refund.

If you take a course for the purpose of skill development, in that case the refund policy is valid only if you ask for a refund within 14 days of course registration.

As a UPI member, you don’t pay for individual courses. Instead, you choose a bundle plan with UPI.

Lifetime Access to Course Material
Study via Mobile or Web
Accredited

Talk to other students taking this or similar course 🎙

A community of 80K+ students✨

JOIN THE COMMUNITY

Which universities accept transfer credits?

How many credits can I transfer from this course?

Who can take UPI Courses?

Importance of taking college courses early?

Ch 1 - Introduction to Database Fundamentals

Ch 1.1 - Data Fundamentals

Ch 1.2 - Understanding Databases

Ch 1.3 - Elements of Databases

Ch 1.4 - Database Terminology

Ch 1.5 - Database Records

Ch 1.6 - Database Fields

Ch 1.7 - Understanding Database Management Systems (DBMS)

Ch 1.8 - Models of Database Management Systems.

Ch 1.9 - Advantages of Database Management Systems

Ch 2 - Relational Database Model

Ch 2.1 - Entities

Ch 2.2 - Attributes

Ch 2.3 - Entity-Relationship Model

Ch 2.4 - Relational Database Design

Ch 2.5 - Implementation of Relational Databases

Ch 3 - Structured Query Language

Ch 3.1 - Introduction to SQL

Ch 3.2 - SQL Basics

Ch 3.3 - Querying Databases

Ch 3.4 - SQL Queries

Ch 3.5 - Basic SQL Query Syntax

Ch 3.6 - SQL Subqueries

Ch 3.7 - SQL: Inner Joins

Ch 3.8 - SQL: Full Outer Joins

Ch 3.9 - SQL: GROUP BY Clause

Ch 3.10 - Create & Run a SQL Script

Ch 3.11 - SQL Scripts vs. Queries

Ch 3.12 - SQL Scripting

Ch 4 - Data Types in SQL

Ch 4.1 - Character and Numeric Data Types.

Ch 4.2 - INT & SMALLINT Data Types

Ch 4.3 - Decimal and Floating-Point Data Types

Ch 4.4 - REAL, FLOAT & DOUBLE Data Types

Ch 4.5 - BOOLEAN Data Types

Ch 4.6 - DATE, TIME & TIMESTAMP Data Types

Ch 4.7 - BINARY LARGE OBJECT Data Types

Ch 5 - Variations of SQL

Ch 5.1 - Transact-SQL (T-SQL)

Ch 5.2 - PL/SQL

Ch 5.3 - Dynamic SQL

Ch 6 - Relational Data Modeling

Ch 6.1 - Abstract Data Models

Ch 6.2 - UML Object Diagram

Ch 6.3 - UML Class Diagram

Ch 6.4 - Database Schema

Ch 6.5 - Database Schema Design

Ch 7 - Relational Database Design

Ch 7.1 - Primary Key

Ch 7.2 - Foreign Key

Ch 7.3 - Database Relationships

Ch 7.4 - Database Table

Ch 7.5 - Design a Relational Database

Ch 7.6 - Database Normalization

Ch 7.7 - SQL Normalization

Ch 7.8 - First Normal Form

Ch 7.9 - Third Normal Form

Ch 8 - Database Management Commands

Ch 8.1 - SQL Constraints

Ch 8.2 - Basic SQL Commands

Ch 8.3 - Database Creation and Deletion

Ch 8.4 - Data Manipulation Language (DML)

Ch 8.5 - SQL: INSERT Statement

Ch 8.6 - SQL: UPDATE Statement

Ch 8.7 - SQL: DELETE Statement

Ch 8.8 - SQL DROP Columns & Rows

Ch 8.9 - SQL DROP Index & DROP Database

Ch 8.10 - Practical Database Programming

Ch 9 - Database Administration & Security

Ch 9.1 - Responsibilities of Database Administrators

Ch 9.2 - Concurrency Control and Locking

Ch 9.3 - Persistence in Databases

Ch 9.4 - Two-Phased Locking, Releasing Locks & Deadlocks in Databases

Ch 9.5 - ACID Properties

Ch 9.6 - Cursor in SQL

Ch 9.7 - Database Security