Inicio > > Bases de datos > Ultimate T-SQL for SQL Server Professionals
Ultimate T-SQL for SQL Server Professionals

Ultimate T-SQL for SQL Server Professionals

Alula Mekonnen Kassa

47,16 €
IVA incluido
Disponible
Editorial:
Orange Education Pvt Ltd
Año de edición:
2026
Materia
Bases de datos
ISBN:
9789349887893
47,16 €
IVA incluido
Disponible

Selecciona una librería:

  • Librería Samer Atenea
  • Kálamo Books
  • Librería Elías (Asturias)
  • Librería Kolima (Madrid)
  • Librería Proteo (Málaga)

Unlock the Power of T-SQL for Efficient Data ManagementBook DescriptionT-SQL is the backbone of Microsoft SQL Server, powering the queries, analytics, and enterprise systems that drive today’s data-driven world. Ultimate T-SQL for SQL Server Professionals takes you on a complete learning journey-from foundational query writing to advanced performance tuning and enterprise-level database development.You begin by building a strong core by understanding data types, mastering SELECT statements, filtering data with precision, and writing efficient joins and subqueries. From there, the book guides you into advanced territory-Common Table Expressions (CTEs), MERGE operations, PIVOT queries, dynamic SQL, and working with JSON and XML. You will learn how to analyze execution plans, leverage Query Store, and apply indexing and performance tuning strategies to optimize real-world workloads.What you will learn● Write efficient, production-ready T-SQL queries using advanced SELECT logic, joins, and subqueries.● Develop and manage views, stored procedures, functions, triggers, and table-valued functions.● Implement CTEs, MERGE, PIVOT, JSON, XML, and dynamic SQL for complex data transformations.● Analyze execution plans and apply performance tuning and indexing strategies.● Manage transactions, concurrency, and isolation levels in high-performance environments.● Secure, automate, and test SQL Server solutions for scalable, enterprise-grade systems.Table of Contents1. Getting Started with T-SQL2. Data Types, NULLs and Conversions3. SELECT Statements and Filtering Logic4. Joins, Set Operations, and Subqueries5. Views, Functions, and Stored Procedures6. CTEs, MERGE, Pivoting, JSON, and XML7. Dynamic SQL, Triggers, and Table-Valued Functions (TVFs)8. Query Optimization and Performance Tuning9. Execution Plans and Query Store10. Transactions, Concurrency, and Isolation Levels11. Automation with SSIS, SQL Agent, and PowerShell12. Azure SQL and Synapse Integration13. Security, Permissions, and Auditing14. Unit Testing T-SQL with tSQLt15. Case Studies and the Future of T-SQL16. Best Practices for T-SQL Development and Database Design       Index

Artículos relacionados

  • Mastering MongoDB 7.0 - Fourth Edition
    Arek Borucki / Leandro Domingues / Marko Aleksendrić
    Gain MongoDB expertise and discover advanced queries and Atlas insights with this ultimate guide to version 7.0Key FeaturesEnhance your proficiency in advanced queries, aggregation, and optimized indexing to achieve peak MongoDB performanceMonitor, back up, and integrate applications effortlessly with MongoDB AtlasImplement security thorough RBAC, auditing, and encryption to en...
  • Bases de datos en SQL server
    Darin Jairo Mosquera Palacios / Edwin Rivas Trujillo / Luis Felipe Wanumen Silva
    El diseño y la implementación de sistemas y la manipulación de bases de datos utilizan los lenguajes LDD (Lenguaje de Definición de Datos) y LMD (Lenguaje de Manipulación de Datos). Los autores ofrecen una obra que permita el uso de estos lenguajes a quienes están encargados de administrar sistemas informáticos y sus desarrolladores. El libro presenta una propuesta para modelar...
  • Practical MongoDB Aggregations
    Paul Done
    Begin your journey toward efficient data manipulation with this robust technical guide and enhance your aggregation skills while building efficient pipelines for a variety of tasksKey Features:Build effective aggregation pipelines for increased productivity and performanceSolve common data manipulation and analysis problems with the help of practical examplesLearn essential str...
  • Data Observability for Data Engineering
    Michele Pinto / Sammy El Khammal
    Discover actionable steps to maintain healthy data pipelines to promote data observability within your teams with this essential guide to elevating data engineering practicesKey FeaturesLearn how to monitor your data pipelines in a scalable wayApply real-life use cases and projects to gain hands-on experience in implementing data observabilityInstil trust in your pipelines amon...
    Disponible

    53,54 €

  • Redis Stack for Application Modernization
    Luigi Fugaro / Mirko Ortensi
    Discover the multi-model capabilities of Redis Stack as a document store and vector database, with support for time series, stream processing, probabilistic data structures, and moreKey FeaturesModel, index, and search data using JSON and vector data typesModernize your applications with vector similarity search, documents hybrid search, and moreConfigure a scalable, highly ava...
    Disponible

    54,72 €

  • Data Mining and Data Warehousing
    Parteek Bhatia
    ...
    Disponible

    140,25 €