Local, instructor-led live MySQL training courses demonstrate through discussion and hands-on practice the fundamentals of MySQL.
MySQL training is available as "onsite live training" or "remote live training". Onsite live MySQL trainings in the US can be carried out locally on customer premises or in NobleProg corporate training centers. Remote live training is carried out by way of an interactive, remote desktop.
NobleProg -- Your Local Training Provider
Testimonials
Training material was very informative. Learned a lot.
Yaw Asamoah
Course: MariaDB Database Administration
I really enjoyed the lessons and examples.
Kelly Taylor
Course: MariaDB Database Administration
He adapted to the experience of the group, gave us great value for a beginners course.
Rich Mickey
Course: MariaDB Database Administration
Enjoyed the pace, delivery and technical know how of the trainer.
Junaid Kalang
Course: MariaDB Database Administration
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
Course: SQL Fundamentals
I learned a LOOOOOT.
Kamil Szmid
Course: SQL Fundamentals
I enjoyed the backup and restore and multiple instances.
Lakshmi Ponnada - Albany Medical Center
Course: MySQL Database Administration
The most I liked it was that we did a lot of practical exercizes.
Cristian Trufasila - Oberthur Technologies Romania SRL
Course: MariaDB Database Administration
The practice we have done during the training.
Ioana Nastase - Oberthur Technologies
Course: MariaDB Database Administration
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
Course: MySQL Database Administration
Small, highly focused group allowed us all to stay involved directly with the instructor the whole time which becomes less tenable as group size grows.
Leading Edge Marketing Inc
Course: MySQL Administration
I generally liked the hands-on exercizes.
Palawan Pawnshop - Palawan Express Pera Padala
Course: MySQL Administration
I really enjoyed all exercize.
Palawan Pawnshop - Palawan Express Pera Padala
Course: MySQL Administration
very logical and step by step but not too much
Anne Homer - States of Jersey
Course: SQL Fundamentals
He was very friendly and he created a very good environment.
European Commision, Joint Research Centre
Course: SQL Advanced in MySQL
I enjoyed the flexibility to explore different areas outside the set training materials.
BMW Group
Course: SQL Fundamentals
The trainer has extensive knowledge of IT.
Iwan Susanto - Universitas Terbuka
Course: Advanced MariaDB for High Availability and Performance
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
Course: Advanced MariaDB for High Availability and Performance
Generally he was good, knowledgeable and understandable in the subject matter
BMO
Course: MariaDB Database Administration
Trainer was great
Clay Solutions
Course: MariaDB Galera Cluster Administration
exercize: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
Kateryna Tokar - Clay Solutions
Course: MariaDB Galera Cluster Administration
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Course: SQL Fundamentals
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
Course: SQL Fundamentals
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course: SQL in MySQL
The practical exercizes.
Clay Solutions
Course: MariaDB Galera Cluster Administration
The exercizes done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
Course: MySQL Database Administration
all topics are interesting
Stolt Tankers BV
Course: MySQL Database Administration
n/d
Artur Bryś - Centrum Innowacji ProLearning
Course: SQL Fundamentals
Patience, reordering, knowledge
Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
Lots of exercizes
Michał Świerkowski - Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
Practice
Santander Bank Polska S.A.
Course: SQL Fundamentals
Machine Translated
MySQL Course Outlines
Format: 40% theoretical/lectures, 60%Practical/hands on lab
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.
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.
The course explains how MySQL Database works, what tools are available, how we can use them, how we can secure the MySQL Database Server and configure it. During the training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You also will learn how to maintain your database, backup and recover your databases and perform crash recovery.
-
Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes
-
SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies
-
Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware
-
Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host
-
Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
By the end of this training, participants will be able to:
- Install and configure ProxySQL.
- Enable thousands of concurrent database connections over multiple backend servers.
- Deploy multiple ProxySQL proxies spanning numerous database instances.
- Optimize the performance of a MySQL cluster, without altering the querying applications.
- 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.
- What is a relational database?
- What is the structure and SQL commands?
By the end of this training, participants will be able to:
- Design and implement new user facing features
- Optimize web applications to maximize speed and scale
- Write client-side code for web-based applications
- Create fast, easy to use, high volume production applications and develop prototypes quickly
Audience
- Beginner web developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
_(gtech).png "international game technology (igt) (gtech)")
.jpg "food and drug administration (fda)")
.jpg "lewisville independent school district (lisd)")
.png "american medical association (ama)")
.png "texas state technical college (tstc)")
.jpg "american international group (aig)")
