Introduction To Transact-SQL
WEBRip | English | MP4 | 960 x 540 | AVC ~328 kbps | 29.970 fps
AAC | 160 Kbps | 48.0 KHz | 2 channels | 4h 46mn | 923.9 MB
AAC | 160 Kbps | 48.0 KHz | 2 channels | 4h 46mn | 923.9 MB
Genre: Video Tutorial / Development, Programming
“ | Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database. Jeff Jones, an IT professional with over forty years of experience shows you how to use the tools available in Transact-SQL to discover the database definition, access tables, submit queries, and view the results. | ” |
Content:
Introduction
Welcome
1. Discovering the Database
Using SQL Server Management Studio (SSMS)
Identifying table relationships
SSMS diagram support
Preparing to write SQL
2. Accessing Tables
The basic SELECT statement
Combining two tables with a join
Combining multiple tables with a join
3. Filtering the Data
Filtering the data
Using functions
4. Displaying Data
Defining the result set
Manipulating numbers and data types
Using conditional column output
Controlling output rows
5. Aggregating Data
Grouping gata
also You can look my other last: Programming-posts
Screenshots
For more, Visit my AH-blog
download
Ly.Introduction.To.Transact-SQL.part1.rar
Ly.Introduction.To.Transact-SQL.part2.rar
Ly.Introduction.To.Transact-SQL.part3.rar
Ly.Introduction.To.Transact-SQL.part4.rar
Ly.Introduction.To.Transact-SQL.part5.rar
Ly.Introduction.To.Transact-SQL.part1.rar
Ly.Introduction.To.Transact-SQL.part2.rar
Ly.Introduction.To.Transact-SQL.part3.rar
Ly.Introduction.To.Transact-SQL.part4.rar
Ly.Introduction.To.Transact-SQL.part5.rar