Adv. 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
  • MySQL Routines
  • Procedures
    • Programming in Procedures o If..elseif…else o while o For loops
    • IN & OUT parameters
    • Integrating SQL with Procedures
    • Using Grouping & Joins in Procedures
    • Returning Select Query Output from Procedures
    • Conditional Select & Query Output from Procedures
    • Condition Updates / Inserts / Deletes
    • Using Temporary Tables
    • Creating Dynamic & Runtime Queries in Procedures & Usage etc.
  • Cursors
  • Functions
    • Programming in Functions o If..elseif…else o while o For loops
    • IN & Return parameters
    • Basic and Advanced Functions with and without SQL Queries
  • Triggers
    • Trigger Concept
    • Before & After Triggers
    • Usage
  • Data Export & Import
  • Creating Professional ER Diagrams in MySQL Workbench
  • Using MySQL Routines in Python MVC Application