CMIS Data Retrieval Exam

Why would a non-IT person learn how to retrieve data from databases

• to better structure your thoughts

• to develop new professional skills

• to become more autonomous in data analyses

• to better communicate with your IT people

What is SQL

a comprehensive database method developed especially for querying relation databases using a non-procedural approach (most used database retrieval method)

SELECT

selecting data fields you want to display in your report

FROM

table/file fields come from sorted by the company

WHERE

specify certain criteria

ORDER BY

sorting report by alpha or numerical order

What ends a SQL statement

semi-colon

Equal to

=

less than

<

greater than

>

greater than or equal to

>=

less than or equal to

<=

not equal to

!=

not equal to

<>

not greater than

!>

not less than

!<

Cyber attacks are a ______ problem

business

The total cost of a successful cyber attack is over __________ or __________ per employee

$8 million; $301

It takes an average ____ days to find and control a breach

280

Cyber security is _______ problem

everyone’s