SCANBA Certificate holder photos
SQL for Data Analysis Certificate

Application form for the SCANBA Certificate

We successfully received your application for the SCANBA Certificate.

Please allow 10 business days to process your request.

If you have any questions on your application status,

please contact Olle Heineken (heineken@scanba.org),  

the SCANBA Online Education Manager.

Your first and last name as it will appear on the certificate:

The email address where the certificate should be sent:

To receive the certificate, you should answer at least 17 out of 20 questions correctly.

Question 1:

What process is usually described with the abbreviation ‘ETL’?

Your answer to question 1:

Question 2:

What command is not a data manipulation command in SQL?

Your answer to question 2:

Question 3:

What SQL command is used in Microsoft SQL Server to load data into a table from a flat file?

Your answer to question 3:

Question 4:

Is the following statement true or false?

"PRIMARY KEY cannot be set after a table is created."

Your answer to question 4:

Question 5:

Which command should be used to retrieve the first 10 rows from the table ‘MyData’?

Your answer to question 5:

Question 6:

Which command should be used to estimate the variance of the data in a dataset?

Your answer to question 6:

Question 7:

Is the following statement true or false?

"The Wildcard character is a special symbol that can stand for a certain range of characters."

Your answer to question 7:

Question 8:

Is the use of prefixes in column names a must?

Your answer to question 8:

Question 9:

Which statement is not a T-SQL command?

Your answer to question 9:

Question 10:

Which SQL command requires two tables to have the same number of columns to combine?

Your answer to question 10:

Question 11:

Can a view can be indexed in T-SQL?

Your answer to question 11:

Question 12:

What command is used to filter grouped results?

Your answer to question 12:

Question 13:

What SQL statement should be used to calculate the data average?

Your answer to question 13:

Question 14:

What SQL command cannot be used to convert variables from one data type to another?

Your answer to question 14:

Question 15:

What command can convert a concatenated string into the time format?

Your answer to question 15:

Question 16:

What is the function for generating ‘pi’?

Your answer to question 16:

Question 17:

Which variable is a system variable in Microsoft SQL Server?

Your answer to question 17:

Question 18:

Is this a ‘simple’ or ‘searched’ case?

SELECT CompanyName, TickerLength =

CASE LEN(Ticker)

WHEN 1 THEN '1 letter'

WHEN 2 THEN '2 letters'

END

FROM CompanyBySector

Your answer to question 18:

Question 19:

Can the ‘BEGIN END’ block be used inside loops?

Your answer to question 19:

Question 20:

Is the following statement true or false?

"Custom functions can be nested."

Your answer to question 20:

The application submission is a subject of 15 € processing fee. PayPal enabled checkout.