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.

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

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

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

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

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

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

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

  • INSERT INTO – UPDATE - DELETE

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K