Course

Credit Type:
Course
ACE ID:
SDCM-0164
Version:
4
Organization's ID:
Computer Science 303
Organization:
Study.com, LLC
Location:
Online
Length:
16 weeks (40 hours)
Minimum Passing Score:
70
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 3 Database Management
Description

Objective:

The course objective is for learners to be able to design, implement, and evaluate database solutions using data modeling, SQL, and principles of database administration and security.

Learning Outcomes:

  • Explain the theoretical foundations, evolution, and core concepts of database management systems.
  • Design relational database solutions from specified requirements using entity-relationship modeling, normalization, and database design principles.
  • Implement relational databases using SQL queries, joins, views, stored procedures, triggers, and transaction processing techniques.
  • Analyze database administration, performance, integrity, security, and backup and recovery issues in database environments.
  • Evaluate database technology solutions (relational, NoSQL, cloud, distributed) based on suitability, scalability, security, and cost tradeoffs.

General Topics:

  • Fundamentals of Database Technology
  • Database Management Systems and Functions
  • Database Types and Models
  • Database Design Processes
  • Database Modeling and Normalization
  • Database Administration Functions
  • Creating Databases in SQL
  • Advanced SQL Queries
  • Database Security and Administration
  • Alternative Database Technologies
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Project-based Instruction

Methods of Assessment:

  • Quizzes
  • Written Papers
Supplemental Materials
Equivalencies

Other offerings from Study.com, LLC

View All Courses
College Credit Opportunities