SCN GmbH

SQL Server Queries / T-SQL

Seminar / Training SQL Server Queries / T-SQL

SQL Server 2016 Basics - Architecture and Components - Tools - SQL Server Management Studio - Introduction to SQL Azure

Transact SQL query basics - Sets - Predicate logic - Logical order of operations in SELECT statements

SELECT queries - simple SELECT statements - eliminating duplicates with DISTINCT - using column and table aliases - writing simple CASE expressions - using JOINs - sorting and filtering data

Working with data types

Functions - Using conversion functions - Using logical functions - Using functions to test for nullability

Grouping and aggregating data - Using the GROUP BY clause - Filtering groups with the HAVING clause

Subqueries - Using scalar subqueries and subqueries with multiple results - Using the IN and EXISTS operators

Table expressions - Views - Using derived tables - Using common table expressions - Using table-valued inline expressions

Set operators - UNION set operators - UNION ALL multi-set operators - CROSS APPLY and OUTER APPLY -EXCEPT and INTERSECT operators

Window Rank, Offset and Aggregation Functions - Use of ROW_NUMBER, RANK, DENSE_RANK, NTILE - Use of LAG, LEAD, FIRST_VALUE, LAST_VALUE - Use of Window Aggregation Functions - Use of Basic Forms of Window Partitioning, Window Arrangement and Division into Windows

Pivoting and grouping sets - Using the PIVOT operator - GROUPING SETS subclause - GROUP BY ROLLUP - GROUP BY CUBE

SQL Server metadata - using system catalog views, stored system procedures, system functions and dynamic management objects

Stored procedures - EXECUTE statement - Parameter OUTPUT clause - Executing stored system procedures

Programming with T-SQL - Batches, variables, control of flow elements such as loops and conditions - Creating and executing dynamic SQL statements - Using synonyms

Error handling - Redirecting errors with TRY/CATCH - Creating error handling routines in a CATCH block with ERROR functions - Using THROW to return an error message to the client

Transactions - Benefits of using transactions - Controlling transactions with BEGIN, COMMIT, ROLLBACK - Error handling with transactions

Tuning queries - Using indexes - Execution plans in SQL Server Management Studio - Execution plans in SQL Server Management Studio - Differences between set-based and cursor-based operations

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

Your contacts

  • Promise Akachukwu Kelechi

    E-Mail:
    Phone: +234 1 227 9218

  • Peter Chidiebere Ugochukuw

    E-Mail:
    Phone: +234 1 227 9218

  • Raphael Chukuwgozie Ndubuisi

    E-Mail:
    Phone: +234 1 227 9218

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

Réservation


Das Seminar wurde auf die Merkliste gesetzt


Das von Ihnen gewählte Seminar wurde bereits auf die Merkliste gesetzt


Bitte wählen Sie einen freien Termin aus


Bitte geben Sie Ihren Wunschtermin im Format tt.mm.jjjj ein


Bitte wählen Sie einen freien Termin aus


Bitte geben Sie den gewünschten Termin im Format tt.mm.jjjj der Schulung ein

Duration 5 Days, approx. 6h/Day
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 1.179.610,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Choose a free date for Aba
















Duration 5 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 3.262.751,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Enter your preferred date for Aba



Duration 5 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 1.179.610,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Please select a free date