for Teachers for Schools for Enterprise
for Teachers for Schools for Enterprise
 Computer Science
First Lesson 

Computer Science 204: Database Programming

Course Summary

This Computer Science 204: Database Programming course provides you with thorough and easy-to-understand lessons you can access on any computer or mobile device at any time. Use this course to refresh your professional knowledge or assist you in your studies.
Create An Account
To Start This Course Today
Try it risk-free for 30 days. Cancel anytime
Create An Account
Try it risk-free for 30 days

11 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, 11)}}
Ch 1. Intro to Relational Database Management Systems {{cp.topicAssetIdToProgress[574311].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - What is a Relational Database? - Elements, Design & Advantages Score: {{cp.lessonAssetIdToProgress[8624].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8624].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8624].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8624].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is a Database Application? Score: {{cp.lessonAssetIdToProgress[182663].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182663].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182663].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182663].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Database Programs: Types & Examples Score: {{cp.lessonAssetIdToProgress[182665].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182665].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182665].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182665].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Design a Database Schema Score: {{cp.lessonAssetIdToProgress[440027].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440027].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[440027].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440027].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL Normalization: Example & Rules Score: {{cp.lessonAssetIdToProgress[215607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215607].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215607].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215607].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is Normal Form in DBMS? - Types & Examples Score: {{cp.lessonAssetIdToProgress[219281].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219281].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219281].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219281].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - First Normal Form in DBMS with Examples Score: {{cp.lessonAssetIdToProgress[219283].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219283].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219283].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219283].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Third Normal Form in DBMS with Examples Score: {{cp.lessonAssetIdToProgress[219285].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219285].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219285].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219285].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Database Query: Definition & Tools Score: {{cp.lessonAssetIdToProgress[182657].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182657].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182657].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182657].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - What are DDL, DML and DCL in MySQL? Score: {{cp.lessonAssetIdToProgress[182697].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182697].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182697].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182697].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - Basic SQL Commands in Database Management Systems (DBMS) Score: {{cp.lessonAssetIdToProgress[219275].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219275].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219275].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219275].bestScoreQuestions}}  Take Quiz Optional
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
Go to chapter Intro to Relational Database Management Systems
Practice test: Intro to Relational Database Management Systems Score: {{cp.topicAssetIdToProgress[574311].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574311].bestScoreQuestions}} Practice test: Intro to Relational Database Management Systems
Week {{::cp.getGoalWeekForTopic(1, 11)}}
Ch 2. Creating & Managing Database Tables {{cp.topicAssetIdToProgress[574319].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database Table: Design & Conventions Score: {{cp.lessonAssetIdToProgress[182741].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182741].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182741].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182741].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Data Definition Language (DDL): Definition & Example Score: {{cp.lessonAssetIdToProgress[182693].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182693].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182693].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182693].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Data Definition Language (DDL) Commands Score: {{cp.lessonAssetIdToProgress[182699].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182699].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182699].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182699].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What is a Primary Key in SQL? Score: {{cp.lessonAssetIdToProgress[215599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215599].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215599].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215599].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - What is a Foreign Key in SQL? Score: {{cp.lessonAssetIdToProgress[215601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215601].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215601].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215601].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is a Schema in SQL? - Definition & Design Score: {{cp.lessonAssetIdToProgress[215611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215611].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215611].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215611].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL Data Types: CHAR & VARCHAR Score: {{cp.lessonAssetIdToProgress[215579].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215579].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215579].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215579].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - SQL Data Types: INT & SMALLINT Score: {{cp.lessonAssetIdToProgress[215581].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215581].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215581].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215581].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - SQL Data Types: DECIMAL & NUMERIC Score: {{cp.lessonAssetIdToProgress[215583].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215583].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215583].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215583].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - SQL Data Types: REAL, FLOAT & DOUBLE Score: {{cp.lessonAssetIdToProgress[215585].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215585].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215585].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215585].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - SQL Data Types: BOOLEAN Score: {{cp.lessonAssetIdToProgress[215587].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215587].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215587].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215587].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - SQL Data Types: DATE, TIME & TIMESTAMP Score: {{cp.lessonAssetIdToProgress[215589].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215589].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215589].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215589].bestScoreQuestions}}  Take Quiz Optional
Lesson 13 - SQL Data Types: BINARY LARGE OBJECT Score: {{cp.lessonAssetIdToProgress[215591].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215591].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215591].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215591].bestScoreQuestions}}  Take Quiz Optional
Lesson 14 - SQL: Constraints Score: {{cp.lessonAssetIdToProgress[215615].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215615].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215615].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215615].bestScoreQuestions}}  Take Quiz Optional
Lesson 15 - Practical Application for Database Programming: Database Creation in Oracle Database Express
Go to chapter Creating & Managing Database Tables
Practice test: Creating & Managing Database Tables Score: {{cp.topicAssetIdToProgress[574319].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574319].bestScoreQuestions}} Practice test: Creating & Managing Database Tables
Week {{::cp.getGoalWeekForTopic(2, 11)}}
Ch 3. Populating & Retrieving Data in Databases {{cp.topicAssetIdToProgress[574323].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Basic SQL Query Syntax Score: {{cp.lessonAssetIdToProgress[215543].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215543].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215543].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215543].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Advanced SQL Query Syntax Score: {{cp.lessonAssetIdToProgress[574325].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574325].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574325].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574325].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: INSERT Statement Score: {{cp.lessonAssetIdToProgress[215623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215623].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215623].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - How to Limit the Results of a SELECT SQL Query Score: {{cp.lessonAssetIdToProgress[574327].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574327].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574327].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574327].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: ISNULL Function Score: {{cp.lessonAssetIdToProgress[215631].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215631].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215631].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215631].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Structured Query Language: Manipulating Databases Using SQL Score: {{cp.lessonAssetIdToProgress[8626].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8626].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8626].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8626].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - How to Sort the Results of an SQL Query Score: {{cp.lessonAssetIdToProgress[574329].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574329].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574329].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574329].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - What are SQL Functions? - Use & Examples Score: {{cp.lessonAssetIdToProgress[574331].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574331].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574331].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574331].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - SQL: NVL Function Score: {{cp.lessonAssetIdToProgress[215629].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215629].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215629].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215629].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - SQL: CASE Statement Score: {{cp.lessonAssetIdToProgress[215633].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215633].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215633].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215633].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - SQL: GROUP BY Clause Score: {{cp.lessonAssetIdToProgress[215559].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215559].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215559].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215559].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - Advanced Use of the GROUP BY Clause in SQL Score: {{cp.lessonAssetIdToProgress[574333].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574333].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574333].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574333].bestScoreQuestions}}  Take Quiz Optional
Lesson 13 - Practical Application for Database Programming: Retrieving Data in Databases
Go to chapter Populating & Retrieving Data in Databases
Practice test: Populating & Retrieving Data in Databases Score: {{cp.topicAssetIdToProgress[574323].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574323].bestScoreQuestions}} Practice test: Populating & Retrieving Data in Databases
Week {{::cp.getGoalWeekForTopic(3, 11)}}
Ch 4. Manipulating Data in Databases {{cp.topicAssetIdToProgress[574337].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Data Manipulation Language (DML): Definition & Example Score: {{cp.lessonAssetIdToProgress[182695].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182695].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182695].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182695].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Data Manipulation Language (DML) Commands Score: {{cp.lessonAssetIdToProgress[182701].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182701].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182701].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182701].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: UPDATE Statement Score: {{cp.lessonAssetIdToProgress[215625].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215625].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215625].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215625].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: DELETE Statement Score: {{cp.lessonAssetIdToProgress[215637].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215637].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215637].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215637].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - TCL & How to Control Transactions in SQL Score: {{cp.lessonAssetIdToProgress[574339].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574339].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574339].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574339].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL TRUNCATE String: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182715].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182715].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182715].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182715].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL TRUNCATE Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182717].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182717].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182717].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182717].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Practical Lesson for Database Programming: Manipulating Data
Go to chapter Manipulating Data in Databases
Practice test: Manipulating Data in Databases Score: {{cp.topicAssetIdToProgress[574337].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574337].bestScoreQuestions}} Practice test: Manipulating Data in Databases
Week {{::cp.getGoalWeekForTopic(4, 11)}}
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 Score: {{cp.lessonAssetIdToProgress[466729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466729].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466729].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL Join: Definition & Examples Score: {{cp.lessonAssetIdToProgress[466733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466733].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466733].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL: Inner Joins Score: {{cp.lessonAssetIdToProgress[215547].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215547].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215547].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215547].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: Left & Right Joins Score: {{cp.lessonAssetIdToProgress[215549].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215549].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215549].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215549].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: Full Outer Joins Score: {{cp.lessonAssetIdToProgress[215551].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215551].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215551].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215551].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL: Cross Joins Score: {{cp.lessonAssetIdToProgress[215553].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215553].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215553].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215553].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL: Self-Joins Score: {{cp.lessonAssetIdToProgress[215555].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215555].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215555].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215555].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Aliases in SQL: Syntax & Examples Score: {{cp.lessonAssetIdToProgress[574345].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574345].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574345].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574345].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Practical Application for Database Programming: Displaying Data from Different Tables
Go to chapter Data Queries in Multiple Tables Using Joins
Practice test: Data Queries in Multiple Tables Using Joins Score: {{cp.topicAssetIdToProgress[574343].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574343].bestScoreQuestions}} Practice test: Data Queries in Multiple Tables Using Joins
Week {{::cp.getGoalWeekForTopic(5, 11)}}
Ch 6. Data Queries in Multiple Tables Using Subqueries {{cp.topicAssetIdToProgress[574349].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL Subqueries: Example & Definition Score: {{cp.lessonAssetIdToProgress[215545].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215545].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215545].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215545].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Advanced SQL Subqueries: Use & Examples Score: {{cp.lessonAssetIdToProgress[574351].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574351].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574351].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574351].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL Correlated Subqueries: Use & Examples Score: {{cp.lessonAssetIdToProgress[574353].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574353].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574353].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574353].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - SQL: EXISTS, NOT EXISTS & WITH Score: {{cp.lessonAssetIdToProgress[574355].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574355].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574355].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574355].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Practical Application for Database Programming: Using Subqueries
Go to chapter Data Queries in Multiple Tables Using Subqueries
Practice test: Data Queries in Multiple Tables Using Subqueries Score: {{cp.topicAssetIdToProgress[574349].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574349].bestScoreQuestions}} Practice test: Data Queries in Multiple Tables Using Subqueries
Week {{::cp.getGoalWeekForTopic(6, 11)}}
Ch 7. Views & Indexes in Databases {{cp.topicAssetIdToProgress[574359].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - SQL Views: Definition & Example Score: {{cp.lessonAssetIdToProgress[466731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466731].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466731].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL DROP View: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182713].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182713].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182713].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182713].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - What is a Database Index? - Definition & Tutorial Score: {{cp.lessonAssetIdToProgress[182739].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182739].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182739].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182739].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Indexes in SQL Score: {{cp.lessonAssetIdToProgress[215597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215597].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215597].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215597].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: CREATE Index Score: {{cp.lessonAssetIdToProgress[215621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215621].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215621].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Practical Application for Database Programming: Using Schema Objects
Go to chapter Views & Indexes in Databases
Practice test: Views & Indexes in Databases Score: {{cp.topicAssetIdToProgress[574359].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574359].bestScoreQuestions}} Practice test: Views & Indexes in Databases
Week {{::cp.getGoalWeekForTopic(7, 11)}}
Ch 8. Modifying Tables in Databases {{cp.topicAssetIdToProgress[574363].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Modifying Tables Using SQL Score: {{cp.lessonAssetIdToProgress[574365].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574365].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574365].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574365].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL DROP Columns & Rows: Tutorial Score: {{cp.lessonAssetIdToProgress[182703].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182703].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182703].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182703].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - SQL DROP Constraint: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182705].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182705].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182705].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182705].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Referential Integrity & Constraints in Databases: Definition & Example Score: {{cp.lessonAssetIdToProgress[574367].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574367].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574367].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574367].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL DROP Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182707].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182707].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182707].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182707].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - SQL DROP Temp Table: Tutorial & Explanation Score: {{cp.lessonAssetIdToProgress[182709].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182709].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182709].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182709].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - SQL DROP Index & DROP Database: Tutorial Score: {{cp.lessonAssetIdToProgress[182711].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182711].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182711].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182711].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Practical Application for Database Programming: Modifying Tables in Databases
Go to chapter Modifying Tables in Databases
Practice test: Modifying Tables in Databases Score: {{cp.topicAssetIdToProgress[574363].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574363].bestScoreQuestions}} Practice test: Modifying Tables in Databases
Week {{::cp.getGoalWeekForTopic(8, 11)}}
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 Score: {{cp.lessonAssetIdToProgress[574373].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574373].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574373].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574373].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - SQL: UNION vs. JOIN Score: {{cp.lessonAssetIdToProgress[215557].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215557].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215557].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215557].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Grouping Data in Databases: ROLLUP & CUBE Score: {{cp.lessonAssetIdToProgress[574375].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574375].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574375].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574375].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Multi-Table Inserts in Databases: Example & Use Score: {{cp.lessonAssetIdToProgress[574379].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574379].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574379].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574379].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - SQL: PIVOT & UNPIVOT Score: {{cp.lessonAssetIdToProgress[215561].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215561].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215561].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215561].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Practical Application for Database Programming: Manipulating Sets
Go to chapter Manipulating Large Data Sets in Databases
Practice test: Manipulating Large Data Sets in Databases Score: {{cp.topicAssetIdToProgress[574371].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574371].bestScoreQuestions}} Practice test: Manipulating Large Data Sets in Databases
Week {{::cp.getGoalWeekForTopic(9, 11)}}
Ch 10. Developing & Using Regular Expressions in Databases {{cp.topicAssetIdToProgress[574383].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Regular Expressions: Definition & Example Score: {{cp.lessonAssetIdToProgress[574385].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574385].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574385].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574385].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Regular Expressions in Oracle Databases: Implementation & Use Score: {{cp.lessonAssetIdToProgress[574387].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574387].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574387].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574387].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Regular Expressions in MySQL Databases: Implementation & Use Score: {{cp.lessonAssetIdToProgress[574389].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574389].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574389].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574389].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Regular Expressions in SQL Server Databases: Implementation & Use Score: {{cp.lessonAssetIdToProgress[574391].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574391].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574391].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574391].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Practical Application for Database Programming: Regular Expressions
Go to chapter Developing & Using Regular Expressions in Databases
Practice test: Developing & Using Regular Expressions in Databases Score: {{cp.topicAssetIdToProgress[574383].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574383].bestScoreQuestions}} Practice test: Developing & Using Regular Expressions in Databases
Week {{::cp.getGoalWeekForTopic(10, 11)}}
Ch 11. Database Security {{cp.topicAssetIdToProgress[574395].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database Administration and Security: Definition and Purpose Score: {{cp.lessonAssetIdToProgress[9269].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[9269].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[9269].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[9269].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Database Security Management Score: {{cp.lessonAssetIdToProgress[199789].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[199789].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[199789].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[199789].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Database Security Using SQL Score: {{cp.lessonAssetIdToProgress[466737].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466737].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466737].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466737].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Advanced Database Security: Cascading, Inference & Statistical Databases Score: {{cp.lessonAssetIdToProgress[574397].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574397].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574397].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574397].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Advanced Database Security: Query Restrictions, Partitioning & Perturbation Score: {{cp.lessonAssetIdToProgress[574399].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574399].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574399].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574399].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Database Encryption: Techniques & Applications Score: {{cp.lessonAssetIdToProgress[574401].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574401].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574401].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574401].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - Auditing Databases: Methods & Use Score: {{cp.lessonAssetIdToProgress[574403].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574403].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[574403].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[574403].bestScoreQuestions}}  Take Quiz Optional
Go to chapter Database Security
Practice test: Database Security Score: {{cp.topicAssetIdToProgress[574395].bestScoreCorrect}}/{{cp.topicAssetIdToProgress[574395].bestScoreQuestions}} Practice test: Database Security
Earning Credit

Earning College Credit

Did you know… We have over 160 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.

Recommended Articles
Practice Tests in this course
Check your knowledge of this course with a 50-question practice test. Once you take the test, you will receive a detailed exam report complete with your personal statistics and even specific lessons to focus on! Take the practice test now
Your detailed study guide will include:
  • Answers and detailed explanations to each question
  • Video lessons to explain complicated concepts
Course Practice Test
Computer Science 204: Database Programming
Not Taken
Take Practice Test
More practice by chapter
Ch. 1
Intro to Relational Database Management Systems
Not Taken
Take Practice Test
Ch. 2
Creating & Managing Database Tables
Not Taken
Take Practice Test
Ch. 3
Populating & Retrieving Data in Databases
Not Taken
Take Practice Test
Ch. 4
Manipulating Data in Databases
Not Taken
Take Practice Test
Ch. 5
Data Queries in Multiple Tables Using Joins
Not Taken
Take Practice Test
Ch. 6
Data Queries in Multiple Tables Using Subqueries
Not Taken
Take Practice Test
Ch. 7
Views & Indexes in Databases
Not Taken
Take Practice Test
Ch. 8
Modifying Tables in Databases
Not Taken
Take Practice Test
Ch. 9
Manipulating Large Data Sets in Databases
Not Taken
Take Practice Test
Ch. 10
Developing & Using Regular Expressions in Databases
Not Taken
Take Practice Test
Ch. 11
Database Security
Not Taken
Take Practice Test
See practice tests for:

Explore our library of over 75,000 lessons

Browse by subject
Support