Database Management Systems from Florida State University

Database Management Systems

This course is an introductory database course appropriate for students who have basic knowledge about information organization. Although several database models are briefly presented, the course focuses on the relational model, the basis for most currently installed production database management systems (DBMS). The course covers the principles of database design and implementation including relational concepts, data modeling, conceptual and logical database design, use of SQL as a data- manipulation language, and current issues in database administration.

Course Overview

Overall Proficiency Level

2 - Intermediate

Course Prerequisites

n/a

Training Purpose

Functional Development

Specific Audience

All

Delivery Method

Classroom

Online, Instructor-Led

Course Location

600 W College Avenue
Tallahassee, FL 32306

Course Location Map

Your Location
Providers
Courses
Course and Provider Quantity

National CAE Designated Institution

Classroom
Online, Instructor-Led

Learning Objectives

Summarize the advantages/disadvantages of the relational model in resolving users’ needs for storing, organizing, accessing, and protecting data.
Explain relational theory as the conceptual basis for relational database management systems.
Analyze organizational artifacts to identify entities, attributes, relationships, and constraints.
Create an entity-relationship diagram in Universal Modeling Language (UML).
Develop a normalized schema from an entity-relationship diagram.
Construct an operational database in a database management system.
Write SQL statements for data manipulation, retrieval, and organization.

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Competency Areas

Work Roles

Feedback

If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.