Introduction to Computer Science

  1. Database Systems
    1. Database Concepts
      1. Data vs Information
        1. Database Definition
          1. Database Management Systems (DBMS)
            1. Database Applications
            2. Database Models
              1. Hierarchical Model
                1. Network Model
                  1. Relational Model
                    1. Tables (Relations)
                      1. Rows (Tuples)
                        1. Columns (Attributes)
                          1. Keys
                            1. Primary Keys
                              1. Foreign Keys
                                1. Candidate Keys
                                  1. Composite Keys
                                2. Object-Oriented Model
                                  1. NoSQL Models
                                    1. Document Databases
                                      1. Key-Value Stores
                                        1. Column-Family
                                          1. Graph Databases
                                        2. Relational Database Design
                                          1. Entity-Relationship Modeling
                                            1. Entities
                                              1. Attributes
                                                1. Relationships
                                                  1. Cardinality
                                                  2. Normalization
                                                    1. First Normal Form
                                                      1. Second Normal Form
                                                        1. Third Normal Form
                                                          1. Benefits of Normalization
                                                          2. Database Schema
                                                            1. Logical Schema
                                                              1. Physical Schema
                                                                1. Schema Evolution
                                                              2. Structured Query Language (SQL)
                                                                1. SQL Basics
                                                                  1. SQL Standards
                                                                    1. SQL Syntax
                                                                    2. Data Definition Language (DDL)
                                                                      1. CREATE Statements
                                                                        1. ALTER Statements
                                                                          1. DROP Statements
                                                                          2. Data Manipulation Language (DML)
                                                                            1. SELECT Statements
                                                                              1. Basic Queries
                                                                                1. Filtering with WHERE
                                                                                  1. Sorting with ORDER BY
                                                                                    1. Grouping with GROUP BY
                                                                                      1. Joining Tables
                                                                                      2. INSERT Statements
                                                                                        1. UPDATE Statements
                                                                                          1. DELETE Statements
                                                                                          2. Data Control Language (DCL)
                                                                                            1. GRANT Statements
                                                                                              1. REVOKE Statements
                                                                                            2. Database Administration
                                                                                              1. Database Security
                                                                                                1. User Management
                                                                                                  1. Access Control
                                                                                                    1. Data Encryption
                                                                                                    2. Database Performance
                                                                                                      1. Indexing
                                                                                                        1. Query Optimization
                                                                                                          1. Database Tuning
                                                                                                          2. Database Maintenance
                                                                                                            1. Backup Strategies
                                                                                                              1. Recovery Procedures
                                                                                                                1. Database Monitoring

                                                                                                            Previous

                                                                                                            8. Cybersecurity Fundamentals

                                                                                                            Go to top

                                                                                                            Next

                                                                                                            10. Artificial Intelligence and Machine Learning