Search (advanced search) | ||||
Use this Search form before posting, asking or make a new thread.
|
04-02-2014, 05:07 AM
Post: #1
|
|||
|
|||
Lynda - Querying Microsoft SQL Server 2012
[align=center]Querying Microsoft SQL Server 2012
Audio: aac, 44100 Hz, stereo | Video: h264, yuv420p, 1280x720, 29.97 fps 5h 35m | Beginner Mar 31, 2014 | Exercise Files | 858 MB[/center] Learn how to query data from SQL Server tables. Microsoft Certified Trainer Gerry O'Brien reviews the history of SQL and relational theory, so you'll understand exactly where this data manipulation language, and Microsoft's seminal database program, got their starts. Then he shows how to query one or many different tables using SELECT statements, and filter, group, and sort the results. Next, learn how to work with special data types like dates, times, and characters. Gerry also covers advanced topics like subqueries, programming with T-SQL (Microsoft's proprietary extension for SQL), and improving query performance. Topics include: Writing SELECT queries Querying multiple tables Filtering text and duplicates Sorting and grouping query results Using SQL Server's built-in functions Writing subqueries Using common table expressions Programming with T-SQL Interpreting query performance data Screenshots If get link die or problem with unrar file , send request to >>>[[[Reported by Members as URL Shortener! Post the actual link!]]]<<</124uJzh Use 7zip for unrar if you get "Max 260 character" error Password for Unrar : tut4dl Code: [b][Uploaded][/b] |
|||