Course Summary

Computer Science 204: Database Programming has been evaluated and recommended for 3 semester hours and may be transferred to over 2,000 colleges and universities. With this self-paced course, you get engaging lessons, expert instructors who make even the most challenging database programing topics simple, and an excellent resource for getting a head start on your degree.

Create an account
to start this course today

Try it risk-free for 30 days

Create an account
Try it risk-free for 30 days

12 chapters in Computer Science 204: Database Programming

expand all | collapse all

Course Practice Test

Check your knowledge of this course with a 50-question practice test.

Comprehensive test covering all topics
Detailed video explanations for wrong answers

Take Practice Test

View all practice tests in this course

Week {{::cp.getGoalWeekForTopic(0, 12)}}

Ch 1. Intro to Relational Database Management Systems {{cp.topicAssetIdToProgress[574311].percentComplete}}% complete

	Best Score
Lesson 1 - What is a Relational Database? - Elements, Design & Advantages	Take Quiz
		Take Quiz
Lesson 2 - What is a Database Application?	Take Quiz
Lesson 3 - Database Programs: Types & Examples	Take Quiz
Lesson 4 - How to Design a Database Schema	Take Quiz
Lesson 5 - SQL Normalization: Example & Rules	Take Quiz
Lesson 6 - What is Normal Form in DBMS? - Types & Examples	Take Quiz
Lesson 7 - First Normal Form in DBMS with Examples	Take Quiz
Lesson 8 - Third Normal Form in DBMS with Examples	Take Quiz
Lesson 9 - Database Query: Definition & Tools	Take Quiz
Lesson 10 - What are DDL, DML and DCL in MySQL?	Take Quiz
Lesson 11 - Basic SQL Commands in Database Management Systems (DBMS)	Take Quiz
Lesson 12 - Installing Oracle Database Express Edition for Database Programming
Lesson 13 - Installing MySQL for Database Programming
Lesson 14 - Installing SQL Server Express Edition for Database Programming

Week {{::cp.getGoalWeekForTopic(1, 12)}}

Ch 2. Creating & Managing Database Tables {{cp.topicAssetIdToProgress[574319].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Database Table: Design & Conventions			Take Quiz
	Lesson 2 - Data Definition Language (DDL): Definition & Example			Take Quiz
	Lesson 3 - Data Definition Language (DDL) Commands			Take Quiz
	Lesson 4 - What is a Primary Key in SQL?			Take Quiz
	Lesson 5 - What is a Foreign Key in SQL?			Take Quiz
	Lesson 6 - What is a Schema in SQL? - Definition & Design			Take Quiz
	Lesson 7 - SQL Data Types: CHAR & VARCHAR			Take Quiz
	Lesson 8 - SQL Data Types: INT & SMALLINT			Take Quiz
	Lesson 9 - SQL Data Types: DECIMAL & NUMERIC			Take Quiz
	Lesson 10 - SQL Data Types: REAL, FLOAT & DOUBLE			Take Quiz
	Lesson 11 - SQL Data Types: BOOLEAN			Take Quiz
	Lesson 12 - SQL Data Types: DATE, TIME & TIMESTAMP			Take Quiz
	Lesson 13 - SQL Data Types: BINARY LARGE OBJECT			Take Quiz
	Lesson 14 - SQL: Constraints			Take Quiz
	Lesson 15 - Practical Application for Database Programming: Database Creation in Oracle Database Express

Week {{::cp.getGoalWeekForTopic(2, 12)}}

Ch 3. Populating & Retrieving Data in Databases {{cp.topicAssetIdToProgress[574323].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Basic SQL Query Syntax			Take Quiz
	Lesson 2 - Advanced SQL Query Syntax			Take Quiz
	Lesson 3 - SQL: INSERT Statement			Take Quiz
	Lesson 4 - How to Limit the Results of a SELECT SQL Query			Take Quiz
	Lesson 5 - SQL: ISNULL Function			Take Quiz
	Lesson 6 - Structured Query Language: Manipulating Databases Using SQL			Take Quiz
	Lesson 7 - How to Sort the Results of an SQL Query			Take Quiz
	Lesson 8 - What are SQL Functions? - Use & Examples			Take Quiz
	Lesson 9 - SQL: NVL Function			Take Quiz
	Lesson 10 - SQL: CASE Statement			Take Quiz
	Lesson 11 - SQL: GROUP BY Clause			Take Quiz
	Lesson 12 - Advanced Use of the GROUP BY Clause in SQL			Take Quiz
	Lesson 13 - Practical Application for Database Programming: Retrieving Data in Databases

Week {{::cp.getGoalWeekForTopic(3, 12)}}

Ch 4. Manipulating Data in Databases {{cp.topicAssetIdToProgress[574337].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Data Manipulation Language (DML): Definition & Example			Take Quiz
	Lesson 2 - Data Manipulation Language (DML) Commands			Take Quiz
	Lesson 3 - SQL: UPDATE Statement			Take Quiz
	Lesson 4 - SQL: DELETE Statement			Take Quiz
	Lesson 5 - TCL & How to Control Transactions in SQL			Take Quiz
	Lesson 6 - SQL TRUNCATE String: Tutorial & Overview			Take Quiz
	Lesson 7 - SQL TRUNCATE Table: Tutorial & Explanation			Take Quiz
	Lesson 8 - Practical Lesson for Database Programming: Manipulating Data

Week {{::cp.getGoalWeekForTopic(4, 12)}}

Ch 5. Data Queries in Multiple Tables Using Joins {{cp.topicAssetIdToProgress[574343].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - SQL Complex Queries: Functionality & Examples			Take Quiz
	Lesson 2 - SQL Join: Definition & Examples			Take Quiz
	Lesson 3 - SQL: Inner Joins			Take Quiz
	Lesson 4 - SQL: Left & Right Joins			Take Quiz
	Lesson 5 - SQL: Full Outer Joins			Take Quiz
	Lesson 6 - SQL: Cross Joins			Take Quiz
	Lesson 7 - SQL: Self-Joins			Take Quiz
	Lesson 8 - Aliases in SQL: Syntax & Examples			Take Quiz
	Lesson 9 - Practical Application for Database Programming: Displaying Data from Different Tables

Week {{::cp.getGoalWeekForTopic(5, 12)}}

Ch 6. Data Queries in Multiple Tables Using Subqueries {{cp.topicAssetIdToProgress[574349].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - SQL Subqueries: Example & Definition			Take Quiz
	Lesson 2 - Advanced SQL Subqueries: Use & Examples			Take Quiz
	Lesson 3 - SQL Correlated Subqueries: Use & Examples			Take Quiz
	Lesson 4 - SQL: EXISTS, NOT EXISTS & WITH			Take Quiz
	Lesson 5 - Practical Application for Database Programming: Using Subqueries

Week {{::cp.getGoalWeekForTopic(6, 12)}}

Ch 7. Views & Indexes in Databases {{cp.topicAssetIdToProgress[574359].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - SQL Views: Definition & Example			Take Quiz
	Lesson 2 - SQL DROP View: Tutorial & Overview			Take Quiz
	Lesson 3 - What is a Database Index? - Definition & Tutorial			Take Quiz
	Lesson 4 - Indexes in SQL			Take Quiz
	Lesson 5 - SQL: CREATE Index			Take Quiz
	Lesson 6 - Practical Application for Database Programming: Using Schema Objects

Week {{::cp.getGoalWeekForTopic(7, 12)}}

Ch 8. Modifying Tables in Databases {{cp.topicAssetIdToProgress[574363].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Modifying Tables Using SQL			Take Quiz
	Lesson 2 - SQL DROP Columns & Rows: Tutorial			Take Quiz
	Lesson 3 - SQL DROP Constraint: Tutorial & Overview			Take Quiz
	Lesson 4 - Referential Integrity & Constraints in Databases: Definition & Example			Take Quiz
	Lesson 5 - SQL DROP Table: Tutorial & Explanation			Take Quiz
	Lesson 6 - SQL DROP Temp Table: Tutorial & Explanation			Take Quiz
	Lesson 7 - SQL DROP Index & DROP Database: Tutorial			Take Quiz
	Lesson 8 - Practical Application for Database Programming: Modifying Tables in Databases

Week {{::cp.getGoalWeekForTopic(8, 12)}}

Ch 9. Manipulating Large Data Sets in Databases {{cp.topicAssetIdToProgress[574371].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - SET Operators in Database Management: Definition & Use			Take Quiz
	Lesson 2 - SQL: UNION vs. JOIN			Take Quiz
	Lesson 3 - Grouping Data in Databases: ROLLUP & CUBE			Take Quiz
	Lesson 4 - Manipulating Data Using Subqueries			Take Quiz
	Lesson 5 - Multi-Table Inserts in Databases: Example & Use			Take Quiz
	Lesson 6 - SQL: PIVOT & UNPIVOT			Take Quiz
	Lesson 7 - Practical Application for Database Programming: Manipulating Sets

Week {{::cp.getGoalWeekForTopic(9, 12)}}

Ch 10. Developing & Using Regular Expressions in Databases {{cp.topicAssetIdToProgress[574383].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Regular Expressions: Definition & Example			Take Quiz
	Lesson 2 - Regular Expressions in Oracle Databases: Implementation & Use			Take Quiz
	Lesson 3 - Regular Expressions in MySQL Databases: Implementation & Use			Take Quiz
	Lesson 4 - Regular Expressions in SQL Server Databases: Implementation & Use			Take Quiz
	Lesson 5 - Practical Application for Database Programming: Regular Expressions

Week {{::cp.getGoalWeekForTopic(10, 12)}}

Ch 11. Database Security {{cp.topicAssetIdToProgress[574395].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Database Administration and Security: Definition and Purpose			Take Quiz
	Lesson 2 - Database Security Management			Take Quiz
	Lesson 3 - Database Security Using SQL			Take Quiz
	Lesson 4 - Advanced Database Security: Cascading, Inference & Statistical Databases			Take Quiz
	Lesson 5 - Advanced Database Security: Query Restrictions, Partitioning & Perturbation			Take Quiz
	Lesson 6 - Database Encryption: Techniques & Applications			Take Quiz
	Lesson 7 - Auditing Databases: Methods & Use			Take Quiz

Week {{::cp.getGoalWeekForTopic(11, 12)}}

Ch 12. Required Assignments for Computer Science 204 {{cp.topicAssetIdToProgress[574405].percentComplete}}% complete

			Course Progress	Best Score
	Lesson 1 - Database Programming - Assignment: Creating & Manipulating a Database

Course Objective

The course objective is to teach students the requisite skills they'll need to create and manage relational database management systems. Students will learn how to populate, manipulate, and retrieve data; write queries for multiple tables; modify tables; and use regular expressions.

Grading Policy

Your grade for this course will be calculated out of 300 points. The minimum score required to pass and become eligible for college credit for this course is 210 points, or an overall course grade of 70%. The table below shows how your overall grade will be calculated.

	Possible Points
Quizzes	100
Assignments	100
Proctored Final Exam	100
Total	300

Quizzes

Quizzes are meant to test your comprehension of each lesson as you progress through the course. Here's a breakdown of how you will be graded on quizzes and how they'll factor into your final score:

You will have 3 attempts to take each quiz for a score.
The highest score of your first 3 attempts will be recorded as your score for each quiz.
When you've completed the course, the highest scores from your first 3 attempts at each quiz will be averaged together and weighed against the total possible points for quizzes. For instance, if your average quiz score is 85%, you'll receive 85 out of 100 possible points for quizzes.
After your initial 3 attempts, you can take a quiz for practice as many times as you'd like.
You will need to pass each quiz with a score of at least 80% to earn course progress for the lesson. However, it is not necessary to earn 80% within the first three quiz attempts.

Assignments

Assignments are intended to assess your application, analysis, and critical thinking skills in relation to the concepts you learn in the course. One assignment is required for this course. You can access them here.

All assignment scores will total up to 100 points.
Your assignment(s) will be graded by a Study.com instructor.
The instructor will provide a graded rubric for you along with feedback on what you did well and what could be improved.
If you are unsatisfied with your score, you will be able to revise and resubmit your assignment(s) twice. You are free to resubmit an assignment within two weeks of your most recent exam attempt or at any point if you have an active college accelerator membership.

Proctored Final Exam

The proctored final exam is a cumulative test designed to ensure that you've mastered the material in the course.

You'll earn points equivalent to the percentage grade you receive on your proctored final. (So if you earn 90% on the final, that's 90 points toward your final grade.)
If you're unsatisfied with your score on the exam, you'll be eligible to retake the exam after a 3-day waiting period.
You can only retake the exam twice, so be sure to use your study guide and fully prepare yourself before you take the exam again.

Items Allowed on Study.com Proctored Exam for Computer Science 204: Database Programming:

Blank scratch paper
Pen or pencil

Items NOT Allowed on Study.com Proctored Exam for Computer Science 204: Database Programming:

Office programs, web browsers, or any programs other than Software Secure (including Study.com lessons)
Textbooks (digital or physical)
Mobile phones, headphones, speakers, TVs, or radios
Notebooks or notes
Any calculators

Course Outcomes

Upon completion of the course, you will be able to:

Define relational databases and explain core concepts of database design (normalization, normal forms, queries, and basic SQL commands)
Explain data definition language, define SQL data types and describe their use, describe constraints, and create primary and foreign keys in a database
Use SQL commands to populate and retrieve data from a database
Define data manipulation language (DML) and explain its use, write SQL statements to update, delete, and manipulate data in a database.
Write SQL commands to retrieve data from multiple tables using joins: inner, left, right, outer, cross, and self joins; define and explain the use of aliases
Write SQL subqueries to query data from multiple tables
Describe views and indexes in databases, Create views and indexes using SQL
Explain how to modify tables in SQL; write SQL commands to drop columns, rows, constraints, tables, temporary tables, and indexes using SQL.
Define sets in databases; write SQL commands to manipulate sets and group data in databases; perform multi-table inserts.
Define regular expressions and explain their use in Oracle, MySQL, and SQL Server
Explain the importance of database security and describe methods for securing databases through management, use SQL tools for database security, and describe auditing and forensic methods for databases.

Prerequisites

There are no prerequisites for this course.

Course Format

Computer Science 204: Database Programming consists of short video lessons that are organized into topical chapters. Each video is approximately 5-10 minutes in length and comes with a quick quiz to help you measure your learning. The course is completely self-paced. Watch lessons on your schedule whenever and wherever you want.

At the end of each chapter, you can complete a chapter test to see if you're ready to move on or have some material to review. Once you've completed the entire course, take the practice test and use the study tools in the course to prepare for the proctored final exam. You may take the proctored final exam whenever you are ready.

How Credit Recommendations Work

This course has been evaluated and recommended by ACE for 3 semester hours in the lower division baccalaureate degree category. To apply for transfer credit, follow these steps:

If you already have a school in mind, check with the registrar to see if the school will grant credit for courses recommended by either ACE or NCCRS.
Complete Computer Science 204: Database Programming by watching video lessons and taking short quizzes.
Take the Computer Science 204: Database Programming final exam directly on the Study.com site.
Request a transcript to be sent to the accredited school of your choice!
Check out this page for more information on Study.com's credit-recommended courses.

Additional Information

Course Topics

Category	Objectives
Intro to Relational Database Management Systems	Describes database applications and queries, designing database schemas and basic SQL commands in database management systems (DBMS)
Creating & Managing Database Tables	Explores data definition language (DDL), primary and foreign keys in SQL and different SQL data types
Populating & Retrieving Data in Databases	Discusses basic and advanced SQL query syntax, SQL functions and sorting the results of a SQL query
Manipulating Data in Databases	Outlines data manipulation language (DML), the UPDATE and DELETE statements in SQL and how to control transactions in SQL
Data Queries in Multiple Tables Using Joins	Explains SQL joins, including inner joins, full outer joins, left and right joins and self-joins, plus aliases in SQL
Data Queries in Multiple Tables Using Subqueries	Details SQL subqueries and correlated subqueries, plus EXISTS, NOT EXISTS and WITH
Views & Indexes in Databases	Defines SQL views, database indexes, indexes in SQL and the CREATE index in SQL
Modifying Tables in Databases	Covers modifying tables using SQL, SQL DROP columns and rows, as well as DROP tables, indexes and databases
Manipulating Large Data Sets in Databases	Identifies concepts of SET operators in database management, UNION vs. JOIN, manipulating data using subqueries and multi-table inserts in databases
Developing & Using Regular Expressions in Databases	Provides information about regular expressions and how they are implemented in Oracle databases, MySQL databases and SQL server databases
Database Security	Identifies database administration and security, database security using SQL, advanced database security and database encryption

College Credit

Learn More

Start Earning College Credit Today

Learn more about the College Accelerator Plan

What to Expect For the Exam

This Study.com course has been evaluated and recommended for college credit. Once you've completed this course, you can take the proctored final exam and potentially earn credit. Follow the steps below to take the exam.

Exam Steps

Create Account

Take The Exam

Get Your Results

Pre-Exam Checklist

Before taking the exam, all of the following requirements must be met:

	A College Accelerator Study.com membership.
	Completed all lessons in Computer Science 204: Database Programming course and achieved 100% Quiz Progress.
	Not attempted to take this exam within the last three days.
	Have available proctored exams in this month of membership.
	Have not taken this exam three times. (0/3)
	Complete the exam readiness quiz.
	Please note: Assignments are required to complete this course for credit. You have submitted / required assignments for this course.

Start Exam Registration

Please meet all of the pre-requirements in the Pre-Exam Checklist in order to take the exam.

Exam Process Details

1. Register For Exam

Registering for the exam is simple. First, be sure you meet the system requirements. Next, you'll need to agree to the academic integrity policy. Then just confirm your name and the exam name, and you're ready to go!

2. Download Software Secure

You'll receive an unique access code. Please write this down — you'll need it to take the exam. Then download Software Secure and follow the installation instructions.

3. Take Exam

The exam contains 50 - 100 multiple choice questions. You will have two hours to complete the exam, so don't start until you're sure you can complete the entire thing. And remember to pace yourself!

4. Get Exam Results

We will send you an email with your official exam results within 1 to 2 weeks. If you would like to raise your grade after receiving your exam results, you can retake quizzes with fewer than 3 attempts. You will then need to retake the final exam.

Earning Credit

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Research Schools, Degrees & Careers

Get the unbiased info you need to find the right school.

Browse Articles By Category

Browse an area of study or degree level.

Area of Study

Degree Level

Computer Science 204: Database Programming