Conventions used

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

Code in text: 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: “ User ID202 performed a query to create the customers.marketing table.”

A block of code is set as follows:

{"execution_timestamp":"2022-05-03;17:04:09", "user":{"ID202"}, query:"INSERT INTO `customers.marketing` SELECT NAME, EMAIL, AGE, IS_LOYAL, TOTAL_BASKET FROM `customers.info` INNER JOIN `customers.orders` ON customers.info.id = customers.orders.id"}

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

{"NAME":str, "EMAIL":str, "AGE":int, "IS_LOYAL": bool, "TOTAL_BASKET":double}

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “. For instance, page_visited has to contain only integer numbers.”

Tips or important notes

Appear like this.