Percona Server dla MySQL Training Course
Percona Server untuk MySQL adalah bagian dari sistem solusi database terintegrasi yang memberikan kinerja lebih baik, keandalan, dan biaya penggunaan lebih rendah (bila menggunakan paket).
Jest adalah alat yang dikembangkan secara unik untuk Platform Perangkat Lunak Percona yang menjamin pencadangan online, kompresi data, serta diagnosis instan dan penyelesaian masalah.
Course Outline
Instalasi server Percona/MySQL
Pemilihan versi
- Mengunduh penginstal (YUM,RPM)
- Instalasi di sistem Linux
File dan skrip server Percona
- Program Percona / MySQL
- pelayan Percona
- Pelanggan Percona
- alat GUI
Konfigurasi server Percona
- Modus server SQL
- Variabel sistem server
- Variabel sistem dinamis
- Variabel status server
- Proses penutupan
Masalah keamanan Percona Server
- Perlindungan server Percona terhadap serangan
- Opsi keamanan
- Masalah keamanan dengan LOAD DATA LOCAL
Percona Access Sistem akses hak istimewa
- Ikhtisar izin Percona Server
- Izin Disediakan oleh Percona
- Menghubungkan ke server Percona - langkah
- Kontrol akses, Tahap 1: Verifikasi koneksi
- Kontrol akses, Tahap 2: Minta verifikasi
- Alasan menolak panggilan
Manajemen akun pengguna Percona
- Pengguna dan kata sandi
- Membuat pengguna baru
- Menghapus akun pengguna
- Membatasi izin pengguna
- Mengubah kata sandi
Pemeliharaan basis data Percona
- Pencadangan dan Pemulihan - DUMP vs. Cadangan Xtra
- Replikasi basis data
- Pemeliharaan dan pemecahan masalah
- Informasi tentang tabel
File Log Percona
Catatan Kesalahan
- Log Kueri Umum
- Perbarui Log
- BinerLog
- Log Kueri Lambat
- Pemeliharaan dan Rotasi File Log
Percona Tembolok Kueri
- Konsep cache kueri
- Menguji cache kueri menggunakan SELECT
- Mengonfigurasi cache kueri
- Memeriksa status penyangga
Instalasi dan peluncuran Percona XtraDB Cluster
Open Training Courses require 5+ participants.
Percona Server dla MySQL Training Course - Booking
Percona Server dla MySQL Training Course - Enquiry
Percona Server dla MySQL - Consultancy Enquiry
Consultancy Enquiry
Testimonials (5)
The quality of training and wealth of experience !
Edvin - Verizon Connect
Course - MySQL Developer
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin - Drax
Course - MySQL Administration
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course - Python in Data Science
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
Kateryna Tokar - Clay Solutions
Course - MariaDB Galera Cluster Administration
Upcoming Courses (Minimal 5 peserta)
Related Courses
MySQL Administration
28 HoursAudience: Any IT professionals who aspire to become DBAs or database support professionals on MySql Database on linx/windows platforms.
Format: 40% theoretical/lectures, 60%Practical/hands on lab
MariaDB Database Administration
14 HoursMariaDB Administration training course is for anyone who wants to administrate the MariaDB database server. It is a comprehensive course covering all administrator duties.
The course explains how MariaDB Database works, what tools are available, how we can use them, how we can secure the MariaDB Database Server and configure it. During the training course you will learn how to manage user accounts and how the MariaDB Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
Advanced MariaDB for High Availability and Performance
28 HoursIn this instructor-led, live training in Indonesia, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
MariaDB Galera Cluster Administration
21 HoursThis course is intended for database administrators.
The course presents options for High-Availability solutions using Galera Cluster.
You will learn the basics of Galera technology, as well as more advanced topics and practical knowledge related to configuring, optimizing and administering a Galera Cluster.
MySQL Database Administration
14 HoursMySQL Kursus pelatihan administrasi adalah untuk siapa saja yang ingin mengatur server database MySQL. Ini adalah kursus komprehensif yang mencakup semua tugas administrator.
Kursus ini menjelaskan bagaimana MySQL Database bekerja, alat apa yang tersedia, bagaimana kita dapat menggunakannya, bagaimana kita dapat mengamankan Server MySQL Database dan mengonfigurasinya. Selama kursus pelatihan, Anda akan mempelajari cara mengelola akun pengguna dan cara kerja MySQL Access Sistem Privilege. Anda juga akan belajar bagaimana memelihara database Anda, mencadangkan dan memulihkan database Anda dan melakukan pemulihan kerusakan.
MySQL Developer
21 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at advanced-level developers who wish to learn and use MySQL and database technologies for building web applications.
By the end of this training, participants will be able to:
- Write SQL queries to retrieve, filter, sort, and aggregate data.
- Perform data manipulation operations such as inserting, updating, and deleting data.
- Implement advanced SQL concepts such as subqueries, derived tables, and conditional logic.
- Integrate MySQL with popular programming languages and execute queries from application code.
MySQL / Galera
21 HoursThis bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Administrating Percona Server for MongoDB
7 HoursPercona Server untuk MongoDB adalah pengganti MongoDB 3.2 Community Edition yang gratis, disempurnakan, sepenuhnya kompatibel, sumber terbuka, dan siap pakai dengan fitur-fitur kelas perusahaan. Tidak memerlukan perubahan apa pun pada aplikasi atau kode MongoDB.
Hadirin
Kursus ini cocok untuk sysadmin dan teknisi yang ingin beralih ke Percona Server dari instance MongoDB yang sudah ada, atau menerapkan dan mengelola Percona Server baru untuk instance MongoDB.
Setelah menyelesaikan kursus ini, delegasi akan:
- memahami Percona Struktur dan mekanisme penyebaran Server
- mampu melakukan tugas instalasi / lingkungan produksi / arsitektur dan konfigurasi
- dapat menilai kualitas kode, melakukan debugging, pemantauan
- dapat menerapkan produksi tingkat lanjut seperti replikasi, penyetelan kinerja, dan pencatatan
Python in Data Science
35 HoursThe training course will help the participants prepare for Web Application Development using Python Programming with Data Analytics. Such data visualization is a great tool for Top Management in decision making.
SQL Fundamentals
14 HoursThis SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
- how to write SQL queries
- what relational databases are and how we can use them
- what are relations and how to create them
- the structure of data
- differences between SQL dialects (Oracle, T-SQL, ANSI)
- practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
SQL in MySQL
14 Hours- How to build a query?
- What is a relational database?
- What is the structure and SQL commands?
SQL Advanced in MySQL
7 HoursThis course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.