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.