Intermediate Data Management from Florida State University

Intermediate Data Management

Database analysis/management transcends a wide range of skills from data modeling, analysis, scripting, to understanding users, what they do, what they want, as well as statistical analysis and data mining–and, how the developer can meet all of those needs, and code the necessary solutions! This course examines relational database management systems using typical, commercial DBMS, including MySQL, MS SQL Server, Oracle, as well as an introduction to NOSQL (i.e., nonstructured data). Topics include data modeling, database design/implementation, forms and reports, as well as remote access to databases. The goal of this course is to provide students with an intermediate understanding of database design, implementation, and management concepts and techniques.

Course Overview

Overall Proficiency Level

2 - Intermediate

Course Prerequisites

LIS2780 Database Concepts

Training Purpose

Skill 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

Explain the operation of Database Management Systems.
Explain database environments and development processes.
Explain basic information organizational concepts and theories.
Design and implement more advanced logical and physical database solutions.
Utilize client/server database environments.
Use advanced SQL techniques (e.g., advanced queries, inserts, and joins).
Analyze advanced database design and management concepts (e.g., views, stored procedures, and triggers).
Design databases, using advanced modeling techniques, and employing MySQL and MS SQL Server.

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.