SQL Live Coding Interview Guide
Hi BDEs!! ⚡️ Download my SQL Interview Cheat Sheet at the bottom, and check out Big SQL Energy 🔗— my intermediate SQL course packed with interview questions, portfolio project building, and experience on a realistic data model with a modern tech stack! You’ll also get access to the exclusive Big Data Energy Discord community to network, ask questions, and share resources.
Big SQL Energy
I finally launched my very own SQL course called Big SQL Energy (I mean DUH, what else would I call it?!) which is designed to prepare you for Data Analytics interviews whether you’re trying to get your first data job or want to level up to the senior level.
In this course, we’ll work together on some intermediate SQL, practice common SQL interview questions, and build a solid portfolio project (which is an exact replica of the one that has landed me my last 2 6-figure data analyst jobs in tech).
This isn’t a typical boring course where you pull random data and have no idea what you’re doing, leaving you ill-equipped for your job search. This course is based on real business problems I’ve solved on the job using a proprietary dataset (yes I typed every. single. cell with my bare hands) based on a typical SaaS tech company data model. No Titanic or Iris datasets will be found in my course.
We’ll also be using Hex Data Science notebooks and a Snowflake data warehouse, which let’s be honest, will look ✨ sexy ✨ on your resume.
So if you wanna learn:
Joins
CTEs
Subqueries
Window Functions
Set Operations (like union)
Self Joins
Case
Optimization
Temp Tables & Views
Who should take Big SQL Energy?
Current Data Analysts, Business Analysts, Data Scientists who want to level up their technical skills for a more technical role
Career transitioners who want to transition into a data role and have some basic data knowledge
Managers and leadership who want to understand more about what their team does and get hands-on experience
Students who don’t feel like their schooling has prepared them well for technical interviews or portfolio-building.
If you have any questions, EMAIL courses@bdeanalytics.com or message me on social media. Happy to help you make the most-informed choice for you.
SQL Interview Cheat Sheet:
