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