- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Acknowledgments
- Foreword
- Chapter 1: Getting Started
- Chapter 2: Exploring Database Concepts
- Chapter 3: Writing Simple SELECT Queries
- Chapter 4: Using Built-In Functions and Expressions
- Expressions Using Operators
- Using Mathematical Operators
- Using String Functions
- Nesting Functions
- Using Date and Time Functions
- Using Mathematical Functions
- Logical Functions and Expressions
- Administrative Functions
- Using Functions in the WHERE and ORDER BY Clauses
- The TOP Keyword
- Thinking About Performance
- Summary
- Answers to the Exercises
- Solutions to Exercise 4-1: Expressions Using Operators
- Solutions to Exercise 4-2: Using Mathematical Operators
- Solution to Exercise 4-3: Using Functions
- Solution to Exercise 4-4: Using Date and Time Functions
- Solution to Exercise 4-5: Using Mathematical Functions
- Solution to Exercise 4-6: Using Logical and System Functions
- Solution to Exercise 4-7: Using Functions in the WHERE and ORDER BY Clauses
- Chapter 5: Joining Tables
- Chapter 6: Building on Subqueries, Common Table Expressions, and Unions
- Chapter 7: Grouping and Summarizing Data
- Chapter 8: Discovering Windowing Functions
- What Is a Windowing Function?
- Ranking Functions
- Summarizing Results with Window Aggregates
- Defining the Window with Framing
- Calculating Running Totals
- Understanding the Difference Between ROWS and RANGE
- Using Window Analytic Functions
- Applying Windowing Functions
- Thinking About Performance
- Summary
- Answers to the Exercises
- Chapter 9: Advanced WHERE Clauses
- Chapter 10: Manipulating Data
- Inserting New Rows
- Adding One Row with Literal Values
- Avoiding Common Insert Errors
- Inserting Multiple Rows with One Statement
- Inserting Rows from Another Table
- Inserting Missing Rows
- Creating and Populating a Table in One Statement
- Inserting Rows into Tables with Default Column Values
- Inserting Rows into Tables with Automatically Populating Columns
- Deleting Rows
- Updating Existing Rows
- Thinking About Performance
- Summary
- Answers to the Exercises
- Inserting New Rows
- Chapter 11: Writing Advanced Queries
- Chapter 12: Understanding T-SQL Programming Logic
- Chapter 13: Managing Transactions
- Chapter 14: Implementing Logic in the Database
- Chapter 15: Working with XML
- Chapter 16: Expanding on Data Type Concepts
- Chapter 17: Running SQL Server in the Cloud
- Chapter 18: Where to Go Next?
- Index
Beginning T-SQL
Third Edition
Kathi Kellenberger
Scott Shaw
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.