➢What is a database and why do we need SQL?

➢Top 5 problems in Excel and why using SQL solves this problem

➢Should we import from Excel and why? How it is done?

➢Create a link to Excel spreadsheet with Mysql?

➢SQL Data Types

➢Primary Keys|

➢Null values and Not Null Values

➢Auto Increment

➢Use the Where clause

➢Conditional statements

➢Multiple conditions

➢Comparison Operators

➢Logic Values

➢Null Values

➢Patterns also known as Wildcard characters

➢Compare Column Value

➢Distinct Values

➢Top Values

➢Date Functions

➢Date Calculations

➢Aggregate Functions

➢String Functions

➢Sort Data

➢Rank Data

➢Save a Query

➢Execute a Query

➢Modify a Saved Query

➢Group Data

➢Filtering Grouped Data

➢Summarize Group Data

➢Pivot and Unpivot Operators

➢Inner Join

➢Left Join

➢Full Outer Join

➢Self-Join

➢Unions

➢Except and Intersect

➢Presenting and Making Sense of Query Results

➢Saving the Query Results and Exporting

➢Generating Reports

➢Distinct Values

➢Top Values

➢Subqueries with “In”

➢Inline Views

➢Exclusive Table Locks

➢Shared Table Locks

➢Using Variables

➢Setting Variables with Selects

➢Select/Update Example

➢Simple Transactions

➢String to Date and Date Format

➢Control Flow Functions

➢Casting Functions

➢Introduction to Stored Procedures

➢Changing the Delimiter

➢Editing a Stored Procedure

➢Variable Scope

➢A Data Generating Procedure

➢Introduction to Triggers

➢Validating Triggers

➢Triggers and Transactions