Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "It went to the default CASE statement."

A block of code is set as follows:

/*Correlated query*/
SELECT Column1, Column2
FROM Table1 Tb1
WHERE Column1 IN 
(

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

/*Aggregate CASE*/
SELECT SUM(
 CASE WHEN department='IT' THEN) AS SAL_IT
SUM (

Any command-line input or output is written as follows:

tpareset -f testing the restart command

Bold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "JavaScript Object Notation (JSON) is a lightweight programming independent data interchange format."