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: “Enter bigquery-public-data in the Type to Search field again and once it appears, Expand this project.”

A block of code is set as follows:

SELECT country_name, new_confirmed, date, cumulative_confirmed, population FROM `bigquery-public-data.covid19_open_data.covid19_open_data` LIMIT 10

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_name, MAX(cumulative_confirmed) AS TOTAL_CONFIRMED_COVID19
FROM `bigquery-public-data.covid19_open_data.covid19_open_data`
WHERE cumulative_confirmed > 0
GROUP BY country_name
ORDER BY MAX(cumulative_confirmed) DESC
LIMIT 5;

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: “To start, click Activate Cloud Shell from Google Cloud Console in the top-right corner.”

Tips or important notes

Appear like this.