Questions? Speak to an advisor: Request Info

Computer Science 107: Database Fundamentals

Study.com advisor image
Questions about online credit?
Study.com Advisors are available.
Call us or request info by email.

Course Summary

Computer Science 107: Database Fundamentals 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 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

13 chapters in Computer Science 107: Database Fundamentals

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, 13)}}
Ch 1. Introduction to Database Fundamentals {{cp.topicAssetIdToProgress[572965].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - What are Data? - Types, Sources & Definition Score: {{cp.lessonAssetIdToProgress[6123].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[6123].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[6123].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[6123].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What are Databases? - Examples & Types Score: {{cp.lessonAssetIdToProgress[6118].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[6118].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[6118].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[6118].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Database Concepts and Structures: The Elements That Make Up a Database Score: {{cp.lessonAssetIdToProgress[8621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8621].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8621].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8621].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Database Terminology Score: {{cp.lessonAssetIdToProgress[182655].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182655].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182655].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182655].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Database Record: Definition & Explanation Score: {{cp.lessonAssetIdToProgress[182659].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182659].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182659].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182659].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Database Fields: Definition & Types Score: {{cp.lessonAssetIdToProgress[182743].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182743].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182743].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182743].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - What is a Database Management System? - Purpose and Function Score: {{cp.lessonAssetIdToProgress[8622].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8622].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8622].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8622].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Models of Database Management Systems (DBMS) Score: {{cp.lessonAssetIdToProgress[8623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8623].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8623].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8623].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Advantages of Database Management Systems (DBMS) Score: {{cp.lessonAssetIdToProgress[219273].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219273].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219273].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219273].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(1, 13)}}
Ch 2. Relational Database Model {{cp.topicAssetIdToProgress[572967].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - What is an Entity in a Database? Score: {{cp.lessonAssetIdToProgress[182749].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182749].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182749].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182749].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is an Attribute in a Database? Score: {{cp.lessonAssetIdToProgress[182747].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182747].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182747].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182747].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - What is the Entity-Relationship Model? - Diagram & Examples Score: {{cp.lessonAssetIdToProgress[142203].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[142203].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[142203].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[142203].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - 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 5 - Relational Database: Model & Example Score: {{cp.lessonAssetIdToProgress[182721].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182721].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182721].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182721].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(2, 13)}}
Ch 3. Structured Query Language {{cp.topicAssetIdToProgress[572969].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - History of SQL Score: {{cp.lessonAssetIdToProgress[355821].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355821].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355821].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355821].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - 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 3 - 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 4 - What is Query in SQL? Score: {{cp.lessonAssetIdToProgress[355807].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355807].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355807].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355807].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - 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 6 - 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 7 - 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 8 - 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 9 - 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 10 - How to Create & Run a SQL Script Score: {{cp.lessonAssetIdToProgress[355809].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355809].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355809].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355809].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - SQL Scripts vs. Queries Score: {{cp.lessonAssetIdToProgress[355811].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355811].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355811].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355811].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - SQL Scripts: Uses & Examples Score: {{cp.lessonAssetIdToProgress[355813].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355813].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[355813].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[355813].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(3, 13)}}
Ch 4. Data Types in SQL {{cp.topicAssetIdToProgress[572971].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - 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 2 - 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 3 - 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 4 - 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 5 - 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 6 - 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 7 - 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
Week {{::cp.getGoalWeekForTopic(5, 13)}}
Ch 6. Relational Data Modeling {{cp.topicAssetIdToProgress[572975].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Abstract Data Models Score: {{cp.lessonAssetIdToProgress[219395].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219395].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219395].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219395].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is a UML Object Diagram? - Definition & Example Score: {{cp.lessonAssetIdToProgress[440109].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440109].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[440109].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440109].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - What is a UML Class Diagram? - Definition, Symbols & Examples Score: {{cp.lessonAssetIdToProgress[440101].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440101].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[440101].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[440101].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - What is a Database Schema? - Example & Definition Score: {{cp.lessonAssetIdToProgress[182737].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182737].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182737].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182737].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - 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
Week {{::cp.getGoalWeekForTopic(6, 13)}}
Ch 7. Relational Database Design {{cp.topicAssetIdToProgress[572977].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - 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 2 - 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 3 - Relationships in SQL: Examples & Explanation Score: {{cp.lessonAssetIdToProgress[572979].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572979].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572979].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572979].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - 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 5 - Designing a Relational Database: Tutorial & Overview Score: {{cp.lessonAssetIdToProgress[182723].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182723].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182723].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182723].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 - 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 8 - 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 9 - 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
Week {{::cp.getGoalWeekForTopic(7, 13)}}
Ch 8. Creating, Modifying & Deleting Databases {{cp.topicAssetIdToProgress[572981].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - 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 2 - 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 3 - SQL: CREATE DATABASE & DROP DATABASE Statements Score: {{cp.lessonAssetIdToProgress[466725].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466725].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466725].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466725].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - 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 5 - 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 6 - 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 7 - 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 8 - 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 9 - 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 10 - Practical Application for Database Programming: Database Creation in Oracle Database Express
Week {{::cp.getGoalWeekForTopic(8, 13)}}
Ch 9. Database Administration & Security {{cp.topicAssetIdToProgress[572983].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database Administrator: Responsibilities & Activities Score: {{cp.lessonAssetIdToProgress[466721].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466721].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[466721].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[466721].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Database Concurrency & Locking Score: {{cp.lessonAssetIdToProgress[572985].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572985].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572985].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572985].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Persistence in Databases: Definition, Examples & Importance Score: {{cp.lessonAssetIdToProgress[572987].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572987].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572987].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572987].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Two-Phased Locking, Releasing Locks & Deadlocks in Databases Score: {{cp.lessonAssetIdToProgress[572989].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572989].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572989].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572989].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - ACID Properties in Data Base Management Systems (DBMS) Score: {{cp.lessonAssetIdToProgress[219277].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219277].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219277].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219277].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is a Cursor in SQL? - Example & Syntax Score: {{cp.lessonAssetIdToProgress[215563].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215563].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[215563].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[215563].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - 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 8 - Configuration & Documentation for Database Administrators: Overview & Examples Score: {{cp.lessonAssetIdToProgress[572991].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572991].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572991].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572991].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - What is a Distributed Database? - Architecture, Principles & Advantages Score: {{cp.lessonAssetIdToProgress[14059].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14059].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[14059].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[14059].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(9, 13)}}
Ch 10. DBMS & Data Processing Applications {{cp.topicAssetIdToProgress[572993].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - 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 2 - 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 3 - What is Microsoft SQL Server? Score: {{cp.lessonAssetIdToProgress[182669].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182669].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182669].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182669].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Oracle Databases: History & Overview Score: {{cp.lessonAssetIdToProgress[572995].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572995].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572995].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572995].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - What is MySQL? - Overview & Usage Score: {{cp.lessonAssetIdToProgress[572997].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572997].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572997].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572997].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What is Microsoft Access? - History & Overview Score: {{cp.lessonAssetIdToProgress[572999].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572999].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[572999].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[572999].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - Database Reporting Tools: Example & Definition Score: {{cp.lessonAssetIdToProgress[182667].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182667].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182667].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182667].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - Markup Language: Definition & Examples Score: {{cp.lessonAssetIdToProgress[7700].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[7700].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[7700].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[7700].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - XML Schema: Definition & Example Score: {{cp.lessonAssetIdToProgress[62675].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62675].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[62675].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62675].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Web Applications in BIS: Shopping, Travel & Navigation Score: {{cp.lessonAssetIdToProgress[339135].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[339135].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[339135].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[339135].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - Web Page Design and Programming Languages: HTML, XHTML, XML, CSS & JavaScript Score: {{cp.lessonAssetIdToProgress[1749].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[1749].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[1749].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[1749].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - How Data is Displayed on the Internet Score: {{cp.lessonAssetIdToProgress[573001].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[573001].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[573001].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[573001].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(10, 13)}}
Ch 11. Business Intelligence & Data Warehouses {{cp.topicAssetIdToProgress[573003].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - What is Business Intelligence? - Definition & Examples Score: {{cp.lessonAssetIdToProgress[69160].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[69160].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[69160].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[69160].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - What is Big Data? - Definition, Concepts & Uses Score: {{cp.lessonAssetIdToProgress[146730].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[146730].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[146730].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[146730].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Basics of Big Data Score: {{cp.lessonAssetIdToProgress[219193].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219193].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219193].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219193].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - The 4 V's of Big Data: Volume, Velocity, Variety, Veracity Score: {{cp.lessonAssetIdToProgress[219195].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219195].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219195].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219195].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Big Data: Advantages & Challenges Score: {{cp.lessonAssetIdToProgress[219197].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219197].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219197].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219197].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - Applications of Big Data Score: {{cp.lessonAssetIdToProgress[219217].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219217].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219217].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219217].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - Data Warehousing and Data Mining: Information for Business Intelligence Score: {{cp.lessonAssetIdToProgress[8627].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8627].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[8627].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[8627].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - What is a Data Mart? - Design, Types & Example Score: {{cp.lessonAssetIdToProgress[339121].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[339121].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[339121].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[339121].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - Data Quality Issues in Data Warehouses Score: {{cp.lessonAssetIdToProgress[219269].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219269].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219269].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219269].bestScoreQuestions}}  Take Quiz Optional
Lesson 10 - Big Data vs. Data Warehouse Score: {{cp.lessonAssetIdToProgress[219201].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219201].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[219201].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[219201].bestScoreQuestions}}  Take Quiz Optional
Lesson 11 - What is Data Analysis? - Definition & Overview Score: {{cp.lessonAssetIdToProgress[62639].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62639].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[62639].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62639].bestScoreQuestions}}  Take Quiz Optional
Lesson 12 - What is Data Analytics? - Definition & Tools Score: {{cp.lessonAssetIdToProgress[62642].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62642].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[62642].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[62642].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(11, 13)}}
Ch 12. Non-Relational Databases {{cp.topicAssetIdToProgress[573005].percentComplete}}% complete
Course Progress Best Score
Lesson 1 - Database and Spreadsheet Software: Excel, Access, dBase & Lotus 1-2-3 Score: {{cp.lessonAssetIdToProgress[1742].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[1742].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[1742].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[1742].bestScoreQuestions}}  Take Quiz Optional
Lesson 2 - Flat File Database: Definition & Example Score: {{cp.lessonAssetIdToProgress[182725].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182725].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182725].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182725].bestScoreQuestions}}  Take Quiz Optional
Lesson 3 - Flat File Database vs. Relational Database Score: {{cp.lessonAssetIdToProgress[182727].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182727].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182727].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182727].bestScoreQuestions}}  Take Quiz Optional
Lesson 4 - Hierarchical Database: Model & Definition Score: {{cp.lessonAssetIdToProgress[182729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182729].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182729].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182729].bestScoreQuestions}}  Take Quiz Optional
Lesson 5 - Hierarchical Database vs. Relational Database Score: {{cp.lessonAssetIdToProgress[182731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182731].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182731].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182731].bestScoreQuestions}}  Take Quiz Optional
Lesson 6 - What are Subject Databases? - Definition & Types Score: {{cp.lessonAssetIdToProgress[182733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182733].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182733].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182733].bestScoreQuestions}}  Take Quiz Optional
Lesson 7 - What are Database Objects? - Definition & Examples Score: {{cp.lessonAssetIdToProgress[182745].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182745].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182745].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182745].bestScoreQuestions}}  Take Quiz Optional
Lesson 8 - What is an Object-Oriented Database? Score: {{cp.lessonAssetIdToProgress[573007].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[573007].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[573007].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[573007].bestScoreQuestions}}  Take Quiz Optional
Lesson 9 - NoSQL Databases: Design & Types Score: {{cp.lessonAssetIdToProgress[182751].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182751].bestScoreQuestions}}  Take Quiz Optional
Score: {{cp.lessonAssetIdToProgress[182751].bestScoreCorrect}}/{{cp.lessonAssetIdToProgress[182751].bestScoreQuestions}}  Take Quiz Optional
Week {{::cp.getGoalWeekForTopic(12, 13)}}
Ch 13. Required Assignments for Computer Science 107 {{cp.topicAssetIdToProgress[573009].percentComplete}}% complete
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

1
Create Account
2
Register For Exam
3
Take The Exam
4
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 107: Database Fundamentals 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 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.

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:

Request more information

Get in contact with one of our transfer advisors to learn how to earn transferable college credit for Computer Science 107: Database Fundamentals.

Support