MySQL Course – 75 Hours, Become a DBA

MySQL Course – 75 Hours, Become a DBA, available at $19.99, has an average rating of 4.17, with 253 lectures, based on 6 reviews, and has 77 subscribers.

You will learn about Will be really prepared to become a MySQL DBA or a dev more prepared to work with MySQL There are more than 75 hours of videos recorded directly from my screen and dozens of files with hundreds of example scripts. You will learn directly from a DBA who works on a daily basis, with large databases, for large multinational companies. You will learn how to configure a domain controller, domain, set ip, configure a VM (virtual server) and MySQL, following the best market practices. You will learn to use select commands, inserts, deletes, updates, to create triggers, procedures, functions, views, etc… You will learn how to create consistent databases from the point of infrastructure and modeling. This course is ideal for individuals who are Database Administrators (DBA) or Developers in general or Data scientists and engineers or Infrastructure professionals in general or IT students. or Programmers who need to learn in detail how to use SQL. or Professionals who work with database in general. It is particularly useful for Database Administrators (DBA) or Developers in general or Data scientists and engineers or Infrastructure professionals in general or IT students. or Programmers who need to learn in detail how to use SQL. or Professionals who work with database in general.

Enroll now: MySQL Course – 75 Hours, Become a DBA

Summary

Title: MySQL Course – 75 Hours, Become a DBA

Price: $19.99

Average Rating: 4.17

Number of Lectures: 253

Number of Published Lectures: 253

Number of Curriculum Items: 253

Number of Published Curriculum Objects: 253

Original Price: R$79.90

Quality Status: approved

Status: Live

What You Will Learn

Will be really prepared to become a MySQL DBA or a dev more prepared to work with MySQL
There are more than 75 hours of videos recorded directly from my screen and dozens of files with hundreds of example scripts.
You will learn directly from a DBA who works on a daily basis, with large databases, for large multinational companies.
You will learn how to configure a domain controller, domain, set ip, configure a VM (virtual server) and MySQL, following the best market practices.
You will learn to use select commands, inserts, deletes, updates, to create triggers, procedures, functions, views, etc…
You will learn how to create consistent databases from the point of infrastructure and modeling.

Who Should Attend

Database Administrators (DBA)
Developers in general
Data scientists and engineers
Infrastructure professionals in general
IT students.
Programmers who need to learn in detail how to use SQL.
Professionals who work with database in general.

Target Audiences

Database Administrators (DBA)
Developers in general
Data scientists and engineers
Infrastructure professionals in general
IT students.
Programmers who need to learn in detail how to use SQL.
Professionals who work with database in general.

Hello, DBA!

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 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!

Sandro

Course Curriculum

Chapter 1: Introduction and Installation of MYSQL Community

Lecture 1: 001 MYSQL – Installing MYSQL Community Server and Workbench

Lecture 2: 002 MYSQL – Installing MYSQL Community Server and Workbench

Chapter 2: Creating our first Database and tables

Lecture 1: 003 MYSQL – Creation of the First Database and Collation

Lecture 2: 004 MYSQL – First Database Creation and Collation

Lecture 3: 005 MYSQL – Creating first tables

Lecture 4: 006 MYSQL – Creating new table via SQL and giving drop table

Lecture 5: 007 MYSQL – Creating Book table, FK and checking the data model (MER)

Chapter 3: Creating Data Models (MER) in WorkBench

Lecture 1: 008 MYSQL – Block 1, creating first MER in Workbench

Lecture 2: 008 MYSQL – Block 2, creating first MER in Workbench

Lecture 3: 008 MYSQL – Block 3, creating first MER in Workbench

Lecture 4: 008 MYSQL – Block 4, creating first MER in Workbench

Lecture 5: 008 MYSQL – Block 5, creating first MER in Workbench

Lecture 6: 008 MYSQL – Block 6, creating first MER in Workbench

Lecture 7: 008 MYSQL – Block 7, creating first MER in Workbench

Lecture 8: 008 MYSQL – Block 8, creating first MER in Workbench

Lecture 9: 008 MYSQL – Block 9, creating first MER in Workbench

Lecture 10: 008 MYSQL – Block 10, creating first MER in Workbench

Lecture 11: 008 MYSQL – Block 11, creating first MER in Workbench

Lecture 12: 008 MYSQL – Block 12, creating first MER in Workbench

Lecture 13: 008 MYSQL – Block 13, creating first MER in Workbench

Lecture 14: 008 MYSQL – Block 14, creating first MER in Workbench

Chapter 4: Creating Database, Tables and Working with SQL Language

Lecture 1: 009 MYSQL – Block 1, creating database and tables from sql script

Lecture 2: 009 MYSQL – Block 2, populating the tables created with INSERT INTO

Lecture 3: 009 MYSQL – Block 3.1, selecting data with SELECT

Lecture 4: 009 MYSQL – Block 3.2, selecting data with SELECT

Lecture 5: 009 MYSQL – Block 3.3, selecting data with SELECT

Lecture 6: 009 MYSQL – Block 3.4, selecting data with SELECT

Lecture 7: 009 MYSQL – Block 3.5, selecting data with SELECT

Lecture 8: 009 MYSQL – Block 3.6, selecting data with SELECT

Lecture 9: 009 MYSQL – Block 3.7, selecting data with SELECT

Lecture 10: 009 MYSQL – Bloco 3.8, selecionando dados com SELECT

Lecture 11: 009 MYSQL – Block 3.9, selecting data with SELECT

Lecture 12: 009 MYSQL – Block 3.10, selecting data with SELECT

Lecture 13: 009 MYSQL – Bloco 3.11, selecionando dados com SELECT

Lecture 14: 009 MYSQL – Block 3.12, Updates, Deletes, Insert Into and Protected Transactions

Lecture 15: 009 MYSQL – Block 3.13, Updates, Deletes, Insert Into and Protected Transactions

Lecture 16: 009 MYSQL – Block 4.1, selecting data with VIEWS

Lecture 17: 009 MYSQL – Block 4.2, selecting data with VIEWS

Lecture 18: 009 MYSQL – Block 4.3, selecting data with VIEWS

Lecture 19: 009 MYSQL – Block 4.4, selecting data with VIEWS

Lecture 20: 009 MYSQL – Block 4.5, selecting data with VIEWS

Lecture 21: 009 MYSQL – Bloco 4.6, selecionando dados com VIEWS

Lecture 22: 009 MYSQL – Block 5.1, working with STORED PROCEDURES

Lecture 23: 009 MYSQL – Block 5.2, working with STORED PROCEDURES

Lecture 24: 009 MYSQL – Block 5.3, working with STORED PROCEDURES

Lecture 25: 009 MYSQL – Block 5.4, working with STORED PROCEDURES

Lecture 26: 009 MYSQL – Block 5.5, working with STORED PROCEDURES

Lecture 27: 009 MYSQL – Block 5.6, working with STORED PROCEDURES

Lecture 28: 009 MYSQL – Block 5.7, working with STORED PROCEDURES

Lecture 29: 009 MYSQL – Block 5.8, working with STORED PROCEDURES

Lecture 30: 009 MYSQL – Block 5.9, working with STORED PROCEDURES

Lecture 31: 009 MYSQL – Block 6.1, working with TRIGGERS

Lecture 32: 009 MYSQL – Block 6.2, working with TRIGGERS

Lecture 33: 009 MYSQL – Block 6.3, working with TRIGGERS

Lecture 34: 009 MYSQL – Block 6.4, working with TRIGGERS

Lecture 35: 009 MYSQL – Block 6.5, working with TRIGGERS

Lecture 36: 009 MYSQL – Block 6.6, working with TRIGGERS

Lecture 37: 009 MYSQL – Block 6.7, working with TRIGGERS

Lecture 38: 009 MYSQL – Block 7.1, working with FUNCTIONS

Lecture 39: 009 MYSQL – Block 7.2, working with FUNCTIONS

Lecture 40: 009 MYSQL – Block 7.3, working with FUNCTIONS

Lecture 41: 009 MYSQL – Block 7.4, working with FUNCTIONS

Lecture 42: 009 MYSQL – Block 7.5, working with FUNCTIONS

Chapter 5: SECURITY: Creating USERS, PRIVILEGES, and ROLES

Lecture 1: 009 MYSQL – Block 8.1, Creating USERS, PRIVILEGES and ROLES

Lecture 2: 009 MYSQL – Block 8.2, Creating USERS, PRIVILEGES and ROLES

Lecture 3: 009 MYSQL – Block 8.3, Creating USERS, PRIVILEGES and ROLES

Lecture 4: 009 MYSQL – Block 8.4, Creating USERS, PRIVILEGES and ROLES

Lecture 5: 009 MYSQL – Block 8.5, Creating USERS, PRIVILEGES and ROLES

Lecture 6: 009 MYSQL – Block 8.6, Creating USERS, PRIVILEGES and ROLES

Lecture 7: 009 MYSQL – Block 8.7, Creating USERS, PRIVILEGES and ROLES

Lecture 8: 009 MYSQL – Block 8.8, Creating USERS, PRIVILEGES and ROLES

Lecture 9: 009 MYSQL – Block 8.9, Creating USERS, PRIVILEGES and ROLES and CLOSING

Chapter 6: Creating Events in MYSQL to be executed automatically.

Lecture 1: 010 MYSQL – Block 1, Creating EVENTS to be executed automatically

Lecture 2: 010 MYSQL – Block 2, Creating EVENTS to be executed automatically

Lecture 3: 010 MYSQL – Block 3, Creating EVENTS to be executed automatically

Lecture 4: 010 MYSQL – Block 4, Creating EVENTS to be executed automatically

Lecture 5: 010 MYSQL – Block 5, Creating EVENTS to be executed automatically

Lecture 6: 010 MYSQL – Block 6, Creating EVENTS to be executed automatically

Lecture 7: 010 MYSQL – Block 7, Creating EVENTS to be executed automatically

Chapter 7: Backup, Restore and Cloning on MYSQL Community

Lecture 1: 011 MYSQL – Block 1, Creating Manual Backups via Workbench

Lecture 2: 011 MYSQL – Block 2, Restoring a Backups manually using the Workbench

Lecture 3: 011 MYSQL – Block 3, Manually Creating Backups with MYSQLDUMP

Lecture 4: 011 MYSQL – Block 4, Manually Creating Backups with MYSQLDUMP

Lecture 5: 011 MYSQL – Block 5, Manually Creating Backups with MYSQLDUMP

Lecture 6: 011 MYSQL – Block 6, Manually Creating Backups with MYSQLDUMP

Lecture 7: 011 MYSQL – Block 7, Creating Incremental Backups manually with MYSQLDUMP

Lecture 8: 011 MYSQL – Block 8, Creating Incremental Backups manually with MYSQLDUMP

Lecture 9: 011 MYSQL – Block 9, Creating Incremental Backups manually with MYSQLDUMP

Lecture 10: 011 MYSQL – Block 10, Creating Incremental Backups manually with MYSQLDUMP

Lecture 11: 011 MYSQL – Block 11, Creating Incremental Backups manually with MYSQLDUMP

Lecture 12: 011 MYSQL – Block 12, Creating Incremental Backups manually with MYSQLDUMP

Lecture 13: 011 MYSQL – Block 13, Creating Incremental Backups manually with MYSQLDUMP

Lecture 14: 011 MYSQL – Block 14, Preparing PowerShell Script to make automatic backups

Instructors

Sandro Servino
Database Engineer and Business Intelligence Professional

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 2 votes
5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu