MySQL
  • Installation & Configuration
  • Using Professional Tool - MySQL Workbench
  • Create Database
  • Create Database Objects
    • Create Tables
    • Implementing Foreign Keys
    • Using Auto Increment
    • Indexes & Index Types
  • Constraints
    • Foreign Keys & index
    • Primary key & index
    • Unique key & index
    • Not null constraint
  • DML Operations
    • Insert
    • Update
    • Delete
  • Select Queries
    • Basic Queries
    • Using AND & OR conditions
    • Using in, between, distinct and like keywords
    • Sorting in ascending and descending order
  • Functions
    • Trim
    • Uppercase
    • Lowercase
    • LengthPosition
    • Left
    • Ifnul
    • Substring
    • Substringindex
    • Date
    • Numbers
    • Convert
    • Cast etc.
  • Groups
    • Understanding Grouping Columns Usage - Dos & Don’ts
    • Grouping Functions o Min o Max o Sum o Count o Average o Distinct Count
    • Using Having Clause
    • Filtering on grouing functions
    • Multi column groups
  • Joins
    • Creating Foreign Keys and use them in Joins
    • Inner Join or Natural Join
    • Left Outer Join
    • Right Outer Join
    • Full Outer Joins
    • Complex Join Queries etc
  • Views & Inline Views
  • Subquery
  • Create Complex Queries
    • Using Joins, Groups, Views & Subquery all together
    • Creating tables using queries
    • Inserting, Update & Delete using Select Queries
  • Mini Project / Case Study