SQL Basic (conducted in English) kursus

You will learn

SQL is a universal language used on several platforms designed to manipulate data in relational databases.
On this course, we focus on functionality of importance for data consumers, like controllers and analysts retrieving data from databases to Excel or other reporting applications.
This course is intended for you who wants to extract data from databases like Microsoft SQL servers, Oracle Servers, Access databases. This course is also the base platform you need if you want to work with the more advanced functions like creating Views, Stored procedures and more, on a Microsoft SQL server.
The course will be conducted in English.

On the course, you will learn to

  • Select and manipulate data
  • Sort data
  • Filter data
  • Use a list of default functions in the SQL language
  • Create groupings of data
  • Create Sub Query´s
  • Select data from multiple tables using Joins

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

You do not need to have previous experience with SQL but we recommend that you show up in time on the day of the course, willing to learn, and we can promise you the best possible course experience.

Feel free to contact us on 33 14 71 44, undervisning@4d.dk or via our chat. We are looking forward to seeing you!

Course Details

Module-1: what is SQL

In this module, you will be introduced to basic theories about designing relational databases some history about RMDB and SQL language.
  • Basic database design
  • Primary key, Foreign key
  • What is SQL

Module-2: Retrieving data and sorting data

In this module, you will be introduced to the SELECT statement, and learn how to perform simple query´s against a relational database.
  • Use the SELECT statement
  • Retrieve all columns
  • Retrieve individual columns
  • Sort data
  • Sort data by multiple keys

Module-3: Filtering data

In this module, you will be introduced to do basic filtering of selected data.
  • The WHERE clause
  • =
  • IN
  • NOT
  • BETWEEN

Module-4: Filtering with Joker Characters

In this module, you will be introduced to filtering using patterns.
  • Like
  • %
  • ?
  • _

Module-5: Calculated Columns and functions

In this module, you will be introduced to how to create calculated columns. You will also meet some of the most commonly used Functions() in SQL. You will also be introduced to some more specific T-SQL functions() and a list of all the available T-SQL functions.
You will be introduced to working 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

In this module, we will introduce a special group of functions. Agregate- functions. Agregate functions are used to calculate pr. Column in a group of data.
  • Agregatefunctions
  • SUM, MAX, MIN, AVG
  • Using agregatefunctions
  • Grouping data
  • Filtering on Groups

Module-7: Sub-Query´s

In this module, you will be introduced to subqueries which on one hand can be very complex but on the other hand can be 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 using subqueries
  • Correlated embedded subqueries

Module-8: Join´s and combined queries

In this module, you will work with the concept of Normalized data and relational data, and be introduced to joins. The different types of joint will be covered and tested.
  • Join
  • What is combined queries
  • Inner join, 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, using SQL statements.
  • INSERT INTO
  • UPDATE
  • DELETE

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K