SQL Server for .NET Application Developers (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.

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

Prices & Delivery methods

Online Training

Duration 3 days

Price (excl. tax)
  • 2,390.— €
Classroom Training

Duration 3 days

Price (excl. tax)
  • Germany: 2,390.— €
  • Switzerland: CHF 2,850.—

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

English

Time zone: Central European Summer Time (CEST)   ±1 hour

Online Training 2 days Time zone: Central European Time (CET)
Online Training Time zone: Central European Time (CET)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST)
Online Training Time zone: Central European Time (CET)
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Hamburg
Berlin
Frankfurt
Munich

Switzerland

Basel This is a FLEX course in German language. Time zone: Central European Time (CET)
Bern This is a FLEX course in German language. Time zone: Central European Time (CET)
Zurich This is a FLEX course in German language. Time zone: Central European Time (CET)
Basel This is a FLEX course in German language. Time zone: Central European Summer Time (CEST)
Bern This is a FLEX course in German language. Time zone: Central European Summer Time (CEST)
Zurich This is a FLEX course in German language. Time zone: Central European Summer Time (CEST)
Basel This is a FLEX course in German language. Time zone: Central European Summer Time (CEST)
Bern This is a FLEX course in German language. Time zone: Central European Summer Time (CEST)
+ show all dates

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.