Workshop: learn SQL with MySQL




DESCRIPTION

In this workshop dedicated to beginners with little or no database skills, we will discover databases through practice and learn how to use SQL. This workshop covers the following points: installing a MySQL server, using the phpMyAdmin client, creating a database, creating a simple table, working with data by implementing the most common queries.

Prerequisites:
  • Know how to use a computer.
  • Basic Excel concepts.

  Download syllabus




DETAILS

Live or self-paced

  •   Course syllabus
  • Learning SQL with MySQL
    Introduction
    Install MySQL and phpMyAdmin
    Create a database
    Create a database table
    Add data to database
    Edit data
    Delete data
    Query database (SELECT)
    Q&A

  •   What's included
  • + Experienced instructor
    + Complete syllabus
    + Course material (PDF)
    + Miscellaneous course notes

  •   Who it is for
  • + IT specialists.
    + Data managers.
    + Developers.

  •   Certification
  • The training is illustrated by case studies and practical work. It does not yet lead to certification.



BENEFITS. TESTIMONIALS

  • Your Reconvert instructor,
  • Hands-on based teaching,
  • Immediate access to VODs,
  • Good quality PDF materials.

Excellent quality, the teacher knows how to create an environment of trust and confidence which makes the training really enjoyable. The course was dynamic and easy to understand. The trainer is an excellent instructor.
J. Ruiz
The Moneytizer, Mexico

The training session with you was awesome, really interesting and full of useful information. I’m currently a Cloud & Big Data engineer with Micropole, Paris. Thanks.
A. Chuttoo
Micropole, France

These 4 days have been enriching. After a training-course in HTML and then CSS, the one on Javascript gave me a lot more knowledge and skills in client side web development.
J. Salgueiro
The Moneytizer, Brazil



Other references :

Click on the logo.


Capgemini Atos Allianz TheMoneytizer CPAM M2iFormation Global Knowledge Ikea Hewlett Packard Department of Defense AKKA Ministry of the Interior AFP Enedis Viveris Titeflex Others


UPCOMING DATES


2022/09/15      LIVE      3 hours

2022/10/06      LIVE      3 h

2022/10/27      LIVE      3 h

2022/11/17      LIVE      3 h


Schedule: 09:00 AM to 11:00 AM (Pacific time)
Do you have your own dates ? - Contact us


PRICE. BOOKING

  •   Online Instructor Led
  • Get a quote or book now.
    Video conference tools : Zoom or Teams.
    Getting a quote does not require any payment or commitment.

    Price : 174 €

    Get a quote

    I receive my quote fast

  •   Online self-paced
  • With Online self-paced format, the lesson is webcast AND turored. In fact, you are never left to work alone – you are able to interact asynchronously with the instructor via a dedicated Discord channel. The lesson is accessible during 30 days on our dedicated LMS platform.

    For the moment, this training course is available exclusively online via ZOOM or Microsoft TEAMS sessions, i.e. as Virtual Class (= Online Instructor Led). It will shortly be available Online self-paced.

    Please stay tuned for further information.

  •   Video On Demand
  • When available, access to VOD is immediate.
    And you'll get access to videos 24/7, by paying by credit card.

    For the moment, this training course is available exclusively online via ZOOM or Microsoft TEAMS sessions, i.e. as Virtual Class (= Online Instructor Led). It will shortly be available in VOD.

    Please stay tuned for further information.




Others trainings

Python programming by hands-on
Learn by hands-on how to program in Python language : syntax, functions, databases.

HTML5 & CSS: how to create modern websites
Learn how to create modern web pages using HTML5 and CSS3 languages.

Creating dynamic PHP web applications
Learn to create PHP applications connected to SQL databases.

Workshop: discovering web development
Discover web development in 30 minutes, and see if this job is for you.

Getting started in algorithms with Java
Learn how to solve a problem by describing it in pseudo code language and then by producing a Java code.

Mastering SQL language with MySQL
Learn how to write and test SQL for your web application data.

Workshop: learn programming with Python
Get started with Python by learning how to install it and create small programs.

Javascript programming
Learn how to create interactivity on the browser with the Javascript language.

E-marketing: techniques and tools
Understand and carry out e-marketing campaigns with professional tools.

How to create a blog without coding
Learn how to create a personal or business blog in your web browser, without programming.

jQuery programming
Learn how to create interactivity with jQuery and use Ajax technology.

Java Database Connectivity
Learn how to perform the interaction between Java code and a relational database.

GIT - source code management
Learn how to manage and deploy all your IT projects with Git and GitHub.

UML: analysis and design
Learn to design object applications with UML by representing entities in classes and interactions between objects.

Java SE programming
Learn how to create Java applications using object-oriented programming.

Java Web Programming
Learn how to create dynamic, data-connected web applications using Java and JEE technology.

JPA and Hibernate persistence
Learn how to use the JPA standard and the Hibernate ORM to manage persistence in your applications.

Spring Web programming
Learn how to use Spring Framework, Spring MVC and Spring Boot to build secure web applications.

Web services with Java REST API
Learn how to create REST services in Java, secure them, deploy them and consume them.

Unit testing with JUnit
Get started with the JUnit reference testing framework and implement unit and integration tests.

Angular: web development
Learn how to develop web applications using the Angular framework.

Web application security
Learn how to detect attacks, secure web applications, implement best practices in web security.

Python API and REST Web Services
Learn how to create REST services in Python, secure them, deploy them and consume them.

Advanced PHP, Doctrine and Web Services
Learn how to create object-oriented PHP applications using specialized libraries and Web services.

Symfony : web development
Learn Symfony concepts to create modern and secure MVC web applications.

Django: web development with Python
Learn how to develop web applications in Python using the Django framework.