SQL DBA & MySQL
Description
This course combines Microsoft SQL Server DBA and MySQL database management into one practical learning path. You'll gain hands-on experience in database setup, query writing, performance tuning, backup strategies, and user security. Ideal for developers, IT admins, and future DBAs.
What you'll learn
- Install and configure SQL Server and MySQL
- Create and manage databases, tables, and indexes
- Write advanced SQL queries and joins
- Perform backups, restores, and schedule jobs
- Configure users, roles, and permissions
- Optimize performance using indexing and tuning
Requirements
- Basic knowledge of computers and databases
- Laptop with SQL Server and MySQL installed
- No prior experience required
Curriculum
Understanding databases, relational models, SQL syntax overview
System setup, configuration tools, GUI & CLI basics
DDL commands, data types, primary & foreign keys, constraints
SELECT, WHERE, GROUP BY, JOINs, subqueries and functions
Creating users, roles, GRANT & REVOKE, permissions best practices
Full/differential backups, MySQL dumps, restore operations
Slow query log, indexing strategies, EXPLAIN plans
Creating jobs with SQL Agent (MSSQL) & cron (MySQL), automation
Error logs, transaction logs, replication basics (master-slave)
Set up and manage a real-world database with queries, tuning, security
Transform Your Future with Ais Education
- Unlock your potential with expert guidance.
- Achieve your academic and personal goals.
- Empower yourself with lifelong learning skills.
