
Learn to install MySQL server and Workbench on Windows, choose a custom installation, resolve path conflicts, and configure server, Workbench, and data directories for optimal performance.
Install MySQL server and Workbench on Windows, configure memory and port 3306, create a root password and a daily user, and run as a Windows service.
Create your first database named bookstore using MySQL Workbench, learn about charset and collation, and assign proper user privileges instead of logging in as root.
Create a new table using sql, defining publisher_id as an auto increment integer primary key and editor name as varchar, and discuss char vs varchar and storage considerations.
Create the books table, define a primary key (single or composite), and use a foreign key to the authors table to enforce referential integrity and relationships across authors and publishers.
Explore data modeling foundations for relational databases, including physical modeling, normalization forms, and designing efficient MySQL databases with SQL in Workbench.
Create a dedicated contact table to store multiple emails and phone numbers for a member, linked by a foreign key in a one-to-many relationship, using Workbench for modeling.
Create a primary key and use foreign keys to model a member's contacts, introduce a separate contact type table, and establish an associative one-to-many relationship to reduce redundancy.
Explore creating a first entity-relationship model in MySQL Workbench by improving a data model through normalization, reducing redundancy, and structuring country, state, city, and address tables; balance normalization with performance.
Learn to create an address table in MySQL Workbench, define a primary key with auto increment, and model a one-to-many relation from member to address via a foreign key.
Model a member and dependent system in MySQL Workbench by creating a dependent table with generated primary key and a foreign key to the member table, establishing a one-to-many relationship.
Master selecting across related tables with inner joins, on clauses, and aliases, using primary and foreign keys; explore reverse engineering to build an entity relationship diagram for clearer queries.
Learn how to pull data from orders, order items, and products using inner joins, aliases, and on conditions to display order dates, totals, product names, and quantities.
Master left joins and inner joins to retrieve all members or customers with and without related records, linked by primary and foreign keys.
Explore subqueries, inner and outer queries, and views; compare with joins for performance, and apply in, not in, and exists techniques.
Learn how to use insert into with values, handle primary keys without auto increment, and enable auto increment via alter table, including managing referential constraints.
Discover how views restrict access and simplify data retrieval by presenting a filtered perspective on multiple tables. Create and use views to predefine complex queries, boosting performance and consistency.
Learn how to query data through views, filter by partial phone matches, and manage multi-step transactions with begin, commit, and rollback to ensure data integrity and recoverability.
Build a daily sales view to simplify a complex multi-table select with inner joins on orders, order items, and products; derive year, month, day, and sales.
Modify an existing view with alter view to add columns such as first name and last name, and use concat for a full name while monitoring performance with complex joins.
Create and execute MySQL stored procedures using begin and end blocks, manage delimiters, and call procedures to view results and status via routines.
Learn to modify and recreate stored procedures in MySQL using drop procedure, create, and limit clauses. Pass parameters as input, output, or both with call, contrasting with SQL Server behavior.
Learn how to handle optional parameters in MySQL stored procedures by implementing null checks and defaults, and build flexible price-range queries using min and max values.
Learn to create and call MySQL stored procedures with input and output parameters, returning product names by id, and using if, else if, else and while loops.
Explore creating triggers in MySQL, compare with SQL Server, and log inserts and deletes in a product audit table, including drop table if exists.
create and manage MySQL triggers on the product table to log inserts and deletes into the product audit log table, using delimiter tricks and new/old row concepts.
Learn how MySQL functions work, how they compare to stored procedures, how to create and call deterministic functions, and how they return values using begin, end, and select statements.
Learn to create a MySQL function and compare it with SQL Server practices, using begin and end, delimiter handling, and a practical calculation of sales value.
Build a MySQL function called client level that returns a varchar(20) based on credit, using if/else if logic, set and return, and illustrate correct ordering by calling it.
Use a function we created in MySQL to calculate discounts from quantity and unit price, per order item row, and aggregate results with sum and avg.
Create a MySQL function that sums unit price times quantity, stores results in a table, and use temporary tables to simplify complex queries and boost performance.
Define and manage MySQL users, privileges, and roles with commands and workbench. Learn global, database, and object privileges, plus the grant option and service user access.
Create a MariaDB user on localhost, grant select on a table, and verify with show grants; compare mysql community edition to sql server’s login and note MariaDB as an alternative.
Learn to create and manage roles in MySQL, grant privileges to roles, assign roles to users, and verify role-based access with show grants.
Create and manage MySQL users, roles and privileges using revoke and grant commands, explore root and DBA privileges, and perform graphically via Workbench, including show privileges and shutdown.
Learn to create users, assign roles, grant or revoke privileges, and set per-hour limits in MySQL using Workbench, with database and schema privileges and secure connections.
Create and schedule automated MySQL events that run at defined times, with event scheduling enabled by default. Use create, alter, show, and drop commands to manage events and their history.
Create a MySQL event that runs automatically one minute from now using interval and now to insert data. Learn how to schedule and verify the event's one-time execution in lab.
Learn to create a one-time MySQL event that runs on a specific date and time, performing an insert and a delete inside a single transaction with start transaction and commit.
Demonstrates creating and executing a MySQL event that automatically runs a stored procedure to create a table in a database, illustrating event scheduling, automatic execution, and idempotent object creation.
Create a MySQL event that runs a procedure every hour, starting now and ending ten hours later, using server time and interval expressions.
Learn how to back up and restore MySQL databases using Workbench, including file-by-file versus single-file backups, rollback-safe strategies, and InnoDB considerations for reliable recovery.
Learn to back up all databases with mysqldump, including routines and events, and to back up specific databases or a single table, with guidance on file organization and restoration.
Master manual backups and restores of MySQL databases using mysqldump and the mysql client from the command line. Learn to handle drop database operations and troubleshoot common issues.
Learn how MySQL uses binary log files for point-in-time recovery and incremental backups, including managing binlog size, recycling up to 30 files, and purging logs safely.
Master incremental backups with mysql dump by preserving binary logs for precise point in time recovery; learn safe transactions and log purging to manage disk space.
perform a full mysql backup with mysqldump, create incremental binlog backups, and restore data by applying transactional logs to recover to a precise point in time.
Learn to protect binlog files for incremental backups and restore a full backup by applying transactions.
Create a robust mysqldump backup workflow that builds a full backup, compresses backups and binlog files, transfers them to a separate disk, and deletes originals via a secure config file.
Develop a PowerShell backup script for MySQL named backup full db ps1 that automatically backs up, compresses, and saves to a designated folder, with admin PowerShell execution policy steps.
Explore building a PowerShell-based MySQL backup workflow that uses mysqldump, config files for credentials, timestamped backup files, error logging, and automated retention with compression and old-file cleanup.
Back up all databases with a MySQL dump using the all databases option to create a single date-stamped SQL file, including stored procedures, functions, routines, and events.
Automate binlog backups with a PowerShell script, recycling logs, compressing them into a dated zip, and storing them in a designated backups folder for recovery.
Learn to create automated MySQL full backups on Windows using Task Scheduler and PowerShell scripts, scheduling tasks for a DB test backup, full instance backups, and transaction logs.
Explore using PowerShell and batch scripts to automate MySQL backups on Windows and Windows Server, including creating batch files, scheduling backups with Task Scheduler, compressing, and securing credentials.
Automate MySQL backups by creating Windows Task Scheduler triggers for full backups, all databases, and log backups using a batch file and mysqldump.
Explore using the MySQL clone plugin in Workbench for fast physical backups. Learn its limitations, such as InnoDB dependency, same-version cloning, and no binary logs.
Learn to fix a failed database copy after restoring databases by re-copying and replacing corrupted files, and by reviewing the SQL error log and backups.
Demonstrates fixing a startup error in MySQL Workbench by cleaning junk files in a user folder path and setting up an automated backup routine for the next class.
Learn to automate MySQL cloning with Workbench events and Windows task scheduler, pairing clone and move and compress steps to run daily without manual intervention.
Master automating backups by creating a Windows task scheduler that copies clones to a separate disk, timestamps, compresses, moves to final location, and deletes redundant folders to streamline recovery.
Learn to integrate MySQL Workbench with Windows Task Scheduler to automate backups in Windows and Linux environments by running a three-minute recurring event that clones databases and compresses folders.
Move all databases to a separate disk, back up first, stop the database service, copy files to a new location, update the data directory, restart, and verify.
Learn to perform integrity checks on MySQL databases by verifying table structures, running targeted or full database checks, interpreting results, and planning repairs or backups.
Learn how to implement auditing in MySQL by configuring logs to capture executed commands, user activity, and performance data, enabling slow-transaction logs, and supporting internal and external audits for compliance.
Activate the audit to record slow sql transactions, log results to a table, and learn how disk access, memory, and blocking influence performance.
Configure MySQL block 4 to log slow commands over five seconds, saving the on-disk log in Windows and verifying service user permissions to write in the data folder.
Configure MySQL to generate audit logs in files or tables by editing the my.ini or cnf file, enabling the general log and slow log, and ensuring logs persist across restarts.
Learn to generate audit logs in MySQL using triggers and track tables. See how inserts, updates, and deletes are logged with who, when, and what changed.
Download Windows Vista from Microsoft's official site, save the 180-day trial, and keep Windows and SQL Server in English for the online Azure environment.
Download and install VirtualBox from official sources to create and manage virtual machines for the course, using the Windows version with admin privileges.
Rename the virtual machine to a domain controller–related name using Windows settings, avoiding forbidden characters, then restart to apply the new domain controller designation.
Explore how a domain centralizes user login and access to computers, servers, and printers through a domain controller and global catalog, with DNS and DHCP support.
Promote a simple virtual machine to a domain controller by installing the domain services feature with Server Manager and creating a new forest with a root domain.
Create and configure a dedicated virtual machine for MySQL, naming the VM, allocating memory, and adding separate data and log disks on Windows Server 2019 with bridged networking.
Initialize the database VM by installing Windows Server, selecting the desktop experience, and configuring disks. Then prepare to join the domain and install SQL Server on the VM.
Learn to join a database VM to the domain by validating network connectivity with the control VM and using domain administrator credentials to enroll and log in.
Download and install the MySQL enterprise suite, unzip to create three folders for the installer, engine, and workbench, and copy the files to the server via a shared path.
Install MySQL Server Enterprise in a best-practices server environment, using a domain service account to run the database, and optimize memory and storage for virtual machines.
Connect to a MySQL enterprise server via Workbench from inside or outside a virtual machine, configure privileges and ports, and create a bank database with tables.
Learn how to apply a dark theme in MySQL Workbench by replacing an XML color file, with steps to back up the original and deploy on Windows, Mac, or Linux.
Hello, DBA!
I present to you the MySQL Course - 75 hours, become a DBA. Over 75 hours of careful preparation have gone into covering the key features of MySQL Server.
Our goal is to provide the best learning experience at an incredibly affordable cost. Whether you're a beginner looking to become a DBA in a short time or someone looking to enhance their skills, this course is perfect for you.
Here, you will learn everything from setting up the environment (AD, DHCP, domain, etc.) to performance tuning, security, auditing, backup, and restoration. Additionally, we will delve into advanced concepts such as events, database integrity, SQL language, and data modeling.
With over 75 hours of video content and dozens of example script files, you will have access to everything you need to stand out in the market.
The course is taught by an experienced DBA who works daily with large databases, serving major multinational companies. You will learn directly from someone who knows the secrets and best practices of DBAs.
Our approach is practical and hands-on, avoiding time wastage on slides and tedious labs. Here, you will have direct access to MySQL demonstrations, providing a more efficient and dynamic learning experience.
Your knowledge will be enhanced in various aspects, from infrastructure configurations and data modeling to SQL commands, trigger creation, procedures, and functions.
Furthermore, you will learn how to optimize the performance of your MySQL, enhancing queries, indexes, statistics, and much more.
Our goal is to make you a qualified DBA with valued skills in the job market. And the best part is that the course is incredibly affordable, making it the most advantageous option compared to Udemy and other in-person courses.
You will receive a participation certificate, validating your skills and dedication.
This is a lifelong course! Available indefinitely, it can be your future reference for any MySQL-related tasks.
And rest assured, we are confident that you will be satisfied with the course quality. We offer a 30-day guarantee for you to study with confidence.
Invest in your future as a DBA, learning from an expert who masters the best techniques and scripts used by world-renowned DBAs.
Don't waste any more time, this is the opportunity you've been waiting for. Enroll now and start your journey towards success!
Happy studying!
ATTENTION. This course is in Portuguese language. Some international students asked me to put subtitles in English to access the course. I created the English subtitles with software. Some subtitles may not be 100% correct. If this is the case, let me know the class and the minute. I am currently also translating the videos into English and gradually releasing the lessons.
Sandro