On this SQL Basic course, you will learn SQL from the ground up and build a solid foundation for retrieving, filtering, sorting, and combining data from relational databases.
The course is designed for beginners who want to work more efficiently with data. You will be introduced to Transact-SQL (T-SQL) and, through practical exercises, learn how to build queries, use functions, and retrieve data from multiple tables.
SQL is particularly useful if you work with data in Excel, Power Query, Power Pivot, VBA, Business Intelligence, or reporting, where accessing and processing data from databases is an important part of your work.
After completing the course, you will have a fundamental understanding of SQL and be able to independently build queries to retrieve and process the data you need.
After the course, you will be able to:
Explore our other SQL courses if you are looking for a different level.
Before the course
During the course
After the course
SQL Basic is designed for anyone who wants to learn SQL from the ground up and become able to independently retrieve and process data from relational databases.
The course is particularly relevant if you work with:
No previous SQL experience is required. However, some experience working with data in Excel, Access, or similar applications can be an advantage.
If you already have experience with SQL and basic queries, our SQL Experienced course may be a more suitable next step.
Module 1: Introduction to SQL
You will be introduced to SQL and the fundamental principles behind relational databases.
Topics include:
Module 2: Retrieving data and sorting data
You will learn how to use the SELECT statement to retrieve data from a relational database and sort the results.
Topics include:
Module 3: Filtering data
You will learn how to filter your data using WHERE and essential operators.
Topics include:
Module 4: Filtering by using joker characters
You will work with more advanced filtering and learn how to search for specific patterns in your data.
Topics include:
Module 5: Calculated fields and functions
You will learn how to create calculated fields and use essential T-SQL functions to work with text, numbers, and dates.
Topics include:
Module 6: Totals and grouping data
You will learn how to summarize and group data using aggregate functions.
Topics include:
Module 7: Sub-Queries
You will be introduced to subqueries and learn how to use them for more advanced data retrieval.
Topics include:
Module 8: Joins and combined queries
You will learn how to combine data from multiple tables and gain a better understanding of relationships between data in a relational database.
Topics include:
Siden 1991 har 4D Academy hjulpet virksomheder og specialister med at omsætte viden til målbare resultater. Vores kursister belønner os med en gennemsnitlig rating på 4,8 ud af 5 på Trustpilot, Google og Facebook, og det gør os stolte.
Se hvorfor både nye og erfarne fagfolk vælger os, når de vil løfte deres kompetencer.