Mastering SQL language with MySQL




DESCRIPTION

In this training, you will learn how to manipulate a database with the SQL language: create and alter objects, update (insert, delete, update) and select data. This skill is needed to connect your apps to data.

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

  Download syllabus






DETAILS

  •   Course syllabus

  • MySQL Getting Started
    Client-server web architecture
    PHP MySQL platforms
    Install XAMPP on Windows
    Test the installation
    phpMyAdmin Client
    MySQL Workbench Client
    Navicat for MySQL Client
    Install Notepad++
    Basic CLI commands
    Using a graphical client

    Data definition
    Create database
    Database Objects
    Defining a DB table
    Create a table in SQL
    Create a table graphically
    The different constraints
    Concept of foreign key
    How to create constraints
    Insert with foreign key
    How to create an index
    How to delete an index
    MySQL data types

    Mastering SQL update clauses
    Insert some columns
    Insert all columns
    Insert multiple rows
    Sequences, auto increment
    Dates with MySQL
    Modify data: UPDATE
    Modify data: REPLACE
    Delete data
    Integrity of data

    Modify data structures
    ALTER TABLE and its options
    Edit Constraints and Indexes
    The RENAME clause
    Navicat, Workbench

    Selecting data (I)
    Introduction
    Projection operation
    Selection or restriction
    Union and difference
    The intersection
    Cartesian product
    Inner join
    Self-join
    Outer join
    Lab : Relational Algebra

    Selecting data (II)
    SELECT Syntax
    Projection, order by
    Filtering and operators
    Group and aggregate
    Group and filter
    Intersection
    Union
    Difference
    Cartesian product

    SQL joins and subqueries
    Equijoin, self-join
    Outer joins
    Full joins
    Natural join
    Sub queries
    Single line subqueries
    Multi-line subqueries
    Related Subqueries

    MySQL Lab
    Lab: data definition
    Lab: insert, modify, delete data
    Lab: selection, grouping, joins
    Lab: modify data structures

  •   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 if available,
  • 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


DURATION (H)



Duration : 21 hours.



PRICE & QUOTES

  •   Online Instructor Led

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

    Guide price : $1490




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.

Workshop: learn SQL with MySQL
Learn how to get started with a database by writing simple SQL clauses.

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.