- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes 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.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, XML, JSON, and much more.Learn how to...Use T-SQL in the Microsoft SQL Server environment Construct complex T-SQL statements using multiple clauses and operators Filter data so you get the information you need quickly Retrieve, sort, and format database contents Join two or more related tables Make SQL Server work for you with globalization and localization Create subqueries to pinpoint your data Automate your workload with triggers Create and alter database tables Work with views, stored procedures, and more Contents at a Glance 1 Understanding SQL 2 Introducing SQL Server 3 Working with SQL Server 4 Retrieving Data 5 Sorting Retrieved Data 6 Filtering Data 7 Advanced Data Filtering 8 Using Wildcard Filtering 9 Creating Calculated Fields 10 Using Data Manipulation Functions 11 Summarizing Data 12 Grouping Data 13 Working with Subqueries 14 Joining Tables 15 Creating Advanced Joins 16 Combining Queries 17 Full-Text Searching 18 Inserting Data 19 Updating and Deleting Data 20 Creating and Manipulating Tables 21 Using Views 22 Programming with T-SQL 23 Working with Stored Procedures 24 Using Cursors 25 Using Triggers 26 Managing Transaction Processing 27 Working with XML and JSON 28 Globalization and Localization 29 Managing Security 30 Improving Performance A The Example Tables B T-SQL Statement Syntax C T-SQL Datatypes D T-SQL Reserved Words
Contents
IntroductionWho Is This Book For?Companion WebsiteConventions Used in This Book1 Understanding SQLDatabase BasicsWhat Is SQL?Try It Yourself2 Introducing SQL ServerWhat Is SQL Server?Getting Started with SQL Server and T-SQLPreparing for Your Lessons3 Working with SQL ServerMaking the ConnectionNavigating SQL Server Management StudioCreating the Example TablesSelecting a DatabaseLearning About Databases and Tables4 Retrieving DataThe SELECT StatementRetrieving Individual ColumnsRetrieving Multiple ColumnsRetrieving All ColumnsRetrieving Distinct RowsLimiting ResultsUsing Fully Qualified Table Names5 Sorting Retrieved DataSorting DataSorting by Multiple ColumnsSpecifying Sort Direction6 Filtering DataUsing the WHERE ClauseThe WHERE Clause Operators7 Advanced Data FilteringCombining WHERE ClausesUsing the IN OperatorUsing the NOT Operator8 Using Wildcard FilteringUsing the LIKE OperatorTips for Using Wildcards9 Creating Calculated FieldsUnderstanding Calculated FieldsConcatenating FieldsPerforming Mathematical Calculations10 Using Data Manipulation FunctionsUnderstanding FunctionsUsing Functions11 Summarizing DataUsing Aggregate FunctionsAggregates on Distinct ValuesCombining Aggregate Functions12 Grouping DataUnderstanding Data GroupingCreating GroupsFiltering GroupsGrouping and SortingSELECT Clause Ordering13 Working with SubqueriesUnderstanding SubqueriesFiltering by SubqueryUsing Subqueries as Calculated FieldsChecking for Existence with Subqueries14 Joining TablesUnderstanding JoinsCreating a Join15 Creating Advanced JoinsUsing Table AliasesUsing Different Join TypesUsing Joins with Aggregate FunctionsUsing Joins and Join Conditions16 Combining QueriesUnderstanding Combined QueriesCreating Combined Queries17 Full-Text SearchingUnderstanding Full-Text SearchingSetting Up Full-Text SearchingPerforming Full-Text Searches18 Inserting DataUnderstanding Data InsertionInserting Complete RowsInserting Multiple RowsInserting Retrieved DataReporting On Inserted Data19 Updating and Deleting DataUpdating DataDeleting DataReporting On Updated And Deleted DataGuidelines for Updating and Deleting Data20 Creating and Manipulating TablesCreating TablesUpdating TablesDeleting TablesRenaming Tables21 Using ViewsUnderstanding ViewsUsing Views22 Programming with T-SQLUnderstanding T-SQL ProgrammingUsing VariablesUsing Conditional ProcessingGrouping StatementsUsing Looping23 Working with Stored ProceduresUnderstanding Stored ProceduresWhy Use Stored ProceduresUsing Stored Procedures24 Using CursorsUnderstanding CursorsWorking with Cursors25 Using TriggersUnderstanding TriggersUsing Triggers26 Managing Transaction ProcessingUnderstanding Transaction ProcessingControlling Transactions27 Working with XML and JSONUsing SQL Server XML SupportUsing SQL Server JSON SupportRetrieving Data as JSONThe JSON Functions28 Globalization and LocalizationUnderstanding Character Sets and Collation SequencesWorking with Collation SequencesManaging Case SensitivityWorking with Unicode29 Managing SecurityUnderstanding Access ControlManaging UsersManaging Access Rights30 Improving PerformanceImproving PerformanceAppendixesA The Example TablesB T-SQL Statement SyntaxC T-SQL DatatypesD T-SQL Reserved Words9780672337925, TOC, 11/18/2016
