Sign In to Download the Syllabus
The Computer Science 381 syllabus is available to enrolled or registered students. Sign in to your UPI Study account to download it instantly — or enroll today to get access.
Once signed in, the syllabus will download automatically. No extra steps.
Database
Programming
Go beyond queries and build the database logic that powers real applications. A hands-on course for developers who want to work at depth.
What You'll Learn
A full semester of database programming — completed at your own pace, with no deadlines or fixed class times.
What You'll Be Able to Do
- Evaluate the impact and significance of database applications across various industries
- Design and implement effective database schemas based on key design principles and requirements
- Apply normalization rules to enhance database integrity and performance
- Develop and optimize complex SQL queries using advanced techniques for effective data manipulation and retrieval
- Master SQL commands — including DDL, DML, and DCL — to manage database systems efficiently; install and configure DBMS platforms like MySQL and SQL Server
- Implement robust security measures to safeguard sensitive data, including SQL injection prevention, encryption, and auditing
- Utilize SQL to perform detailed data analysis and generate insightful reports
Major Course Topics
Course chapters and lessons
Database Programming has 12 chapters across 49 instructional hours, as listed in the course syllabus. Expand any chapter to see the lessons inside it.
- Chapters
- 12
- Lessons
- 81
- Instructional hours
- 49 hrs
- Semester hours
- 3
Chapter 1
Getting Started with Databases and SQL Setup
- 1.1 What Are Database Applications? Purpose and Significance
- 1.2 Varieties of Database Programs: Tools and Use Cases
- 1.3 Planning a Database Schema: Key Ideas and Steps
- 1.4 Querying Databases: Definitions and Essential Tools
- 1.5 DDL, DML, and DCL in MySQL: What They Do and When to Use Them
- 1.6 SQL Command Essentials: The Must-Know Statements
- 1.7 Installing Your Database Environment — MySQL and SQL Server Express Setup Guide
Chapter 2
Normalization and Data Integrity
- 2.1 Making Data Clean: Normalization Rules in SQL
- 2.2 Understanding Normal Forms: Types and Worked Examples
- 2.3 Breaking Down First Normal Form (1NF) with Examples
- 2.4 Achieving Third Normal Form (3NF): Walkthrough and Examples
- 2.5 Primary Keys in SQL: What They Are and How to Use Them
- 2.6 Foreign Keys in SQL: Linking Tables Together
- 2.7 SQL Constraints: Enforcing Rules on Your Data
Chapter 3
Data Definition Language and Schema Design
- 3.1 Data Definition Language (DDL): Concepts and Examples
- 3.2 A Complete Guide to DDL Commands
- 3.3 Schemas in SQL: Definitions and Design Fundamentals
- 3.4 Character Data Types: CHAR vs. VARCHAR
- 3.5 Whole Number Data Types: INT and SMALLINT
Chapter 4
SQL Data Types in Depth
- 4.1 Precision Number Types: DECIMAL and NUMERIC
- 4.2 Floating-Point Data Types: REAL, FLOAT, and DOUBLE
- 4.3 Working with BOOLEAN Values in SQL
- 4.4 Date and Time Data Types: DATE, TIME, and TIMESTAMP
- 4.5 Storing Binary Data: The BLOB Type
- 4.6 Writing Advanced SQL Queries: Techniques and Patterns
Chapter 5
Querying, Filtering, and Sorting Data
- 5.1 Adding Records with the INSERT Statement
- 5.2 Controlling Result Size: Limiting Query Output
- 5.3 Handling Missing Values with the ISNULL Function
- 5.4 Core Concepts for Manipulating Databases with SQL
- 5.5 Ordering Results: Sorting Techniques in SQL
- 5.6 Built-In SQL Functions: How and When to Use Them
- 5.7 Replacing Nulls with the NVL Function
- 5.8 Conditional Logic in SQL: The CASE Statement
- 5.9 Grouping Rows and Calculating Summaries with GROUP BY
- 5.10 Filtering Grouped Results and Advanced Aggregation with HAVING
Chapter 6
Data Retrieval and Modification
- 6.1 Hands-On Data Retrieval: Practical Database Exercises
- 6.2 Data Manipulation Language (DML): Commands at a Glance
- 6.3 Changing Records with the UPDATE Statement
- 6.4 Removing Records with the DELETE Statement
- 6.5 Transaction Control Language (TCL): Managing Data Safely
Chapter 7
Text Operations and Practical Data Manipulation
- 7.1 Trimming Text with SQL TRUNCATE String
- 7.2 Clearing Tables with SQL TRUNCATE Table
- 7.3 Hands-On Data Modification: Practice Exercises
Chapter 8
Joining Tables and Combining Data
- 8.1 Understanding SQL Joins — Core Concepts and Inner Join Fundamentals
- 8.2 Left and Right Joins: When and How They Differ
- 8.3 Full Outer Joins: Capturing All Records
- 8.4 Cross Joins: Generating Every Combination
- 8.5 Self-Joins: Joining a Table to Itself
- 8.6 Using Aliases to Simplify SQL Queries
- 8.7 Pulling Data from Multiple Tables: Practical Applications
Chapter 9
Subqueries, Views, and Indexes
- 9.1 Advanced Subqueries: Patterns and Real-World Uses
- 9.2 Correlated Subqueries: How the Inner Query Depends on the Outer
- 9.3 EXISTS, NOT EXISTS, and WITH: Filtering with Subquery Logic
- 9.4 Applying Subqueries in Practical Database Scenarios
- 9.5 Removing Views with SQL DROP View
- 9.6 What Database Indexes Are and How They Speed Up Query Performance
- 9.7 Types of Indexes and the Trade-Offs Between Read Speed and Write Overhead
- 9.8 Creating Indexes in SQL: Steps and Examples
- 9.9 Working with Schema Objects in Practice
- 9.10 Building and Using Temporary Tables in SQL
- 9.11 Altering Table Structures with SQL Commands
Chapter 10
Table Cleanup and Structural Changes
- 10.1 Dropping Columns and Rows from Tables
- 10.2 Removing Constraints with SQL DROP Constraint
- 10.3 Removing Permanent and Temporary Tables with SQL DROP
- 10.4 Dropping Indexes and Databases: Steps and Examples
- 10.5 Hands-On Table Modification Exercises
Chapter 11
Advanced Data Operations and Pattern Matching
- 11.1 UNION vs. JOIN: Understanding the Difference
- 11.2 Summarizing Data with ROLLUP and CUBE
- 11.3 Advanced Data Manipulation Using Subqueries
- 11.4 Inserting Across Multiple Tables: Techniques and Examples
- 11.5 Reshaping Data with PIVOT and UNPIVOT
- 11.6 Hands-On Data Set Manipulation Exercises
- 11.7 Regular Expressions Across Platforms — MySQL and SQL Server Implementation Compared
- 11.8 Applying Regular Expressions: Practical Database Exercises
Chapter 12
Database Security and Auditing
- 12.1 Managing Database Security: Key Practices and Tools
- 12.2 Securing Databases with SQL: Techniques and Examples
- 12.3 How SQL Injection Attacks Exploit Vulnerable Queries — Patterns and Real-World Examples
- 12.4 Defending Against SQL Injection — Parameterized Queries, Input Validation, and Best Practices
- 12.5 Advanced Techniques for Protecting Database Systems
- 12.6 Encrypting Database Data: Methods and Applications
- 12.7 Auditing Databases: Tracking Activity and Ensuring Compliance
These chapters come straight from the official course syllabus, which also sets out the graded assignment and the proctored final exam.
How It Works
Three steps from enrollment to transferable college credit — no campus visits, no application required.
Pick & Enroll
Start one or more courses covering lower or upper division requirements — instantly, today.
Earn College Credit
Watch short video lessons, take quizzes and the final exam — all from home, on your schedule.
Transfer Your Credits
Send earned credits to your school and graduate sooner, at a fraction of the cost.
Does My School Accept This Course?
UPI Study courses carry NCCRS recommendations — the same standard recognized by hundreds of cooperating colleges and universities. Check if your school is on our list and move forward with confidence — or schedule a call with our team.
Students Also Enrolled In
Stack multiple courses to build 6, 9, or 12+ transferable college credits — at a fraction of the cost of most campus options.
UPI Study Courses Include
Master database programming and build a foundation for a tech career.
Go beyond queries and build the database logic that powers real applications. A hands-on course for developers who want to work at depth.
🎯 Why It Matters
- Gain in-demand technical skills recognized by employers
- Understand systems, security, and infrastructure at a practical level
- Build knowledge that applies across IT roles and industries
- Foundation for certifications and advanced study
💼 In-Demand Careers
- IT Support Specialist
- Systems Administrator
- Network Technician
- Security Analyst
- Database Administrator
- Technical Consultant
🚀 How This Sets You Up
- Complete structured lessons and a comprehensive final exam
- Earn 3 transferable college credit hours
- Recognized by NCCRS cooperating universities globally
- Self-paced — no deadlines, no campus visits required
135,000+ Learners.
Real Results.
From college freshmen to career changers, international students to working adults — here's what our community says.
Refer a friend, earn free courses
Your friend gets 25% off their first purchase, and you earn points when they join and buy. 1 point = $1 toward courses, transcripts and Lifetime. Points are never cash.
See how it works →
See the course before you enroll
A 55-second look at Database Programming.
Common Questions Answered.
Everything you need to know about Database Programming — credits, grading, transfer, and how it compares to traditional options.
What is Database Programming?
Do I need prior programming experience?
Is the Database Programming course self-paced for college credit?
How many college credits is Database Programming worth?
How is the Database Programming course graded? Are there exams?
Will my university accept Database Programming credits from UPI Study?
Why take Database Programming online instead of at a traditional university?
Can international students take Database Programming for college credit?
What's the difference between Database Fundamentals and Database Programming?
Do I need to take Fundamentals before Database Programming?
Which database language is used in this course?
Does it cover database design principles?
Where will my college put this credit?
Still have questions? Our team answers within hours — not days.
Book a Free 15-Min Call with UPI Team →We're Here When You Need Us
Book an Advisor Call
Talk directly with our team about how credits transfer and whether your university accepts them.
WhatsApp Support
Quick answers about credits, course selection, pricing, and transfer policies — over WhatsApp.
Transfer Credit Blog
In-depth guides on testing out of courses, transfer credit policies, ACE evaluations, and saving on tuition.
Find My College
Check how your college treats our courses before you enroll.
Why Take College Credits?
Quick answers about transferable online credits, test-out style learning, and NCCRS-recommended options through UPI Study.
Which universities accept these credits?
UPI Study courses carry NCCRS recommendations recognized by hundreds of cooperating colleges and universities across the U.S., Canada, and UK.
Who can take self-paced college courses?
Anyone can enroll — including high school students, incoming college students, adult learners, and students trying to test out of traditional courses.
Why choose this over traditional classes?
Save time and reduce tuition costs. Many students complete prerequisites faster and shorten their time to graduation — at a fraction of the cost.
How many credits can I earn?
This course is NCCRS-recommended for 3 semester credit hours. Transfer as many credits as your university allows — students have transferred anywhere from 3 to 90+ credits depending on their school's policy.
Everything You Need to Succeed
Video-Based Lessons
HD video lectures broken into short, focused modules. Watch at your own pace — pause, rewind, replay any time.
Quizzes & Final Exam
Evaluate your understanding after every section with quizzes and a comprehensive final exam that mirrors real college assessment.
Structured College-Level Course
Structured lessons covering every topic — designed as a standard Database Programming college-level course.
Official Transcript
Complete the course, request your transcript, and transfer 3 credit hours to cooperating universities. No separate exam required.
Earn 3 College Credits
for $250.
Self-paced. No deadlines. NCCRS-recommended, recognized by various NCCRS cooperating universities. Join 135,000+ learners on the UPI Study platform.