Course

Credit Type:
Course
ACE ID:
SDCM-0212
Version:
2
Organization's ID:
Computer Science 107
Organization:
Study.com, LLC
Length:
20 weeks (45 hours)
Minimum Passing Score:
70
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 database fundamentals
Description

Objective:

The course objective is to introduce students to the fundamentals of databases. Students will learn about database models and designs, structure query language, administration and security, and business intelligence.

Learning Outcomes:

  • Describe the purpose of a database and its structure
  • Explain the difference in various database models
  • Utilize data modeling tools to design a database
  • Use Structured Query Language (SQL) to create a database and manipulate data in a database
  • Explain database security and policy development
  • Explain the different methods to connect and display data from a database

General Topics:

  • Introduction to database fundamentals
  • Relational database model
  • Structured query language
  • Data types in SQL
  • Variations of SQL
  • Relational data modeling
  • Relational database design
  • Creating, modifying and deleting databases
  • Database administration and security
  • DBMS and data processing applications
  • Business intelligence and data warehouses
  • Non-relational databases
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials

Methods of Assessment:

  • Examinations
  • Other
  • Quizzes
  • Students will demonstrate how to create a simple database.
Supplemental Materials
Equivalencies

Other offerings from Study.com, LLC

View All Courses
College Credit Opportunities