Introduction
  • Introduction
  • SQL Powerpoint Presentation ( For your reference )
  • What is SQL ?
  • What is MySQL ? How does it Differ from SQL ?
  • Installation in Mac , Windows and Linux Machines
  • Possible Installation Problem
  • Further Installation instructions for Mac
  • What is DB and Table ?
  • How to create DB and Tables ?
  • Section Quiz
Inserts , Selects and Updates
  • add Data with INSERT
  • See Data with SELECT
  • LIMIT
  • conditions with WHERE clause
  • modify Data with Update
  • Table structure change with ALTER
  • AND as well as OR Clause
  • Sort result using ORDER BY Clause
  • IN Clause
  • Find Patterns in Data with LIKE Clause
  • Selecting specific Fields / Columns
  • DISTINCT
  • ALIAS
  • Section Quiz
  • Test - INSERTS , SELECTS and UPDATES
MySQL Datatypes and Constraints
  • Datatypes
  • Constraints
  • Section Quiz
JOINS and UNIONS
  • Creating base for Future Lectures
  • Relational Databases ?
  • What is a FOREIGN KEY Constraint ?
  • What are JOINS ?
  • LEFT JOIN
  • RIGHT JOIN
  • INNER JOIN
  • UNION
  • Subquery .... Query inside another Query
  • Section Quiz
GROUPS and MySQL Functions
  • MySQL Functions
  • GROUP BY Clause
  • HAVING Clause
  • Section Quiz
VIEWS
  • What are VIEWS and how to Create Them ?
  • ALTER and DROP VIEWS
  • Test - CREATE , ALTER and DROP VIEWs
DELETEs , DROPs and TRUNCATEs
  • DELETE data from tables
  • TRUNCATE Tables , DROP Tables and Database
  • Section Quiz
  • 25+ Sample Queries
  • Importing Tables and Data to your local PhpMyAdmin
  • 30+ Sample Queries