Training in the operation of a MySql database

Woospeak, language and office training center since 2006 , offers you its expertise for your training in MySql and in database operation . Our experienced trainers will help you improve and master SQL.

Goal: Learn to design and manage a database.
Know and master the SQL language and its different functions. Being able to create tables and joins, make queries, set up the functions of aggregates and statistics, create views, manage users.
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: Know how to use a computer in a basic way (mouse, keyboard) and know the Windows environment.
Public: Webmaster or anyone wishing to learn how to manage databases.
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: TOSA and ENI.

The objectives of your MySql training

Our MySql training is one of our training courses in our office catalog. It will help you to master SQL language . This training will allow you, among other things, to design and administer a database, to know how to handle numbers and set up functions of aggregates and statistics, to make queries, etc.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

The training program for operating a MySql database

The content of the MySql training program is organized according to the framework below, and will be adapted according to your objectives and your needs:


1. Architecture of a database

  • Links, constraints, primary and foreign keys
  • Table: permanent, temporary, views
  • SQL queries

2. SELECT

  • Extraction, calculations, Comparisons, Hours and dates
  • Aggregates and statistics function
  • Mathematical functions
  • NULL processing

3. Game operators

  • UNION operator
  • INTESECT operator
  • EXCEPT or MINUS operator (Oracle)

4. Add, modify and delete by SQL

5. CREATE TABLE

  • Data types

6. Subqueries

  • Correlation of sub queries

7. Joins

  • Inner, left, right
  • Join tree

8. Windowing

  • Score, over…

9. Other functions:

  • Statistics, time, system, chain…

Control of learning

If you wish, we can also offer you an office certification such as TOSA or ENI. This MySql training is eligible for the CPF (Personal Training Account) .


MySql database training program

MySql in videoformation, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This HTML and CSS training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your MySql training .