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 youll 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 youll 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. Youll also learn how you can join the data together from multiple tables, efficiently including related data in the result sets.
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.