Lynda - Querying Microsoft SQL Server 2012

English | Mar 31, 2014 | .MP4 | Audio: aac, 44100 Hz, mono | Video: h264, yuv420p, 1280x720, 15.00 fps(r) | 858 MB

Genre: E-learning

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

More Info