The SQL Superhero Program
This is a three step program, aimed primarily at people who either work in a data role, or are looking to make a career change into a data role where SQL is required.
For more details on who would benefit from this program, see the section entitled 'Who are these programs aimed at?' in the FAQs below.
Step 1 is SQL - the coding & programming language.
You will start from the very basic SELECT [fields] FROM [tables], but then dive deeply into the WHERE clause, date and time functions, aggregation and grouping, string handling including NULLs, numeric calculations, the CASE statement all the way up to some advanced programming using window functions, CTEs, temp tables, cross apply, views and plenty more.
Its a fully comprehensive program to teach you EVERYTHING you could ever need to know when using SQL and working with data.
Step 2 is about database design and development.
You might think it is odd that we consider this to be a pillar of SQL knowledge for data and reporting but if you have a thorough understanding of databases and how they are designed and built then you will be able to write much more efficient and effective SQL queries.
We will dig deeply into database design theory and learn about normalisation, constraints, indexing, primary and foreign keys and then how to build all these 'objects' in SQL code. We use case studies and practical examples to get a full understanding of the subject.
Then we get into user defined functions and stored procedures, and the importance of data integrity.
A lot of our past students have loved this part of the program so much they have ended up following careers as SQL Database Developers.
Step 3 is teaching you how to be a SQL multi-linguist.
We top it all off by teaching you how to do all the SQL programming across all the main relational database platforms - SQL Server (that's where we start), then MySQL, Oracle and Postgres.
If you can put THAT on your CV, you'll be way ahead of the crowd.
Frequently Asked Questions
Who are these programs aimed at?
Anyone working in data or looking to move into this line of work. By 'data' I mean data analysis, insight analysis, data science, data engineering, reporting , management information, business intelligence and loads more. Right at the very heart of all these careers is SQL.
Maybe you already have some SQL knowledge, or perhaps you have none at all. We help people who want to advance their SQL skills just as much as people who want to move into a career in SQL from something totally different.
How are these programs delivered?
A series of video tutorials, accessible via our website.
Weekly group coaching and mentoring sessions delivered via Zoom where you can bring any questions or queries to your SQL coach. You are welcome to join even if you don't have a specific question, and just be part of the community. These will be streamed on Facebook live meaning that you will be able to refer back to previous sessions.
You will also be able to have two or three one-to-one meetings with your coach as you move through the program (or more if you need them). The priority is making sure you get through the program, pick up the knowledge and get you to a place where you can use your skills to get ahead in your career.
How much does this cost?
This is a difficult one to answer because everything we do is bespoke, so until we speak to you we don't yet know what your needs are and what will be appropriate for you, but I'm sure we'll be able to find a suitable offer for you based on your needs. You'll need to book a call and this will really help you to see the situation you're in more clearly, and will help us learn more about you, and what is going to work best for you.
How do I enrol?
Well this program isn't for everyone, so as much as we need to make sure it is the right choice for you, we also need to make sure you are the right choice for us. We're quite picky about who we work with, making sure it is a good fit, and that this relationship is going to work for the benefit of both parties.
So you'll need to book a brief call with me in the first instance and we'll have a chat about you, your career and where you're heading, and if everyone's happy, we'll proceed.
What do you expect from your students?
Great question! I expect you to keep turning up, to engage with the program regularly (maybe two or three times per week), watching the videos, doing the challenges and exercises, attending the group coaching and mentoring sessions, and engaging with the community too.
Accountability is a key principal, and if you're holding yourself accountable to us and your fellow learners, as well as yourself, you are then far more likely to succeed.
And what can your student expect from you?
I'm going to teach you everything I have learned in twenty years working with SQL.
I'll even include the commands and programming techniques that I rarely use, because you need to know they exist and be able to understand them, but its mainly about the everyday commands and techniques - HOW to use certain commands, WHEN to use them, the benefits and drawbacks of certain approaches.
I'll get you ready for a career in SQL. I can't provide the work experience, but with plenty of real-world examples, plus some anecdotes from my own experiences, you should be ready for anything.
One of the key features of the program is problem solving, because how you approach a specific challenge is such a huge part of what will make you successful, so that's a key element we will come back to time and time again.
You'll get direct access to me through the group sessions, and the one-to-one sessions as well, and after you've completed the program, you'll still be able to hit me up for help if you ever get stuck. No promises here but I'll do my best to support you for as long as you need me.
What if it doesn't work out?
We offer a full money back guarantee.
Our philosophy is this: people come to us for a result, whether its to learn SQL from the start or to progress their existing SQL skills to an advanced level, and that aim is what we discuss when you book a call and sign up with us. That's why we don't just let you add programs to a shopping cart and check out on your own.
If you don't feel like you've got the result you set out to achieve, then we have no right to keep your money.
Part of our program involves regular check-ins with coaches to make sure you're hitting targets and keeping on task, and all this is to ensure that you DO reach that goal, but if we let you down, then you get your money back. Every penny of it.
What we expect of you is that you show up each week *, do the lessons, complete the challenges and let us know if you feel its not going as you had hoped.
This program is about YOU, not us. We will move heaven and earth to make sure you achieve the result you set out to achieve.
* obviously there are going to be weeks when you can't make it. We're not going to hold this against you, we just want to make sure you're committed to the program and doing your best. We promise we will too!
Other products we offer...
The Legend of BI is planned for launch in 2023 and is a fully comprehensive program to teach business intelligence skills
SQL, data warehousing, ETL and data reporting & visualisation.
Watch this space for more information.