Summarizing Database Concepts
Goals
- Describe different data structures.
- Identify relational and non-relational databases.
- Describe the way we use tables, primary keys, and normalization.
- Differentiate field data types.
Describe Different Data Structures
- Structured Data versus Unstructured Data
- Structured Data
- Unstructured Data
- Semi-Structured Data
Identify Relational and Non-Relational Databases
- Relational Databases
- ACID Principles
- Non-Relational Databases
- Key Differences between Relational and Non-Relational Databases
Describe the Way We Use Tables, Primary Keys, and Normalization
- Normalization
- Relationships in Data
- Primary Keys and Indexing
- Types of Database Relationships
- Referential Integrity
- Denormalized Data
Differentiate Field Data Types
- Introduction to Field Data Types
- Field Data Types
- String Data Types
- Date Data Type
- Numeric Data Types
- Currency Data Type
- Boolean Data Type
- Spatial Data
- Large Objects
- Data Type Conversion
- Universally Unique Identifier (UUID)