SQL experienced (conducted in English) kursus

Kursusmål

This course is aimed at you, who wishes to use SQL in a larger context, or just want to know much more about the SQL language. By participating in this experienced SQL course, you will achieve a solid knowledge of the advanced possibilities when using Transact-SQL.

This course is for you, who wishes to use SQL in a larger context, or if you just want to know much more about the SQL language. By participating in this experienced SQL course, you will achieve a solid knowledge of the advanced possibilities when using Transact-SQL.

You will learn how to create new tables called temporary tables and views with SQL, which can will make your computing process much easier. You will also learn how to divide your SQL code into smaller and more manageable chunks.

Many of the tools you learn in this course are relevant if you want to use SQL with reporting services or other kind of tools. In short; to extract data to meet your complicated needs.

On the course, you will learn to

  • Create and alter tables and constraints
  • Create and work with temporary tables
  • Create and alter views
  • Work with build-in functions
  • Create and edit functions and stored procedures
  • Work with Common Table Expressions (CTE) and ranking functions
  • Use and create variables and control structures
In the section, ”Course Details” below, you will find more details about the content of this course in SQL.

Deltagere

We strongly recommend that you participate in our basic SQL course before entering this course, or in other ways have achieved the expected basic knowledge about T-SQL and relational databases.

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

Kursusmateriale

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

Kursusindhold

Module-1: Datatypes and related problems in SQL
The aim and purpose of this module is to focus on the different datatypes supported in T-SQL. We will focus on date and string types.

The following will be covered:
  • Date / Time
  • Strings

Module-2: Advanced SQL
Here you will be introduced to some advanced concepts in T-SQL.

The following will be covered:
  • Common table expression
  • Pivot and unpivot
  • Ranking functions

Module-3: Variables and programming
You will learn the different possibilities you have when programming in T-SQL.

The following will be covered:
  • Declaration of variables
  • Scope and lifetime
  • IF, ELSE - BEGIN, END
  • Error handling

Module-4: Temporary tables and table variables
In this module, we will introduce to use temporary tables to store selected data. We will also start using table variables and discus the pros and cons of these objects.

The following will be covered:
  • Creating temporary tables
  • Creating table variables

Module-5: Cursors
Here you will learn about the different types of cursors. When and where to use them. What

The following will be covered:]
  • Types of cursors you can have and the settings of cursors

Module-6: Dynamic SQL
We will look upon Dynamic SQL, which is often used in Stored procedures.

The following will be covered:
  • Creating Store procedures
  • Using the EXEC command

Module-7: Introduction to views
In this module, you will to use views. What is a view and why would you use a view? Creating views to select, insert, update data and create views to validate data.

The following will be covered:
  • Create / edit / drop view
  • Update with a view
  • View options

Module-8: Introduction to functions
We will introduce you to user defined functions. How do you create your own function and how do you use it afterwards?

The following will be covered:
  • Create / alter / drop function
  • Scalar functions
  • Table functions

Module-9: Introduction to stored procedures
In this module, you will be presented to stored procedures. Stored procedures are a very important objects on a Microsoft SQL Server. You will be working with stored procedures taking input parameters and returning output.

The following will be covered:
  • Create / alter / drop stored procedure
  • Stored procedures with parameters
  • Output

Module-10: Transactions
The purpose of this module is to learn you about transactions. Transactions are one of the important tools to ensure that data in your database are valid. If errors occur you will be able to roll back all the actions, you tried to perform.

The following will be covered:
  • Transactions
  • Savepoints
  • Commit / rollback

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
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K