[mothered]

Damn....I was hoping to beat mothered's time. Oh well it's late.

I didn't expect a single error from you and you haven't let me down.

I use SQL on a daily basis, which probably explains the quicker completion time. The test should be a lot more difficult. It only covers the basics.

I haven't used straight SQL in a very long time. Used to be I was writing queries 5 hours a day every day, but after I started my own company I just use frameworks that do all that nonsense for me.

Given you haven't used raw SQL In quite a while, you've done well In the test.

I certainly understand your point with frameworks. As simple as queries are, they can be a headache at the best of times.

[phyrrus9]

I didn't expect a single error from you and you haven't let me down.

I use SQL on a daily basis, which probably explains the quicker completion time. The test should be a lot more difficult. It only covers the basics.

I haven't used straight SQL in a very long time. Used to be I was writing queries 5 hours a day every day, but after I started my own company I just use frameworks that do all that nonsense for me.

Given you haven't used raw SQL In quite a while, you've done well In the test.

I certainly understand your point with frameworks. As simple as queries are, they can be a headache at the best of times.

When I was doing that sort of work it was all for identity automation software. Implementing with skyward (you should look it up and see if you can find a db dump) is atrocious. I'm talking about having to join up and do aggregation on hundreds of tables just to get basic info about a student..

[mothered]

When I was doing that sort of work it was all for identity automation software. Implementing with skyward (you should look it up and see if you can find a db dump) is atrocious. I'm talking about having to join up and do aggregation on hundreds of tables just to get basic info about a student..

Sounds quite challenging, which suits me fine In the capacity of SQL.

I'll definitely have a look for a DB dump.

[Sikom]

I got 21 out of 25 => 84%

I have used MySQL quite a bit lately, which I think is the reason for that score. I did however have problems with some specific cases.
What I got wrong:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

Which SQL statement is used to return only different values?

What is the most common type of join?

Which operator is used to search for a specified pattern in a column?

I have never done anything related to it, so I understand why I didn't get them.

[Bish0pQ]

Though I could've done better, these are my results:

Spoiler:

Because I tried to answer the questions as quick as possible, I still made 2 stupid mistakes.

[phyrrus9]

I got 21 out of 25 => 84%

I have used MySQL quite a bit lately, which I think is the reason for that score. I did however have problems with some specific cases.
What I got wrong:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

Which SQL statement is used to return only different values?

What is the most common type of join?

Which operator is used to search for a specified pattern in a column?

I have never done anything related to it, so I understand why I didn't get them.

Those were all trick questions.... SQL uses old school terminology.

[mothered]

I got 21 out of 25 => 84%

I have used MySQL quite a bit lately, which I think is the reason for that score. I did however have problems with some specific cases.
What I got wrong:

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

Which SQL statement is used to return only different values?

What is the most common type of join?

Which operator is used to search for a specified pattern in a column?

I have never done anything related to it, so I understand why I didn't get them.

If you've never dealt with these, they can be confusing.

However those fluent In SQL, should well and truly get these right. They're very basic questions.

[drxddock]

I don't use SQL often. The only real thing I've used it for is setting up a webserver, but only with basic functions (register, login, but I plan to add more). Anyway, here's what I got.

Spoiler:

You can find my webserver framework mentioned in this post here.

[Pikami]

[mothered]

I was actually under the Impression you would've nailed It.

Still, a good score.