Microsoft SQL Server kompakt - Schulung in Wien

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

Description

After the training, you will work secure 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

Content in detail

• Relational database design (star schema)
• SQL queries in SQL Management Studio
• Structured Query Language (SQL): SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE TABLE, GRANT, REVOKE
• Table joins
• Work with group functions
• Sub-queries
• Field functions
• Create and edit views
• Back up & restore databases
• Creation/expansion of tables
• Creation of registrations / users
• Automations via the integration services
• ATVISIO consulting practice: “Best practice” and avoidable errors

New: Book now as an online training

You can also book the training offered as an online training. The training is divided into 6 online training blocks. At the mutually agreed training times, 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, you can use the hours gained productively for your day-to-day business, you enjoy the advantages of individual training - and you are also very flexible when choosing a date.

For further information, call us.

Further information

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