Mysql

MySQL Syllabus (Week-Wise)

Week 1: Introduction to Databases & MySQL

• Introduction to Databases
• Types of Databases (Relational vs Non-Relational)
• What is MySQL and its applications
• Installing MySQL Server & MySQL Workbench
• Database concepts: Tables, Rows, Columns
• Basic SQL syntax
• Creating and deleting databases

Week 2: Data Types & Basic SQL Commands

• MySQL Data Types
• • Numeric
  • String
  • Date & Time
• Creating tables
• INSERT, SELECT, UPDATE, DELETE statements
• Using WHERE clause
• LIMIT and DISTINCT keywords

Week 3: Operators, Constraints & Functions

• SQL Operators
• • Arithmetic
  • Comparison
  • Logical
• Constraints
• • PRIMARY KEY
  • FOREIGN KEY
  • UNIQUE
  • NOT NULL
  • DEFAULT
• Built-in Functions
• • String functions
  • Numeric functions
  • Date functions

Week 4: Joins & Subqueries

• Types of Joins
• • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN (concept)
• Subqueries
• • Single-row subqueries
  • Multi-row subqueries
• Correlated subqueries

Week 5: Grouping, Aggregation & Views

• Aggregate Functions
• • COUNT, SUM, AVG, MIN, MAX
• GROUP BY clause
• HAVING clause
• Creating and managing Views

 Week 6: Indexes, Transactions & Stored Programs

• Indexes
• • Creating and dropping indexes
• Transactions
• • START TRANSACTION
  • COMMIT
  • ROLLBACK
• ACID properties
• Stored Procedures
• Stored Functions

Week 7: Triggers & Cursors

• Triggers
• • BEFORE and AFTER triggers
• Events
• Cursors
• Error handling in MySQL

Week 8: Database Design & Normalization

• Database Design principles
• Entity Relationship (ER) diagrams
• Normalization
• • 1NF, 2NF, 3NF
• Denormalization (overview)

Week 9: Security, Backup & Optimization

• User management & privileges
• SQL Injection (basics & prevention)
• Backup and restore databases
• Query optimization
• Performance tuning basics

Week 10: Project & Advanced Topics

• Importing large datasets
• Real-world database scenarios
• Mini Project (Design & Implementation)
• Best practices in MySQL
• Revision & assessments