Syllabus – MySQL

MySQL is a powerful, open-source relational database management system that is widely used in web applications for data storage and retrieval. It supports a wide range of functions including transactions, joins, and indexing, making it a preferred choice for developers looking to build scalable, high-performance applications. MySQL is known for its reliability, ease of use, and flexibility, providing robust tools for managing databases in various development environments.

Session 1 – Overview of MySQL

  • Introduction of MySQL
  • MySQL Features
  • MySQL Advantage
  • MySQL Installation
  • MySQL Data Types
  • MySQL Variables

Session 2 – User Management

  • Create User
  • Drop User
  • Show Users
  • Change User Password
  • Grant Privileges
  • Revoke Privileges

Session 3 – Databases

  • Create Database
  • Select Database
  • Show Database
  • Drop Database
  • Rename Database
  • Backup Database

Session 4 – Tables & Views

  • Create Table
  • Drop Table
  • Alter Table
  • Show Table
  • Truncate Table
  • Temporary Table
  • Copy Table
  • Views

Session 5 – MySQL Queries

  • Insert Query
  • Update Query
  • Delete Query
  • Select Query
  • Constraints
  • Insert On Duplicate Key Update
  • Joins
  • Subqueries

Session 6 – MySQL Indexes

  • Create Index
  • Drop Index
  • Show Index
  • Clustered Index
  • Clustered vs Non-Clustered Index
  • Unique Index
  • Composite Index
  • Full-Text Index

Session 7 – MySQL Clauses

  • Where
  • AND
  • OR
  • LIKE
  • Limit
  • Order By
  • Group By
  • Having
  • Distinct
  • Union
  • Union All

Session 8 – MySQL Flow Functions

  • IF()
  • IFNULL()
  • NULLIF()
  • CASE
  • IF Statement
  • COALESCE()
  • ELSE
  • DECODE()
  • GREATEST()
  • LEAST()
  • SWITCH()

Session 9 – MySQL Joins

  • Join
  • Inner Join
  • Outer Join
  • Cross Join
  • Self Join
  • Delete Join
  • Union vs Join
  • Left Join
  • Right Join
  • Natural Join
  • Anti Join

Session 10 – MySQL Keys

  • Primary Key
  • Foreign Key
  • Unique Key
  • Composite Key
  • Auto Increment Key
  • Natural Key
  • Surrogate Key
  • Candidate Key

Session 11 – Aggregate Functions

  • count()
  • sum()
  • avg()
  • max()
  • min()
  • first()
  • last()
  • GROUP_CONCAT()

Session 12 – MySQL Miscellaneous

  • Comments
  • Commands Cheat-Sheet
  • Transaction
  • Cursor
  • Limit
  • Stored Function
  • Format Function
  • Ranking Function
  • Window Function
  • Union
  • Varchar
  • Enum
  • Set
  • Decimal
  • Cast
  • Convert()
  • Wildcards
  • Alias
  • Function
  • Trigger