National CAE Designated Institution
  • Online, Instructor-Led
Course Description

Theory and practice of databases with emphasis on how to create, maintain, and query a database with SQL. Relational databases and relational algebra; queries and data manipulation in SQL, constraints, triggers, views, controlling security, data modeling, and normalization, recursive queries, indexing, XML, and other topics.

Learning Objectives

Students should be able to: 1) describe basic concepts of the relational data model, relational database design, and indexing; 2) use SQL for schema definition: creating tables with specifying data types and constraints; 3) use SQL for data manipulation: insertions, deletions, updates; 4) use SQL for data retrieval: queries with subqueries, aggregation, grouping.

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):

Specialty Areas

  • Data Administration

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.