Login:  Password:    
forgot my password
sign up!
Search: 

E-learning-Transact-Sql-Lesson 02 | SQL courses

In this second lesson you will learn the importance of determine the amount of columns to return and how to create subqueries.

0 0
Course:   E-learning-Transact-Sql

OBS: download the application please visit www.mrbool.com/player

 

Title: E-learning-Transact-Sql-Lesson 02

 

Duration: 15:24 min


Summary:The query language that Microsoft Sql server uses is a variant of the ANSI-standard Structured Query Language, SQL. The SQL Server variant is called Transact-SQL. Database administrators and database developers must have a thorough knowledge of Transact-SQL  to read data from and write date to SQL Server databases. Using Transact SQL is the only way to work with the data. In this second lesson you will learn the importance of determine the amount of columns to return. How to create subqueries Use the CASE expression and the most common used aggregate functions of Sql Server.


Technologies Used: Sql Server 2005.


Keywords: Sql Server 2005.


Ruy Bentes Pimentel Neto
Ruy Bentes Pimentel Neto (ruy.pimentel@gmail.com) is a Senior Database Administrator, Dell Computers Employee, Hold MCDBA, MCSE+I Certifications. Experience of 10 years in Networking, Operational Systems and Database Administration.
Add your comment
[Fechar]

Este post é fechado - você precisa ter acesso ao post para incluir um comentário.


no comments have been posted - be the first!
Help us to improve! Give us your feedback:

Give your note to this post: 1 2 3 4 5 6 7 8 9 10
Is this post helpful? Yes No



[Close]
To have full access to this post (or download the associated files) you must have MrBool Credits.

  See the prices for this post in Mr.Bool Credits System below:

Individually – in this case the price for this post is US$ 2,00 (Buy it now)
in this case you will buy only this video by paying the full price with no discount.

Package of 10 credits - in this case the price for this post is US$ 1,00
This subscription is ideal if you want to download few videos. In this plan you will receive a discount of 50% in each video. Subscribe for this package!

Package of 50 credits – in this case the price for this post is US$ 0,33
This subscription is ideal if you want to download several videos. In this plan you will receive a discount of 83% in each video. Subscribe for this package!


> More info about MrBool Credits








mrbool.com
contact us   |   publish your post   |   buy credits
Copyright 2013 - all rights reserved to www.web-03.net