Introduction to SQL, the query language for relational databases
SQL is the most popular query language par excellence and is used by many world-famous companies such as Facebook, Microsoft, Adobe and others. It is hard to imagine working with relational databases without SQL. In this very practical course we will not only learn about the language, but also perform various data queries on a MySQL server.
The training sessions are very hands-on oriented in dedicated computer rooms.
Through an active engagement, we will tackle various problem sets and discuss the different approaches.
10 in stock
December 2, 2023
December 16, 2023
Language(s) of the training
Languages spoken by the coach(es)
English, German, Luxembourgish, French
1. Introduction to SQL: Overview of SQL as a query language, its importance in working with relational databases, and its applications in various industries.
2. Database Concepts: Understanding fundamental concepts related to databases, including tables, rows, columns, primary keys, foreign keys, and relationships.
3. Data Manipulation: Learning how to retrieve, insert, update, and delete data using SQL statements, including SELECT, INSERT, UPDATE, and DELETE.
4. Data Filtering and Sorting: Exploring techniques to filter and sort data based on specific criteria using WHERE, ORDER BY, and other relevant clauses.
5. Data Aggregation: Understanding how to perform aggregations on data using functions like COUNT, SUM, AVG, MIN, and MAX, and utilizing GROUP BY and HAVING clauses.
6. Joins and Relationships: Explaining various types of joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, etc.) to combine data from multiple tables based on common columns.
The objective of the entry-level SQL course is to provide learners with an introduction to SQL, focusing primarily on data retrieval in MySQL relational databases.
On successful completion of this course, participants will be able to:
• Create queries in SQL for relational database systems
• Write single table queries
• Filter records to obtain only the relevant information
• Use joins to read data from multiple tables simultaneously
• Perform CRUD operations to add, fetch, modify and delete records in a table.
This training has a total duration of 12 hours and takes place over 3 days
- 2023-12-02 – 08:30 – 12:30
- 2023-12-09 – 08:30 – 12:30
- 2023-12-16 – 08:30 – 12:30
Format and Location
This course takes place ON-SITE
Terres Rouges building
14, porte de France
No prerequisites necessary
This training does not have any assessment or exams; a certificate of participation will be issued to participants.
operate relational database management system