SQL for Data Analysis

  1. Fundamental SQL Queries
    1. The SELECT Statement
      1. Basic Syntax and Structure
        1. Selecting All Columns
          1. Selecting Specific Columns
            1. Column Order and Positioning
              1. Selecting Distinct Values
                1. Handling Duplicate Rows
                2. The FROM Clause
                  1. Specifying Source Tables
                    1. Table References
                      1. Schema Qualification
                        1. Database Qualification
                        2. The WHERE Clause
                          1. Filtering Rows
                            1. Condition Evaluation
                              1. Comparison Operators
                                1. Equal
                                  1. Not Equal
                                    1. Less Than
                                      1. Greater Than
                                        1. Less Than or Equal To
                                          1. Greater Than or Equal To
                                          2. Operator Precedence
                                          3. The ORDER BY Clause
                                            1. Sorting Results
                                              1. Ascending Order
                                                1. Descending Order
                                                  1. Sorting by Multiple Columns
                                                    1. Sorting by Column Position
                                                      1. Sorting by Expressions
                                                        1. NULL Value Ordering
                                                        2. The LIMIT Clause
                                                          1. Restricting Row Count
                                                            1. OFFSET for Pagination
                                                              1. TOP Clause Alternative
                                                                1. FETCH and OFFSET Standard
                                                                2. Using Aliases
                                                                  1. Column Aliases
                                                                    1. Table Aliases
                                                                      1. Alias Scope and Visibility
                                                                        1. Best Practices for Aliases

                                                                      Previous

                                                                      2. Basic SQL Query Structure

                                                                      Go to top

                                                                      Next

                                                                      4. Advanced Filtering and Selection