SPECIAL OFFER
Use code BACKTOLEARN during checkout to save 50% on books, eBooks, & videos. Shop now.
Register your product to gain access to bonus material or receive a coupon.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
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…
Download the sample pages (includes Chapter 3 and the Index).
Introduction
Who Is This Book For?
Companion Website
Conventions Used in This Book
1 Understanding SQL
Database Basics
What Is SQL?
Try It Yourself
2 Introducing SQL Server
What Is SQL Server?
Getting Started with SQL Server and T-SQL
Preparing for Your Lessons
3 Working with SQL Server
Making the Connection
Navigating SQL Server Management Studio
Creating the Example Tables
Selecting a Database
Learning About Databases and Tables
4 Retrieving Data
The SELECT Statement
Retrieving Individual Columns
Retrieving Multiple Columns
Retrieving All Columns
Retrieving Distinct Rows
Limiting Results
Using Fully Qualified Table Names
5 Sorting Retrieved Data
Sorting Data
Sorting by Multiple Columns
Specifying Sort Direction
6 Filtering Data
Using the WHERE Clause
The WHERE Clause Operators
7 Advanced Data Filtering
Combining WHERE Clauses
Using the IN Operator
Using the NOT Operator
8 Using Wildcard Filtering
Using the LIKE Operator
Tips for Using Wildcards
9 Creating Calculated Fields
Understanding Calculated Fields
Concatenating Fields
Performing Mathematical Calculations
10 Using Data Manipulation Functions
Understanding Functions
Using Functions
11 Summarizing Data
Using Aggregate Functions
Aggregates on Distinct Values
Combining Aggregate Functions
12 Grouping Data
Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering
13 Working with Subqueries
Understanding Subqueries
Filtering by Subquery
Using Subqueries as Calculated Fields
Checking for Existence with Subqueries
14 Joining Tables
Understanding Joins
Creating a Join
15 Creating Advanced Joins
Using Table Aliases
Using Different Join Types
Using Joins with Aggregate Functions
Using Joins and Join Conditions
16 Combining Queries
Understanding Combined Queries
Creating Combined Queries
17 Full-Text Searching
Understanding Full-Text Searching
Setting Up Full-Text Searching
Performing Full-Text Searches
18 Inserting Data
Understanding Data Insertion
Inserting Complete Rows
Inserting Multiple Rows
Inserting Retrieved Data
Reporting On Inserted Data
19 Updating and Deleting Data
Updating Data
Deleting Data
Reporting On Updated And Deleted Data
Guidelines for Updating and Deleting Data
20 Creating and Manipulating Tables
Creating Tables
Updating Tables
Deleting Tables
Renaming Tables
21 Using Views
Understanding Views
Using Views
22 Programming with T-SQL
Understanding T-SQL Programming
Using Variables
Using Conditional Processing
Grouping Statements
Using Looping
23 Working with Stored Procedures
Understanding Stored Procedures
Why Use Stored Procedures
Using Stored Procedures
24 Using Cursors
Understanding Cursors
Working with Cursors
25 Using Triggers
Understanding Triggers
Using Triggers
26 Managing Transaction Processing
Understanding Transaction Processing
Controlling Transactions
27 Working with XML and JSON
Using SQL Server XML Support
Using SQL Server JSON Support
Retrieving Data as JSON
The JSON Functions
28 Globalization and Localization
Understanding Character Sets and Collation Sequences
Working with Collation Sequences
Managing Case Sensitivity
Working with Unicode
29 Managing Security
Understanding Access Control
Managing Users
Managing Access Rights
30 Improving Performance
Improving Performance
Appendixes
A The Example Tables
B T-SQL Statement Syntax
C T-SQL Datatypes
D T-SQL Reserved Words
9780672337925, TOC, 11/18/2016