IT / Programming / Microsoft / MS SQL Server 2019 / T-SQL 2 - Implementing and Programming
| ID | 2757644 |
|---|---|
| Classroom | 3 days 9:00-16:30 |
| Webinar | 5 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | Bases MS SQL Server |
| Audience | DBAs, database developers |
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.
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
Inserting, Updating, and Deleting Data - Execution Plan Core Concepts - Common Execution Plan Elements - Designing Effective (Non-)Clustered Indexes - Using the Database Engine Tuning Advisor
Variables - Control Structure - Dynamic SQL - Transactions - Exceptions and T-SQL Error Handling - Cursors
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
Enforcing Data Integrity - Implementing Domain Integrity - Implementing Entity and Referential Integrity - Implementing DML Triggers
SQL Server´s Security Concepts - Defining and Using Logins, Users and Rollen
Import Data using T-SQL – Backup and Recovery of Database and Data/Files
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.
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.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
