Startup Zone

31 Queen Street, Charlottetown, Canada, C1A 7K7
Conveniently located in the innovation hub of Prince Edward Island.

Explore Our Courses

MySQL Developer

21 Hours
This instructor-led, live training in Charlottetown (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.
Read more...

Python in Data Science

35 Hours
The 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.
Read more...

SQL in MySQL

14 Hours
  • How to build a query?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL Advanced in MySQL

7 Hours
This 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.
Read more...

SQL Fundamentals

14 Hours
This 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.
Read more...

MySQL Administration

28 Hours
Audience: 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
Read more...

MariaDB Database Administration

14 Hours
MariaDB 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.
Read more...

Advanced MariaDB for High Availability and Performance

28 Hours
In this instructor-led, live training in Charlottetown, participants will learn how to install, configure and manage MariaDB for high availability and performance. Other topics include backup and recovery, security and clustering.
Read more...

MariaDB Galera Cluster Administration

21 Hours
This 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.
Read more...

MySQL Database Administration

14 Hours
MySQL Administration training course is for anyone who wants to administrate the MySQL database server. It is a comprehensive course covering all administrator duties. 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.
Read more...

MySQL / Galera

21 Hours
This bespoke course has been designed specifically against the requirements provided by Now Managed Learning Services
Read more...

Percona Server dla MySQL

14 Hours
The "Percona Server dla MySQL" training focuses on optimizing the use of Percona Server dla MySQL, optimized for cloud computing, NoSQL access, containers, and modern hardware such as SSDs and Flash storage. The course covers the installation, configuration and optimization of Percona Server, focusing on features related to security, scalability, monitoring and data management. Participants will acquire practical skills enabling the effective use of advanced capabilities Percona Server dla MySQL.
Read more...

ProxySQL

14 Hours
This instructor-led, live training in Charlottetown (online or onsite) is aimed at engineers who wish to use a proxy approach to ensure high availability for MySQL based databases. 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.
Read more...

Last Updated:

Testimonials (22)

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

The trainer explained everything with a lot o detail, and it was always engaging us.

Florian Lipianu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration

It was structured very well and documented information. I really liked the trainer enthusiasm.

Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration

A lot of practical examples.

Stefan Turcu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration

knowledge of the trainer

mohamed labib - e-finance
Course - MariaDB Database Administration

The training environment was accessed very fast without any specific configurations.

Krasimir Troskov
Course - MariaDB Database Administration

I really like the Exercises and balance between theory and practice

Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance

Was well organized Instructor ability to explain concepts, in a manner that is easy to understand

Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Galera Cluster Administration

Les performances

chrstophe delcenserie - MALAKOFF HUMANIS
Course - MariaDB Galera Cluster Administration

les explications

daniel Moroani - Direction Générale de la Gendarmerie Nationale
Course - MariaDB Galera Cluster Administration

Nous avons pu comprendre le schéma de fonctionnement. Le formateur s'est adapté à nos infrastructures et a toujours eu une solution. La préparation était optimum avec les pré requis les serveurs déjà configurés. Le formateur sait capter son auditoire et partager sa passion.

Hervé Gbaguidi - Gendarmerie
Course - MariaDB Galera Cluster Administration

Partie théorique reprise dans les scripts fournis et demos

Michel Nachun - Pôle emploi DSI
Course - MariaDB Galera Cluster Administration

The training can use relevant examples in your work.

Aisha - Iziko Museums
Course - MySQL Database Administration

practical examples.

Kesh Mulloo - Vodacom
Course - MySQL Database Administration

The quality of training and wealth of experience !

Edvin - Verizon Connect
Course - MySQL Developer

Trainer was accommodative. And actually quite encouraging for me to take up the course.

Grace Goh - DBS Bank Ltd
Course - Python in Data Science

I like this training because it was interactive

Amalia - Banca Transilvania
Course - SQL Fundamentals

He had a lot of patience with all the students.

Cristina
Course - SQL Fundamentals

I like the exercise part.It was exactly as a course should be.

Larisa
Course - SQL Fundamentals

His attitude, the way he teaches, very easy to understand and it's so enjoyable having him as a trainer!

Raluca Voicu
Course - SQL Fundamentals

the way he explained, I finally understood certain functions that I didn't understand even in college

Adriana
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

Upcoming Courses

Other regions in Canada

Other Countries

These courses are also available in other countries

Consulting

MySQL Consulting
Online MySQL training in charlottetown, MySQL training courses in charlottetown, Weekend MySQL courses in charlottetown, Evening MySQL training in charlottetown, MySQL instructor-led in charlottetown, MySQL private courses in charlottetown, Evening MySQL courses in charlottetown, MySQL classes in charlottetown, MySQL boot camp in charlottetown, MySQL instructor-led in charlottetown, MySQL coaching in charlottetown, Weekend MySQL training in charlottetown, MySQL one on one training in charlottetown, MySQL instructor in charlottetown, Online MySQL training in charlottetown, MySQL trainer in charlottetown, MySQL on-site in charlottetown
1