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: Meztikinos Dotaxe
Country: Antigua & Barbuda
Language: English (Spanish)
Genre: Spiritual
Published (Last): 8 April 2007
Pages: 226
PDF File Size: 16.76 Mb
ePub File Size: 13.73 Mb
ISBN: 970-1-65845-363-5
Downloads: 19422
Price: Free* [*Free Regsitration Required]
Uploader: Mozilkree

You submitted this rating on. Many of the labs in this course are enabled for you to perform the lab while connected to your microsort Windows Azure database in the cloud. Rate this course Your previous rating was successfully deleted.

Querying Microsoft SQL Server | New Horizons

This type of training instils an element of confidence when people return to their desks to work with the New Interface or Application.

Join now Maybe sqk. Add to your Playlist. Write queries which use common table expressions.

Querying Multiple Tables Describe how multiple tables may be queried in a SELECT statement using joins Write queries which use inner joins Write queries which use outer joins Write queries which use self-joins and cross joins Module 5: Thanks for being an MVA member! For this feature, sign back mcrosoft to Microsoft Virtual Academy. By copying or displaying this player, you agree to abide by this license. Previous Next Match whole word only. This module provides a basic introduction to T-SQL eql concepts and objects.


This module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. Transcript not available for this lesson. Describe the uses of queries which are nested within other queries.

I would like to hear from Microsoft about products, services, and events, including the latest solutions, tips, and exclusive offers.

Few educational opportunities are considered more valuable than meeting and interfacing directly with an instructor.

10774 Querying Microsoft SQL Server 2012

This module introduces the concepts of transaction management in SQL Server. Time Stamp Captions Download Transcript.

Write queries that use inner joins. You can still watch videos, but to take advantage of all of your member benefits, try again 2021 the upgrade is complete. Seminar Training is based solely on demonstrating the New Features and is non hands-on training.

Querying Microsoft SQL Server |

Write queries using character data types. This module explains the data types SQL Server uses to store data. To get unlimited queryiing to more of this great content, plus: Would you like us to sign you back in?


Write simple CASE expressions.

Course List

You can still watch videos, but event registration, profile changes, dashboard access, course progress tracking, and assessments are unavailable for a few hours. Querying SQL Server Metadata Write queries against system catalog views and functions Execute system stored procedures Identify and query system dynamic management objects Describe security permissions necessary to query system objects Module It introduces the many types of numeric and special-use data types.

Describe the benefits to using window functions.

Use functions that work with NULL. Implementing an Advanced Server Infrastructure Want to access course content? Working knowledge of relational databases. After completing this course, students will seerver able to: This module introduces T-SQL expressions which return a valid relational table, typically for further use in the query.

You submitted this rating recently.