RE: SQL Test 04-05-2018, 09:52 AM
#12
(04-05-2018, 09:50 AM)mothered Wrote:(04-05-2018, 09:37 AM)phyrrus9 Wrote:(04-05-2018, 09:31 AM)mothered Wrote: 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..