Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

Advanced MySQL

Take your MySQL skills to the next level with this advanced course. This course covers high-level concepts including performance optimization, complex stored procedures, advanced indexing, and comprehensive data security strategies, preparing you for managing large-scale, production-grade databases.

4.9 Rating Advanced Course 12 Weeks

About this Course

This advanced MySQL course is designed for learners looking to master database management and optimization at an expert level. Topics include advanced query optimization, complex stored procedures, comprehensive indexing, and implementing data security at scale. Practical projects and case studies will give you hands-on experience with high-level database tasks.

Course Objective

This course aims to deepen your expertise in MySQL, preparing you to work with complex database environments. By the end, you'll have a strong command of advanced MySQL operations, enabling you to optimize databases, secure sensitive information, and design resilient database structures for enterprise-level applications.

Skills you'll gain

Advanced Query Optimization Complex Stored Procedures and Triggers High-Level Indexing Techniques Enterprise Data Security

Syllabus

  • Understanding Databases and MySQL Overview
  • Basic SQL Syntax and Commands
  • Introduction to Data Types in MySQL
  • Creating and Managing Databases
  • Basic Data Retrieval with SELECT Statements
Practice Task: Create a simple database and write basic SELECT queries to retrieve data.

  • Creating and Modifying Tables
  • Inserting, Updating, and Deleting Data
  • Constraints: Primary Key, Foreign Key, Unique, Not Null
  • Using WHERE Clauses for Data Filtering
  • Understanding NULL Values in SQL
Practice Task: Create tables with different constraints and practice data insertion, updates, and deletions.

  • Basic Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
  • GROUP BY and HAVING Clauses
  • Sorting Data with ORDER BY
  • Using Aliases for Columns and Tables
  • Combining Conditions with AND, OR, and NOT
Practice Task: Write queries to group data and use aggregate functions to calculate summary statistics.

Project: Build a Simple Library Management System to manage book records and user interactions.
  • Designing the Database Schema
  • Creating Tables and Setting Constraints
  • Implementing CRUD Operations for Book Records
  • Writing Queries for Book Searching and Borrowing
  • Testing and Finalizing the Project

  • INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
  • Using Subqueries in SELECT, WHERE, and FROM Clauses
  • Correlated vs. Non-Correlated Subqueries
  • EXISTS and NOT EXISTS Clauses
  • Common Table Expressions (CTEs)
Practice Task: Write complex queries using joins and subqueries to extract data from multiple tables.

  • Advanced INSERT, UPDATE, and DELETE Operations
  • Managing Data with Transactions
  • Using SAVEPOINT and ROLLBACK
  • Creating and Managing Views
  • Security Considerations for Views
Practice Task: Create views for data security and manage transactions for data integrity.

  • Introduction to Indexes and Their Use
  • Optimizing Queries with Indexes
  • Creating and Using Stored Procedures
  • Variables, Control Flow, and Loops in Stored Procedures
  • Error Handling in Stored Procedures
Practice Task: Implement indexing strategies and create stored procedures for repetitive tasks.

Project: Build an E-commerce Database Management System with tables, constraints, CRUD operations, and optimization techniques.
  • Designing a Database for E-commerce Applications
  • Setting Up Tables and Relationships for Products, Customers, Orders
  • Implementing CRUD Operations for Products and Orders
  • Writing Queries for Order Management and Customer Analysis
  • Optimizing Performance with Indexes and Stored Procedures

  • Understanding Query Execution Plans
  • Using Indexes Effectively
  • Optimizing Joins and Subqueries
  • Working with Temporary Tables and Views
  • Indexing Strategies for Large Databases
Practice Task: Analyze and optimize a set of complex queries, applying indexing techniques and using the EXPLAIN command to interpret query execution plans.

  • Writing Complex Stored Procedures
  • Using Cursors and Control Flow in Procedures
  • Creating and Managing Triggers
  • Error Handling in Stored Procedures
  • Performance Considerations for Stored Procedures and Triggers
Practice Task: Write stored procedures to automate tasks, and create triggers to manage data integrity constraints.

  • User Roles, Privileges, and Access Control
  • Implementing Transactions and Isolation Levels
  • Locking Mechanisms and Deadlock Resolution
  • Data Backup and Recovery Strategies
  • Database Monitoring and Maintenance
Practice Task: Set up a secure database environment with appropriate access control, implement transaction handling, and configure regular backup and recovery procedures.

Project: Develop a comprehensive Inventory Management System that includes advanced querying, security, transaction management, and backup solutions.
  • Designing the Database Schema
  • Creating Tables and Setting Constraints
  • Implementing CRUD Operations for Inventory Records
  • Writing Queries for Stock Management and Reporting
  • Testing and Documenting the System

About the Instructor

Shalini Baskaran

Founder & CEO

4.98 Instructor rating

40 Students

Shalini Baskaran, is the CEO and Curriculum Director at Savvy Axiss. With a deep background in computer science, she has designed numerous courses to build strong foundations for aspiring programmers. Known for her clear, practical teaching style, she excels at making complex topics accessible. She is passionate about empowering students with real-world skills, and she looks forward to guiding you through this foundational journey in programming.

Fee ₹ 3999

₹ 2999

ENROLL NOW

Duration

12 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Advanced

Schedule

Monday to Friday

Certificate

Yes

SoftSkill Trainning

Free

Share this Course