SCN GmbH

SQL Server 2022 Programming

Seminar / Training SQL Server Programming

Overview of MS SQL Server - Overview of MS SQL Server - MS SQL Server Integration - MS SQL Server Databases - MS SQL Server Security - Working with MS SQL Server

T-SQL program structures of MS SQL Server - Designing the application architecture of an organization - MS SQL Server programming tools - The Transact-SQL programming language - The individual elements of Transact-SQL - Additional language elements - Ways to execute Transact-SQL statements

MS SQL Server databases - Creating databases - File groups - Managing databases - Data structures

MS SQL Server tables - data types - tables - column values - script generation

MS SQL Server data integrity - data integrity types - enforcing data integrity - constraint types - disabling MS SQL Server constraints - default values and rules in MS SQL Server

MS SQL Server Indexes - Introduction of indexes - Index architecture of MS SQL Server - Management of index and heap structures by MS SQL Server - Selecting which columns are indexed

Working with indexes - Creating indexes - Working with CREATE INDEX options - Managing indexes - Statistics - sysindexes tables - Index optimization wizards - Performance aspects of MS SQL Server

MS SQL Server Views - Introduction - Benefits of views - Defining views - Modifying data using views - Optimizing performance using views

MS SQL Server Stored Procedures - Introduction - Creating, executing, modifying and deleting stored procedures - Parameter passing - Advanced stored procedures - MS SQL Server error reporting - Performance aspects

MS SQL Server Functions - User-defined functions in Microsoft SQL Server - Definition of user-defined functions in MS SQL Server

MS SQL Server Triggers - Introduction to Triggers - Definition of Triggers - How Triggers Work - Examples of Triggers

MS SQL Server Distributed data storage and partitions - distributed queries on MS SQL Server - ad hoc queries for a remote data source - connection server - query on a connection server - stored procedures on a connection server - distributed transactions - changing data on a connection server - partitioned views on MS SQL Server

MS SQL Optimizer - Introduction - Retrieving execution plan information - Using an index - Indexing strategies on MS SQL Server - Overriding a query optimizer

MS SQL Server Logical Operators - AND operator - OR operator - Queries with join operations

MS SQL Server Transactions - Introduction - Managing transactions on MS SQL Server - MS SQL Server locks - Managing locks

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