IT / Programming / Microsoft / MS SQL Server 2019 / T-SQL 2 - Implementing and Programming

MS SQL Server 2019 - T-SQL 2 - Implementing and Programming

Details

ID 2757644
Classroom 3 days
Webinar 5 days
Method Lecture with examples and exercises.
Prequisite Bases MS SQL Server
Audience DBAs, database developers

Services:

  • Lunch / Catering
  • Assistance for hotel / travel bookings
  • Comelio certificate
  • Flexible: Free cancellation up until 10 days before the training

Summary

This 3-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server. In this course, students learn the skills and best practices on how to use SQL Server product features and tools related to implementing a database server. This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries. After completing this course, students will be able to: a) Understand the product, its components, and basic configuration, b) Work with the data types supported by SQL Server, c) Design and implement tables and work with schemas / Design and implement views and partitioned views, f) Describe the concept of an index and determine the appropriate data type for indexes and composite index structures / Identify the appropriate table structures and implement clustered indexes and heaps, g) Describe and capture execution plans, h) Describe transactions, transaction isolation levels, or i) Design and implement scalar and table-valued functions, stored procedures, triggers.

Training Dates

  • 2020-Nov-09 - Nov-13
  • 2021-Jan-18 - Jan-22
  • 2021-Mar-29 - Apr-02
  • 2021-Jun-07 - Jun-11

850 EUR +VAT

Location | Enrollment


Agenda

Designing and Implementing Databases, Tables/Views and Files

Introduction to SQL Server Platform - Working with SQL Server Tools - Configuring SQL Server Services - Data Types: Using Data Types, Converting Data Types - Tables: Designing Tables, Working with Schemas, Creating and Altering Tables - Views: Introduction to Views, Creating and Managing Views, Performance Considerations for Views

Data Manipulation and Optimiziation/Tuning

Inserting, Updating, and Deleting Data - Execution Plan Core Concepts - Common Execution Plan Elements - Designing Effective (Non-)Clustered Indexes - Using the Database Engine Tuning Advisor

T-SQL Programming

Variables - Control Structure - Dynamic SQL - Transactions - Exceptions and T-SQL Error Handling - Cursors

Implementing Procedures and Functions

User-Defined Functions: Designing and Implementing Scalar Functions, Designing and Implementing Table-valued Functions - Introduction to Stored Procedures - Working With Stored Procedures - Implementing Parameterized Stored Procedures

Ensuring Data Integrity through Constraints and Triggers

Enforcing Data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity - Implementing DML Triggers

Security

SQL Server´s Security Concepts - Defining and Using Logins, Users and Rollen

Data Import/Export and Backup

Import Data using T-SQL – Backup and Recovery of Database and Data/Files

Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Publications
  • MS SQL Server - XML und SOAP-Webservices ISBN 978-3-939701-03-3
  • MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-02-6
  • SQL und relationale Datenbanken ISBN 978-3-939701-52-1
  • Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen ISBN 978-3-939701-23-1
  • System und Systematik von Fragebögen ISBN 978-3-939701-26-2
  • MS SQL Server - XML und SOAP-Webservices ISBN 978-3-939701-03-3
  • MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-02-6
  • SQL und relationale Datenbanken ISBN 978-3-939701-52-1
  • Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen ISBN 978-3-939701-23-1
  • System und Systematik von Fragebögen ISBN 978-3-939701-26-2
Projects

He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Research

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.