SQL Training: Mastering SQL Queries
This SQL training gives you the opportunity to learn the theory and immediately practice SQL queries directly on a course server, allowing you to apply your knowledge at your own pace.
Introduction to the SQL Training
- Definition of a database
- Definition of a Database Management System (DBMS)
- Defining a relational model
- Overview of SQL languages: DQL, DML, DDL
Module 1: Course on DQL (Data Query Language)
- SELECT FROM query
- SELECT WHERE query
- SELECT ORDER query
- SELECT LIMIT query
- SELECT EXPR query
- SELECT FROM JOIN query
- SELECT AGGR GROUP query
- SELECT AGGR GROUP HAVING query
Module 2: Course on DML (Data Manipulation Language)
- Introduction to DML
- INSERT query
- INSERT SELECT query
- INSERT INTO MULTIPLE TABLES
- UPDATE query
- UPDATE MULTIPLE TABLES
- DELETE query
- DELETE FROM MULTIPLE TABLES
Module 3: Course on DDL (Data Definition Language)
- CREATE TABLE query
- DROP TABLE query
- ALTER TABLE query
Module 4: Theory on Advanced SQL Concepts
- Indexes and index types
- Foreign key constraints
- Database modeling: explanation of 1NF, 2NF, and 3NF
- Natural keys vs. complex keys
SQL Triggers and Stored Procedures
Autre(s) cours dans cette catégorie
→ SQL Training: Mastering SQL Queries
Préalables :
- Basic computer literacy
Who Should Attend / Target Audience for SQL Training
Both practical and comprehensive, this SQL training is designed for anyone looking to learn the basics of SQL to create queries for retrieving and updating data in databases.Prerequisites for SQL Training
Good knowledge of Windows (or MacOS)Materials Provided During the SQL Training
Training document including course theory and exercises, MySQL server access for the duration of the courseRequired Tools or Materials for SQL Training
Installation of MySQL WorkbenchWhy Choose SQL Training with Doussou Formation? / Advantages of SQL Training at Doussou Formation
Experienced instructors who adapt to your needs, hands-on learning, and up-to-date SQL content.Teaching Approach of the SQL Training
The SQL training is based on a personalized approach that takes into account your previous knowledge, skills, project, and what you want to learn about SQL.Objectifs :
By the end of the SQL training, you will be able to:
- Understand and interpret different types of diagrams that define and represent a database.
- Grasp the basic concepts of a relational database.
- Create, modify, delete, and populate a database with tables and data.
- Retrieve the data you need from your database using the appropriate queries.
Montréal :
Québec :
Gatineau / Ottawa :
Moncton :
Classe virtuelle (en ligne) :
663 $
per participant
Duration :2 day(s), is 14 hours.
Hours: 9 am-5pm, 2 coffee breaks.
Locations: Montreal, Gatineau / Ottawa, Quebec City.
Regular price: 781 $
*The preferential rate applies if you register at least two participants in the same session.
“ I want to thank you both for providing my resources some excellent training(Cobol) over the past 3 days. Mamadou, thank you for being so accommodating on such short notice and for sending your facilitator to Gatineau for this customised and personalised training course. We’ll look forward to continuing our partnership for future training needs. “
“J’ai grandement apprécié les méthodes d’enseignement du prof. Le fait que nous soyons un petit groupe a grandement facilité les apprentissages. Il s’adapte à son audience et les exercices sont formateurs. Je recommande fortement. “
“ Ce fut un plaisir de faire affaires avec Doussou Formation. Ce qui fait LA différence est le service personnalisé totalement à l'écoute des participants ainsi que l'adaptation aux besoins de formation. Flexibilité / Adaptabilité / Professionnalisme / Courtoisie. Merci!“