Courses for Every Stage of Your Career
Each syllabus integrates lecture instruction with live database exercises using the HeidiSQL client.
ADA-101: HeidiSQL Fundamentals & Table Operations
Beginner Level • 4 WeeksIdeal for students and professionals new to relational databases or migrating from spreadsheet applications to SQL databases. Focuses on setting up connection profiles, navigating database schemas, and running essential data exploration queries.
Module 1: Client Setup
Session configuration, TCP/IP network parameters, port mapping, and establishing secure connections to MariaDB and MySQL.
Module 2: Data Navigation
Browsing database tables, viewing column data types, applying quick filters, sorting columns, and inline row inspection.
Module 3: Query Execution
Writing basic SELECT statements, WHERE condition filters, LIMIT clauses, and exporting query result sets to CSV.
ADA-201: Schema Architecture & Database Administration
Intermediate Level • 6 WeeksDesigned for administrators and application developers responsible for creating and modifying relational schemas, managing primary and foreign key integrity, and performing routine database operations.
Module 1: Schema Design
Designing tables using HeidiSQL's structural interface, defining primary keys, auto-increment sequences, and constraints.
Module 2: Data Maintenance
Managing SQL dumps, database backups, bulk data imports, table defragmentation, and database verification.
Module 3: Access Control
Configuring database users, setting up role privileges, host restrictions, and granting table-level permissions via HeidiSQL.
ADA-301: Advanced Query Optimization & Stored Routines
Advanced Level • 6 WeeksRigorous curriculum for senior data analysts and database engineers. Master execution plan evaluation, indexing strategies, complex relational joins, views, triggers, and stored procedures inside HeidiSQL's query studio.
Module 1: EXPLAIN & Profiling
Analyzing query execution paths, full table scan detection, index lookups, and query performance tuning in HeidiSQL.
Module 2: Stored Logic
Creating and debugging stored procedures, functions, database triggers, and recurring scheduled events.
Module 3: Complex Analytics
Window functions, CTEs (Common Table Expressions), multi-tier aggregation, and transaction isolation management.
Ready to Enroll or Need Guidance?
Our admissions department helps you evaluate your existing SQL background to place you into the optimal course track.
Contact Admissions Desk