SQL Fundamentals by Tyler Clark

• Create a Table with SQL Create
• Add Data to a Table with SQL Insert
• Query Data with the Select Command in SQL
• Update Data in a Table with SQL Update
• Removing Data with SQL Delete, Truncate, and Drop
• Conditionally Select out Filtered Data with SQL Where
• Select Grouped and Aggregated Data with SQL
• Combining Tables Together with SQL Join Statements
• Organize Table Data with Indexes
• Subquery Dynamic Datasets in SQL
• Setup and Introduction to SQL Fundamentals
• Keep Data Integrity with Constraints