Database Structures, Query Logic, and Security Administration

This chapter introduces the database concepts needed to understand how systems store and control information. The emphasis is on structure, access, and integrity rather than deep technical administration.

In This Chapter

• Relational Databases, Schemas, and Normalization explains the structural logic behind organized data storage.
• SQL Queries: Common Commands, Clauses, Operators introduces the query concepts most relevant to understanding data retrieval.
• Data Dictionary and Data Integrity Controls covers the mechanisms that support consistent, accurate data definitions.
• Database Security and User Access addresses access restriction and protection within the database environment.

How to Use This Chapter

• Read this chapter when database language is becoming a barrier to understanding controls.
• Focus on how structure and access rules support data integrity.
• Return here whenever an ISC question relies on knowing how data is organized or retrieved.

In this section

• Relational Databases, Schemas, Normalization, and Redundancy Control
  Relational databases, schemas, normalization, and redundancy control.
• SQL Queries, Clauses, Joins, and Common Operators
  SQL queries, clauses, joins, and common operators.
• Data Dictionaries, Referential Integrity, and Validation Controls
  Data dictionaries, referential integrity, and validation controls.
• Database Security, Encryption, Privileges, and User Access
  Database security, encryption, privileges, and user access.