Course Overview & Objectives
HeidiSQL provides an intuitive and robust desktop environment to inspect and interact with MariaDB, MySQL, Microsoft SQL Server, and PostgreSQL databases. This introductory course eliminates intimidating command-line hurdles by teaching students how to harness the graphical user interface systematically.
Detailed Weekly Syllabus
- Week 1 – Installation & Session Management: Downloading HeidiSQL from the official open-source repository, configuring local MySQL/MariaDB connections, storing credentials securely, and managing multiple server profiles.
- Week 2 – Navigating Schemas & Tables: Understanding database trees, inspecting table schemas, examining data types (INT, VARCHAR, DATETIME), and exploring column defaults.
- Week 3 – The Data Tab & Quick Filtering: Inspecting live records, using client-side column filters, sorting values, executing safe in-place cell edits, and exporting table excerpts to Excel/CSV.
- Week 4 – The Query Editor & Essential SQL: Writing SELECT, WHERE, ORDER BY, and LIMIT queries. Using syntax auto-completion, saving favorite query snippets, and interpreting query execution messages.
Prerequisites:
No prior programming or database experience required. Basic familiarity with desktop operating systems (Windows) is recommended.
Syllabus Quick Facts
| Course Code | ADA-101 |
| Skill Level | Beginner / Introductory |
| Duration | 4 Weeks (16 Laboratory & Lecture Hours) |
| Software Used | HeidiSQL Desktop Client |
| Location | Huntsville, TX Campus & Virtual Interactive Labs |
Enrollment Information
Inquire about upcoming cohort start dates, syllabus PDF downloads, and group enrollment discounts for corporate teams.
Register for ADA-101