- 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
About the Authors
Kathi Kellenberger, known as Aunt Kathi to the SQL Server community, is a business intelligence consultant and a former DBA with 17 years of SQL Server experience. She loves writing, teaching, and speaking about SQL Server and will talk about SQL Server to just about anyone who will listen. Kathi talks about SQL Server so much that she received the MVP award for SQL Server in 2013. Kathi loves karaoke just about as much as SQL Server. Have you heard about all the karaoke parties after SQL Saturdays and at PASS Summit? Kathi and three friends started the first SQL karaoke event the week of PASS Summit in 2006. You can’t blame her for how big and crazy it has become, but you can blame her for getting karaoke started in the SQL Server community to begin with. There is one more thing that is very important to Kathi and that is family. Even though she goes by Aunt Kathi in the computing world, she is the proud mother of two and grandmother of four.
Scott Shaw has over a decade of experience in data management. Scott is a frequent speaker at local and national community events. He teaches Pig, Hive, Hadoop, SQL Server, and Microsoft BI-related courses. He is currently working on a book titled Practical Hive for Apress. He lives in St. Louis, Missouri, and is a solutions engineer for Hortonworks.
-
No Comment