English | 11/19/2012 | mp4 | H264 800x600, 1024x768 | AAC 1 ch | 2 hr 6 min | 196 MB
eLearning | Level: Intermediate
This course will start with a quick overview of the history of SQL, then dive right into using T-SQL. You’ll learn about batches and scripts, how to declare and use variables—including the inevitable data type conversions—as well as the rich supply of operators available. Next you’ll learn about some of the many built-in T-SQL functions, for doing things like working with numbers, string manipulation, as well as global functions for getting state information. You’ll also learn about how to rank results using special functions and the OVER clause.
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.