SQL Advanced (conducted in English) kursus

You will learn

On this SQL advanced course, you will build on your existing SQL skills and learn how to work with advanced programming techniques in Transact-SQL (T-SQL).

The course focuses on the programming capabilities of SQL. You will learn how to create advanced and reusable database solutions using variables, user-defined functions, stored procedures, error handling, transactions, and triggers. You will also be introduced to indexes and execution plans, giving you a better understanding of how to improve the performance of your SQL code.

The course is designed for experienced SQL users who want to write more robust, efficient, and maintainable T-SQL solutions.

After the course, you will be able to:

• Work with variables and control structures in T-SQL.
• Create and use user-defined functions.
• Create stored procedures with input and output parameters.
• Write robust SQL code using structured error handling.
• Create and manage transactions.
• Implement triggers to automate database operations.
• Work with clustered, non-clustered, and covering indexes.
• Use execution plans to understand and optimise SQL queries.

You get

Before the course

• The opportunity to speak with an instructor who can help you determine whether SQL Advanced is the right course for your level.

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.
• Full catering including breakfast, freshly brewed coffee, tea, fruit, soft drinks, lunch at a nearby restaurant, cake and sweets.
• A course certificate documenting 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

SQL advanced is designed for experienced SQL users who want to learn about the advanced programming capabilities of Transact-SQL.

The course is particularly relevant if you work with databases, development, Business Intelligence, or other data-driven solutions and need to create more advanced, robust, and efficient SQL solutions.

We recommend that you have completed our SQL Experienced course or have equivalent knowledge of T-SQL and relational databases.

Course Details