Microsoft SQL Server Basis - Schulung in Wien

You will learn to create SQL queries and calculations yourself.

Description

Through consistent further development From simple examples to complex solutions, the essential concepts of SQL are applied and deepened. You will also learn the most important SQL clauses and functions.

Target group

Beginners, specialist users, business analysts

Duration

1 day

Content in detail

Introduction and basics

• Working environment: Overview and setup
• SQL Server Management Studio: interface and functions
• T-SQL syntax: basic SQL commands

Basic SQL queries in the Data Query Language (DQL)

• SELECT clause: query data
• WHERE clause: filter data
• ORDER BY clause: Sorting data
• Practice: Creating simple queries

SQL functionalities and their applications

• Views: Creating and editing
• Data types: Common SQL data types
• Functions: Central SQL functions
• JOINs: Linking tables
• Practice: Queries with JOINs and Functions

Tips from the consultation

• Best practices: Efficient SQL use
• Performance tuning: optimization and indexing
• Avoid errors: common pitfalls
• Practice: Optimize sample queries

New: Book now as online training

On the mutually agreed training day, your trainer will contact you and first mirrors its screen onto 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 Kunz about this - by email kunz@atvisio.de or by phone 0631/4140140