Beginning T-SQL : a step-by-step approach

Beginning T-SQL a step-by-step approach

Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now...

Full description

Bibliographic Details
Other Authors: Kellenberger, Kathi, author (author), Everest, Lee, author
Format: eBook
Language:Inglés
Published: Berkeley, California : Apress [2021]
Edition:Fourth edition
Subjects:
Database management.
Microsoft .NET Framework.
Microsoft software.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631318106719
Table of Contents:
  • 1. Getting Started
  • 2. Exploring Database Concepts
  • 3. Writing Simple SELECT Queries
  • 4. Using Built-In Functions and Expressions
  • 5. Joining Tables
  • 6. Building on Subqueries, Common Table Expressions, and Unions
  • 7. Grouping and Summarizing Data
  • 8. Discovering Windowing Functions
  • 9. Advanced WHERE Clauses
  • 10. Manipulating Data
  • 11. Managing Transactions
  • 12. Understanding T-SQL Programming Logic
  • 13. Implementing Logic in the Database
  • 14. Expanding on Data Type Concepts
  • 15. Working with XML and JSON
  • 16. Writing Advanced Queries
  • 17.Where to Go Next?
  • Appendix A: SQL Server for Linux and macOS
  • Appendix B: Using SSMS
  • Appendix C: SQL Notebooks.

Similar Items