WK4 Query databases with SQL

Question 1

SQL

Answer 1

S-Q-L, stands for Structured Query Language. SQL is a programming language used to create, interact with, and request information from a database.

It can search through millions of data points to extract relevant rows of data using one query that takes seconds to run.

Question 2

Query

Answer 2

A query is a request for data from a database table or a combination of tables. Nearly all relational databases rely on some version of SQL to query data.

Question 3

Log

Answer 3

A log is a record of events that occur within an organization’s systems.

Question 4

SQL and being a security analyst

Answer 4

As a security analyst, you can use SQL’s filtering to find data to support security-related decisions and analyze when things may go wrong. For instance, you can identify what machines haven’t received the latest patch. This is important because patches are updates that help secure against attacks. As another example, you can use SQL to determine the best time to update a machine based on when it’s least used.