Bücher online kaufen
|
| Der Artikel wird am Ende des Bestellprozesses zum Download zur Verfügung gestellt. |
Beginning T-SQL
A Step-by-Step Approach
Langbeschreibung
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 include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new in this edition is coverage of JSON from T-SQL, news about performance enhancements called Intelligent Query Processing, and an appendix on running SQL Server in a container on macOS or Linux.
Inhaltsverzeichnis
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.
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.
ISBN-13:
9781484266069
Veröffentl:
2020
Seiten:
706
Autor:
Kathi Kellenberger
eBook Typ:
PDF
eBook Format:
EPUB
Kopierschutz:
1 - PDF Watermark
Sprache:
Englisch
56,99 €*
Lieferzeit: Sofort lieferbar
Alle Preise inkl. MwSt.