Database Management Systems

  1. SQL (Structured Query Language)
    1. SQL Fundamentals
      1. History and Evolution of SQL
        1. SQL Standards
          1. ANSI SQL Standards
            1. ISO SQL Standards
              1. Vendor-Specific Extensions
              2. SQL Components Overview
              3. Data Definition Language
                1. Database Creation and Management
                  1. CREATE DATABASE
                    1. ALTER DATABASE
                      1. DROP DATABASE
                      2. Table Definition and Management
                        1. CREATE TABLE
                          1. Column Definitions
                            1. Data Types
                              1. Constraints
                              2. ALTER TABLE
                                1. Adding Columns
                                  1. Modifying Columns
                                    1. Dropping Columns
                                      1. Adding Constraints
                                        1. Dropping Constraints
                                        2. DROP TABLE
                                          1. TRUNCATE TABLE
                                          2. Index Management
                                            1. CREATE INDEX
                                              1. DROP INDEX
                                                1. Index Types
                                                2. View Management
                                                  1. CREATE VIEW
                                                    1. ALTER VIEW
                                                      1. DROP VIEW
                                                      2. Data Types
                                                        1. Numeric Types
                                                          1. Character Types
                                                            1. Date and Time Types
                                                              1. Boolean Type
                                                                1. Binary Types
                                                                2. Constraints
                                                                  1. PRIMARY KEY
                                                                    1. FOREIGN KEY
                                                                      1. UNIQUE
                                                                        1. CHECK
                                                                          1. NOT NULL
                                                                            1. DEFAULT
                                                                          2. Data Manipulation Language
                                                                            1. INSERT Operations
                                                                              1. Single Row Insertion
                                                                                1. Multiple Row Insertion
                                                                                  1. INSERT with SELECT
                                                                                  2. UPDATE Operations
                                                                                    1. Simple Updates
                                                                                      1. Conditional Updates
                                                                                        1. Correlated Updates
                                                                                        2. DELETE Operations
                                                                                          1. Simple Deletions
                                                                                            1. Conditional Deletions
                                                                                              1. Cascading Deletions
                                                                                            2. Data Query Language
                                                                                              1. Basic SELECT Structure
                                                                                                1. SELECT Clause
                                                                                                  1. FROM Clause
                                                                                                    1. WHERE Clause
                                                                                                    2. Filtering and Sorting
                                                                                                      1. WHERE Conditions
                                                                                                        1. Comparison Operators
                                                                                                          1. Logical Operators
                                                                                                            1. Pattern Matching with LIKE
                                                                                                              1. NULL Value Handling
                                                                                                                1. ORDER BY Clause
                                                                                                                2. Aggregate Functions
                                                                                                                  1. COUNT Function
                                                                                                                    1. SUM Function
                                                                                                                      1. AVG Function
                                                                                                                        1. MIN Function
                                                                                                                          1. MAX Function
                                                                                                                            1. GROUP BY Clause
                                                                                                                              1. HAVING Clause
                                                                                                                              2. Join Operations
                                                                                                                                1. INNER JOIN
                                                                                                                                  1. LEFT OUTER JOIN
                                                                                                                                    1. RIGHT OUTER JOIN
                                                                                                                                      1. FULL OUTER JOIN
                                                                                                                                        1. CROSS JOIN
                                                                                                                                          1. SELF JOIN
                                                                                                                                            1. Natural Join
                                                                                                                                            2. Subqueries
                                                                                                                                              1. Scalar Subqueries
                                                                                                                                                1. Row Subqueries
                                                                                                                                                  1. Table Subqueries
                                                                                                                                                    1. Correlated Subqueries
                                                                                                                                                      1. EXISTS and NOT EXISTS
                                                                                                                                                        1. IN and NOT IN
                                                                                                                                                        2. Set Operations
                                                                                                                                                          1. UNION
                                                                                                                                                            1. UNION ALL
                                                                                                                                                              1. INTERSECT
                                                                                                                                                                1. EXCEPT
                                                                                                                                                                2. Advanced Query Features
                                                                                                                                                                  1. Window Functions
                                                                                                                                                                    1. Common Table Expressions
                                                                                                                                                                      1. Recursive Queries
                                                                                                                                                                    2. Views
                                                                                                                                                                      1. View Creation
                                                                                                                                                                        1. View Modification
                                                                                                                                                                          1. View Deletion
                                                                                                                                                                            1. Updatable Views
                                                                                                                                                                              1. View Limitations
                                                                                                                                                                                1. Materialized Views
                                                                                                                                                                                2. Data Control Language
                                                                                                                                                                                  1. User Management
                                                                                                                                                                                    1. CREATE USER
                                                                                                                                                                                      1. ALTER USER
                                                                                                                                                                                        1. DROP USER
                                                                                                                                                                                        2. Privilege Management
                                                                                                                                                                                          1. GRANT Statement
                                                                                                                                                                                            1. REVOKE Statement
                                                                                                                                                                                              1. Privilege Types
                                                                                                                                                                                              2. Role Management
                                                                                                                                                                                                1. CREATE ROLE
                                                                                                                                                                                                  1. GRANT ROLE
                                                                                                                                                                                                    1. REVOKE ROLE
                                                                                                                                                                                                  2. Transaction Control Language
                                                                                                                                                                                                    1. Transaction Boundaries
                                                                                                                                                                                                      1. BEGIN TRANSACTION
                                                                                                                                                                                                        1. COMMIT
                                                                                                                                                                                                          1. ROLLBACK
                                                                                                                                                                                                          2. Savepoints
                                                                                                                                                                                                            1. SAVEPOINT
                                                                                                                                                                                                              1. ROLLBACK TO SAVEPOINT
                                                                                                                                                                                                              2. Transaction Isolation Levels
                                                                                                                                                                                                                1. Autocommit Mode

                                                                                                                                                                                                              Previous

                                                                                                                                                                                                              4. Database Design

                                                                                                                                                                                                              Go to top

                                                                                                                                                                                                              Next

                                                                                                                                                                                                              6. Storage and File Structure