SQL Basic (conducted in English) kursus

You will learn

SQL queries (Transact-SQL) provides you with many possibilities for extracting and manipulating data. We will teach you all the basic SQL enabling you, after the course, to create your own solutions which include using the SQL language. The course is also relevant for you if you are using SQL in Excel - either in Power Queries, Power Pivot, VBA codes or in other tools.

On the course, you will learn to

  • Select and manipulate data
  • Sort data and filter data
  • Use the built-in functions in the SQL language
  • Create groups of data
  • Create Sub Queries
  • Select data from multiple tables by using joins
In the section, ”Course Details” below, you will find more details about the content of this course in SQL.

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 in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • 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

This SQL course is a part of 4D's unique collection of English conducted courses in the Business Intelligence category.

Course Details

Module-1: What is SQL?
In this module, you will be introduced to basic theories about designing relational databases and to some history about RMDB and SQL language.

The following will be covered:
  • Basic database design
  • Primary keys and foreign keys
  • What is SQL?

Module-2: Retrieving data and sorting data
Here you will be introduced to the SELECT statement and learn how to perform simple querys in a relational database.

The following will be covered:
  • Use the SELECT statement
  • Retrieve all columns and retrieve individual columns
  • Sort data and sort data by using multiple keys

Module-3: Filtering data
In this module, you will learn to filter selected data.

The following will be covered:
  • The WHERE clause
  • Formulas in a WHERE clause
  • The use of IN – NOT - BETWEEN

Module-4: Filtering by using joker characters
In this module, you will be introduced to filtering by using patterns.

The following will be covered:
  • Special filter characters using Like: %, ?, _

Module-5: Calculated columns and functions
Here you will be introduced to how to create calculated columns. You will also see some of the most commonly used Functions() in SQL. You will learn some of the more specific T-SQL-functions() and be given a list of all the available T-SQL functions. You will also learn to work with alias for tables and columns.

The following will be covered:
  • What is a field? - Concatenation of fields
  • Using alias
  • Calculations
  • What is a function? - using functions

Module-6: Calculating totals and grouping of data
We will introduce you to a special group of functions: The aggregate-functions, which are functions used to calculate per column in a group of data.

The following will be covered:
  • Aggregate functions - SUM, MAX, MIN, AVG
  • Using aggregate functions
  • Grouping data
  • Filtering groups

Module-7: Sub-Queries
In this module, you will learn about subqueries which, on one hand, can be very complex but on the other hand also extremely useful. You will after this module be able to use subqueries as a filter and to use subqueries as embedded in calculations.

The following will be covered:
  • What is a subquery?
  • Filtering by using subqueries
  • Correlated embedded subqueries

Module-8: Joins and combined queries
Here you shall work with normalized data and relational data you will learn how to use joins. We will explain the different types of joins and how they are used.

The following will be covered:
  • Join
  • What are combined queries?
  • Inner join and outer join
  • Joins and aggregations

Module-9: Editing data
In this module, you will get a short introduction to inserting and updating data in a database, by using SQL statements.

The following will be covered:
  • INSERT INTO – UPDATE - DELETE

Hvad siger vores kunder om os?

Se vores google reviewsPå Google Bussiness har vi en score på 4,8 af 5 fordelt på 256 reviews

Se vores facebook Reviews

På Facebook har vi en score på 5 af 5 fordelt på 162 reviews

 

 

Se alle vores reviews 

 

 

Hold dig opdateret med vores nyhedsbrev

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

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Kejsergade 2, 3 sal
1155 København K
Kursusindgang
Kejsergade 2, 3 sal
1155 København K
Åbningstider
Mandag: 08.30 - 15.30
Tirsdag: 08.30 - 15.30
Onsdag: 08.30 - 15.30
Torsdag: 08.30 - 15.30
Fredag: 08.30 - 15.30

 

Kontaktoplysninger

 
Kejsergade 2, 3 sal
1155 København K