Sams teach yourself Transact-SQL in 21 days

Sams teach yourself Transact-SQL in 21 days

4.11 - 1251 ratings - Source

Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards Review variations from ANSI-standard SQL Be presented with basic server operations. Recognize performance issues with queries. This book will also include:Constructs such as CUBE, ROLLUP, CASE, and JOIN. Techniques to solve complex problems How the server uses indexes Methods to write (correctly) stored procedures and triggers. Templates of procedures and triggers (reference) Advanced Topics such as: Outer and self joins Temporary tables Sub-queries.Creating and Using Entity Relationship Diagrams (ERDs) An entity relationship diagram is a drawing that shows a set of tables in a ... In an ice-cream shop, the entities might include products, flavors, menu items, purchases, and workers.

Title:Sams teach yourself Transact-SQL in 21 days
Author:Lowell Mauer, David Solomons
Publisher:Sams Publishing - 2001-03-18


You Must CONTINUE and create a free account to access unlimited downloads & streaming