Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition
- Serie wydawnicze:
- Learn
- Wydawnictwo:
- Packt Publishing
- Ocena:
- Stron:
- 456
- Dostępne formaty:
-
PDFePub
Opis
książki
:
Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition
Starting with query processing fundamentals, the book lays a foundation for writing performant T-SQL queries. You’ll explore the mechanics of the Query Optimizer and Query Execution Plans, learning to analyze execution plans for insights into current performance and scalability. Using dynamic management views (DMVs) and dynamic management functions (DMFs), you’ll build diagnostic queries. The book covers indexing and delves into SQL Server’s built-in tools to expedite resolution of T-SQL query performance and scalability issues. Hands-on examples will guide you to avoid UDF pitfalls and understand features like predicate SARGability, Query Store, and Query Tuning Assistant.
By the end of this book, you‘ll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and avoid pitfalls
Wybrane bestsellery
-
T-SQL is an extension of the SQL language which allows you to tackle advanced querying and query-tuning challenges in SQL Server and Azure SQL Database. This book will be a perfect reference for you to write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis.-
- PDF + ePub + Mobi pkt
(29,90 zł najniższa cena z 30 dni)
152.10 zł
169.00 zł (-10%) -
-
Master essential data concepts and Azure services with this comprehensive guide packed with practical examples, exam tips, flashcards, and mock exams to prepare you to confidently take the DP-900 exam.-
- PDF + ePub pkt
(98,10 zł najniższa cena z 30 dni)
107.10 zł
119.00 zł (-10%) -
-
This book offers practical guidance on managing data as a product, drawing from real-world experience to empower you to implement your own data product-centric approach.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
A practical guide that will help you transform your data into actionable insights with Azure Synapse Analytics Key Features Explore the different features in the Azure Synapse Analytics workspace. Learn how to integrate Power BI and Data Governance capabilities with Azure Synapse Analytics. Accelerate your analytics journey with the no-code/low-co-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Unlock a world of job opportunities and accelerate your career growth by mastering MongoDB Key Features Master the fundamental principles of Schema Design, Querying, and Database Administration. Explore advanced topics, including Aggregation, Replication, and Sharding. Develop a fully functional application utilizing MongoDB Cloud Services. Descr-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A practical guide that will help you learn and leverage PostgreSQL's core features Key Features Acquire in-depth knowledge of PostgreSQL's key capabilities and gain a comprehensive understanding of its inner workings. Discover the art of extending PostgreSQL's core features and effectively troubleshooting any challenges that may arise. Explore the-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
A practical guide to using Spark SQL to perform complex queries on your Databricks data Key Features Learn SQL from the ground up, with no prior programming or SQL knowledge required. Progressively build your knowledge and skills, from basic data querying to complex analytics. Gain hands-on experience with SQL, covering all levels of knowledge fro-
- ePub + Mobi pkt
(76,49 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Achieve data engineering excellence with this comprehensive guide. Learn essential best practices, design patterns, and real-world use cases to architect robust, cost-effective data solutions in the cloud.-
- PDF + ePub pkt
Data Engineering Best Practices. Architect robust and cost-effective data solutions in the cloud era
(29,90 zł najniższa cena z 30 dni)
125.10 zł
139.00 zł (-10%) -
-
PowerShell Essentials - Your path to efficient automation and scripting Key Features Understand the concepts of .NET and PowerShell. Learn the basics of PowerShell, including the syntax, commands, and core concepts. Learn how to work with variables in PowerShell, including how to store data, perform arithmetic operations, and display data. Get fam-
- ePub + Mobi pkt
(38,90 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Analyze, Architect, and Innovate with Databricks Lakehouse Key Features Create a Lakehouse using Databricks, including ingestion from source to Bronze. Refinement of Bronze items to business-ready Silver items using incremental methods. Construct Gold items to service the needs of various business requirements. Description The Databricks Lakehous-
- ePub + Mobi pkt
(38,90 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
-
Navigating the Oracle landscape, mastering installation on OCI Compute Key Features Comprehend Oracle Database 21c installation, essential concepts, and advanced features. Focus on Oracle Cloud Infrastructure (OCI) Compute, to deploy databases in a cloud environment. Practical tips and best practices to optimize performance and troubleshoot effect-
- ePub + Mobi pkt
(38,90 zł najniższa cena z 30 dni)
80.91 zł
89.90 zł (-10%) -
Zobacz pozostałe książki z serii Learn
-
Expand your knowledge of C# and discover the capabilities of the Godot Engine by developing a first-person 3D adventure game. With the help of step-by-step instructions and explanations of the essential software development principles, you'll not only complete the book's project, but also be able to leverage this game engine for your own projects.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Polars excels in data analysis, surpassing Pandas in speed, featuring a robust API, and managing large datasets. This book covers basic to advanced Polars topics and helps you apply them to real business cases with step-by-step explanations.-
- pkt
Niedostępna
-
-
Whether you're building an indie game or working on a larger production, this book will equip you with the knowledge and skills needed to breathe life into your virtual worlds and become a master of Unity's animation capabilities.-
- pkt
Niedostępna
-
-
This book covers the most important software development techniques, libraries, and utilities unique to C++ that every C++ developer can use to refactor their code base. This will simplify development, enabling you to create performant apps.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
107.10 zł
119.00 zł (-10%) -
-
This RxJS book will help you understand the core concepts of RxJS and provide practical patterns to make your code more reactive and declarative. You'll also understand Angular Signals, which provide another way to improve code reactivity.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
98.10 zł
109.00 zł (-10%) -
-
This book will teach you how to leverage Open Horizon, and its commercial distribution - the IBM Edge Application Manager to manage your AI/ML workloads at scale and minimize the risks involved in edge projects.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
107.10 zł
119.00 zł (-10%) -
-
Big data demands scalable solutions. This book delves into graph-based algorithms in Python that tackle massive datasets. Using code examples, you’ll be able to leverage these techniques for big data analytics.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
116.10 zł
129.00 zł (-10%) -
-
Learn Ansible will teach you how to write Ansible Playbooks for deploying simple apps. This updated edition covers the latest Ansible features, helping you confidently implement Ansible in your daily workflows.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
116.10 zł
129.00 zł (-10%) -
-
Whether you're a beginner or experienced user, this book will help you master the frontend development aspects of Adobe Commerce, covering the essentials of theme customization and the art of creating bespoke e-commerce experiences.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
89.91 zł
99.90 zł (-10%) -
-
Gain an overview of Microsoft Fabric and designing and building analytics systems for various use cases, including lakehouses, data warehouses, real-time analytics, and data science, while also boosting developers' productivity through Copilot integration.-
- PDF + ePub pkt
(29,90 zł najniższa cena z 30 dni)
116.10 zł
129.00 zł (-10%) -
Szczegóły książki
- Tytuł oryginału:
- Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition
- ISBN Ebooka:
- 978-18-376-3683-9, 9781837636839
- Data wydania ebooka :
-
2024-02-29
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna
z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie.
Jeśli masz wątpliwości skontaktuj się z nami sklep@helion.pl.
- Język publikacji:
- 1
- Rozmiar pliku Pdf:
- 16.7MB
- Rozmiar pliku ePub:
- 36.6MB
- Zgłoś erratę
- Kategorie:
Bazy danych
Bazy danych » SQL Server
- Serie wydawnicze: Learn
Packt Publishing - inne książki
-
Developers with prior experience can leverage the latest modern Android development libraries to build exceptional Android apps. This book discusses crucial factors to consider when developing Android applications and how to maintain them better.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Maximize your Ubuntu 24.04 experience with this guide, covering desktop usage, security, and advanced development environments. You'll gain practical insights from the experience of a core Ubuntu developer for enhanced productivity and innovation.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
This book focuses on developing a capacity to manage cybersecurity incidents by practically implementing methodologies, platforms, and tools through step-by-step exercises. You'll learn how to respond to cybersecurity incidents using intelligence-based threat hunting techniques.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Master the realm of Cyber Threat Intelligence and Proactive Threat Hunting with 'Practical Threat Intelligence and Data-Driven Threat Hunting, 2nd edition'. This is your essential guide in the ever-evolving landscape of cyber threats.-
- ePub + Mobi pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Many intermediate users find advanced features in Clip Studio Paint challenging. This guide offers step-by-step tutorials and insider tips to master these tools, enhancing creativity and efficiency in digital art creation.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
The Power Platform Administration Guide addresses the most important topic in the enterprise space today: No Code/Low Code applications. Gone are the days of thousands of lines of code. Apps are now built by business users and citizen developers with point-and-click ease. If you want to know everything about Power Platform, this book is for you-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
This book is your ultimate guide to mastering Rust and advancing your software development career. It addresses the industry's demand for Rust programmers with insights into Rust's ecosystem, latest tools, and frameworks.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
This comprehensive guide to implementing CI/CD through tried and tested design patterns helps you discover the full potential of CI/CD through industry implemented CI/CD design patterns and improve robustness and resilience for CI/CD.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Defense Evasion Techniques is an exciting and important resource for security professionals and enthusiasts who want to stay ahead of the curve in the ever-evolving cybersecurity landscape. This book delves into defense evasion techniques used in red team operations and penetration testing, providing invaluable insights into how attackers bypass or avoid detection. By understanding and these cutting-edge tactics, readers will be better equipped to assess their existing security measures, identify areas for improvement, and ultimately strengthen their organization's security posture. Don't miss the opportunity to gain a competitive edge in the cybersecurity field by mastering the art of defense evasion.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
Linux for Networking Professionals Second Edition is your one-stop shop for everything Linux. From networking basics and configuration to diagnosis, troubleshooting, and security – this book is all you need to be successful with Linux.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@helion.pl
Książka drukowana
Oceny i opinie klientów: Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition Pedro Lopes, Pam Lahoud (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.