MariaDB Database

  1. SQL Fundamentals
    1. Data Definition Language (DDL)
      1. CREATE DATABASE
        1. Syntax and Options
          1. Character Sets and Collations
          2. USE
            1. Switching Databases
            2. CREATE TABLE
              1. Column Definitions
                1. Data Types
                  1. Default Values
                  2. Primary Keys
                    1. Defining Primary Keys
                      1. Auto-Increment Columns
                      2. Foreign Keys
                        1. Defining Foreign Key Constraints
                          1. Referential Actions
                            1. CASCADE
                              1. RESTRICT
                                1. SET NULL
                                  1. SET DEFAULT
                                2. Constraints
                                  1. NOT NULL
                                    1. UNIQUE
                                      1. CHECK
                                        1. DEFAULT
                                      2. ALTER TABLE
                                        1. Adding and Dropping Columns
                                          1. Modifying Columns
                                            1. Adding and Dropping Constraints
                                              1. Renaming Tables
                                              2. DROP TABLE
                                                1. Syntax and Options
                                                  1. Impact on Data and Indexes
                                                  2. DROP DATABASE
                                                    1. Syntax and Options
                                                      1. Precautions and Backups
                                                      2. TRUNCATE TABLE
                                                        1. Differences from DELETE
                                                          1. Use Cases and Limitations
                                                        2. Data Manipulation Language (DML)
                                                          1. INSERT INTO
                                                            1. Single Row Insertion
                                                              1. Multiple Row Insertion
                                                                1. Inserting with SELECT
                                                                  1. Handling Duplicate Keys (ON DUPLICATE KEY UPDATE)
                                                                  2. UPDATE
                                                                    1. Syntax and Options
                                                                      1. Using the WHERE Clause
                                                                        1. Updating Multiple Rows
                                                                        2. DELETE FROM
                                                                          1. Syntax and Options
                                                                            1. Using the WHERE Clause
                                                                              1. Deleting All Rows
                                                                            2. Data Query Language (DQL)
                                                                              1. The SELECT Statement
                                                                                1. Basic Syntax
                                                                                  1. Selecting All Columns vs. Specific Columns
                                                                                  2. FROM Clause
                                                                                    1. Single Table Queries
                                                                                      1. Multiple Table Queries
                                                                                      2. WHERE Clause for Filtering
                                                                                        1. Comparison Operators
                                                                                          1. Logical Operators
                                                                                            1. AND
                                                                                              1. OR
                                                                                                1. NOT
                                                                                                2. Pattern Matching (LIKE)
                                                                                                  1. Range Filtering (BETWEEN)
                                                                                                    1. Set Membership (IN)
                                                                                                      1. Null Checks (IS NULL)
                                                                                                      2. ORDER BY for Sorting
                                                                                                        1. Sorting by One or More Columns
                                                                                                          1. Ascending and Descending Order
                                                                                                          2. LIMIT and OFFSET for Pagination
                                                                                                            1. Limiting Result Sets
                                                                                                              1. Skipping Rows
                                                                                                              2. SELECT DISTINCT for Unique Values
                                                                                                                1. Removing Duplicate Rows
                                                                                                                2. Column Aliases
                                                                                                                  1. Using AS Keyword
                                                                                                                    1. Improving Readability

                                                                                                                Previous

                                                                                                                2. Installation and Initial Setup

                                                                                                                Go to top

                                                                                                                Next

                                                                                                                4. Data Types