Overview

Full Product Details

Author:   Kathi Kellenberger ,  Lee Everest
Publisher:   APress
Imprint:   APress
Edition:   4th ed.
Weight:   1.377kg
ISBN:  

9781484266052

ISBN 10:   1484266056
Pages:   706
Publication Date:   27 December 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

1. Getting Started 2. Exploring Database Concepts 3. Writing Simple SELECT Queries4. Using Built-In Functions and Expressions5. Joining Tables6. Building on Subqueries, Common Table Expressions, and Unions7. Grouping and Summarizing Data8. Discovering Windowing Functions9. Advanced WHERE Clauses10. Manipulating Data11. Managing Transactions12. Understanding T-SQL Programming Logic13. Implementing Logic in the Database 14. Expanding on Data Type Concepts15. Working with XML and JSON16. Writing Advanced Queries17. Where to Go Next?Appendix A: SQL Server for Linux and macOS Appendix B: Using SSMSAppendix C: SQL Notebooks

Reviews

Author Information

Kathi Kellenberger is an editor and DevOps advocate at Redgate Software and a Microsoft Data Platform MVP. She has been working with SQL Server for over 20 years, starting with version 6.5. She has worked as a developer, database administrator, and consultant. Kathi has been involved with almost 20 book projects as an author, co-author, or technical editor, and enjoys presenting at events, webinars, and user groups. When not working, she teaches T-SQL to beginners at a non-profit in St. Louis, Missouri that helps people transition to tech careers.   Lee Everest is a SQL Server developer who has worked with the product since version 6.5. He has taught part-time at Dallas College North Lake Campus for 18 years, and has had several students move on to companies such as Microsoft, filling roles from support engineer to data scientist to vice president. When Lee isn’t working, he enjoys computers, golf, and fishing.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions