Data Engineering

  1. Database Systems and Data Storage
    1. Relational Database Fundamentals
      1. Database Design Principles
        1. Entity-Relationship Modeling
          1. Relational Model Concepts
            1. Primary and Foreign Keys
              1. Referential Integrity
              2. ACID Properties
                1. Atomicity
                  1. Transaction Boundaries
                    1. All-or-Nothing Execution
                    2. Consistency
                      1. Data Integrity Rules
                        1. Constraint Enforcement
                        2. Isolation
                          1. Concurrent Transaction Handling
                            1. Isolation Levels
                            2. Durability
                              1. Persistent Storage
                                1. Recovery Mechanisms
                              2. Database Normalization
                                1. First Normal Form
                                  1. Second Normal Form
                                    1. Third Normal Form
                                      1. Boyce-Codd Normal Form
                                        1. Denormalization Strategies
                                          1. Trade-offs in Normalization
                                          2. Database Indexing
                                            1. Index Types
                                              1. B-Tree Indexes
                                                1. Hash Indexes
                                                  1. Bitmap Indexes
                                                    1. Partial Indexes
                                                    2. Indexing Strategies
                                                      1. Single Column Indexes
                                                        1. Composite Indexes
                                                          1. Covering Indexes
                                                          2. Index Performance Considerations
                                                            1. Index Maintenance Overhead
                                                              1. Query Optimization with Indexes
                                                                1. Index Monitoring and Tuning
                                                              2. NoSQL Database Systems
                                                                1. CAP Theorem
                                                                  1. Consistency
                                                                    1. Availability
                                                                      1. Partition Tolerance
                                                                        1. Trade-offs in Distributed Systems
                                                                        2. BASE Properties
                                                                          1. Basically Available
                                                                            1. Soft State
                                                                              1. Eventual Consistency
                                                                              2. NoSQL Database Types
                                                                                1. Key-Value Stores
                                                                                  1. Use Cases and Examples
                                                                                    1. Data Modeling Patterns
                                                                                    2. Document Databases
                                                                                      1. Document Structure and Querying
                                                                                        1. Schema Flexibility
                                                                                        2. Column-Family Databases
                                                                                          1. Wide Column Storage
                                                                                            1. Time-Series Data Handling
                                                                                            2. Graph Databases
                                                                                              1. Graph Data Models
                                                                                                1. Graph Query Languages
                                                                                                  1. Relationship-Heavy Use Cases
                                                                                                2. NoSQL vs. SQL Trade-offs
                                                                                                  1. Scalability Considerations
                                                                                                    1. Consistency Models
                                                                                                      1. Query Flexibility
                                                                                                        1. Operational Complexity

                                                                                                    Previous

                                                                                                    3. Computer Science and Software Engineering Foundations

                                                                                                    Go to top

                                                                                                    Next

                                                                                                    5. Data Warehousing and Analytics