BigQuery (a SQL database)

Question 1

Schema

Answer 1

Displays the column names in the dataset

Question 2

Details

Answer 2

Contains metadata like the creation date of the dataset

Question 3

Preview

Answer 3

Shows the first rows from the dataset

Question 4

BigQuery

Answer 4

a data warehouse on the Google Cloud Platform used to query and filter large datasets, aggregate results, and perform complex operations.

Question 5

SQL dialects

Answer 5

The different variations of SQL; vendors of SQL databases may use slightly different variations of SQL.

SQL platforms include, but are not limited to: SQLServer, MySQL, BigQuery, PostgreSQL, Vertica, etc.

Question 6

SQL platforms

Answer 6

Where you write and run SQL queries.

SQL platforms include, but are not limited to: SQLServer, MySQL, BigQuery, PostgreSQL, Vertica, etc.

NOTE: Not all SQL platforms provide native script editors to write SQL code. SQL text editors give you an interface where you can write your queries in an easier and color-coded way.

*If your SQL platform doesn’t have color coding, you may want to use a text editor like Sublime Text. (You have color coding and can get rid of all incorrect indents at one time as opposed to going line by line, etc.)

Question 7

Regular Expressions (regex)

Answer 7

Sequences of characters/a text string that will define a search pattern. They’re used to find, match, and manipulate text based on specific patterns rather than just exact matches.

For example, if you look for all email addresses in a text document, you might enter something like “.+\@.+..+”

Question 8

Data analysts share their work in a variety of formats, such as _____________

Answer 8

Data analysts share their work in a variety of formats, such as pdfs, html files, and R Markdown notebooks