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
Prerequisites
There are no prerequisites
ESCO Skills
ESCO Occupations
Your trainer(s) for this course
