DAY 1: Database Basics and Schema
  • Database
  • Tables
  • Set of Tables
  • Primary and Foreign Key
  • Data Types
  • Schema
DAY 2 : Managing Database and Tables
  • Database Creation
  • Show Database
  • Drop Database
  • Data Types
  • Create Table
  • Describe Table
  • Alter Table
  • Delete Table
  • Create Foreign Key
  • Create Primary Key
DAY 3: Populating Data
  • Setting up Database and Tables
  • Add Data to table
  • WHERE Clause
  • WHERE Clause examples
  • Arithmetic Operators and Expressions
  • Comparison Operators and Simple Condition
  • Logical Operators and Operator Precedence
  • Update Table Data
  • Delete Data from Table
DAY 4: Retrieving Data
  • Simple Select
  • Change Column Header
  • Select Specific Columns
  • Select Distinct Columns
  • Sorting the Data
  • Retrieve Data from Multiple Tables
DAY 5: Functions and Creating Sub-totals
  • String Functions
  • Mathematical Functions
  • Date Functions
  • Logical Operators
  • NULL Data
  • GROUP BY clause
  • GROUP Functions
  • HAVING clause
DAY 6: Sub-Queries
  • Sub-Queries in SELECT
  • Sub-Queries in WHERE
  • Sub-Queries in WHERE - ANY Operator
  • Sub-Queries in WHERE - ALL Operator
  • Sub-Queries using EXISTS Operator
  • Sub-Queries in INSERT
Conclusion
  • Conclusion