SQL Database Language

  1. Data Manipulation Operations
    1. Inserting Data
      1. INSERT Statement Fundamentals
        1. Basic Syntax Structure
          1. Target Table Specification
          2. Single Row Insertion
            1. Column List Specification
              1. Value List Provision
                1. Column-Value Matching
                2. Multiple Row Insertion
                  1. VALUES Clause Extensions
                    1. Bulk Insert Syntax
                      1. Performance Benefits
                      2. Inserting from Other Tables
                        1. INSERT SELECT Syntax
                          1. Column Mapping
                            1. Data Transformation
                              1. Conditional Insertion
                              2. Default Values and NULL
                                1. DEFAULT Keyword Usage
                                  1. Implicit Default Values
                                    1. NULL Value Insertion
                                      1. Column Default Definitions
                                      2. Insert Error Handling
                                        1. Constraint Violations
                                          1. Data Type Mismatches
                                            1. Duplicate Key Errors
                                          2. Updating Existing Data
                                            1. UPDATE Statement Structure
                                              1. Target Table Specification
                                                1. SET Clause Requirements
                                                2. Single Column Updates
                                                  1. Value Assignment
                                                    1. Expression-Based Updates
                                                    2. Multiple Column Updates
                                                      1. Comma-Separated Assignments
                                                        1. Correlated Updates
                                                        2. Conditional Updates
                                                          1. WHERE Clause Usage
                                                            1. Update Criteria
                                                              1. Partial Table Updates
                                                              2. Update Safety
                                                                1. WHERE Clause Importance
                                                                  1. Accidental Mass Updates
                                                                    1. Backup Considerations
                                                                    2. Update with Joins
                                                                      1. Multi-Table Updates
                                                                        1. Correlated Subqueries
                                                                          1. Performance Considerations
                                                                        2. Deleting Data
                                                                          1. DELETE Statement Basics
                                                                            1. Target Table Specification
                                                                              1. Row Removal Concepts
                                                                              2. Conditional Deletion
                                                                                1. WHERE Clause Usage
                                                                                  1. Deletion Criteria
                                                                                    1. Selective Row Removal
                                                                                    2. Mass Deletion Risks
                                                                                      1. Unqualified DELETE Statements
                                                                                        1. Data Loss Prevention
                                                                                          1. Recovery Considerations
                                                                                          2. DELETE vs TRUNCATE
                                                                                            1. TRUNCATE TABLE Statement
                                                                                              1. Performance Differences
                                                                                                1. Transaction Log Impact
                                                                                                  1. Constraint Considerations
                                                                                                    1. Identity Column Behavior
                                                                                                    2. Cascading Deletes
                                                                                                      1. Foreign Key Constraints
                                                                                                        1. CASCADE DELETE Options
                                                                                                          1. Referential Integrity

                                                                                                      Previous

                                                                                                      3. Basic Data Retrieval with SELECT

                                                                                                      Go to top

                                                                                                      Next

                                                                                                      5. Database Structure Management