SQL Skills Assessment and feedback

Complete this online assessment of your existing SQL skills and knowledge, and receive detailed feedback including recommendations on how you could improve.

This feedback will be in the form of a PDF with the opportunity to book a one-to-one discussion over Zoom for further advice and guidance.

There are twenty questions. Expect this to take 20-30 minutes to complete.

THIS PAGE IS CURRENTLY A WORK IN PROGRESS, AND THE ASSESSMENT IS NOT LIVE!

Question 1. Consider the following query

Which of these statements is true regarding a LEFT JOIN and an INNER JOIN such as the one shown above?

An INNER JOIN will generally show a higher number of results A LEFT JOIN will show all the rows from the table immediately following the FROM An INNER will show all the rows from the table immediately following the LEFT or INNER JOIN A LEFT JOIN always runs faster Don't know

2. Consider the following query

The result of running the above query is:

Runs successfully Fails because of a data type mismatch between forename and postcode Fails because of a data type mismatch between surname and created_date 2 and 3 Don't know

Submit your responses...

Name

Phone

Message

consent

I consent and agree to receive email communications. I understand I may update my preferences or opt-out of communications at any time using the unsubscribe link provided in all email communications.

The BI School by Nick Holt

Founded in 2022 by Nick Holt, The BI School offers a unique method for individuals and businesses to learn SQL.

Useful Links

Home
Login
About Us
SQL Training For Individuals
SQL Training For Businesses
Our Support
Blog

For SQL coding tips and advice
Updates and offers

Information about our products and services
Enter your details to give yourself a head start