20461: Querying Microsoft SQL Server (MOC20461)

Placeholder

20461: Querying Microsoft SQL Server (MOC20461)

 2.345,00

20461: Querying Microsoft SQL Server (MOC20461)

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Doel

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Doelgroep

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren?t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Voorkennis

This course requires that you meet the following prerequisites: ? Working knowledge of relational databases ? Basic knowledge of the Microsoft Windows operating system and its core functionality.

Vorm

Klassikaal en Maatwerk

Inhoud

In deze training worden de volgende onderwerpen behandeld:

Module 1: Introduction to Microsoft SQL Server 2014
Module 2: Introduction to T-SQL Querying
Module 3: Writing SELECT Queries
Module 4: Querying Multiple Tables
Module 5: Sorting and Filtering Data
Module 6: Working with SQL Server 2014 Data Types
Module 7: Using DML to Modify Data
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Executing Stored Procedures
Module 16: Programming with T-SQL
Module 17: Implementing Error Handling
Module 18: Implementing Transactions

Vervolgopleidingen

Deze training kan worden gebruikt ter voorbereiding op het examen:
70-461: Querying Microsoft SQL Server 2012

Bijzonderheden

Deze training kan worden gebruikt ter voorbereiding op het examen:
70-461: Querying Microsoft SQL Server 2012

5 dagen

€ 2.345

Cursusdata

Data op aanvraag

Andere data?

Locaties

Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

Andere locatie?

SKU: MOC20461 Categorieën: , , Tag:
Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.