MS SQL Server 2022 - Implementing a Microsoft SQL Server 2022 Database
Course Overview
| ID | 2101002 |
| Duration | 3.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | Bases MS SQL Server |
| Target group | DBAs, database developers |
| Vorgängerkurs | 2101001 |
Overview
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.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Description
Learn how to set up a database in MS SQL Server using T-SQL, program procedures, functions and triggers, and administer the database.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
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
Instructor
Marco Skulschus studied economics in Wuppertal and Paris with a focus on business informatics and has been working for over 10 years as a lecturer and developer for data warehouse and database solutions using MS SQL Server and the Microsoft BI Stack. He is also an author of specialist books and has participated in various research projects.
Publications
- MS SQL Server - T-SQL Abfragen und Analysen (Comelio Medien )
978-3-939701-93-4 - MS SQL Server - Implementierung, Administration und Programmierung mit T-SQL (Comelio Medien )
978-3-939701-71-2 - MS SQL Server 2014 - XML-Integration mit T-SQL (Comelio Medien )
978-3-939701-97-2 - SQL und relationale Datenbanken (Comelio Medien )
978-3-939701-52-1