Introduction to SQL, the query language for relational databases
48,00 €
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
Start date
December 2, 2023
End date
December 16, 2023
Language(s) of the training
English
Languages spoken by the coach(es)
English, German, Luxembourgish, French
Instructor(s)
Dren Gashi
Contents
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.
Objective
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.
Learning Outcomes
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.
Schedule
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
L-4360 Esch/Alzette
Level
Beginner
Prerequisites
No prerequisites necessary
Additional Info
Certification
This training does not have any assessment or exams; a certificate of participation will be issued to participants.
Esco Skills
operate relational database management system
Esco Occupations
database developer