Windows SQL Server - Administration

Description

Learning objectives

The training provides a sound and basic introduction to the world of database management systems (DBMS) with SQL Server 2016. After the training, you will be able to install, set up and administer Windows SQL Server in the essential areas. You will know how to set up BI projects with Analysis Services, Reporting Services or Integration Services.

More advanced topics, such as database design, writing Transact-SQL queries (T-SQL Queries) or Server Analysis Services are only touched upon, as these areas could be the subject of separate trainings, such as the training SQL Fundamentals and Database Design.

Intended audiences

• Database administrators upgrading from an older SQL Server version to SQL Server 2016
• Network administrators who are new to SQL Server administration
• Developers programming database applications for SQL Server

Recommended previous knowledge

• Previous experience in configuring and operating Windows server systems
• Basic knowledge of TCP/IP networking
• Knowledge regarding the construction of databases is helpful, but not mandatory

General information

Training details

• In-house training or in our training room (region Marburg, Hesse)
• Dates and duration: Flexible and depending on number of participants and previous knowledge
• Detailed training materials with a total of over 300 pages, incl. (German)
• Incl. access for the e-learning platform for the provision of electronic accompanying materials and e-learning content (German)

Proposed programme and training content (customisable).

SQL Server Basics

• Types of databases and field of application of SQL Server
• Installing the server and configuring database instances
• SQL Server Management Studio and SQL Server Data Tools
• SQLCMD, Windows PowerShell and other tools
• Manage system databases
• Manage databases, create database maintenance plans

Database design and Transact-SQL (T-SQL).

• Basic concept of relational databases
• Working with database objects
• Relationships between tables, indices, views and stored procedures
• Create and execute T-SQL scripts
• Deploy and use client applications

Server security

• The security concept
• Setting up login accounts and database access
• Manage permissions and roles
• Backing up and restoring data, developing and implementing a backup concept
• Set up replication and high availability

Error handling and performance tuning

• Perform error handling
• Use monitoring tools
• SQL server profiler, SQL statements analysis and database optimisation
• Using SQL Server Agent

Business Intelligence (BI)

• Server Integration Services: Data Export and Data Import
• Server Reporting Services: Design and publish reports
• Server Analysis Services: Design data source views and cubes
• Design Measure Groups