We are happy to advise you!
+386 1 320 78 80     Contact

SQL Server for .NET Application Developers (SQL04)

 

Course Overview

Want to 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 more 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

After taking this course, you will 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 and 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
Online Training
Modality: L

Duration 3 days

Classroom Training
Modality: C

Duration 3 days

 

Schedule

German
Time zone Central European Summer Time (CEST)
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.