SQL for Data Analysis

  1. Data Transformation and Manipulation
    1. String Functions
      1. String Concatenation
        1. CONCAT Function
          1. Concatenation Operators
          2. String Extraction
            1. SUBSTRING Function
              1. LEFT Function
                1. RIGHT Function
                2. String Modification
                  1. UPPER Function
                    1. LOWER Function
                      1. INITCAP Function
                      2. String Cleaning
                        1. TRIM Function
                          1. LTRIM Function
                            1. RTRIM Function
                            2. String Analysis
                              1. LENGTH Function
                                1. CHAR_LENGTH Function
                                2. String Replacement
                                  1. REPLACE Function
                                    1. TRANSLATE Function
                                    2. String Splitting
                                      1. String Parsing Techniques
                                        1. Delimiter-based Splitting
                                      2. Numeric Functions
                                        1. Rounding Functions
                                          1. ROUND Function
                                            1. CEIL Function
                                              1. FLOOR Function
                                                1. TRUNC Function
                                                2. Mathematical Operations
                                                  1. Basic Arithmetic
                                                    1. POWER Function
                                                      1. SQRT Function
                                                        1. ABS Function
                                                        2. Trigonometric Functions
                                                          1. SIN Function
                                                            1. COS Function
                                                              1. TAN Function
                                                              2. Logarithmic Functions
                                                                1. LOG Function
                                                                  1. LN Function
                                                                  2. Random Number Generation
                                                                    1. RAND Function
                                                                      1. RANDOM Function
                                                                    2. Date and Time Functions
                                                                      1. Current Date and Time
                                                                        1. NOW Function
                                                                          1. CURRENT_DATE
                                                                            1. CURRENT_TIME
                                                                              1. CURRENT_TIMESTAMP
                                                                              2. Date Component Extraction
                                                                                1. YEAR Function
                                                                                  1. MONTH Function
                                                                                    1. DAY Function
                                                                                      1. HOUR Function
                                                                                        1. MINUTE Function
                                                                                          1. SECOND Function
                                                                                          2. Date Arithmetic
                                                                                            1. DATE_ADD Function
                                                                                              1. DATE_SUB Function
                                                                                                1. DATEDIFF Function
                                                                                                  1. INTERVAL Operations
                                                                                                  2. Date Formatting
                                                                                                    1. DATE_FORMAT Function
                                                                                                      1. TO_CHAR Function
                                                                                                        1. Format Strings
                                                                                                        2. Date Conversion
                                                                                                          1. STR_TO_DATE Function
                                                                                                            1. TO_DATE Function
                                                                                                            2. Date Truncation
                                                                                                              1. DATE_TRUNC Function
                                                                                                                1. Truncating to Different Periods
                                                                                                              2. Type Conversion
                                                                                                                1. Explicit Casting
                                                                                                                  1. CAST Function
                                                                                                                    1. CONVERT Function
                                                                                                                    2. Implicit Casting
                                                                                                                      1. Automatic Type Conversion
                                                                                                                        1. Type Precedence Rules
                                                                                                                        2. Data Type Compatibility
                                                                                                                        3. Conditional Logic
                                                                                                                          1. CASE Expressions
                                                                                                                            1. Simple CASE
                                                                                                                              1. Searched CASE
                                                                                                                                1. Nested CASE Statements
                                                                                                                                2. NULL Handling Functions
                                                                                                                                  1. COALESCE Function
                                                                                                                                    1. ISNULL Function
                                                                                                                                      1. NULLIF Function
                                                                                                                                      2. Conditional Aggregation
                                                                                                                                        1. Conditional Counting
                                                                                                                                          1. Conditional Summing

                                                                                                                                      Previous

                                                                                                                                      6. Joining Tables

                                                                                                                                      Go to top

                                                                                                                                      Next

                                                                                                                                      8. Subqueries and Derived Tables