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

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

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.

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
More practice by chapter
See practice tests for:
Support