Microsoft SQL Server für Fortgeschrittene - Schulung in Stuttgart

Learn how to take your SQL knowledge to an advanced level.

Description

After the training you are able to solve even more complex queries and problems with your data. You will also gain basic insights into the administration of relational databases.
A basic understanding of T-SQL is expected.

Target group

Advanced users, specialist users, business analysts

Duration

2 days

Content in detail

Advanced T-SQL programming

• CTEs (Common Table Expressions) and temporary tables
• Calculating with date values
• Table joins and subqueries
• Aggregate, quantifier & group functions (with performance tips)
• Execution order and optimization

Advanced SQL functionality

• Creating and editing views
• Functions (Scalar vs. Table-Valued) and performance
• Stored procedures and triggers

Query optimization

• Clustered vs. Non-clustered indexes: application and performance
• Analyzing and optimizing queries (JOIN strategies, Window Functions)

Database management

• Automated backup & restore
• Creation/expansion of tables
• Creation of primary/foreign keys
• User management and logins

Tips from the consultation

• ATVISIO “Best Practice”
• Avoidable errors in T-SQL and database administration (concrete case studies)

On the mutually agreed training days, your trainer will contact you and first mirror his 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 Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140