SQL Database Language

  1. SQL Fundamentals and Syntax
    1. SQL Statement Structure
      1. Basic Statement Anatomy
        1. Keywords and Identifiers
          1. Statement Termination
            1. Semicolon Usage
              1. Statement Separators
              2. Statement Formatting
                1. Line Breaks and Spacing
                  1. Indentation Practices
                    1. Readability Guidelines
                  2. SQL Naming Conventions
                    1. Identifier Rules
                      1. Reserved Words
                        1. Quoted Identifiers
                          1. Case Sensitivity Rules
                            1. Identifier Case Handling
                              1. Data Value Case Sensitivity
                                1. Dialect Differences
                              2. Comments in SQL
                                1. Single-Line Comments
                                  1. Double Dash Syntax
                                    1. Usage Guidelines
                                    2. Multi-Line Comments
                                      1. Block Comment Syntax
                                        1. Nested Comments
                                        2. Documentation Best Practices
                                          1. When to Comment
                                            1. Comment Clarity
                                              1. Maintenance Considerations
                                            2. SQL Expressions and Operators
                                              1. Expression Types
                                                1. Column References
                                                  1. Literal Values
                                                    1. Calculated Expressions
                                                    2. Arithmetic Operators
                                                      1. Addition
                                                        1. Subtraction
                                                          1. Multiplication
                                                            1. Division
                                                              1. Modulo
                                                              2. Comparison Operators
                                                                1. Equality Testing
                                                                  1. Inequality Testing
                                                                    1. Range Comparisons
                                                                    2. Logical Operators
                                                                      1. Boolean Logic
                                                                        1. Operator Precedence
                                                                          1. Truth Tables
                                                                        2. SQL Data Types
                                                                          1. Character Data Types
                                                                            1. CHAR Fixed-Length
                                                                              1. Storage Characteristics
                                                                                1. Padding Behavior
                                                                                  1. Use Cases
                                                                                  2. VARCHAR Variable-Length
                                                                                    1. Length Specifications
                                                                                      1. Storage Efficiency
                                                                                        1. Performance Considerations
                                                                                        2. TEXT Large Text
                                                                                          1. Storage Limits
                                                                                            1. Performance Impact
                                                                                              1. Use Cases
                                                                                              2. Character Set Considerations
                                                                                                1. Collation Rules
                                                                                                2. Numeric Data Types
                                                                                                  1. Integer Types
                                                                                                    1. TINYINT
                                                                                                      1. SMALLINT
                                                                                                        1. INT
                                                                                                          1. BIGINT
                                                                                                            1. Storage Requirements
                                                                                                            2. Exact Numeric Types
                                                                                                              1. DECIMAL
                                                                                                                1. NUMERIC
                                                                                                                  1. Precision and Scale
                                                                                                                  2. Approximate Numeric Types
                                                                                                                    1. FLOAT
                                                                                                                      1. REAL
                                                                                                                        1. DOUBLE PRECISION
                                                                                                                          1. Precision Considerations
                                                                                                                          2. Numeric Type Selection
                                                                                                                          3. Date and Time Types
                                                                                                                            1. DATE Type
                                                                                                                              1. Format Standards
                                                                                                                                1. Range Limitations
                                                                                                                                2. TIME Type
                                                                                                                                  1. Precision Options
                                                                                                                                    1. Time Zone Considerations
                                                                                                                                    2. DATETIME Type
                                                                                                                                      1. Combined Date and Time
                                                                                                                                        1. Storage Requirements
                                                                                                                                        2. TIMESTAMP Type
                                                                                                                                          1. Automatic Updates
                                                                                                                                            1. Time Zone Handling
                                                                                                                                            2. INTERVAL Type
                                                                                                                                              1. Date Arithmetic
                                                                                                                                              2. Boolean Data Types
                                                                                                                                                1. TRUE and FALSE Values
                                                                                                                                                  1. NULL Handling
                                                                                                                                                    1. Dialect Variations
                                                                                                                                                    2. Binary Data Types
                                                                                                                                                      1. BINARY Fixed-Length
                                                                                                                                                        1. VARBINARY Variable-Length
                                                                                                                                                          1. BLOB Large Objects
                                                                                                                                                            1. Use Cases and Limitations
                                                                                                                                                            2. Other Specialized Types
                                                                                                                                                              1. UUID Types
                                                                                                                                                                1. JSON Types
                                                                                                                                                                  1. XML Types
                                                                                                                                                                    1. Array Types
                                                                                                                                                                    2. Data Type Conversion
                                                                                                                                                                      1. Implicit Conversion
                                                                                                                                                                        1. Explicit Casting
                                                                                                                                                                          1. CAST Function
                                                                                                                                                                            1. CONVERT Function
                                                                                                                                                                              1. Type Compatibility

                                                                                                                                                                          Previous

                                                                                                                                                                          1. Introduction to Databases and SQL

                                                                                                                                                                          Go to top

                                                                                                                                                                          Next

                                                                                                                                                                          3. Basic Data Retrieval with SELECT