Microsoft SQL Server kompakt- Schulung in Berlin

Learn how to access all the data in the company and prepare it optimally for your business intelligence application.

Description

Learn how to access all the data in the company and prepare it optimally for your business intelligence application. After the training, you will confidently work with the basic mechanisms of Microsoft SQL Server. You are able to obtain and change your data and also solve more complex queries and problems. You will also gain insights into the administration and security of relational databases.

Target group

Users, beginners in the MS SQL Server environment

Duration

3 days / €2,990 per person

Special conditions for in-house training on request. In-house training also in English.

Content in detail

Introduction and basics

• Relational database design (star schema)
• Introduction to the working environment
• SQL Server Management Studio: interface and functions

Basic SQL queries

• Structured Query Language (SQL)
• SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE TABLE, GRANT, REVOKE
• Data types in SQL
• Data Query Language (DQL): SELECT, WHERE
• Data Definition Language (DDL): CREATE TABLE, ALTER
• Data Manipulation Language (DML): INSERT, UPDATE, DELETE
• Data Control Language (DCL): GRANT, REVOKE

Advanced options in SQL queries

• Aliases and expressions with strings
• Calculation with date values
• WHERE clause and sorting via ORDER BY clause
• Table joins
• Working with group functions
• Subqueries and CTE (Common Table Expression)
• SET operators
• Restriction types

SQL functions and applications

• Field functions
• Creating and editing views
• Creating stored procedures
• Triggers

Database management

• Backup & restore of databases
• Creation/expansion of tables
• Creation of primary/foreign keys
• Creation of logins/users

ATVISIO consulting practice: "Best practice" and avoidable mistakes

New: Book online training now

On the mutually agreed training day, your trainer will contact you and first mirror his screen on your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your daily business.

For further information, call us.

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140