Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses

Posted By: serpmolot
LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses

LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses
English | 11/26/2012 | mp4 | H264 800x600, 1024x768 | AAC 1 ch | 1 hr 38 min | 140 MB
eLearning | Level: Intermediate

In this course you’ll learn about the SELECT statement and its incredible flexibility when retrieving data from one or more database tables. You can shape the data you retrieve, and filter it using the WHERE clause. SQL Server rarely returns data in the order you want, so you can use the ORDER BY clause to sort it. Next you’ll learn some advanced ways to select data. With the GROUP BY clause, you can summarize the information in one or more tables, aggregating it various ways, if you wish. You’ll also learn how you can join the data together from multiple tables, efficiently including related data in the result sets.

Prerequisites
This course assumes that you have at least a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio. You should also have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes, and how to assign permissions on securable objects to principals.

Screenshots:

LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses

LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses

LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses

NO MIRRORS PLEASE

WANT MORE? VISIT MY BLOG!


LearnNowOnline - SQL Server 2012: T-SQL Select, Where, and Clauses