📞 +91-9456968800
✉️ contact@pixelcomputer.co.in
Introduction to MySQL
▶
- What is MySQL?
- Features of MySQL
- MySQL vs Other Databases
- Installation & Setup
MySQL Database Basics
▶
- Databases and Tables
- Data Types in MySQL
- SQL Syntax Overview
- Using MySQL Command Line & GUI (phpMyAdmin)
Basic SQL Commands
▶
- CREATE, DROP, ALTER
- INSERT INTO
- SELECT Queries
- UPDATE & DELETE
Constraints and Keys
▶
- Primary Key
- Foreign Key
- Unique, Not Null, Default
- Auto Increment
Filtering & Sorting Data
▶
- WHERE Clause
- ORDER BY
- LIMIT
- BETWEEN, LIKE, IN
Joins in MySQL
▶
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN (using UNION)
Functions and Operators
▶
- Aggregate Functions (SUM, COUNT, AVG, MAX, MIN)
- String Functions
- Date and Time Functions
- Mathematical Operators
Group By and Having Clause
▶
- GROUP BY Syntax
- Using HAVING with Aggregates
- Combining GROUP BY with JOIN
Subqueries and Views
▶
- Single Row Subquery
- Multiple Row Subquery
- Creating and Using Views
Indexing and Performance
▶
- Creating Indexes
- Types of Indexes
- Using EXPLAIN
- Query Optimization Tips
Data Export and Import
▶
- Export using phpMyAdmin / MySQL Dump
- Import SQL Files
- Backup and Restore
MySQL with PHP/Other Languages
▶
- PHP MySQLi / PDO
- Connecting MySQL with Python
- Real-World Use Cases
