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

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

<p style="margin:0px;"> <i>Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes </i>offers straightforward, practical answers when you need fast results. By working through the book’s 30 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of Microsoft SQL Server’s T-SQL language.</p> <p style="margin:0px;"> <br> </p> <p style="margin:0px;">This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, <br> </p> <p style="margin:0px;">XML, JSON, and much more.</p> <p style="margin:0px;"> <br> </p> <p style="margin:0px;">Learn how to…</p> <ul> <li> <div style="margin: 0px;">Use T-SQL in the Microsoft SQL Server environment</div> </li> <li> <div style="margin: 0px;">Construct complex T-SQL statements using multiple clauses and operators</div> </li> <li> <div style="margin: 0px;">Filter data so you get the information you need quickly</div> </li> <li> <div style="margin: 0px;">Retrieve, sort, and format database contents</div> </li> <li> <div style="margin: 0px;">Join two or more related tables</div> </li> <li> <div style="margin: 0px;">Make SQL Server work for you with globalization and localization</div> </li> <li> <div style="margin: 0px;">Create subqueries to pinpoint your data</div> </li> <li> <div style="margin: 0px;">Automate your workload with triggers</div> </li> <li> <div style="margin: 0px;">Create and alter database tables</div> </li> <li> <div style="margin: 0px;">Work with views, stored procedures, and more</div> </li> </ul> <b>Contents at a Glance</b> <div> <div>   </div> <div>1 Understanding SQL</div> <div>2 Introducing SQL Server</div> <div>3 Working with SQL Server</div> <div>4 Retrieving Data</div> <div>5 Sorting Retrieved Data</div> <div>6 Filtering Data</div> <div>7 Advanced Data Filtering</div> <div>8 Using Wildcard Filtering</div> <div>9 Creating Calculated Fields</div> <div>10 Using Data Manipulation Functions</div> <div>11 Summarizing Data</div> <div>12 Grouping Data</div> <div>13 Working with Subqueries</div> <div>14 Joining Tables</div> <div>15 Creating Advanced Joins</div> <div>16 Combining Queries</div> <div>17 Full-Text Searching</div> <div>18 Inserting Data</div> <div>19 Updating and Deleting Data</div> <div>20 Creating and Manipulating Tables</div> <div>21 Using Views</div> <div>22 Programming with T-SQL</div> <div>23 Working with Stored Procedures</div> <div>24 Using Cursors</div> <div>25 Using Triggers</div> <div>26 Managing Transaction Processing</div> <div>27 Working with XML and JSON</div> <div>28 Globalization and Localization</div> <div>29 Managing Security</div> <div>30 Improving Performance</div> <div>A The Example Tables</div> <div>B T-SQL Statement Syntax</div> <div>C T-SQL Datatypes</div> <div>D T-SQL Reserved Words</div> <p style="margin:0px;"> </p> </div>