postgre sql

Goals


- Master the administration of a MySQL database server

Program

History
Sun and Oracle
MariaDB
Server architecture
Concept of storage engine

Installation by the package manager
Instance creation
Administrator password (depending on the version)

Workshop: Install an instance

Command mysql
client web phpmyadmin
Client graphical MySQL Workbench

Workshop: Create an example diagram

Configuration principle Configuration
file
Global variables and session
variables Visualization of variables
Best practices for modifying variables

List of storage engines: SHOW ENGINES
MyISAM
InnoDB
CSV
Memory
Archive

General structure
Configuration of transaction logs
Outsourcing of Undo Logs
Synchronization tolerance

Lab: Reconfigure Transaction Logs

Error
logging Query log and slow queries
– Activation / Deactivation
– File / table storage
Binary logs

Lab: Enable logging of slow requests

Physical backup vs. logical backup
Detach / attach a table
Physical backup and snapshot (FS / LVM)
Logical backup and restore
Binary logs and PITR

Workshop: Save and restore the sample database

Account
management Access rights management
Concept of roles
Authentication plugins
Password management and policy
Local access without password

Workshop: Create accounts and roles

Duration

3 days

Price

£ 1634

Audience

System administrators

Prerequisites

Have knowledge of basic concepts of DBMS and SQL language

Reference

BAS41-F

Sessions

Contact us for more informations about session date