Coding

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.

Content

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.

Learning Outcomes

On 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.

Training Method

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.

Organised By
Digital Learning Hub Luxembourg
Digital Learning Hub Luxembourg
Prerequisites

There are no prerequisites


Available Edition(s):

https://www.dlh.lu/web/image/product.template/817/image_1920?unique=946153c

This combination does not exist.

64.00 € 64.0 EUR 64.00 €

64.00 €

Not Available For Sale

Your trainer(s) for this course
Vanessa AL DAHAM