0 Comment

26 Sep Prepare for Exam Take our Microsoft SQL Server database course to learn about security, data management, and disaster. This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server This course is the foundation for all SQL Server-related disciplines; namely, The Querying Microsoft SQL Server Course prepare students for the .

Author: Arazshura Migar
Country: Czech Republic
Language: English (Spanish)
Genre: Career
Published (Last): 3 August 2015
Pages: 402
PDF File Size: 12.92 Mb
ePub File Size: 19.50 Mb
ISBN: 659-3-99882-515-8
Downloads: 71411
Price: Free* [*Free Regsitration Required]
Uploader: Dailrajas

You’ve reached the maximum number of courses 10 that can be added to a playlist. Content can be taken from any of our course oulines and customised to suit the exact requirmements of your group and scheduled on dates that suit your delegates.

10774 Querying Microsoft SQL Server 2012

Write queries that retrieve system metadata using system views and functions. Querying Multiple Tables Write queries using inner and multi-table joins Write queries using self and outer joins Skills Describe how multiple tables may be queried in a SELECT statement using joins Write queries which use inner or outer joins, and queries which use self-joins and cross joins top Module 6: For the optimal Microsoft Virtual Academy experience and to track your course progress, manage playlists, earn badges, and more, sign in with or create a personal Microsoft account.

This module provides a basic introduction to T-SQL programming concepts and objects. Basic knowledge of the Microsoft Windows operating system and its core functionality Basic understanding of virtualization technology Classroom labs utilize virtual machines. Your instructor should be able to provide a current list of Windows Azure enabled labs. Working knowledge of relational databases.


If you click Noyou microaoft be signed out courde the site and will lose any unsaved progress.

Describe batches and how they are handled by SQL Server. This type of training instils an element of confidence when people return to their desks to work with the New Interface or Application.

Write queries using character data types.

This module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. This module introduces the concepts of system resource usage and the performance impact of querying SQL Server The player is governed by this license.

Level 2 Word Pre-training evaluation – PFH will assess your training requirements and levels prior to attending training: Much of this functionality is new to SQL Server Instructor-led training serveg an effective means of delivering information, as it allows for real-time feedback, questions and answers, manipulation and changeable delivery to suit the needs of learners in a real-time environment.

This module introduces window functions including ranking, aggregate and 10747a functions.

Course List

Describe numeric data types, type precedence and type conversions. Provision a SQL Azure server and configure its security. Working knowledge of relational databases.

For more information, see terms of use and privacy policy. To continue on the Microsoft Virtual Academy site without accessing these personalized features, sign out of your current account. Microsofft transactions and the differences between batches and transactions. Create and manage transactions with transaction control language statements. Implementing a Desktop Infrastructure To rate this course please view the content first, then let us know what you think.


MOC A – Querying Microsoft SQL Server

I would like to hear from Microsoft about products, services, and events, including the latest solutions, tips, and exclusive offers. You can still watch videos, but event registration, profile changes, dashboard access, course progress tracking, and assessments are unavailable for a few hours. Write queries which use window functions to operate on a window of rows and return ranking, aggregation and offset comparison results.

Join now You are not signed in yet. Working with SQL Server Denali Data Types Describe numeric data types, type precedence and type conversions Write queries using character data types Write queries using date and time data types Module 7: Describe the language elements of T-SQL used for simple programming tasks.

Do you have Sofware Assurance Training Vouchers?

Using Built-In Functions Write queries which use conversion functions Write queries which use logical functions Write queries which test for nullability Skills Write queries with built-in scalar functions Use conversion functions Use logical functions Use functions that work with NULL top Module 8: