+49 (911) 80 10 30

Give us a call or have us call you back!

Simply leave a message with your callback appointment

Your Name *

Your phone number *

Callback date *

Callback time *

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.

* All fields marked with an asterisk are mandatory fields.
Send a message

Your Name *

Your email *

Your phone number

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.*

* All fields marked with an asterisk are mandatory fields.
Social Media

Share page

DB310: SQL Server 2016/17/19 Programming with T-SQL

Training: Microsoft™ - Databases

Developers and administrators learn programming with Transact-SQL (T-SQL) for Microsoft™ SQL Server. The course covers database and table creation, complex SELECT queries with filters, aggregate functions and joins, data modifications with INSERT, UPDATE, DELETE, and MERGE, as well as variables, loops, views, procedures, and functions. Advanced topics include memory-optimized tables, columnstore indexes, and features from SQL Server 2017.

Appointment selection

Appointments in German language


Unfortunately there are currently no available appointments. Would you like to request an appointment? Then click on 'No matching appointment?'

Possible course languages: German

Request prefered appointment period:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* All fields marked with an asterisk are mandatory fields.

Unfortunately there are currently no available appointments.
Would you like to request an appointment? Then click on 'No matching appointment?'

Request prefered appointment period:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* All fields marked with an asterisk are mandatory fields.

Agenda:

Database and table creation
- CREATE DATABASE and CREATE TABLE statements
Basic query techniques
- Column selection in SELECT statement
- Using alias names
- Filtering records with the WHERE clause
- BETWEEN, IN and LIKE operators
- Logical operators
- Processing NULL values
- Sorting (ORDER BY)
System functions
- Aggregate functions (SUM, AVG, MAX, MIN, COUNT)
- Date-time functions
- String functions
- Conversion functions
Advanced query techniques
- Using subqueries
- Grouping (GROUP BY)
- Filtering groups (HAVING)
- Concatenating multiple queries (UNION)
- Multi-table queries (INNER-, OUTER-, CROSS JOIN)
Data modification statements
- INSERT, UPDATE, DELETE and MERGE
SQL programming
- Using variables
- Case distinctions and loops
- Creating views, procedures and user-defined functions
Advanced table creation options
- Memory-optimized tables
- System-compiled stored procedures
- Clustered columnstore indexes
- Temporary tables
- Indirect checkpoints
- New string functions in SQL Server 2017
Extensive Hands-on Practice

Objectives:

The participants of the course DB310 SQL Server 2016/17/19 Programming with T-SQL learn the programming of MS SQL 2016/17/19 Server using Microsoft™ T-SQL. This includes the necessary query techniques as well as the creation of database objects.

Target audience:

The workshop DB310 SQL Server 2016/17/19 Programming with T-SQL is targeted at:

Developers
Administrators

Prerequisites:

To be able to follow the learning pace and content of the training DB310 SQL Server 2016/17/19 Programming with T-SQL effectively, basic knowledge of relational databases is advantageous.

We recommend prior attendance of the training:

DB100 Oracle™ SQL

Description:

In the workshop DB310 SQL Server 2016/17/19 Programming with T-SQL, developers and administrators learn programming with the Transact-SQL language (T-SQL) for Microsoft™ SQL Server. The course covers fundamental and advanced query techniques, such as creating databases and tables, complex SELECT queries with filters, aggregate functions, and joins. Additionally, data modification commands (INSERT, UPDATE, DELETE, MERGE) and important programming concepts such as variables, loops, views, procedures, and user-defined functions are covered.

Advanced topics include memory-optimized tables, columnstore indexes, and new features from SQL Server 2017. The course is characterized by a high practical component and enables participants to effectively utilize SQL Server programming.