Kurs: SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A)

Pris: 22500,-Varighet: 5 dager

Aktuelle SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

Ingen planlagte kurs?
Vi har for tiden ingen planlagte kurs i SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A), men send oss en epost, eller ring oss på 32 20 09 90, så finner vi en løsning!

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. 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.


All the labs for this course can be performed using the provided virtual machines.  However, if you have a Microsoft Windows  Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom.  Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. Your instructor should be able to provide a current list of Windows Azure enabled labs. To acquire a trial Windows Azure account click here.
Audience Profile
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

Målsetting SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

After completing this course, students will be able to:
•Write SELECT Queries
•Query Multiple Tables
•Use Built-In Functions
•Use Subqueries
•Execute Stored Procedures
•Use Set Operators
•Implement Error Handling
•Implementing Transactions
•Use Table Expressions
•Sort and Filter Data
•Use Window Ranking, Offset and Aggregate Functions
•Query SQL Server Metadata
•Program with T-SQL
•Improve Query Performance

Forkunnskaper SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

Before attending this course, students must have:
•Working knowledge of relational databases.
•Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
•Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
To help you prepare for this class, review the following resources:


•Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure
•MCTS Self Paced Training Kit 70-461

Dokumentasjon SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

Microsoft Official Documentation.

Kursinnhold SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

Se link til originalkurs her.

Metodikk SQL Server 2012 - Querying Microsoft SQL Server 2012 (ref. kurs 10774A) kurs

Gateway tilbyr praktisk og virkelighetsnær opplæring.

I tillegg til å jobbe med kurs og opplæring, er våre instruktører også konsulenter som jobber med utvikling og problemløsninger i den aktuelle programvare. Dette betyr at instruktørene kjenner den praktiske bruk av programmet i ulike bedriftsmiljøer.

Vi har som oftest små grupper på kurs, slik at kursleder kan ta seg av hver enkelt. Alle deltakere får egen PC under kurset. Kursleder vil vise ulike teknikker på storskjerm, deltakerne vil deretter få oppgaver der de kan prøve ut disse teknikkene.