Preface

This heading explains the working of tasks or instructions that you have just completed.

You will also find some other learning aids in the book, including:

These are short multiple-choice questions intended to help you test your own understanding.

These practical challenges give you ideas for experimenting with what you have learned.

You will also find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: “We made a copy of the report 05_Adding_Groups.prpt and saved it with the name 15_Adding_Hyperlinks_Sparklines.prpt.”

A block of code is set as follows:

SELECT country.country_id, country.country, customer.first_name, customer.last_name, SUM(payment.amount) sum_amount, payment.customer_id
FROM payment 
INNER JOIN customer ON customer.customer_id=payment.customer_id
INNER JOIN address ON address.address_id=customer.address_id
INNER JOIN city ON city.city_id=address.city_id
INNER JOIN country ON country.country_id=city.country_id
WHERE country.country_id IN (20,24,29,34,48,67,74)
GROUP BY payment.customer_id
ORDER BY country.country, customer.first_name

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

SELECT country.country_id, country.country, customer.first_name, customer.last_name, SUM(payment.amount) sum_amount, payment.customer_id
FROM payment 
INNER JOIN customer ON customer.customer_id=payment.customer_id
INNER JOIN address ON address.address_id=customer.address_id
INNER JOIN city ON city.city_id=address.city_id
INNER JOIN country ON country.country_id=city.country_id
WHERE country.country_id IN (20,24,29,34,48,67,74)
GROUP BY payment.customer_id
ORDER BY country.country, customer.first_name

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: “On the Select Destination Location screen, click on Next to accept the default destination.”.

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded to our website, or added to any list of existing errata, under the Errata section of that title.

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at <copyright@packtpub.com> with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

You can contact us at <questions@packtpub.com> if you are having a problem with any aspect of the book, and we will do our best to address it.