SQL Advanced (conducted in English) kursus

Kursusmål

In this course you will learn how to use advanced T-SQL. Primarily you’ll learn to use the programming part, how to create advanced queries and handle transactions. Additionally, indexes are introduced where you learn about the different types of indexes.

After the course you’ll be able to handle the following tasks:
  • Work with variables and control structures
  • Create user defined functions
  • Create stored procedures with parameters
  • Make robust code using error handling
  • Work with transactions
  • Implement triggers
  • Implement index in tables and optimise code
  • Work with execution plans

In the section ”Course content” below you will find more details about the content of this course in SQL.

Deltagere

We strongly recommend that you participate in our SQL Experienced course before entering this course, or in other ways have achieved the expected knowledge about T-SQL and relational databases.
This SQL course is a part of 4D's collection of English conducted courses in the Business Intelligence category. It is meant for persons that wants to learn about the advanced options in Transact-SQL.

Kursusmateriale

Before the course
The option of talking to an instructor, that can assist in finding the right course for you.

During the course
  • Teaching by the most experienced instructor team in our cosy and fully updated classrooms located in the centre 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 encyclopaedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch at an Italian restaurant, cake, candy and off cause Wi-Fi to your devices.
  • A course diploma 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 – Variables and control structures

In this module you’ll learn to use variables and control structures in T-SQL. You’ll learn how to declare, initiate and use variables. You’ll learn to use the build-in control structures and how to use cursors is introduced. After this module you’ll have a good understanding of using programming in T-SQL.

The following topics are presented:
  • Declaring and using variables
  • Table variables
  • Control structures and code blocks
  • Introduction to cursors

Modul 2 – User defined functions

In this module you’ll learn to create user defined functions. You’ll learn to create scalar functions that resembles classic functions and you’ll learn to the use the more specialised, but very useful, table-values functions. After this module you’ll be able to solve complex cases by using user defined functions.

The following topics are presented:
  • Creating- and using scalar functions
  • Creating- and using table-valued functions
  • Advantages of functions

Modul 3 – Stored Procedures

In this module you’ll learn to use both simple stored procedures, but also stored procedures with input- and output parameters. You’ll learn the benefits and disadvantages of using stored procedures and you’ll learn to optimize your code.
After this module you an able to create and implement stored procedures. Also, you’ll have a good understanding of how to use them optimally.

The following topics are presented:
  • Creating stored procedures
  • Stored procedures and parameters
  • Optimizing stored procedures
  • Dynamic SQL

Modul 4 – Error handling in T-SQL code

In this module you’ll learn to implement robust code using error handling. You’ll learn different ways of implementing error handling in your code. Advantages/disadvantages using the different techniques are discussed. After the module you’ll be able to develop code taking care of errors in an appropriate way.

The following topics are presented:
  • Error handling with RAISERROR
  • Error handling with the @@ERROR variable
  • Error handling with TRY CATCH
  • Modern Error handling with THROW

Module 5 – Transactions

In this module you’ll learn how to handle transactions in a database. You’ll learn how to create user defined transactions and how to secure, that related updates are handled properly. After this module you’ll be able to manage updating data efficiently.

The following topics are presented:
  • Transactions and autocommit
  • User defined transactions
  • User defined transactions and error handling
  • User defined transactions best practice

Module 6 – Implementing Triggers

In this module you’ll learn how to implement DML triggers in tables and views. You’ll learn how to create triggers and implement advanced business logic. After this module you have obtained a decent knowledge of using triggers in databases.

The following topics are presented:
  • Insert trigger
  • Update trigger
  • Delete trigger
  • Instead Of trigger

Module 7 – Introduction to Index

In the module you’ll get an introduction to the classical types of indexes. You’ll learn the difference between a clustered and a non-clustered index. After this module you have obtained a basic knowledge about indexes and implementing them.

The following topics are presented:
  • Advantages and drawbacks to index
  • Clustered index
  • Non-clustered index
  • Covering index
  • Execution plans

Hvad siger vores kunder om os?

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

Se vores facebook Reviews

På Facebook har vi en score på 4,9 af 5 fordelt på 110 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
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 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

 
Amagertorv 21
1160 København K