SQL Associate
Query, join and aggregate without producing a number you cannot explain.
Add it to your LinkedIn profile with the insiderOne logo, verifiable by anyone.
What you will be able to do
- Design a small set of tables with keys and constraints that reject bad rows
- Write filters that handle NULL correctly and return the same rows every time
- Group and join tables without double counting, and find what is missing with an anti-join
- Break a hard question into CTEs and answer ranking and month-on-month questions with window functions
- Change live data inside a transaction, checking the row count before you commit
- Read a query plan and say whether an index can help
Students and freshers preparing for the SQL round of a data analyst or software internship, and anyone who can write SELECT but does not yet trust the numbers it returns.
What is in it
- 1Tables, keys and the shape of a database11 min
- 2SELECT, WHERE and the trouble with NULL12 min
- 3Aggregates, GROUP BY and HAVING11 min
- 4Joins, and the rows that go missing12 min
- 5Subqueries and CTEs11 min
- 6Window functions: ranks, running totals, month on month12 min
- 7Changing data safely11 min
- 8Indexes, and reading a query plan11 min
Month end at the Whitefield store
For each of the six questions, the SQL you wrote, the result it returns, and one or two sentences on what you checked or what the answer means, ending with a short note to the manager on what the dashboard got wrong.
About 125 minutes in total.
Two levels
Finish the units and the project and you get the Certificate of Completion. Pass the live skill challenge on SQL at Practitioner level or above and it becomes a Verified Certificate, which anyone you send it to can check for themselves.
Questions
What does it cost?
Nothing while insiderOne is in beta.
Can an employer check it?
Yes. Every certificate has its own page, and the code printed on it resolves there without anyone needing an account.
Do I need any experience?
No. These are written for students and people in their first job, and they assume nothing.
What do I actually walk away with?
The certificate, and the piece of work you made for the project. That goes into your insiderOne profile as a proof item, private until you choose to show it.
Know someone studying this?
It is free while insiderOne is in beta, and the certificate is checkable by anyone they send it to.