We are happy to advise you!
+49 40 253346-10     Contact
> > > SQL04

SQL Server für .NET Applikationsentwickler (SQL04)

 

Course Overview

Become a full stack developer. This course teaches you the essential basics and skills that will help you as a .NET developer to build more stable, faster, and secure solutions using SQL Server.

Note: This text was automatically translated and may contain errors.

Who should attend

Application developers, .NET specialists and software developers

Prerequisites

Programming knowledge

Course Objectives

You know the basics of the various Windows databases and learn how to develop stable, secure applications in SQL Server 2019.

Follow On Courses

Course Content

Basics
  • Repetition of the database basics
  • Various database types and products
  • Database design
  • Software Architecture
  • NoSQL databases
SQL
  • Repetition interrogation techniques
  • Stored Procedures in TSQL und C#
  • SQL Server as .NET runtime environment
Database access techniques
  • Transactions
  • Entity Framework
  • Other OR/Mapper
Tooling
  • SQL Server Management Studio
  • Visual Studio / Data Tools
  • tips and tricks
  • ALM in applications (FTS)
Database
  • The main administrative points
  • DB interfaces (views, stored procedures, ...)
  • Data quality
  • Monitoring
  • Operation
Performance und Security
  • Performance measurements/analysis
Performance improvements
  • Indexe
  • Administratives
  • Query optimizations
  • Infrastructure Aspects
  • In-memory techniques
Brief introduction of new techniques in SQL Server 2019
  • Big Data
  • Data Science
  • AI
Classroom Training

Duration 3 days

Price (excl. tax)
  • Germany: 2,190.- €
  • Switzerland: CHF 2,670.-
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


 
Click on town name to book Schedule
Fast Lane will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
Germany

Currently no local training dates available.  For enquiries please write to info@flane.de.

International guaranteed dates
18/03/2020 ― 20/03/2020 Basel
18/03/2020 ― 20/03/2020 Bern
18/03/2020 ― 20/03/2020 Zurich
02/06/2020 ― 04/06/2020 Basel
02/06/2020 ― 04/06/2020 Bern
02/06/2020 ― 04/06/2020 Zurich
23/09/2020 ― 25/09/2020 Basel
23/09/2020 ― 25/09/2020 Bern
Switzerland
18/03/2020 ― 20/03/2020 Basel guaranteed date!
18/03/2020 ― 20/03/2020 Bern guaranteed date!
18/03/2020 ― 20/03/2020 Zurich guaranteed date!
02/06/2020 ― 04/06/2020 Basel guaranteed date!
02/06/2020 ― 04/06/2020 Bern guaranteed date!
02/06/2020 ― 04/06/2020 Zurich guaranteed date!
23/09/2020 ― 25/09/2020 Basel guaranteed date!
23/09/2020 ― 25/09/2020 Bern guaranteed date!