MySQL Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of MySQL Database Admin




Total 389 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Php & Mysql
PHP and MySQL
MySQL
MySQL Database Administration
mysql for developers
PHP MySQL


PHP and MySQL Programming

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

PHP and MySQL are two of today&,#146,s most popular, open-source tools for server-side web programming. In this five day, instructor-led course you&,#146,ll learn how to use them together. You&,#146,ll create a database-driven website that implements the MVC pattern. You will learn how to build out your PHP and MySQL skills to the professional level.
Learn how to use the latest versions of PHP, MySQL, the Apache web server and the NetBeans IDE to build your first PHP applications. You&,#146,ll learn to create applications that conform to the MVC pattern, so they&,#146,ll be easier to maintain as they grow.
The course covers the skills you&,#146,ll use every day in professional applications, like how to work with form data, dates, arrays, sessions, cookies, functions, objects, regular expressions and exceptions. Use MySQL to design and create a database and learn how to access and maintain the data in a database.
Learn important web programming skills like how to secure web pages, prevent SQL injection attacks, guard against XSS attacks, send email, upload files, process images and access content from other websites.

Prerequi... [Read More]

MySQL Administration & Development

Course Format: Classroom
School/Trainer: ISInc
Training Center(s)/Venue(s): Sacramento, United States
  V

MySQL is the open source community&,#146,s most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP - Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs

MySQL

Course Format: Classroom
School/Trainer: GTC Economic Development and Corporate Training
Training Center(s)/Venue(s): Greenville, Simpsonville, Taylors, United States
  V

This course will give students the skills they need to set up and manage a MySQL database. Students will learn the basics of designing a relational database and learn to use SQL statements to create databases, tables and manage data in the data tables. Students will create a MySQL database and will identify the types of data that can be stored in data tables. Students will use the PHPMyAdmin tool to view and manage their MySQL databases. Students will learn to write applications which use MySQL databases.

•Students will install MySQL, connect to the MySQL database application and create a database and set up users for their database.
•Students will design a relational database.
•Students will use MySQL commands to define a database and tables.
•Students will add records to their database, edit records, delete records and select records.
•Students will use MySQL functions to work with database data.
•Students will explore tools, applications and programming environments that work with MySQL.
•Students will work with transactions and advanced SQL queries.
•Students will explore feature that are new to MySQL 5.
•Students wil... [Read More]

phpMyAdmin for MySQL Essential

Course Format: Classroom
School/Trainer: Tertiary Infotech Sdn. Bhd.
Training Center(s)/Venue(s): Cheras, Malaysia
  V

MySQL is one of the most widely used database systems for dynamic websites and content management systems. And phpMyAdmin is the most common method of administering a MySQL database, included in many CMSs as well as the XAMPP and MAMP testing environments.

This introductory course will show designers and developers how to create a database, design tables, and insert, update, and delete data either on a local computer or a remote server. Plus, you&,#146,ll learn how to use phpMyAdmin to export data to a text file that can be used as a backup or to transfer the data to another server. You&,#146,ll also learn how to run database queries within its intuitive form-based interface, and monitor server performance.

MySQL Essential

Course Format: Classroom
School/Trainer: Tertiary Infotech Sdn. Bhd.
Training Center(s)/Venue(s): Cheras, Malaysia
  V

MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, the trainer will go through the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines.

PHP with MySQL Essential

Course Format: Classroom
School/Trainer: Tertiary Infotech Sdn. Bhd.
Training Center(s)/Venue(s): Cheras, Malaysia
  V

This is a 2 days training on PHP and MYSQL. PHP is a popular, reliable programming language at the foundation of many data-driven CMS websites such as Wordpress, Joomla and Magento. This comprehensive PHP with MYSQL course will help beginners to learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database. The trainer will cover the basic CRUD routines for updating a database.
Topics include:
-What is PHP?
-Installing and configuring PHP and MySQL on Mac and Window
-Exploring data types
-Controlling code with logical expressions and loops
-Using PHP&,#146,s built-in functions
-Writing custom functions
-Building dynamic web pages
-Working with forms and form data
-Using cookies and sessions to store data
-Connecting to MySQL with PHP
-Creating and editing database records

LAMP Developer

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

LAMP is a stack of free and open source software. The acronym LAMP was first used by Michael Kunz in 1998. It stands for:

Linux - the operating system
Apache - the web server
MySql - the database server
PHP/Perl/Python - the scripting language

LAMP is used to run dynamic websites and servers and is an adequate alternative to commercial packages. Because of its flexibility, customization and cost effectiveness, LAMP is one of the most popular ways to develop enterprise level web applications.

Course Objectives

Comprehend installation of Linux
Comprehend Service Management
Comprehend Dynamic Content
Comprehend Error Handling
Understand MySQL Table Types
Manage User privileges
Comprehend Proxies
Comprehend Package Management with YUM

WAMP Developer

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

The acronym WAMP stands for:

Windows - the operating system
Apache - the web server
MySql - the database server
PHP/Perl/Python - the scripting language

WAMP is variation of LAMP (instead of Linux, it uses the more familiar Windows platform)

WAMP (Windows, Apache, My SQL and PHP) is used to run dynamic websites and servers and is an adequate alternative to commercial packages. Because of its flexibility, customization and cost effectiveness, WAMP (Windows, Apache, My SQL and PHP) is one of the most popular ways to develop enterprise level web applications.

Course Objectives

Deploy, support, and troubleshoot applications on Apache
Navigate Apache&,#146,s directory structure
Learn to manage sessions with PHP
Learn to work with the MDB2 package
Understand how MySQL works
Learn advanced form validation with regular expressions.
Learn to send email with PHP
Understand Apache configuration files: httpd.conf
Secure Apache and applications running on it
Set up Apache for SSL

MySQL Performance Tuning

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

This training teaches how to safely and effectively optimize the performance of MySQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

This certification also validates your skills to perform tasks like server tuning, storage engine examination, and application architecture assessment. Candidates additionally get acquainted with general concepts related to tuning. The course is appropriate for developers, as well as database and system administrators.

Candidates understand the fundamentals of performance tuning, and learn about the usage of performance tuning tools.

Course Objectives


Improve performance by implementing appropriate Schema Design
Portray additional items regarding performance tuning
Enhance performance by tuning MySQL Server instance

OCP MySQL 5.6 Developer (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

This course was previously called SCMDEV, i.e. Sun Certified MySQL Developer. As the training is primarily about writing applications, the topics covered include functions, data types, queries, triggers, transactions, and stored procedures. The course curriculum also consists of practical sessions that tell you how to deal with complex queries.
In order to achieve the Oracle Certified Professional, MySQL 5.6 Developer certification, students are required to clear both Part 1 and Part II exams. While it is advised that you clear Part 1 first and Part 2 later, the distinction in parts does not mean a difference in advancement level. Both the parts cover different expertise areas, and hence you can appear in the exams as per your choice.

This certification is meant for professionals who aim to develop applications by using MySQL as the back-end storage system. Students attending the training are able to create and use tables and databases. They become proficient in data storage in MySQL database. This involves tasks like insertion, retrieval, modification and deletion.

Course Objectives


Maintaining data in organizational database... [Read More]

OCP MySQL 5.6 Database Administrator (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

The training imparts various skills, such as securing user privileges, defining resource limitations, setting up access controls, and describing recovery fundamentals. You also learn about the creation and use of stored procedures, views and triggers. Oracle Certified Professional, MySQL 5 Database Administrator certification is meant for both Developers and Database Administrators. This certification proves your capabilities in effectively managing various server-based issues. The training also teaches you how to configure server options of MySQL at runtime. It additionally offers an understanding about the usage of MySQL with InnoDB storage engine.

Course Objectives


Understanding MySQL Architecture
Installing and upgrading MySQL
Using INFORMATION_SCHEMA database for accessing metadata
Performing start and end operations of MySQL
Evaluating character sets and data types for performance-related concerns
Understanding the effective way of MySQL installation
Using triggers for management tasks
Understanding views
Performing backup and recovery activities
Understanding data locking concepts in MySQLRead More]

PHP & MySql

Course Format: Classroom
School/Trainer: Jumping Bean
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Polokwane, South Africa
  V

PHP and MySql are the killer combination for rapid web application development. PHP and MySql are two of the most widely used open source technologies that power millions of web sites allowing businesses to leverage the Internet to create lasting value and competitive advantage. In this course you will learn how to build a web site from scratch It covers all you need to know to start developing your own solutions or to customise many of the open source application already available like Drupal, Wordpress or Joomla.

The course contetn covers the basics of databases design, SQL query langfuage, and how to access a database from a web applicaiton using PHP. On completion of the course students will be able to create and maintain data-driven web applications powered by PHP.

Course Outline
•PHP Basics ◦How to install PHP/Apache
◦PHP language ◾Basic syntax,
◾control and loops,
◾types,
◾functions,

•MySQL/Maria DB installation
•Introduction to SQL syntax, ◦Selecting, updating and deleting SQL data,

•PHP Web application overview ◦HTML/CSS,
◦Dynamic Web pages with PHP,

•Connecting PHP &, ... [Read More]

MYSQL

Course Format: Classroom
School/Trainer: HB Education and Consulting Services
Training Center(s)/Venue(s): Chennai, India
  V

Module 1 - Introduction
MySQL Overview, Products, Services
MySQL Services and Support
Supported Operating Services
Training Curriculum Paths
MySQL Documentation Resources

Module 2 - MySQL Architecture
The client/server model
Communication protocols
The SQL Layer
The Storage Layer
How the server supports storage engines
How MySQL uses memory and disk space
The MySQL plug-in interface

Module 3 - System Administration
Choosing between types of MySQL distributions
Installing the MySQL Server
The MySQL Server installation file structure
Starting and stopping the MySQL server
Upgrading MySQL
Running multiple MySQL servers on a single host

Module 4 - Server Configuration
MySQL server configuration options
System variables
SQL Modes
Available log files
Binary logging

Module 5 - Clients and Tools
Available clients for administrative tasks
MySQL administrative clients
The MySQL command-line client
The MySQL admin command-line client
The MySQL Workbench graphical client
MySQL tools ?Available A... [Read More]

MySQL for Developers

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This five day instructor led course teaches developers how to plan, design and implement applications using MySQL. Expert Oracle
University instructors will teach you through realistic examples, interactive instruction and hands-on exercises using Java and PHP
languages.
After taking this course, you will be able to write programs that take advantage of the power and flexibility of MySQL. You will
have developed the skills to build a database that&,#146,s optimal for your application, while creating fast and effective queries.
Prerequisites
Before attending this course, students must have:
?Basic knowledge of SQL
?Experience of Java, PHP or another programming or scripting language
?Experience of creating tables and queries in a relational database
Oracle requires and recommends that delegates have attended the following course prior to attending Oracle Database Program
with PL/SQL.
?D61918GC30 MySQL for Beginners
At Course completion
After completing this course, students will be able to:
?Use client programs and options.
?Access the database from program code.
?Build &,quot... [Read More]

MySQL for Database Administrators

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This five-day instructor-led course is for DBAs and other database professionals who want to install and configure the MySQL
Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
Database administrators will learn how new enhancements made available in MySQL 5.6 will increase performance, scalability,
reliability and manageability for their Web, Cloud and embedded application requirements. You will be able to install, configure,
maintain and tune databases for a wide variety of workloads and environments.
Prerequisites
Before attending this course, students must have:
?Have some experience with databases and the SQL language
Oracle requires and recommends that delegates have attended the following course prior to attending Oracle Database Program
with PL/SQL.
?D61918GC30 MySQL for Beginners
At Course completion
After completing this course, students will be able to:
?Describe the MySQL Architecture
?Install and Upgrade MySQL
?Use the INFORMATION_SCHEMA database to access metadata
?Perform the MySQL start and shutdown operat... [Read More]

MySQL for Beginners

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This four-day instructor-led course helps you learn about the world&,#146,s most popular open source database. Expert Oracle
University instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of
using relational databases.
This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud
and embedded applications. In learning about MySQL, you will develop an understanding of relational databases and how to
design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them
with data and query that data through extensive hands-on practices.
Prerequisites
Before attending this course, students must have:
?Basic computer literacy
?Knowledge of database concepts
?Experience with any command-line program
Oracle requires and recommends that delegates have attended the following course prior to attending Oracle Database Program
with PL/SQL.
?None Required
At Course completion
After completing this course, students will be... [Read More]

Oracle 11g DBA/Developer Workshop (Certificate)

Course Format: Classroom
School/Trainer: Synergy Education Services, A Division of Synergy Computers (Pvt.) Ltd.
Training Center(s)/Venue(s): Karachi, Pakistan
  V

Oracle 11g is a contemporary release of Oracle Database family of products. Besides retaining core concepts of its predecessor Oracle 10g, it has introduced certain new concepts and features to make it a most robust database system. This course develops skills required to manage Oracle 11g Databases efficiently with new functionality that makes many common operations tasks incredibly fast and simple. The course starts from teaching Oracle Database 11g fundamentals and moves on to the advanced level tasks a DBA has to exercise to keep the system up and running.

PHP Developer (Certificate)

Course Format: Classroom
School/Trainer: GetCertified IT Training
Training Center(s)/Venue(s): Johannesburg, South Africa
  V

Day 1

Application Planning and Design

•What is Web 2.0?
•Database connectivity
•Web Site Templates
•Web Site Features
•Other Aspects of Development
•Version control and unit testing

Setting up the Application Framework

•Web Server Setup
•Application Filesystem Structure
•Installing the Zend Framework
•Configuring the Web Server
•Setting Up the Database
•Using the Model-View-Controller Pattern
•Defining Application Settings
•Connecting to the Database
•The Smarty Template Engine
•Adding Logging Capabilities

User Authentication, Authorization and Management

•Creating the User Database Table
•Introduction to Zend Auth
•Introduction to Zend Acl
•Combining Zend_Auth Zend_Acl and Zend_Controller_Front
•Managing User Records with DatabaseObject
•Managing User Profiles

Day 2
User Registration, Login and Logout

•Creating the User Database Table
•Introduction to Zend Auth
•Introduction to Zend Acl
•Combining Zend_Auth Zend_Acl and Zend_Controller_Front
•Managing User Records w... [Read More]

PHP Advanced (Certificate)

Course Format: Classroom
School/Trainer: GetCertified IT Training
Training Center(s)/Venue(s): Johannesburg, South Africa
  V


Day 1

•Building personalized web apps
•Prepping the database for log-ins
•Constructing a log-in user interface
•Encrypt passwords with SHA()
•Comparing passwords
•Authorizing users with HTTP
•Logging In Users with HTTP Authentication
•A form for signing up new users
•Use cookies with PHP
•A cookie-powered log-in
•Logging out means deleting cookies
•Sessions aren’t dependent on the client
•Keeping up with session data
•Log out with sessions
•Complete the session transformation
•Sessions + Cookies Superior log-in persistence
•Eliminate duplicate code
•Using templates
•Control your data, control your world
•Model a database with a schema
•Wire together multiple tables
•Foreign keys in action
•Tables can match row for row
•One row leads to many
•Matching rows many-to-many
•Build a questionnaire
•Get responses into the database
•We can drive a form with data
•Generate the questionnaire form
•Strive for a bit of normalcy
•When normalizing, think in atoms
•Three steps to a normal database
•Altering the d... [Read More]

MySQL Administration

Course Format: Classroom
School/Trainer: VerticalDivers
Training Center(s)/Venue(s): Bangalore, India
  V

You will learn how MySQL Database works, what tools are available, how we can use them, how to secure and configure a MySQL Database Server. During this MySQL training course you will learn how to manage user accounts and how the MySQL Access Privilege System works. You will also learn how to to database maintenance, as well as perform your database backup and recovery.

Outline

MySQL Server Files and Scripts

MySQL Programs
Extended MySQL Server (mysqld-max)
mysqld_safe, mysql.server
mysqld_multi

MySQL Server Configuration

mysqld Options
The Server SQL Mode
Server System Variables
Dynamic System Variables
Server Status Variables
Shutdown Process

MySQL Security Issues

Securing MySQL Against Attacks
Security-Related mysqld Options
Security Issues with LOAD DATA LOCAL

MySQL Access Privilege System

MySQL Privilege System Overview
Privileges Provided by MySQL
Connecting to the MySQL Server - Stages
Access Control, Stage 1: Connection Verification
Read More]

Pages: 1 2 3 4 5 6 ...


Find MySQL training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.



- Other Topics -
- Online/E-learning -
MySQL
Ask for Training
Add Courses