Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Home > Data > Database Administration > Learn T-SQL Querying
Learn T-SQL Querying
Learn T-SQL Querying

Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code

Arrow left icon
Profile Icon Pedro Lopes Profile Icon Lahoud
Arrow right icon
€24.99 €35.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2 (9 Ratings)
eBook May 2019 484 pages 1st Edition
eBook
€24.99 €35.99
Paperback
€44.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Pedro Lopes Profile Icon Lahoud
Arrow right icon
€24.99 €35.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2 (9 Ratings)
eBook May 2019 484 pages 1st Edition
eBook
€24.99 €35.99
Paperback
€44.99
Subscription
Free Trial
Renews at €18.99p/m
eBook
€24.99 €35.99
Paperback
€44.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents Preview book icon Preview Book

Learn T-SQL Querying

Section 1: Query Processing Fundamentals

To understand how to write solid, performant T-SQL, users should know how SQL Server runs T-SQL syntax to deliver the intended result sets in a scalable fashion. This section introduces the reader to concepts that are used throughout the remaining sections of this book to explain most patterns and anti-patterns, as well as mitigation strategies.

The following chapters are included in this section:

Left arrow icon

Page 1 of 1

Right arrow icon
Download code icon Download Code

Key benefits

  • Discover T-SQL functionalities and services that help you interact with relational databases
  • Understand the roles, tasks, and responsibilities of a T-SQL developer
  • Explore solutions for carrying out database querying tasks, database administration, and troubleshooting

Description

Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL language used with Microsoft SQL Server and Azure SQL Database. This book will be a usefu to learning the art of writing efficient T-SQL code in modern SQL Server versions as well as the Azure SQL Database. The book will get you started with query processing fundamentals to help you write powerful, performant T-SQL queries. You will then focus on query execution plans and leverage them for troubleshooting. In later chapters, you will explain how to identify various T-SQL patterns and anti-patterns. This will help you analyze execution plans to gain insights into current performance, and determine whether or not a query is scalable. You will also build diagnostic queries using dynamic management views (DMVs) and dynamic management functions (DMFs) to address various challenges in T-SQL execution. Next, you will work with the built-in tools of SQL Server to shorten the time taken to address query performance and scalability issues. In the concluding chapters, this will guide you through implementing various features, such as Extended Events, Query Store, and Query Tuning Assistant, using hands-on examples. By the end of the book, you will have developed the skills to determine query performance bottlenecks, avoid pitfalls, and discover the anti-patterns in use.

Who is this book for?

This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues with the help of practical examples. Previous knowledge of T-SQL querying is not required to get started with this book.

What you will learn

  • Use Query Store to understand and easily change query performance
  • Recognize and eliminate bottlenecks that lead to slow performance
  • Deploy quick fixes and long-term solutions to improve query performance
  • Implement best practices to minimize performance risk using T-SQL
  • Achieve optimal performance by ensuring careful query and index design
  • Use the latest performance optimization features in SQL Server 2017 and SQL Server 2019
  • Protect query performance during upgrades to newer versions of SQL Server

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 03, 2019
Length: 484 pages
Edition : 1st
Language : English
ISBN-13 : 9781789342970
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Database Administration

What do you get with eBook?

Product feature icon Instant access to your Digital eBook purchase
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : May 03, 2019
Length: 484 pages
Edition : 1st
Language : English
ISBN-13 : 9781789342970
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Database Administration

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

SQL Server 2017 Developer???s Guide
SQL Server 2017 Developer???s Guide
Read more
Mar 2018 816 pages
Full star icon 3.6 (5)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €45.99
€24.99 €36.99
€45.99
Learn T-SQL Querying
Learn T-SQL Querying
Read more
May 2019 484 pages
Full star icon 4.2 (9)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €44.99
€24.99 €35.99
€44.99
SQL for Data Analytics
SQL for Data Analytics
Read more
Aug 2019 386 pages
Full star icon 3.5 (35)
eBook
eBook
  • eBook eBook €32.99
  • Paperback Paperback €59.99
€32.99 €47.99
€59.99
Stars icon
Total € 150.97
SQL Server 2017 Developer???s Guide
€45.99
Learn T-SQL Querying
€44.99
SQL for Data Analytics
€59.99
Total € 150.97 Stars icon
Banner background image

Table of Contents

17 Chapters
Section 1: Query Processing Fundamentals Chevron down icon Chevron up icon
Section 1: Query Processing Fundamentals
Anatomy of a Query Chevron down icon Chevron up icon
Anatomy of a Query
Building blocks of a T-SQL statement
Logical statement processing flow
Summary
Understanding Query Processing Chevron down icon Chevron up icon
Understanding Query Processing
Query compilation essentials
Query optimization essentials
Query execution essentials
Plan caching and reuse
The importance of parameters
Summary
Mechanics of the Query Optimizer Chevron down icon Chevron up icon
Mechanics of the Query Optimizer
Introducing the Cardinality Estimator
Understanding the query optimization workflow
Summary
Section 2: Dos and Donts of T-SQL Chevron down icon Chevron up icon
Section 2: Dos and Donts of T-SQL
Exploring Query Execution Plans Chevron down icon Chevron up icon
Exploring Query Execution Plans
Accessing a query plan
Navigating a query plan
Query plan operators of interest
Query plan properties of interest
Summary
Writing Elegant T-SQL Queries Chevron down icon Chevron up icon
Writing Elegant T-SQL Queries
Understanding predicate SARGability
Basic index guidelines
Best practices for T-SQL querying
Summary
Easily-Identified T-SQL Anti-Patterns Chevron down icon Chevron up icon
Easily-Identified T-SQL Anti-Patterns
The perils of SELECT *
Functions in our predicate
Deconstructing table-valued functions
Complex expressions
Optimizing OR logic
NULL means unknown
Fuzzy string matching
Inequality logic
EXECUTE versus sp_executesql
Composable logic
Summary
Discovering T-SQL Anti-Patterns in Depth Chevron down icon Chevron up icon
Discovering T-SQL Anti-Patterns in Depth
Implicit conversions
Avoiding unnecessary sort operations
Avoiding UDF pitfalls
Avoiding unnecessary overhead with stored procedures
Pitfalls of complex views
Pitfalls of correlated sub-queries
Properly storing intermediate results
Summary
Section 3: Assemble Your Query Troubleshooting Toolbox Chevron down icon Chevron up icon
Section 3: Assemble Your Query Troubleshooting Toolbox
Building Diagnostic Queries Using DMVs and DMFs Chevron down icon Chevron up icon
Building Diagnostic Queries Using DMVs and DMFs
Introducing Dynamic Management Views
Exploring query execution DMVs
Exploring query plan cache DMVs
Troubleshooting common scenarios with DMV queries
Summary
Building XEvent Profiler Traces Chevron down icon Chevron up icon
Building XEvent Profiler Traces
Introducing Extended Events
SQL Server Profiler – deprecated but not forgotten
Getting up and running with XEvent Profiler
Remote collection with PSSDiag and SQLDiag
Analyzing traces with RML Utilities
Summary
Comparative Analysis of Query Plans Chevron down icon Chevron up icon
Comparative Analysis of Query Plans
Query Plan Comparison
Query Plan Analyzer
Summary
Tracking Performance History with Query Store Chevron down icon Chevron up icon
Tracking Performance History with Query Store
The Query Store
Tracking expensive queries
Fixing regressed queries
Summary
Troubleshooting Live Queries Chevron down icon Chevron up icon
Troubleshooting Live Queries
Using Live Query Statistics
Understanding the need for Lightweight Profiling
Activity Monitor gets a new life
Summary
Managing Optimizer Changes with the Query Tuning Assistant Chevron down icon Chevron up icon
Managing Optimizer Changes with the Query Tuning Assistant
Understanding where QTA is needed
Understanding QTA fundamentals
Exploring the QTA workflow
Summary
Other Books You May Enjoy Chevron down icon Chevron up icon
Other Books You May Enjoy
Leave a review - let other readers know what you think

Recommendations for you

Left arrow icon
Coding with ChatGPT and Other LLMs
Coding with ChatGPT and Other LLMs
Read more
Nov 2024 304 pages
Paperback eBook
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook €18.99
  • Paperback Paperback €23.99
€18.99 €27.99
€23.99 €34.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €20.98
€15.99 €23.99
€20.98 €29.99
AI-Assisted Programming for Web and Machine Learning
AI-Assisted Programming for Web and Machine Learning
Read more
Aug 2024 602 pages
Full star icon 4.9 (9)
eBook
eBook
  • eBook eBook €19.99
  • Paperback Paperback €24.99
€19.99 €28.99
€24.99 €35.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook €24.99
  • Paperback Paperback €30.99
€24.99 €35.99
€30.99 €44.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €25.99
€20.98 €29.99
€25.99 €37.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook €22.99
  • Paperback Paperback €41.99
€22.99 €32.99
€41.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook €22.99
  • Paperback Paperback €40.99
€22.99 €32.99
€40.99
Hands-On Reinforcement Learning with Python
Hands-On Reinforcement Learning with Python
Read more
Jun 2018 318 pages
Full star icon 2.6 (18)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €29.99
€15.99 €23.99
€29.99
LLM Engineer's Handbook
LLM Engineer's Handbook
Read more
Oct 2024 522 pages
Full star icon 4.8 (13)
eBook
eBook
  • eBook eBook €43.99
  • Paperback Paperback €54.99
€43.99
€54.99
Right arrow icon

Customer reviews

Top Reviews
  • Top Reviews
  • Most Recent
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.2
(9 Ratings)
5 star 55.6%
4 star 33.3%
3 star 0%
2 star 0%
1 star 11.1%
Filter icon Filter
Top Reviews
  • Top Reviews
  • Most Recent

Filter reviews by

Brian Kelley Aug 09, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
First and foremost, this book lives up to its subtitle: developing efficient and elegant T-SQL code. There's a significant amount of information packed into its pages. For instance, great detail is given into reading an execution plan and breaking down all the information provided from the types of operations SQL Server is performing to the resources SQL Server is committing to execute the query. The authors have also provided information explaining how SQL Server's optimization engine has changed over the years and the reasons for that change. Part of that is explaining why some queries which perform well on older versions don't perform as well on the newer versions. That's important to know if you're performing migrations and upgrades.Another aspect of this book I like is the coverage of anti-patterns: typical T-SQL code we see that can tremendously impact performance negatively. However, the authors don't just say, "Stop it!" They also provide execution plans and explanations detailing WHY something performs poorly and should be considered an anti-pattern.Finally, the authors address a significant issue when it comes to query tuning: finding the queries performing badly over time. It's easy to locate poorly performing queries right now. SQL Server provides DMVs for just that purpose. But unless a DBA is monitoring the system 24x7, we need a way of capturing what's executing and how well it's executing. There's a chapter dedicated to just that: capturing the information over a period of time. Subsequent chapters cover how to break that information and compare the performance over time.This is definitely a book I'd recommend to anyone looking to improve their T-SQL writing skills. I've been working with SQL Server and writing queries for over 20 years and I found the authors cover information that I didn't know. As a previous reviewer (Brent Ozar) indicated, this isn't a book to teach you how to write queries. There are beginning SQL and T-SQL books for that. However, if you have at least that basic knowledge, this book will teach you how to write T-SQL queries better.
Amazon Verified review Amazon
Brent Ozar May 07, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
You've been writing queries for at least a year or two, and you're curious about what's happening under the hood when SQL Server runs a query. You want to know what you can do to improve your queries, tune your indexes, and change SQL Server's configuration settings so that your results will return faster.This book is for curious people like you. It is by no means a level 100, here's-how-to-write-a-query book. The first couple dozen pages act as if they're a gentle on-ramp to the parts of a query, but just jump past those to chapter 2, understanding query processing, and the authors start getting into how a query is optimized.Or if you're not quite so curious, and you just want faster queries, jump to chapter 6 and learn about anti-patterns.That is probably my only objection to the book - it seems just a little bit out of order, with some really challenging concepts coming before the easier parts about simple things you can do to make your queries go faster. That's easy to work around, however: just read the Table of Contents, find the parts that interest you, and hit those first. This is the kind of book that rewards repeated reading, and beyond that, rewards using the book's contents as a jumping-off point for additional learning. When I first read the Table of Contents, I wondered how the authors were going to cover so much ground in ~450 pages - and they did a great job striking a balance between giving you enough to get started, versus dragging you into the weeds with obscure internals details.Highly recommended for folks who want to start a curious journey into SQL Server query execution and tuning.
Amazon Verified review Amazon
David Mar 19, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Fantastic book, written by part of the SQL Server team. This covers more than just writing tSql queries; it provides a real insight into how the product processes your queries and why.
Amazon Verified review Amazon
Hilary Cotter Aug 27, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Lots of tips in this book and the explanations are very clear.
Amazon Verified review Amazon
Sergey Ten Feb 22, 2020
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This book stands out of the myriads of books written on the topic. This is not your ordinary T-SQL book that goes over a syntax and teaches you when to use WHERE and when - HAVING. In that aspect, the title is slightly misleading - the book goes much deeper than just "learn T-SQL querying". In fact, the book is on par with the "deep dive" volumes on the topic, and oftentimes goes even deeper - all without losing clarity and overwhelming readers with noisy details.The uniqueness of this volume is in the fact that it not only tells the reader to do "this" and not do "that", but goes on explaining _why_ you should be doing the former and not doing the latter. The authors actually captured respective SQL Server execution plans to illustrate what happens under the hood when you do "this" and when you do "that", so readers can see the _why_ with their own eyes. The number of scenarios covered is also quite plenty.From SQL parsing to query optimizing to actual execution, the authors guide the reader through all the stages of a query life cycle. I was especially impressed with the query optimization phase coverage, as this book provides you with the information no other book does - how the Query Optimizer rules work, and what kinds of "knobs" (query hints, trace flags) you can use to influence their internal workings. Once you build this kind of understanding, it enables you to see patterns in your own queries, "think" like SQL Server if you wish. And that thought process will make you well-rounded and much more versatile in writing queries that are efficient and scale well.
Amazon Verified review Amazon

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook €20.98
  • Paperback Paperback €37.99
€20.98 €29.99
€37.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook €15.99
  • Paperback Paperback €20.98
€15.99 €23.99
€20.98 €29.99
Right arrow icon

About the authors

Left arrow icon
Profile icon Pedro Lopes
Pedro Lopes
LinkedIn icon Github icon
Pedro Lopes is a Program Manager in the Database Systems group, based in Redmond, WA, USA. He has over 19 years of industry experience and has been with Microsoft for 9 years. He is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Relational Engine. He has extensive experience with query performance troubleshooting and is a regular speaker at numerous conferences such as SQLBits, PASS Summit, SQLIntersection, Microsoft Ignite, and Microsoft Build. He blogs about SQL on the SQL Server Team blog. He has authored several tools in the Tiger toolbox on GitHub: AdaptiveIndexDefrag maintenance solution, BPCheck, and usp_WhatsUp.
Read more
See other products by Pedro Lopes
Profile icon Lahoud
Lahoud
LinkedIn icon Github icon
Pam Lahoud is a Program Manager in the Database Systems group, based in Redmond, WA, USA. She has been with Microsoft for 13 years and is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer's perspective, throughout her career. She is a SQL Server 2008 Microsoft Certified Master (MCM) with over 20 years of experience working with SQL Server.
Read more
See other products by Lahoud
Right arrow icon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook? Chevron down icon Chevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website? Chevron down icon Chevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook? Chevron down icon Chevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support? Chevron down icon Chevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks? Chevron down icon Chevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook? Chevron down icon Chevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.