Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

MySQL Intermediate Course

Enhance your MySQL knowledge and master advanced techniques for managing complex queries and optimizing database performance. Perfect for learners looking to deepen their SQL skills for data-driven roles.

4.7 Rating Intermediate Course 8 Weeks

About this Course

This intermediate-level MySQL course delves into advanced querying techniques, data management strategies, and database optimization practices. You'll learn to work with complex functions, handle transactions, and implement data security, preparing you to tackle real-world database challenges with confidence.

Course Objective

To deepen learners' MySQL expertise by exploring complex query structures, data integrity, and optimization techniques, culminating in a project that demonstrates advanced database management skills.

Skills you'll gain

Advanced Querying Techniques Window Functions and CTEs Data Transactions and Error Handling Database Security and Permissions

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

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 ₹ 2999

₹ 1999

ENROLL NOW

Duration

8 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Intermediate

Schedule

Monday to Friday

Certificate

Yes

Share this Course