Pular para o conteúdo

[email protected]
Contato

Curitiba 41 3204.1999 | Brasil 4007.2186
Tel

Whatsapp 41 98754.3534
Whatsapp
SoftSell
MENUMENU
  • HOME
  • TREINAMENTOS E CERTIFICAÇÕES
    • CALENDÁRIO DE TREINAMENTOS
    • Certificações em TI
    • Check Point
      • CCSA – Check Point Certified Security Administrator
      • CCSE – Check Point Security Engineering
      • Check Point CCSA+CCSE – Bundle R.80
    • Cisco
      • Cisco Digital Network Architecture Implementation Essentials (DNAIE) v2.0
      • Cisco SD-WAN Operation and Deployment (ENSDW) v1.0
      • Designing Cisco Enterprise Networks (ENSLD) v1.0
      • Implementing and Administering Cisco Solutions (CCNA) v1.0
      • Implementing and Configuring Cisco Identity Services Engine (SISE) v3.0
      • Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.0
      • Implementing and Operating Cisco Security Core Technologies (SCOR) v1.0
      • Implementing Cisco Application Centric Infrastructure (DCACI) v1.0
      • Implementing Cisco Catalyst 9000 Switches (ENC9K) v1.0
      • Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) v1.0
      • Implementando Cisco Enterprise Wireless Networks (ENWLSI) v1.1
      • Implementing Secure Solutions with Virtual Private Networks (SVPN) v1.0
      • Securing Email with Cisco Email Security Appliance (SESA) v3.1
      • Securing the Web with Cisco Web Security Appliance (SWSA) v3.0
      • Understanding Cisco Wireless Foundations (WLFNDU) v1.0
    • CompTIA
      • Linux+ CompTIA
      • Security+ CompTIA
      • Webinar – Cibersegurança e o Mercado de Trabalho
    • EC-Council
      • CASE JAVA Training & Certification
      • CEH v11
      • CHFI
      • CND v2
      • CSA - Certified SOC Analyst
      • CSCU Certified Secure Computer User
      • ECIH
      • Webinar CEH – Certified Ethical Hacker v10
    • Extreme Networking
      • Campus EXOS Switching and Routing
    • F5
      • Configuring F5 Advanced WAF (previously licensed as ASM)
      • F5 ADM BIG IP – Administering BIG-IP
      • F5 BIG-IP DNS (Antigo GTM)
      • F5 Configuring BIG-IP (AFM): Advanced Firewall Manager
      • F5 Configuring BIG-IP (APM): Access Policy Manager
      • F5 LTM – Configuring BIG-IP Local Traffic Manager
      • F5 Troubleshooting BIG-IP
    • Fortinet
      • FortiGate (I) Security v6
      • FortiGate (II) Infrastructure v6
      • NSE 5 – FortiAnalyzer
      • NSE 5 – FortiManager
      • NSE 7 - Enterprise Firewall
    • Furukawa
      • Data Cabling System & MCT Fluke Networks
      • FCP Fibras Ópticas
      • FCP Fibras Ópticas | Módulo Emendas Ópticas
      • FCP Fibras Ópticas | Módulo Medição em Redes Ópticas
      • FCP Fibras Ópticas | Módulo Redes Externas
      • FCP Master
      • FCP Update
      • FCP Professional
      • FTTx Conceitos e Projetos
      • FTTx Equipamentos | Módulo 1 Networking
      • Webinar
    • Infoblox
      • CDAT – Core DDI Advanced Troubleshooting 8.x
    • Java
      • Java Performance Tuning
      • Java SE 8 Fundamentals
      • Java SE 8 New Features
      • Java SE 8 Programming
      • OO Analysis & Design Using UML
    • Microsoft
      • 10990CC Analyzing Data With SQL Server Reporting Services
      • 20483 Programação em C#
      • 207031BC Administering System Center Configuration Manager
      • 20740CC Installation, Storage and Compute with Windows Server 2016
      • 20741BC Networking with Windows Server 2016
      • 20742BC Identity with Windows Server 2016
      • 20761 Querying Data with Transact-SQL
      • 20762C Developing SQL Databases
      • 20764 Administering a SQL Database Infrastructure
    • MySQL
      • MySQL Cluster
      • MySQL for Developers
      • MySQL for Administrators
      • MySQL for Beginners
      • MySQL Fundamentals
      • MySQL Performance Tuning
    • Oracle
      • Database 12c ASM Administration
      • Database 12c Clusterware Administration
      • Database 12c Data Guard Administration
      • Database 12c Novos Recursos Para Administradores
      • Database 12c Performance Management and Tuning
      • Database 12c RAC Administration
      • Database 12c R2 Administration Workshop
      • Database 12c R2 Backup & Recovery
      • Database 12c R2 Install and Upgrade Workshop
      • Database 12c R2 New Features for Adm 2
      • Database 18c Managing Multitenant Architecture
      • Database Coud for Oracle DBAs
      • Database Program with PL/SQL Ed 2
      • Database SQL and PL/SQL New Features Ed 1
      • Database SQL & PL/SQL Fundamentals
      • Database SQL Workshop II
      • Data Integrator 12c Integration and Administration Ed 3 NEW
      • Exadata Database Machine 12c Administration Workshop
      • Introduction to SQL
      • SQL Tuning for Developers
      • WebLogic Server 12c Adm 1
      • WebLogic Server 12c Adm 2
      • WebLogic Server 12c JMS Adm
      • WebLogic Server 12c Performance Tuning
      • WebLogic Server 12c Troubleshooting
    • Palo Alto Networks
      • PAN 210 – Firewall 9.1 Essentials: Configuration and Management
      • PAN 214 – Firewall 8.1: Optimizing Firewall Threat Prevention
      • PAN 220 – Palo Alto Panorama: Managing Firewalls at Scale v9
      • PAN 318 – Prisma Access Sase Security: Design and Operation
      • PAN 330 – Firewall: Troubleshooting v9
    • Salesforce
      • Salesforce ADX 201
      • Salesforce ADX 251
      • Salesforce ADX 261
      • Salesforce DEX 450
      • Salesforce EEB101 + JB101
    • SoftSell
      • Gerenciamento Win Server 2012
      • Gestão de Projetos
      • Gestão de Projetos na era da Indústria 4.0
      • Linux Essentials
      • Pentest for Red Teams - Buffer Overflow Windows e Linux
      • Pentest for Red Teams – Web Application
      • Redes e Novas Tecnologias
    • SonicWall
      • SonicWall Network Security Administrator (SNSA)
      • SonicWall Network Security Professional (SNSP)
    • Veeam
      • Veeam Certified Engineer V9
    • VMWare
      • VMware vSphere: Install, Configure, Manage v6.7 – VMware
  • SOLUÇÕES DE TI
    • Fábrica de Softwares e BI
    • Produtos e Equipamentos de TI
    • Serviços de TI
      • Computação em Nuvem
      • Gerenciamento de TI
      • IBM Cloud
      • Suporte Infraestrutura
  • INSTITUCIONAL
    • Sobre a SoftSell
  • BLOG
MySQL for Database Administrators
Publicada em 28 de março de 2018 na categoria
Slider

MySQL for Database Administrators

Sobre este Treinamento

  • Define and implement a backup strategy
  • Perform physical and logical backups of your data
  • Describe MySQL replication and its role in high availability and scalability
  • Configure simple and complex replication topologies
  • Administer a replication topology
  • Install the MySQL server and client programs
  • Upgrade MySQL on a running server
  • Describe MySQL architecture
  • Explain how MySQL processes, stores, and transmits data
  • Configure MySQL server and client programs Use server logs and other tools to monitor database activity
  • Protect your data from common security risks
  • Identify and optimize poorly-performing queries
  • Troubleshoot server slowdowns and other common problems
  • Gain an understanding of MySQL Cloud

What you will learn

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability. Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.

Learn To:

  • Install and configure MySQL Server and client programs.
  • Recognize the key components of the MySQL architecture.
  • Secure your server.
  • Troubleshoot server slowdowns and other issues.
  • Improve query performance.
  • Configure and administer a variety of replication topologies.
  • Understand the benefits of MySQL Cloud.

Benefits To You:

After taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether you use on-premise or MySQL Cloud-based instances, and whether your challenge is complex replication requirements, or highly-tuned transactional systems.

Carga Horária: 5 dias

GARANTIR MINHA VAGA!

Pré-requisito

Should be knowlegeable with Joining tables
Should be knowlegeable with MySQL data types and executing basic DDL and DML queries using SQL
Should be knowlegeable with relational database concepts and using the mysql command-line client
MySQL Fundamentals Ed 1

Suggested Prerequisites: MySQL for Developers, MySQL for Developers Ed 2, MySQL for Developers Ed 3.

Database Administrators
Database Developers
Technical Consultant

Público-alvo

Conteúdo

Introduction to MySQL
MySQL overview
MySQL Enterprise Edition
MySQL on the Web
MySQL in the Cloud
The MySQL community

Installing MySQL
Installing MySQL
Installed Files and Directories
Initial Configuration
Starting and Stopping MySQL
Upgrading MySQL

MySQL Architecture
Architectural Overview
How MySQL Transmits Data
How MySQL Processes Requests
How MySQL Stores Data
Tablespaces
Redo and Undo Logs
How MySQL Uses Memory
Plug-in Interface

Configuring MySQL
Server Options, Variables, and the Command Line
Option Files
System Variables
Launching Multiple Servers on the Same Host

Monitoring MySQL
Monitoring MySQL with Log Files
Monitoring MySQL with Status Variables
Monitoring MySQL with Performance Schema
MySQL Enterprise Audit
MySQL Enterprise Monitor
Monitoring User Activity

User Management
MySQL Privilege System
Creating and Modifying User Accounts
Configuring Passwords and Account Expiration
Authentication Plug-Ins
Granting Permissions
Grant Tables
Resetting a Forgotten Root Password

MySQL Security
Security Risks
Network Security
Secure Connections
Password Security
Operating System Security
Protecting Against SQL Injections
MySQL Enterprise Firewall

Maintaining a Stable System
Stability
Why Databases Fail
Capacity Planning
Troubleshooting
Identifying the Causes of Server Slowdowns
InnoDB Recovery

Optimizing Query Performance
Identifying Slow Queries
The EXPLAIN statement
Working with Indexes
Index Statistics

Backup Strategies
Understanding Backups
Backup Techniques
Creating a Backup Strategy

Performing Backups
MySQL Backup Tools
Raw Backup Methods
Techniques that Use the Binary Log

Configuring a Replication Topology
Overview of Replication
Replication Conflicts
When to Use Replication
Configuring Replication

Administering a Replication Topology
Failover
MySQL Utilities
Replication Threads
Monitoring Replication
Troubleshooting Replication

Group Replication
Overview
Single-Primary and Multi-Primary Modes
Configuring Group Replication
Monitoring Group Replication

Conclusion
Course Overview
MySQL Curriculum
Course Evaluation
Thank You!
Q&A Session

Acesse o Calendário de Treinamentos

Atendimento Personalizado

Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:

Curitiba: 41 3204.1999
Demais localidades: 4007.2186
WhatsApp : 41 98754.3534
Email: [email protected]
 

ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080

    Relacionado

    TREINAMENTOS E CERTIFICAÇÕES

    • Treinamentos e Certificações
    • Certificações em TI
    • Inscrições

    INFRAESTRUTURA DE TI

    • Software e BI
    • Serviços
    • Produtos e Equipamentos

    SOFTSELL

    • Sobre a SoftSell
    • Trabalhe Conosco

    ATENDIMENTO

    Telefone SoftSell Curitiba 41 3204.1999

    Telefone SoftSell Demais localidades 4007.2186

    Whatssap SoftSell WhatsApp 41 98754.3534

    Contato SoftSell [email protected]

     


    Rua Emiliano Perneta, 680 – 9º Andar – Centro – Curitiba – Paraná – 80420-080

    Siga-nos

    • Ver perfil de softsell no Facebook
    • Ver perfil de softsell.treinamentos no Instagram
    • LinkedIn

    SoftSell – Todos os Direitos Reservados | Desenvolvido por Pontodesign

    Pontodesign
    © 2021 SoftSell • Distribuído por GeneratePress
    Voltar ao topo