MySQL Database

  1. SQL Fundamentals: Data Query Language (DQL)
    1. Basic SELECT Operations
      1. Column Selection
        1. All Columns (*)
          1. Specific Column Lists
            1. Column Order Control
            2. Column Aliases
              1. AS Keyword Usage
                1. Alias Naming Rules
                  1. Expression Aliases
                  2. Table Aliases
                    1. Short Table Names
                      1. Multi-Table Queries
                        1. Alias Scope
                      2. Filtering Data
                        1. WHERE Clause Fundamentals
                          1. Condition Specification
                            1. Boolean Evaluation
                              1. Null Handling
                              2. Comparison Operators
                                1. Equality (=)
                                  1. Inequality (<>, !=)
                                    1. Less Than (<)
                                      1. Greater Than (>)
                                        1. Less Than or Equal (<=)
                                          1. Greater Than or Equal (>=)
                                          2. Logical Operators
                                            1. AND Operator
                                              1. Multiple Conditions
                                                1. Precedence Rules
                                                2. OR Operator
                                                  1. Alternative Conditions
                                                    1. Parentheses Usage
                                                    2. NOT Operator
                                                      1. Condition Negation
                                                        1. Complex Expressions
                                                      2. Range and Set Operations
                                                        1. BETWEEN Operator
                                                          1. Inclusive Range Testing
                                                            1. Date Range Queries
                                                              1. Numeric Ranges
                                                              2. IN Operator
                                                                1. Value List Matching
                                                                  1. Subquery Usage
                                                                    1. Performance Considerations
                                                                  2. Pattern Matching
                                                                    1. LIKE Operator
                                                                      1. Wildcard Characters
                                                                        1. Pattern Specifications
                                                                        2. Wildcard Usage
                                                                          1. Percent (%) Wildcard
                                                                            1. Underscore (_) Wildcard
                                                                              1. Escape Characters
                                                                              2. Regular Expressions
                                                                                1. REGEXP Operator
                                                                                  1. Pattern Syntax
                                                                                    1. Advanced Matching
                                                                                  2. Null Value Handling
                                                                                    1. IS NULL Operator
                                                                                      1. IS NOT NULL Operator
                                                                                        1. Null Comparison Behavior
                                                                                      2. Sorting and Limiting Results
                                                                                        1. ORDER BY Clause
                                                                                          1. Single Column Sorting
                                                                                            1. Multiple Column Sorting
                                                                                              1. Sort Direction
                                                                                                1. Ascending (ASC)
                                                                                                  1. Descending (DESC)
                                                                                                  2. Expression Sorting
                                                                                                    1. Null Value Ordering
                                                                                                    2. Result Limiting
                                                                                                      1. LIMIT Clause
                                                                                                        1. Row Count Specification
                                                                                                          1. Performance Benefits
                                                                                                          2. Pagination
                                                                                                            1. LIMIT with OFFSET
                                                                                                              1. Page-Based Navigation
                                                                                                                1. Large Dataset Handling
                                                                                                            2. Aggregate Functions
                                                                                                              1. Basic Aggregate Functions
                                                                                                                1. COUNT Function
                                                                                                                  1. Row Counting
                                                                                                                    1. Non-Null Counting
                                                                                                                      1. DISTINCT Counting
                                                                                                                      2. SUM Function
                                                                                                                        1. Numeric Summation
                                                                                                                          1. Null Value Handling
                                                                                                                          2. AVG Function
                                                                                                                            1. Average Calculation
                                                                                                                              1. Precision Considerations
                                                                                                                              2. MIN Function
                                                                                                                                1. Minimum Value Finding
                                                                                                                                  1. Date/String Minimums
                                                                                                                                  2. MAX Function
                                                                                                                                    1. Maximum Value Finding
                                                                                                                                      1. Date/String Maximums
                                                                                                                                    2. Aggregate Function Usage
                                                                                                                                      1. Column vs. Expression Aggregation
                                                                                                                                        1. DISTINCT with Aggregates
                                                                                                                                          1. Null Value Treatment
                                                                                                                                        2. Grouping and Having
                                                                                                                                          1. GROUP BY Clause
                                                                                                                                            1. Grouping Fundamentals
                                                                                                                                              1. Single Column Grouping
                                                                                                                                                1. Multiple Column Grouping
                                                                                                                                                  1. Expression Grouping
                                                                                                                                                  2. GROUP BY with Aggregates
                                                                                                                                                    1. Aggregate Calculations per Group
                                                                                                                                                      1. Group-Level Statistics
                                                                                                                                                        1. Summary Reporting
                                                                                                                                                        2. HAVING Clause
                                                                                                                                                          1. Group Filtering
                                                                                                                                                            1. Aggregate Conditions
                                                                                                                                                              1. HAVING vs. WHERE
                                                                                                                                                              2. Advanced Grouping
                                                                                                                                                                1. ROLLUP Operations
                                                                                                                                                                  1. Grouping Sets
                                                                                                                                                                    1. Hierarchical Grouping

                                                                                                                                                                Previous

                                                                                                                                                                6. SQL Fundamentals: Data Manipulation Language (DML)

                                                                                                                                                                Go to top

                                                                                                                                                                Next

                                                                                                                                                                8. Joining Tables