CS 381: Database Programming

This course lays the foundation for tackling topics like distributed Database Architecture, Query, Transaction Management, and concurrency control. This course also covers parallel DBMS and database interoperability.

Enroll Today to Save Tuition

Course Curriculum

1. Ch 1.1 What is a Relational Database? - Elements, Design & Advantages
2. Database Relationships
3. Rules for Relational Databases
4. Primary and Foreign Keys
5. Cardinality of Relationships
6. Lesson Summary
7. Quiz 1.1
1. Introduction
2. What is a Database Application?
3. The Purpose of Database Applications
4. Working of Database Applications
5. Databases vs. Spreadsheets
6. Database Application Examples
7. Lesson Summary
8. Quiz 1.2
1. Introduction
2. Database Programs
3. Types of Database Programs
4. Relational Database Management System (RDMS)
5. Lesson Summary
6. Quiz 1.3
1. Introduction
2. Database Schemas
3. Designing a Schema
4. Map it Out
5. Lesson Summary
6. Quiz 1.4
1. Introduction
2. What is SQL?
3. What is Normalization?
4. What are the Rules for Normalization?
5. Normalization Types
6. Lesson Summary
7. Quiz 1.5
1. Introduction
2. Database Management System Design
3. Why Do We Go to This Length?
4. What Is Normalization?
5. Lesson Summary
6. Quiz 1.6
1. Introduction
2. First Normal Form
3. Examples of 1NF
4. Lesson Summary
5. Quiz 1.7
1. Introduction
2. Normalization
3. Transitive Dependence
4. 3NF: Examples
5. Practical Concerns
6. Lesson Summary
7. Quiz 1.8
1. Introduction
2. Database Query
3. Example of a Query
4. Using Semicolons
5. Other Operations
6. Microsoft Access Example
7. Lesson Summary
8. Quiz 1.9
1. Introduction
2. The History of SQL, MySQL, DDL, and DML
3. What is DCL in SQL?
4. What is DDL in SQL?
5. What is DML in SQL?
6. DDL vs DML vs DCL
7. Other Types of SQL
8. Lesson Summary
9. Quiz 1.10
1. Introduction
2. DBMS & SQL
3. Basic SQL Commands
4. UPDATE, INSERT, and DELETE Statements
5. Lesson Summary
6. Quiz 1.11
1. Introduction
2. Installing MySQL on a Computer
3. Install the MySQL Server
4. Installing on the Microsoft Operating System
5. First Steps
6. Lesson Summary
1. Introduction
2. Microsoft SQL Server 2017 Express Edition - a basic understanding
3. Downloading the necessary software
4. Installing Microsoft SQL Server 2017 Express Edition
5. Selecting Installation Type
6. Selecting Licensing Terms
7. Selecting Installation Directory
8. Installation Starts
9. Testing the installation
10. Checking creation of new windows services
11. Installing SSMS (SQL Server Management Studio)
12. Lesson Summary
1. Ch 2.1 Database Table: Design & Conventions
2. The Database Table
3. Lesson Summary
4. Quiz 2.1
1. Introduction
2. DDL: Definition
3. Other Functions of DDL
4. Lesson Summary
5. Quiz 2.2
1. Introduction
2. Tweaking the Structure
3. Lesson Summary
4. Quiz 2.3
1. Introduction
2. Using SQL's Primary Keys
3. How Are They Used?
4. Lesson Summary
5. Quiz 2.4
1. Introduction
2. What is a Foreign Key?
3. Primary vs. Foreign Keys
4. Linking Tables
5. Example of a Foreign Key
6. Lesson Summary
7. Quiz 2.5
1. Introduction
2. The Need for Order
3. What is SQL?
4. What is a Schema in SQL?
5. Why are Schemas Important?
6. What Does Schema Design Look Like?
7. Lesson Summary
8. Quiz 2.6
1. Introduction
2. Naming Data Types in SQL
3. Lesson Summary
4. Quiz 2.7
1. Introduction
2. Different Types of Numbers
3. Others
4. Lesson Summary
5. Quiz 2.8
1. Introduction
2. Data Types for Numbers
3. NUMERIC and DECIMAL
4. How Are They Different from Other Data Types?
5. Lesson Summary
6. Quiz 2.9
1. Introduction
2. SQL Data Types
3. The Real & Float Data Types
4. The Double Data Type
5. Lesson Summary
6. Quiz 2.10
1. Introduction
2. What is BOOLEAN?
3. The Use of Boolean Logic
4. Lesson Summary
5. Quiz 2.11
1. Introduction
2. Knowing When in SQL
3. Why Use a Specific Data Type?
4. The TIME Data Type
5. The DATE Data Type
6. The TIMESTAMP Data Type
7. Lesson Summary
8. Quiz 2.12
1. Introduction
2. What's a BLOB?
3. MySQL
4. Lesson Summary
5. Quiz 2.13
1. Introduction
2. Constraining Data
3. Where Does the Constraint Go?
4. Types of Constraints
5. Lesson Summary
6. Quiz 2.14
1. Ch 3.1 Basic SQL Query Syntax
2. Query Concepts
3. What is Syntax?
4. What is a Relational Database?
5. What is Structural Query Language (SQL)?
6. SQL Clauses
7. SQL Statements
8. SQL Syntax Notes
9. SQL Commands and Syntax
10. Lesson Summary
11. Quiz 3.1
1. Introduction
2. Modify or transform raw data extracted from tables
3. Sorting
4. Selective display of records
5. Aggregate functions
6. Lesson Summary
7. Quiz 3.2
1. Introduction
2. How Do We Add Information to the Table?
3. Insert Multiple Records
4. SQL INSERT Examples
5. Lesson Summary
6. Quiz 3.3
1. Introduction
2. The SELECT SQL statement
3. Lesson Summary
4. Quiz 3.4
1. Introduction
2. Dealing With NULL Values
3. Examples
4. Lesson Summary
5. Quiz 3.5
1. Introduction
2. Manipulating a Database
3. Structured Query Language
4. SQL Statements
5. SQL Syntax
6. SQL Operators
7. Lesson Summary
8. Quiz 3.6
1. Introduction
2. ORDER BY Clause in SQL
3. Summary
4. Quiz 3.7
1. Introduction
2. What is SQL Used For?
3. SQL Functions
4. How to Use SQL?
5. SQL Function Examples
6. Lesson Summary
7. Quiz 3.8
1. Introduction
2. NVL-Land
3. Examples
4. Lesson Summary
5. Quiz 3.9
1. Introduction
2. The CASE statement
3. Examples
4. Lesson Summary
5. Quiz 3.10
1. Introduction
2. What is SQL?
3. Grouping Without an Order
4. Grouping With an Order
5. Lesson Summary
6. Quiz 3.11
1. Introduction
2. What Is the GROUP BY Clause in SQL?
3. Using the SQL AVG (Average) Function with GROUP BY
4. Using the SQL SUM function with GROUP BY
5. Using the SQL COUNT function with GROUP BY
6. Lesson Summary
7. Quiz 3.12
1. Introduction
2. Install MySQL
3. Test Data
4. Questions
5. Answer Key
6. Summary
1. Ch 4.1 Data Manipulation Language (DML): Definition & Example
2. What is Data Manipulation Language?
3. Contrasted with Programming Language
4. Uses of DML
5. Examples of DML
6. Lesson Summary
7. Quiz 4.1
1. Introduction
2. Data Manipulation Language
3. Lesson Summary
4. Quiz 4.2
1. Introduction
2. What is SQL?
3. Lesson Summary
4. Quiz 4.3
1. Introduction
2. SQL?
3. Lesson Summary
4. Quiz 4.4
1. Introduction
2. Transaction Control Language (TCL)
3. Conclusion
4. Quiz 4.5
1. Introduction
2. Truncating a String
3. The LEFT function
4. The RIGHT Function
5. The SUBSTR Function
6. Lesson Summary
7. Quiz 4.6
1. Introduction
2. SQL TRUNCATE
3. Difference between DELETE and TRUNCATE
4. Difference between DROP and TRUNCATE
5. SQL TRUNCATE in action
6. Lesson summary
7. Quiz 4.7
1. Lesson Overview and Knowledge Required
2. Test Data
3. Follow-Up Questions
4. Answer Key
5. Lesson Summary
1. Ch 5.1 SQL Complex Queries: Functionality & Examples
2. SQL Complex Queries
3. Inner Join
4. Outer Join
5. Right Outer Join
6. Full Outer Join (Rows That Don't Join)
7. Union
8. Stored Procedures
9. Lesson Summary
10. Quiz 5.1
1. Introduction
2. SQL Join
3. Join Example
4. Lesson Summary
5. Quiz 5.2
1. Introduction
2. A Common Join
3. Example
4. Lesson Summary
5. Quiz 5.3
1. Introduction
2. SQL and the Relational Database
3. Joins
4. Lesson Summary
5. Quiz 5.4
1. Introduction
2. Example
3. Lesson Summary
4. Quiz 5.5
1. Introduction
2. SQL Cross Join
3. Syntax & Examples
4. Practical Uses
5. Lesson Summary
6. Quiz 5.6
1. Introduction
2. Self-Join
3. Aliases
4. Other Examples
5. Lesson Summary
6. Quiz 5.7
1. Introduction
2. Why is Database Aliasing Needed?
3. How is the Aliasing Feature Used?
4. Additional Uses
5. Lesson Summary
6. Quiz 5.8
1. Introduction
2. Program Code
3. Follow-Up Questions
4. Answer Key
1. Ch 6.1 SQL Subqueries: Example & Definition
2. What Is A Subquery?
3. How to Write a Subquery in SQL with SELECT Statements
4. Nested SELECT or INNER SELECT Statements in SQL
5. SQL SELECT Statement Subquery Examples
6. Subquery Rules
7. Lesson Summary
8. Quiz 6.1
1. Introduction
2. What Is a Sub-Query?
3. Nested & Correlated Sub-Queries
4. Lesson Summary
5. Quiz 6.2
1. Introduction
2. What is a sub-query?
3. Using a sub-query within a SELECT statement
4. Lesson Summary
5. Quiz 6.3
1. Introduction
2. Using the EXISTS and NOT EXISTS Operators
3. EXISTS vs. IN Operator
4. Lesson Summary
5. Quiz 6.4
1. Lesson Overview & Knowledge Required
2. Program Code
3. Notes on the test data provided
4. Code Application
5. Follow-Up Questions
6. Answer Key
7. Sample Database Script
1. Ch 7.1 SQL Views: Definition & Example
2. What Is an SQL View?
3. SQL View Syntax
4. Example of an SQL View
5. Materialized Views - Storing Data
6. Lesson Summary
7. Quiz 7.1
1. Introduction
2. DROP View
3. The SQL View
4. IF EXISTS
5. Lesson Summary
6. Quiz 7.2
1. Introduction
2. What a Database Index Is
3. Spreadsheet v. Database Index
4. Full-Text Search Engine Comparison
5. Database Index Types
6. Categories of Database Indexes
7. Lesson Summary
8. Quiz 7.3
1. Introduction
2. What is SQL?
3. What is an Index?
4. Lesson Summary
5. Quiz 7.4
1. Introduction
2. What is an Index?
3. Considerations
4. Unique Index
5. Lesson Summary
6. Quiz 7.5
1. Introduction
2. What are Schema Objects in a Database?
3. Prerequisites
4. Questions
5. Answer Key
6. Lesson Summary
1. Ch 8.1 Referential Integrity & Constraints in Databases: Definition & Example
2. Referential Constraints
3. Referential Integrity
4. Lesson Summary
5. Quiz 8.1
1. Introduction
2. Temporary Tables
3. Uses for Temporary Tables
4. Lesson Summary
5. Quiz 8.2
1. Introduction
2. Simple Modifications to SQL Tables
3. Modifying & Removing Constraints
4. Lesson Summary
5. Quiz 8.3
1. Introduction
2. DROP Columns & Rows
3. Remove a Column
4. Some Examples
5. Delete a Row of Data
6. Lesson Summary
7. Quiz 8.4
1. Introduction
2. What Is a Constraint?
3. Effects of Adding a Constraint
4. Dropping a Constraint
5. Lesson Summary
6. Quiz 8.5
1. Introduction
2. SQL DROP TABLE
3. Database differences
4. Uses
5. Caveats
6. Lesson summary
7. Quiz 8.6
1. Introduction
2. Temp Tables
3. Dropping Tables
4. Lesson Summary
5. Quiz 8.7
1. Introduction
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.8
1. Lesson Overview & Knowledge Required
2. Program Code
3. Code Application
4. Follow-Up Questions
5. Answer Key
1. Ch 9.1 SET Operators in Database Management: Definition & Use
2. What is the SET Operator?
3. Example of SET Operators
4. Caveats
5. SET using UNION and UNION ALL
6. Lesson Summary
7. Quiz 9.1
1. Introduction
2. UNION vs. JOIN
3. What Does UNION Do?
4. What Does JOIN Do?
5. Lesson Summary
6. Quiz 9.2
1. Introduction
2. Simple Grouping Using GROUP BY
3. ROLLUP and CUBE
4. GROUPING Sets
5. Lesson Summary
6. Quiz 9.3
1. Introduction
2. What is a Subquery?
3. How Can We Use Subqueries to Manipulate Data?
4. A Subquery to Create a Table
5. Lesson Summary
6. Quiz 9.4
1. Introduction
2. Exploring the concept of multi-table inserts
3. Multi-table inserts across different SQL implementations
4. Other commonly supported mechanisms
5. Lesson Summary
6. Quiz 9.5
1. Introduction
2. Making Decisions Based On Information
3. PIVOT and UNPIVOT
4. PIVOT and UNPIVOT in Action
5. Lesson Summary
6. Quiz 9.6
1. Introduction
2. Basic Understanding About Sets and How They Are Implemented in Databases
3. Prerequisites
4. Test Data
5. Sets and using set operators to manipulate data:Questions
6. Answer Key
7. Sample Database Script
8. Lesson Summary
1. Ch 10.1 Regular Expressions: Definition & Example
2. What Is A Regular Expression?
3. Complex Examples
4. Lesson Summary
5. Quiz 10.1
1. Introduction
2. Regular Expressions and MySQL
3. Examples on the usage of regular expressions in MySQL
4. Lesson Summary
5. Quiz 10.2
1. Introduction
2. Regular Expression Definition
3. Using Regular Expressions
4. Case Sensitivity
5. Matching Number Patterns
6. Complex Matching
7. Lesson Summary
8. Quiz 10.3
1. Introduction
2. Lesson Overview & Knowledge Required
3. Program Code
1. Ch 11.1 Database Administration and Security: Definition and Purpose
2. Database Administration
3. Security Threats
4. Database Security
5. Lesson Summary
6. Quiz 11.1
1. Introduction
2. What Is Database Security Management?
3. Threats to Database Security
4. Forms
5. Lesson Summary
6. Quiz 11.2
1. Introduction
2. Database Security
3. Controlling Access Permissions
4. Roles
5. Stored Procedures
6. Lesson Summary
7. Quiz 11.3
1. Introduction
2. SQL Injection
3. Prevention of SQL Injection
4. Lesson Summary
5. Quiz 11.4
1. Introduction
2. Cascading Permissions
3. Database Inference
4. Statistical Databases
5. Lesson Summary
6. Quiz 11.5
1. Introduction
2. Advanced Database Security
3. Query Restrictions
4. Database Partition
5. Data Perturbation
6. Lesson Summary
7. Quiz 11.6
1. Introduction
2. Database Encryption
3. Methods of Database Encryption
4. Database Encryption and Security
5. Lesson Summary
6. Quiz 11.7
1. Introduction
2. Database Security
3. Database Auditing
4. Database Forensics
5. Database Integrity
6. Database Imaging
7. Transaction Logs
8. Activity Reconstruction
9. Authentication and Authorization Data
10. Artifact Analysis
11. Lesson Summary
12. Quiz 11.8
1. Assignment
2. Final Exam

About this course

588 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.

Ch 1. Introduction to Relational Database Management Systems

Ch 1.2 What is a Database Application?

Ch 1.3 Database Programs: Types & Examples

Ch 1.4 How to Design a Database Schema

Ch 1.5 SQL Normalization: Example & Rules

Ch 1.6 What is Normal Form in DBMS? - Types & Examples

Ch 1.7 First Normal Form in DBMS with Examples

Ch 1.8 Third Normal Form in DBMS with Examples

Ch 1.9 Database Query: Definition & Tools

Ch 1.10 What are DDL, DML and DCL in MySQL?

Ch 1.11 Basic SQL Commands in Database Management Systems (DBMS)

Ch 1.12 Installing MySQL for Database Programming on PC

Ch 1.13 Installing SQL Server Express Edition for Database Programming

Ch 2. Creating & Managing Database Tables

Ch 2.2 Data Definition Language (DDL): Definition & Example

Ch 2.3 Data Definition Language (DDL) Commands

Ch 2.4 What is a Primary Key in SQL?

Ch 2.5 What is a Foreign Key in SQL?

Ch 2.6 What is a Schema in SQL? - Definition & Design

Ch 2.7 SQL Data Types: CHAR & VARCHAR

Ch 2.8 SQL Data Types: INT & SMALLINT

Ch 2.9 SQL Data Types: DECIMAL & NUMERIC

Ch 2.10 SQL Data Types: REAL, FLOAT & DOUBLE

Ch 2.11 SQL Data Types: BOOLEAN

Ch 2.12 SQL Data Types: DATE, TIME & TIMESTAMP

Ch 2.13 SQL Data Types: BINARY LARGE OBJECT

Ch 2.14 SQL: Constraints

Ch 3. Populating & Retrieving Data in Databases

Ch 3.2 Advanced SQL Query Syntax

Ch 3.3 SQL: INSERT Statement

Ch 3.4 How to Limit the Results of a SELECT SQL Query

Ch 3.5 SQL: ISNULL Function

Ch 3.6 Structured Query Language: Manipulating Databases Using SQL

Ch 3.7 How to Sort the Results of an SQL Query

Ch 3.8 What are SQL Functions? - Use & Examples

Ch 3.9 SQL: NVL Function

Ch 3.10 SQL: CASE Statement

Ch 3.11 SQL: GROUP BY Clause

Ch 3.12 Advanced Use of the GROUP BY Clause in SQL

Ch 3.13 Practical Application for Database Programming: Retrieving Data in Databases

Ch 4. Manipulating Data in Databases

Ch 4.2 Data Manipulation Language (DML) Commands

Ch 4.3 SQL: UPDATE Statement

Ch 4.4 SQL: DELETE Statement

Ch 4.5 TCL & How to Control Transactions in SQL

Ch 4.6 SQL TRUNCATE String: Tutorial & Overview

Ch 4.7 SQL TRUNCATE Table: Tutorial & Explanation

Ch 4.8 Practical Lesson for Database Programming: Manipulating Data

Ch 5. Data Queries in Multiple Tables Using Joins

Ch 5.2 SQL Join: Definition & Examples

Ch 5.3 SQL: Inner Joins

Ch 5.4 SQL: Left & Right Joins

Ch 5.5 SQL: Full Outer Joins

Ch 5.6 SQL: Cross Joins

Ch 5.7 SQL: Self-Joins

Ch 5.8 Aliases in SQL: Syntax & Examples

Ch 5.9 Practical Application for Database Programming: Displaying Data from Different Tables

Ch 6. Data Queries in Multiple Tables Using Subqueries

Ch 6.2 Advanced SQL Subqueries: Use & Examples

Ch 6.3 SQL Correlated Subqueries: Use & Examples

Ch 6.4 SQL: EXISTS, NOT EXISTS & WITH

Ch 6.5 Practical Application for Database Programming: Using Subqueries

Ch 7. Views & Indexes in Databases

Ch 7.2 SQL DROP View: Tutorial & Overview

Ch 7.3 What is a Database Index? - Definition & Tutorial

Ch 7.4 Indexes in SQL

Ch 7.5 SQL: CREATE Index

Ch 7.6 Practical Application for Database Programming: Using Schema Objects

Ch 8. Modifying Tables in Databases

Ch 8.2 Using SQL to Create Temporary Tables - Application & Example

Ch 8.3 Modifying Tables Using SQL

Ch 8.4 SQL DROP Columns & Rows: Tutorial

Ch 8.5 SQL DROP Constraint: Tutorial & Overview

Ch 8.6 SQL DROP Table: Tutorial & Explanation

Ch 8.7 SQL DROP Temp Table: Tutorial & Explanation

Ch 8.8 SQL DROP Index & DROP Database: Tutorial

Ch 8.9 Practical Application for Database Programming: Modifying Tables in Databases

Ch 9. Manipulating Large Data Sets in Databases

Ch 9.2 SQL: UNION vs. JOIN

Ch 9.3 Grouping Data in Databases: ROLLUP & CUBE