SQL Basic (conducted in English) kursus

You will learn

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:

  • Retrieve relevant data from relational databases using SQL.
  • Sort and filter data based on different criteria.
  • Use essential SQL functions to process data.
  • Create calculated fields and perform basic calculations.
  • Group data and calculate values such as sums, averages, and minimum values.
  • Use subqueries for more complex data retrieval.
  • Combine data from multiple tables using JOINs.
  • Build structured SQL queries that can be applied in your daily work.

Explore our other SQL courses if you are looking for a different level.

You get

Before the course

  • The opportunity to speak with one of our instructors about finding the right course for you

During the course

  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch at a nearby restaurant, cake and sweets.
  • A course certificate as a proof of your new skills

After the course

  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course

Get the best benefit from 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:

  • Excel
  • Power Query and Power Pivot
  • Business Intelligence and reporting
  • Data analysis
  • Databases and other data-driven solutions

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.

Course Details

Module 1: Introduction to SQL

You will be introduced to SQL and the fundamental principles behind relational databases.

Topics include:

  • Basic database theory
  • What is SQL?
  • Relational databases

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:

  • The SELECT statement
  • Retrieving individual columns
  • Retrieving multiple or all columns
  • Sorting data
  • Sorting by multiple columns

Module 3: Filtering data

You will learn how to filter your data using WHERE and essential operators.

Topics include:

  • WHERE
  • Operators in WHERE clauses
  • Formulas in WHERE clauses
  • The IN operator
  • The NOT operator

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:

  • The LIKE operator
  • Wildcards
  • Searching for patterns in data

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:

  • Calculated fields
  • Concatenating fields
  • Aliases
  • Mathematical calculations
  • SQL functions
  • Date and text functions

Module 6: Totals and grouping data

You will learn how to summarize and group data using aggregate functions.

Topics include:

  • Aggregate functions
  • Unique values
  • Combining multiple aggregate functions
  • Grouping data
  • Filtering groups

Module 7: Sub-Queries

You will be introduced to subqueries and learn how to use them for more advanced data retrieval.

Topics include:

  • What is a subquery?
  • Filtering with subqueries
  • Subqueries as calculated fields

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:

  • The JOIN operator
  • Table aliases
  • Different JOIN types
  • INNER JOIN and OUTER JOIN
  • JOINs and aggregates
  • Combined queries

Hvad siger vores kunder om os?

1242 Evalueringer seneste år
4,8 Gns. Rating ud af 5

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.

Læs alle vores anmeldelser her

Trustpilot Logo Sort Google Logo Sort Facebook Logo Sort
Kursus frokost hos 4D Academy

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Her bor vi

Kursuscentre
København (Hovedkontor)
Læderstræde 22, 2. sal, 1201 København K

Aarhus
Tueager 5, 8200 Aarhus

Odense
Ørbækvej 350, 5220 Odense
Åbningstider
Mandag: 08.00 - 16.00
Tirsdag: 08.00 - 16.00
Onsdag: 08.00 - 16.00
Torsdag: 08.00 - 16.00
Fredag: 08.00 - 16.00