Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes

0.0

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you need to know to take advantage of Microsoft SQL Server’s T-SQL language.For Sale in Indian subcontinent onlyFeaturesExpertauthor Ben Forta distills the essentials of T-SQL into a set of self-paced lessons in which the reader completes practice exercises designed to illustrate the most important aspects of setting up, using, and administering T-SQL . Long passages of text are replaced in this unique offering with succinct step-by-step instructions, carefully-crafted examples, and tightly-organized page layouts.ContentsUnderstanding SQL Introducing SQL Server Working with SQL Server Retrieving Data Sorting Retrieved Data Filtering Data Advanced Data Filtering Using Wildcard Filtering Creating Calculated Fields Using Data Manipulation Functions Summarizing Data Grouping Data Working with Subqueries Joining Tables Creating Advanced Joins Combining Queries Full-Text Searching Inserting Data Updating and Deleting Data Creating and Manipulating Tables Using Views Programming with T-SQL Working with Stored Procedures Using Cursors Using Triggers Managing Transaction Processing Working with XML Globalization and Localization Managing Security Improving Performance