menu logo orsys formation
CONTACT - +33 (0)1 49 07 73 73
CONTACT - 📞 +33 (0)1 49 07 73 73    drapeau francais   drapeau anglais
Consult our trainings :

Getting Started with MySQL Training

Hands-on course
meilleur vente
Duration : 3 days
Ref : MSQ
Price  2019 : Contact us
  • Program
  • Participants / Prerequisite
  • Intra/Tailored
Program

This course will make it possible to acquire all the skills needed to effectively and reliably use the MySQL database: Using the SQL language, the objects of the database. This course also offers an introduction to administration.

PROGRAM

Introduction and getting started

  • Versions, overview of features and tools.
  • Resources and documentation.
  • Installation procedure.
  • Post-installation settings and first tests.
  • The mysql command line client tool.
  • The MySQL Query Browser graphical tool.

Relational model, designing and creating a database

  • Design elements of a database schema
  • Integrity constraints.
  • MySQL data types (digital, chains, dates, specific types, etc.).
  • Integrated MySQL functions.
  • Types of tables (MyISAM, MEMORY, MERGE, InnoDB, etc.).
  • Creating databases and tables.
  • The INFORMATION_SCHEMA database.
  • Character sets, internationalization.

Hands-on work
Designing and creating a database with MylSAM tables.

Using SQL with MySQL

  • Single selections, comparisons, sorts.
  • Multitable selections, different types of joins.
  • Embedded queries, prepared queries.
  • Changes and view management.

Hands-on work
Single selections, Multiple selections, internal and external joins, embedded requests. Data changes and deletions.

InnoDB transactional tables

  • Notion of a transaction, isolation levels.
  • Physical structure of tables.
  • Transaction programming (START TRANSACTION, COMMIT, ROLLBACK).

Hands-on work
Implementing transactions

Procedural SQL

  • Stored procedures and functions.
  • Defining procedures Triggers.
  • Managing errors.

Hands-on work
Writing stored procedures. Retrieving results using cursors. Creating and using triggers.

Connections, access rights, security

  • Privilege levels and verifying rights.
  • Managing users and their privileges.
  • Making stored procedures and views secure.

Hands-on work
Managing privileges and passwords.

Introduction to administration

  • Exporting data.
  • Back-ups, the mysqldump command.
  • Overview of MySQL installation.

Hands-on work
Exporting data.

Participants / Prerequisite

» Participants

This course is for all IT workers who need to develop for MySQL.

» Prerequisite

Basic knowledge of an operating system (Windows, Linux/Unix).
Intra/Tailored

Contact Informations

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).
You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr
By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Submit your request

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.
However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.
The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys