SQL Bootcamp - MYSQL for Beginner to Advanced

Overview

Are you ready to dive into the world of databases and master the art of querying with MySQL? This beginner-friendly course is designed to provide you with a solid foundation in MySQL while progressively taking you through advanced concepts.

Whether you're a complete novice or have some prior experience, this course will equip you with the skills to confidently interact with databases.

Syllabus

• Introduction to Databases
Overview of Databases and SQL
Understanding MySQL and its Environment Setup
• Basics of SQL
Introduction to SQL Syntax
Data Types in MySQL
Creating and Using Databases
Tables: Creation, Alteration, and Deletion
• Basic CRUD Operations
Inserting Data into Tables
Querying Data with SELECT
Updating Existing Records
Deleting Records
• Data Filtering and Sorting
Using WHERE Clause for Filtering
Sorting Data with ORDER BY
Pattern Matching with LIKE
Understanding NULL Values
• Advanced Querying Techniques
Aggregate Functions (SUM, AVG, COUNT, etc.)
Grouping Data with GROUP BY
Filtering Grouped Data with HAVING
Joining Tables: INNER, OUTER, LEFT, RIGHT Joins
• Subqueries and Nested Queries
Introduction to Subqueries
Using Subqueries in SELECT, INSERT, UPDATE, DELETE
Correlated Subqueries
• Data Normalization and Design
Understanding Normalization
Designing efficient database schemas
Implementing Keys and Indexes
• Transactions and Data Integrity
Understanding Transactions
Implementing ACID Properties
Managing Concurrency with Locks
• Advanced SQL Features
Views and Stored Procedures
Triggers and Events
User-Defined Functions
• Performance Optimization
Query Optimization Techniques
Index Optimization
Analyzing Query Performance with EXPLAIN
• Security and User Management
Understanding User Privileges and Roles
Implementing Data Security Best Practices
• Practical Application and Project
Hands-on Project: Designing and Implementing a Real-World Database
Review and Feedback Session
• Course Conclusion
Recap of Key Concepts
Resources for Continued Learning

Taught by

Kadhiravan Jayachandiran, KultureHire Education and Akshi

Subjects

Programming