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

  • Introduction to Databases & SQL
  • Setting Up SQL Environment
  • Basic SQL Statements: SELECT, FROM, WHERE
  • Using Operators and Sorting Data
  • Introduction to Functions (COUNT, SUM, AVG, MIN, MAX)
Practice Task: Write a query to display all rows from a sample table, sorted by a specific column.

  • Joining Tables: INNER JOIN, LEFT JOIN, RIGHT JOIN
  • Grouping Data with GROUP BY and HAVING
  • Data Insertion and Modification: INSERT, UPDATE, DELETE
  • Working with Subqueries
  • Handling Null Values and Aliasing
Practice Task: Write queries to join two tables and filter the results based on specific conditions.

  • Constraints and Keys: Primary, Foreign, Unique, and Check
  • Creating and Altering Tables
  • Using Views and Indexes
  • Nested and Complex Queries
  • Combining Queries: UNION, INTERSECT
Practice Task: Design a small database schema with at least two tables and write queries to test the structure.

  • Database Design & Setup
  • Data Insertion and Basic Queries
  • Implementing Advanced Queries
  • Testing and Optimizing Queries
  • Final Project Review & Submission
Project: Build an Employee Management System with tables for Employees, Departments, and Salaries.

  • Window Functions: ROW_NUMBER, RANK, DENSE_RANK
  • Aggregate Functions with OVER and PARTITION BY
  • Common Table Expressions (CTEs)
  • Using CASE Statements for Conditional Logic
  • Intro to Stored Procedures and Functions
Practice Task: Write a query to rank items within groups, using window functions.

  • Transactions: COMMIT, ROLLBACK, SAVEPOINT
  • ACID Properties in SQL
  • Error Handling with TRY...CATCH
  • Managing Triggers for Automation
  • Indexes and Performance Optimization
Practice Task: Write SQL queries with transaction control, demonstrating commit and rollback operations.

  • Managing User Permissions and Roles
  • GRANT and REVOKE Statements
  • Data Encryption Techniques
  • Ensuring Data Integrity with Constraints
  • Best Practices for Database Security
Practice Task: Create user roles with specific permissions and demonstrate data access control.

  • Setting Up the Database Schema
  • Implementing Advanced Queries for Inventory Tracking
  • Building Stored Procedures for Key Operations
  • Implementing Security Controls
  • Testing, Debugging, and Optimization
Project: Develop an Inventory Management System that allows for product tracking, user permissions, and secure transactions.

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