Learn SQL for the 
Real World & 
Advance Your Career
Enroll in the most comprehensive and interactive SQL course on the market. Gain instant access to hours of instructional videos and hundreds of challenges covering everything from the basics to expert level techniques that top analysts use to help grow million dollar companies.
Hi I'm         
Jeremy Jackson
 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas porta orci ut nisi laoreet, eget hendrerit nisi sagittis. Nam rutrum, arcu vel pellentesque interdum, risus est sodales purus, sit amet congue felis felis non metus. Aliquam nunc ante, venenatis facilisis scelerisque in, vehicula sit amet mauris. Curabitur tempor ullamcorper porta. Quisque et massa in massa ullamcorpe .

 Consectetur id vel elit. Etiam eleifend urna ac mauris sollicitudin, eget porta enim fringilla. Morbi ultricies orci a bibendum varius. Nulla facilisi. Aenean sagittis pharetra augue, quis viverra leo fermentum consectetur. Pellentesque viverra dui vitae nisl blandit eleifend. Nam laoreet semper felis at luctus. Quisque eget commodo magna.

 Maecenas consequat quis magna pellentesque tincidunt. Suspendisse potenti. Quisque lacus sapien, suscipit a malesuada et, laoreet et eros. Mauris malesuada aliquet odio, in vulputate magna commodo sed. Phasellus non pretium elit. 
Learn SQL for the 
Real World &
Advance Your Career
Enroll in the most comprehensive and interactive SQL course on the market. Gain instant access to hours of instructional videos and hundreds of challenges covering everything from the basics to expert level techniques that top analysts use to help grow million dollar companies.
Hi I'm         
Jeremy Jackson
 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas porta orci ut nisi laoreet, eget hendrerit nisi sagittis. Nam rutrum, arcu vel pellentesque interdum, risus est sodales purus, sit amet congue felis felis non metus. Aliquam nunc ante, venenatis facilisis scelerisque in, vehicula sit amet mauris. Curabitur tempor ullamcorper porta. Quisque et massa in massa ullamcorpe .

 Consectetur id vel elit. Etiam eleifend urna ac mauris sollicitudin, eget porta enim fringilla. Morbi ultricies orci a bibendum varius. Nulla facilisi. Aenean sagittis pharetra augue, quis viverra leo fermentum consectetur. Pellentesque viverra dui vitae nisl blandit eleifend. Nam laoreet semper felis at luctus. Quisque eget commodo magna.

 Maecenas consequat quis magna pellentesque tincidunt. Suspendisse potenti. Quisque lacus sapien, suscipit a malesuada et, laoreet et eros. Mauris malesuada aliquet odio, in vulputate magna commodo sed. Phasellus non pretium elit. 
"The SQL techniques that Jason helped me learn prepared me for my current Data Analytics position. The 'no-frills' approach and focus on situations I might see in real life allowed me to crush my interview and hit the ground running once I started."
Maggie Adams
Data Analyst @ The New York Times
"The SQL techniques that Jason helped me learn prepared me for my current Data Analytics position. The 'no-frills' approach and focus on situations I might see in real life allowed me to crush my interview and hit the ground running once I started.
Maggie Adams
Data Analyst @ The New York Times
You Don't Have To Be Technical To Learn SQL
Let's face it...learning a coding language sounds overwhelming. Especially if you're a complete beginner...

I encounter people all the time who want to learn SQL so they don't have to keep asking others for reports, or Excel just isn't cutting it for them, or they want to add a skill to their resume and make more money. And almost all of them are intimidated at the task of learning a coding language.

But SQL is probably the easiest coding language to learn...if you have the right strategy. I've perfected the right strategy for learning SQL through thousands of hours of using it myself and teaching it to others.
I'm Here To Help You Win
Everyone needs a coach and mentor. 

When I first started out trying to learn SQL, I didn't seek out any help whatsoever. I tried to do everything myself -- slogging through tutorials, Youtube videos, blog posts, everything. It ended up costing me a lot of wasted time and frustration before I learned what I needed to.

I have a personal stake in the success of all my students so the same thing won't happen to you.
You Don't Have To Be Technical To Learn SQL
Let's face it...learning a coding language sounds overwhelming. Especially if you're a complete beginner...

I encounter people all the time who want to learn SQL so they don't have to keep asking others for reports, or Excel just isn't cutting it for them, or they want to add a skill to their resume and make more money. And almost all of them are intimidated at the task of learning a coding language.

But SQL is probably the easiest coding language to learn...if you have the right strategy. I've perfected the right strategy for learning SQL through thousands of hours of using it myself and teaching it to others.
I'm Here To Help You Win
Everyone needs a coach and mentor. 

When I first started out trying to learn SQL, I didn't seek out any help whatsoever. I tried to do everything myself -- slogging through tutorials, Youtube videos, blog posts, everything. It ended up costing me a lot of wasted time and frustration before I learned what I needed to.

I have a personal stake in the success of all my students so the same thing won't happen to you.
You're In Great Company
WHERE MY STUDENTS HAVE GOTTEN JOBS
You're In Great Company
WHERE MY STUDENTS HAVE GOTTEN JOBS...
START LEARNING AND USING SQL TODAY!
Join The 1000's of Professionals Who Have Leveled Up By Learning SQL Today
$997  $395
START LEARNING AND USING SQL TODAY!
Join The 1000's of Professionals Who Have Leveled Up By Learning SQL Today
$997  $397
THE GAME CHANGER YOU'VE BEEN WAITING FOR
You've Basically Discovered The Course That Can Skyrocket Your Career
THE GAME CHANGER YOU'VE BEEN WAITING FOR
You've Basically Discovered The Course That Can Skyrocket Your Career
Before I tell you more about SQL101, let me ask you a few questions:
  •  Are you looking to learn an in-demand skill to snag a higher paying job?
  •  Are you looking for a way to learn SQL quickly and effectively without any fluff?
  •  Are you fed up with asking others for data that you want to dig into?
  •  Do you want a competitive edge over others in your industry?
  •  Are you nervous about passing the SQL part of an interview and proving you know it?
  •  Are you looking for a better understanding of all the data you have access to?
If you answered yes to 1 (or all!) of these questions then I have some exciting news for you! 

Throughout my career, I have managed large data infrastructures and created reporting systems from scratch for $300M+ companies. Along the way I've taught SQL to colleagues who used their new skills to get jobs at companies like Google, Facebook, and the New York Times. When I was getting started, I pretty much answered yes to all of the questions above, but instead of seeking out a mentor or purchasing any courses, I tried to learn everything by doing it all myself. Luckily, I eventually figured everything out and became an incredibly successful Business Intelligence Analyst, but it cost me a lot (both time and unearned cash).

After accomplishing some personal career goals during the past 12 months, I'm turning my focus to helping other professionals achieve the same level of success I've had with SQL.

This past year, I spent 6 months working around the clock creating one the most comprehensive SQL courses on the market...
Before I tell you more about SQL101, let me ask you a few questions:
  •  Are you looking to learn an in-demand skill to snag a higher paying job?
  •  Are you looking for a way to learn SQL quickly and effectively without any fluff?
  •  Are you fed up with asking others for data that you want to dig into?
  •  Do you want a competitive edge over others in your industry?
  •  Are you nervous about passing the SQL part of an interview and proving you know it?
  •  Are you looking for a better understanding of all the data you have access to?
If you answered yes to 1 (or all!) of these questions then I have some exciting news for you! 

Throughout my career, I have managed large data infrastructures and created reporting systems from scratch for $300M+ companies. Along the way I've taught SQL to colleagues who used their new skills to get jobs at companies like Google, Facebook, and the New York Times. When I was getting started, I pretty much answered yes to all of the questions above, but instead of seeking out a mentor or purchasing any courses, I tried to learn everything by doing it all myself. Luckily, I eventually figured everything out and became an incredibly successful Business Intelligence Analyst, but it cost me a lot (both time and unearned cash).

After accomplishing some personal career goals during the past 12 months, I'm turning my focus to helping other professionals achieve the same level of success I've had with SQL.

This past year, I spent 6 months working around the clock creating one the most comprehensive SQL courses on the market...
INTRODUCING SQL101!
Here's what you get when you enroll today.
This is not just another online coding course where you get access to a few tutorial videos and some examples to work through that aren't relevant to anything. Courses like that are a dime a dozen. And you know what? They don't work. Sure, you might learn SQL... but you don't retain what you learn. The only way to do that is to work and think your way through real situations, with support along the way.
Before I tell you more about SQL101, let me tell you a true story about what really inspired me to create this course in the first place. Nearly a year ago, a friend of mine came to me asking for some help. She was ready to look for a new job in the Analytics field, but was struggling to learn SQL at the level she needed to get a well-paying job. She had gone through a couple courses already, but nothing was sticking with her. So I began creating some problems for her to solve that she would encounter in the real world once she had an Analytics job. If she could demonstrate that she could do everything a high-level analyst could do, then passing an interview would be a breeze. Using the framework I provided and with my guidance along the way, she improved immensely in a matter of weeks and ultimately succeeded in getting her dream job!After this experience, I knew that there was a lack of good SQL courses available, and I set my mind to creating the best one on the market.

SQL101 students get access to over 125+ exercises based on real world situations, all within a proprietary coding interface that's right in your browser. You can test out all of the important techniques on your own to develop a deep understanding of them. And if you ever get stumped, I'm just an email away. This is a level of personal attention that very few programs offer, in any industry.
INTRODUCING SQL101!
Here's what you get when you enroll today.
This is not just another online coding course where you get access to a few tutorial videos and some examples to work through that aren't relevant to anything. Courses like that are a dime a dozen. And you know what? They don't work. Sure, you might learn SQL... but you don't retain what you learn. The only way to do that is to work and think your way through real situations, with support along the way.
Before I tell you more about SQL101, let me tell you a true story about what really inspired me to create this course in the first place. Nearly a year ago, a friend of mine came to me asking for some help. She was ready to look for a new job in the Analytics field, but was struggling to learn SQL at the level she needed to get a well-paying job. She had gone through a couple courses already, but nothing was sticking with her. 

So I began creating some problems for her to solve that she would encounter in the real world once she had an Analytics job. If she could demonstrate that she could do everything a high-level analyst could do, then passing an interview would be a breeze. Using the framework I provided and with my guidance along the way, she improved immensely in a matter of weeks and ultimately succeeded in getting her dream job!After this experience, I knew that there was a lack of good SQL courses available, and I set my mind to creating the best one on the market.

SQL101 students get access to over 125+ exercises based on real world situations, all within a proprietary coding interface that's right in your browser. You can test out all of the important techniques on your own to develop a deep understanding of them. And if you ever get stumped, I'm just an email away. This is a level of personal attention that very few programs offer, in any industry.
125+ EXERCISES
$997 Value
Learn everything from the basics to the advanced level techniques -- but only the ones you will use in the real world. All with data designed to mirror real world datasets. No filler and no fluff.
CODING INTERFACE
$297 Value
One of the only courses on the market where you can write and run your code right in your browser. All of the lessons and exercises are consolidated in one place to make the learning process seamless. 
WEEKLY OFFICE HOURS
$15,600 Value
Multiple times per week I will answer any questions you may have along the way. Stuck? Email me. Confused on a technique? Email me. Looking for advice? Email me! I will be your mentor on your SQL journey.
125+ EXERCISES
$997 Value
Learn everything from the basics to the advanced level techniques -- but only the ones you will use in the real world. All with data designed to mirror real world datasets. No filler and no fluff.
CODING INTERFACE
$297 Value
One of the only courses on the market where you can write and run your code right in your browser. All of the lessons and exercises are consolidated in one place to make the learning process seamless. 
WEEKLY OFFICE HOURS
$15,600 Value
Multiple times per week I will answer any questions you may have along the way. Stuck? Email me. Confused on a technique? Email me. Looking for advice? Email me! I will be your mentor on your SQL journey.
THIS ISN'T A "LEARN SQL IN 2 HOURS" TYPE COURSE
Let's Make Sure We're On The Same Page

There are tons of courses on the market promising to teach you a coding language in an insanely short window of time. Where you can copy and paste some code and say you "learned" it. If this is something you're looking for then we should part ways now because that is not what SQL101 is all about.

This course is for people who are willing to invest the time and money required to learn a life-changing skill. Those that put in the effort will have success.
THIS ISN'T A "LEARN SQL IN 2 HOURS" TYPE COURSE
Let's Make Sure We're On The Same Page

There are tons of courses on the market promising to teach you a coding language in an insanely short window of time. Where you can copy and paste some code and say you "learned" it. If this is something you're looking for then we should part ways now because that is not what SQL101 is all about.

This course is for people who are willing to invest the time and money required to learn a life-changing skill. Those that put in the effort will have success.
LEARN THE TOPICS AND TECHNIQUES TO USE SQL EFFECTIVELY IN THE REAL WORLD
I've Put All Of My Knowledge Into A Useful & Comprehensive Course

The foundations of SQL101 are the exercises based on real world situations and the interactive coding interface. Through this proprietary interface, I'm able to show you exactly how to use the most effective SQL techniques, and then you will develop a deep understanding of them by working through relevant exercises... all right in your internet browser! There is nothing to download or install.

Every day I am testing new SQL techniques and strategies to efficiently organize and analyze data. When I find things that work, I share them inside the course. Long story short, you aren't buying a course that will never be updated and become obsolete in a few months. And SQL will be an important coding language for many years to come.
10
Modules
50+
Interactive Lessons
125+
Real World Exercises
SQL IN ACTION
Here's A Free Demo Of The Course

In this demo, I use one of the lessons to show you the structure of the course so you can see why it is the best SQL course on the market today. Now imagine having all of these lessons and exercises at your fingertips. This is what you can have access to today.
LEARN THE TOPICS AND TECHNIQUES TO USE SQL EFFECTIVELY IN THE REAL WORLD
I've Put All Of My Knowledge Into A Useful & Comprehensive Course

The foundations of SQL101 are the exercises based on real world situations and the interactive coding interface. Through this proprietary interface, I'm able to show you exactly how to use the most effective SQL techniques, and then you will develop a deep understanding of them by working through relevant exercises... all right in your internet browser! There is nothing to download or install.

Every day I am testing new SQL techniques and strategies to efficiently organize and analyze data. When I find things that work, I share them inside the course. Long story short, you aren't buying a course that will never be updated an become obsolete in a few months. And SQL will be an important coding language for many years to come.
10
Modules
50+
Interactive Lessons
125+
Real World Exercises
SQL IN ACTION
Here's A Free Demo Of The Course

In this demo, I use one of the lessons to show you the structure of the course so you can see why it is the best SQL course on the market today. Now imagine having all of these lessons and exercises at your fingertips. This is what you can have access to today.
WORK THROUGH OVER 125 REAL WORLD PROBLEMS - IT'S THE ACE UP YOUR SLEEVE
I Noticed That Most Courses Have A Flaw...Here's How I Fixed It

The problem with most SQL courses is that they try to teach you important concepts by using data that isn't relevant to anything whatsoever. They have you working through examples that use datasets on library books or movie titles. How would this help you when you encounter situations in the real world?!

The other big problem with these courses is that the topics are taught separately and independently. Once you finish with one topic, you move on to the next, never to see it again.

I solved both of these problems by creating over 125 exercises to work through -- all based on situations you would encounter in the real world. And each topic you learn builds on the previous ones so that you know how everything works together. As you go through the course, the repetition of important techniques leads to MASSIVE success.
WORK THROUGH OVER 125 REAL WORLD PROBLEMS - IT'S THE ACE UP YOUR SLEEVE
I Noticed That Most Courses Have A Flaw...Here's How I Fixed It

The problem with most SQL courses is that they try to teach you important concepts by using data that isn't relevant to anything whatsoever. They have you working through examples that use datasets on library books or movie titles. How would this help you when you encounter situations in the real world?!

The other big problem with these courses is that the topics are taught separately and independently. Once you finish with one topic, you move on to the next, never to see it again.

I solved both of these problems by creating over 125 exercises to work through -- all based on situations you would encounter in the real world. And each topic you learn builds on the previous ones so that you know how everything works together. As you go through the course, the repetition of important techniques leads to MASSIVE success.
Don't Just Take My Word For It...
MY STUDENTS ARE CRUSHING IT!
Carmela Villavicencio
Customer Success Analyst
Austin Webb
Data Scientist
"SQL101 is effective and super easy to follow. After going through just part of it, I felt more comfortable working with large datasets at my job. The exercises are challenging enough to make me really think without being overwhelming. And I'm able to refer back to specific modules in case I need a refresher on some of the more advanced topics. I can't wait to continue using this as my secret weapon!"
Matt Mo
Global Business Strategy @ Google
"As a software developer I'm constantly asked to work on tasks across the entire stack of an application, including the database. I needed a course that would give me the confidence to jump into any problem at the database layer. SQL101 gave me the skills and confidence that I needed in order to level up and tackle any problem given to me."
Scott Crawford
Software Engineer @ DigitalOcean
Don't Just Take My Word For It...
MY STUDENTS ARE KILLING IT!
Carmela Villavicencio
Customer Success Analyst
William Webb
Data Scientist
"SQL101 is effective and super easy to follow. After going through just part of it, I felt more comfortable working with large datasets at my job. The exercises are challenging enough to make me really think without being overwhelming. And I'm able to refer back to specific modules in case I need a refresher on some of the more advanced topics. I can't wait to continue using this as my secret weapon!"
Matt Mo
Global Business Strategy @ Google
"As a software developer I'm constantly asked to work on tasks across the entire stack of an application, including the database. I needed a course that would give me the confidence to jump into any problem at the database layer. SQL101 gave me the skills and confidence that I needed in order to level up and tackle any problem given to me."
Scott Crawford
Software Engineer @ DigitalOcean
Curious If SQL101 Is The Right Fit For You?
WHO IS THIS COURSE FOR?
There are very few courses on the market that can provide tremendous value to both people who want to learn SQL for the first time or people who want a refresher on what they learned before. SQL101 currently has students who have no technical experience whatsoever and students who work with data every day. Students at both ends of the spectrum are experiencing amazing results!
ANALYSTS
Any type of analyst will constantly be working with data. SQL101 will show you how to do things with data you've only dreamed of! Gone are the days of creating reports in Excel. This course can 10x your results.
DATA SCIENTISTS
Data Scientists work with HUGE amounts of data, and SQL is the best way to organize this data. This course will give you the skills to effectively work with datasets of any size and arrangement.
MARKETERS
If you work with sales and marketing data, this course is perfect for you. The real world exercises will show you how to organize data and get insights you couldn't previously without a ton of mind-numbing work.
SOFTWARE ENGINEERS
Understanding how data is arranged in databases, and what can be done with it, is a huge advantage for a software engineer. This course will give you the knowledge you need to be a more effective engineer.
PROJECT MANAGERS
If you're tired of relying on others for reports or just want to make better decisions from the data you have at your fingertips, this course will show you how.
ANYONE WORKING W/ DATA
If you work with any kind of data and want to add a skill to your resume that will be in-demand for many years to come (and can make you more money), then this course is DEFINITELY for you.
Curious If SQL101 Is The Right Fit For You?
WHO IS THIS COURSE FOR?
There are very few courses on the market that can provide tremendous value to both people who want to learn SQL for the first time or people who want a refresher on what they learned before. SQL101 currently has students who have no technical experience whatsoever and students who work with data every day. Students at both ends of the spectrum are experiencing amazing results!
ANALYSTS
Any type of analyst will constantly be working with data. SQL101 will show you how to do things with data you've only dreamed of! Gone are the days of creating reports in Excel. This course can 10x your results.
DATA SCIENTISTS
Data Scientists work with HUGE amounts of data, and SQL is the best way to organize this data. This course will give you the skills to effectively work with datasets of any size and arrangement.
MARKETERS
If you work with sales and marketing data, this course is perfect for you. The real world exercises will show you how to organize data and get insights you couldn't previously without a ton of mind-numbing work.
SOFTWARE ENGINEERS
Understanding how data is arranged in databases, and what can be done with it, is a huge advantage for a software engineer. This course will give you the knowledge you need to be a more effective engineer.
PROJECT MANAGERS
If you're tired of relying on others for reports or just want to make better decisions from the data you have at your fingertips, this course will show you how.
ANYONE WORKING WITH DATA
If you work with any kind of data and want to add a skill to your resume that will be in-demand for many years to come (and can make you more money), then this course is DEFINITELY for you.
INSIDE SQL 101
Take A Sneak Peek At The Content Inside SQL 101
Module 1
THE BASICS
  14 Real World Exercises
  The Basics of Every SQL Query
  Using WHERE and LIMIT
  Who Needs Excel When You Can Do Math With SQL!
  Working With Decimals
Module 2
LOGICAL OPERATORS
  18 Real World Exercises
  Let's Be Logical About This...
  Date Formats In Databases
  AND & OR
  Using AND & OR Together
  LIKE It Or NOT...
  You Like It and ILIKE It
  Symbols In Strings
  IN We Go!
  This Is BETWEEN You and Me!
Module 3
NULL & ORDER
  8 Real World Exercises
  NULL, Nothing, Nada, Zip
  ORDER BY
Module 4
AGGREGATE FUNCTIONS
  23 Real World Exercises
  MAX & MIN
  COUNT On It!
  Give Me SUM More!
  Just Your AVG Aggregate Function
  GROUP BY
  Grouping By More Than One Field
Module 5
FILTERING TECHNIQUES
  12 Real World Exercises
  DISTINCT
  HAVING The Time Of Your Life
  Advanced Usage Of HAVING
  CASE and Point
  Staying On The CASE
Module 6
WORKING WITH DATA TYPES
  16 Real World Exercises
  Most Common Data Types
  Changing A Data Type
  Dealing With Null Values
  Do You Have The Time?
  Moving Date Ranges
  Chopping Up Dates
  Calculating The Difference Between Dates
  Stringing You Along
  Other Useful String Functions
Module 7
JOINING DATASETS
  13 Real World Exercises
  Joining Tables Together
  Continuing On With Joins
  LEFT JOIN
  RIGHT JOIN
  More Ways To JOIN
  Filtering In A JOIN
Module 8
MULTIPLE QUERIES
  12 Real World Exercises
  Subquery Basics
  Subqueries In The WHERE Clause
  Joining Subqueries
  Advanced Subquery Usage
  Multiple CTEs
  State Of The UNION
  More Details On UNION
  UNION ALL
Module 9
WINDOW FUNCTIONS
  12 Real World Exercises
  Windows Of Opportunity
  Working With Window Functions
  Window Functions With Ordering
  Ranking & Ordering
  RANK & DENSE_RANK
  MAX, MIN, SUM, COUNT & AVG
Module 10
MORE WINDOW FUNCTIONS
  6 Real World Exercises
  Looking Into The Past And Future
  FIRST_VALUE
INSIDE SQL 101
Take A Sneak Peek At The Content Inside SQL 101
Module 1
THE BASICS
  14 Real World Exercises
  The Basics of Every SQL Query
  Using WHERE and LIMIT
  Who Needs Excel When You Can Do Math With SQL!
  Working With Decimals
Module 2
LOGICAL OPERATORS
  18 Real World Exercises
  Let's Be Logical About This...
  Date Formats In Databases
  AND & OR
  Using AND & OR Together
  LIKE It Or NOT...
  You Like It and ILIKE It
  Symbols In Strings
  IN We Go!
  This Is BETWEEN You and Me!
Module 3
NULL & ORDER
  8 Real World Exercises
  NULL, Nothing, Nada, Zip
  ORDER BY
Module 4
AGGREGATE FUNCTIONS
  23 Real World Exercises
  MAX & MIN
  COUNT On It!
  Give Me SUM More!
  Just Your AVG Aggregate Function
  GROUP BY
  Grouping By More Than One Field
Module 5
FILTERING TECHNIQUES
  12 Real World Exercises
  DISTINCT
  HAVING The Time Of Your Life
  Advanced Usage Of HAVING
  CASE and Point
  Staying On The CASE
Module 6
WORKING WITH DATA TYPES
  16 Real World Exercises
  Most Common Data Types
  Changing A Data Type
  Dealing With Null Values
  Do You Have The Time?
  Moving Date Ranges
  Chopping Up Dates
  Calculating The Difference Between Dates
  Stringing You Along
  Other Useful String Functions
Module 7
JOINING DATASETS
  13 Real World Exercises
  Joining Tables Together
  Continuing On With Joins
  LEFT JOIN
  RIGHT JOIN
  More Ways To JOIN
  Filtering In A JOIN
Module 8
MULTIPLE QUERIES
  12 Real World Exercises
  Subquery Basics
  Subqueries In The WHERE Clause
  Joining Subqueries
  Advanced Subquery Usage
  Multiple CTEs
  State Of The UNION
  More Details On UNION
  UNION ALL
Module 9
WINDOW FUNCTIONS
  12 Real World Exercises
  Windows Of Opportunity
  Working With Window Functions
  Window Functions With Ordering
  Ranking & Ordering
  RANK & DENSE_RANK
  MAX, MIN, SUM, COUNT & AVG
Module 10
MORE WINDOW FUNCTIONS
  6 Real World Exercises
  Looking Into The Past And Future
  FIRST_VALUE
In Case You Were Curious Who Is Teaching This Course
LET ME INTRODUCE MYSELF
Talking about myself is probably the activity I hate most... seriously it's the worst. That being said, most of you don't know me and I am asking you to give me money for my knowledge, so I should tell you a little bit about why this is an awesome deal for you!

I've worked for start ups in New York City for nearly 8 years. At my first job at a small software company, I taught myself SQL to improve my resume... and I struggled with it for a long time until I figured out the right strategies for learning.
As I became better and better with SQL, I built out the reporting and data infrastructure for Bonobos, a men's fashion company, and was an important part of the company on the way to a $300M+ valuation and acquisition. Not only did I help grow the company, but I grew professionally as well. I was able to go from making $50k per year to $122k per year, solely because I knew SQL and understood how it can be used in real business situations. Throughout the years, I also helped dozens of colleagues learn SQL to be more effective at their jobs and improve their career opportunities. I'm proud to have taught SQL to friends that have gone on to success at companies such as Google, Facebook, and The New York Times, among others.

Since then I've moved on to a Senior Business Intelligence role at a video marketing start up and continue to help them utilize the massive amounts of data they gather to make important decisions and increase revenue.

While all of these accomplishments are exciting, I can honestly say that SQL101 is the thing I am most proud of in my entire career! I'm excited for you to join me inside and to help you take your career to the next level.
In Case You Were Curious Who Is Teaching This Course
LET ME INTRODUCE MYSELF
Talking about myself is probably the activity I hate most... seriously it's the worst. That being said, most of you don't know me and I am asking you to give me money for my knowledge, so I should tell you a little bit about why this is an awesome deal for you!

I've worked for start ups in New York City for nearly 8 years. At my first job at a small software company, I taught myself SQL to improve my resume... and I struggled with it for a long time until I figured out the right strategies for learning.
As I became better and better with SQL, I built out the reporting and data infrastructure for Bonobos, a men's fashion company, and was an important part of the company on the way to a $300M+ valuation and acquisition. Not only did I help grow the company, but I grew professionally as well. I was able to go from making $50k per year to $122k per year, solely because I knew SQL and understood how it can be used in real business situations. 

Throughout the years, I also helped dozens of colleagues learn SQL to be more effective at their jobs and improve their career opportunities. I'm proud to have taught SQL to friends that have gone on to success at companies such as Google, Facebook, and The New York Times, among others.

Since then I've moved on to a Senior Business Intelligence role at a video marketing start up and continue to help them utilize the massive amounts of data they gather to make important decisions and increase revenue.

While all of these accomplishments are exciting, I can honestly say that SQL101 is the thing I am most proud of in my entire career! I'm excited for you to join me inside and to help you take your career to the next level.
"SQL101 has been the perfect resource for me in brushing up on my SQL skills. Jason takes the most effective approach to education possible: concise explanations of the most important concepts paired directly with targeted exercises. The coding interface makes it easy to breeze through the course while exercising key concepts. Highly recommended for anyone looking to learn (or re-learn) SQL!"
Jason Wardy
Data Scientist @ Enigma Technologies
"SQL101 has been the perfect resource for me in brushing up on my SQL skills. Jason takes the most effective approach to education possible: concise explanations of the most important concepts paired directly with targeted exercises. The coding interface makes it easy to breeze through the course while exercising key concepts. Highly recommended for anyone looking to learn (or re-learn) SQL!"
Jason Wardy
Data Scientist @ Enigma Technologies
START LEARNING AND USING SQL TODAY!
Join The 1000's of Professionals Who Have Leveled Up By Learning SQL Today
$997  $395
Take A Full 30 Days To Put SQL101 To The Test With My Iron-Clad, Money-Back Guarantee
Your satisfaction is important to me, which is why I offer a 30-day refund period for SQL101 - guaranteed. If you are unsatisfied with the content of this comprehensive course, I want you to email me. Show me you did the work, and I'll give you all your money back. No questions asked.
START LEARNING AND USING SQL TODAY!
Join The 1000's of Professionals Who Have Leveled Up By Learning SQL Today
$997  $397
Take A Full 30 Days To Put SQL101 To The Test With My Iron-Clad, Money-Back Guarantee
Your satisfaction is important to me, which is why I offer a 30-day refund period for SQL101 - guaranteed. If you are unsatisfied with the content of this comprehensive course, I want you to email me. Show me you did the work, and I'll give you all your money back. No questions asked.
FREQUENTLY ASKED QUESTIONS
How long is the course?
The course includes 32 video lessons (about 3 hours in total length), 57 interactive lessons, and 125+ exercises based on real world situations. and unlimited email coaching with me during my weekly office hours. It will probably take you somewhere between 50-75 hours total, or about 6 weeks if you took 1-2 hours per day to work on the course.
Do I need any prior coding experience?
Not at all! The course has been designed to be taken by people of any level of coding experience. If you have used an Excel or Google spreadsheet at any point in your life, then you should pick up the SQL concepts in no time!
How long do I have access to SQL101?
You have lifetime access to SQL101.
How do the weekly office hours work?
If you are stuck at any time, you can send an email to me at jason@SQL101.com, and I will reply to you on Monday, Tuesday or Thursday between 6pm - 9pm EST. Sometimes I will answer on other days or during other time slots, but those are the days and times I will definitely be available. The questions can be about a specific lesson or exercise, more information about a certain topic, or even a question about how to apply SQL in the real world. Anything is fair game. Consider me your mentor.
FREQUENTLY ASKED QUESTIONS
How long is the course?
The course includes 32 video lessons (about 3 hours in total length), 57 interactive lessons, and 125+ exercises based on real world situations. and unlimited email coaching with me during my weekly office hours. It will probably take you somewhere between 50-75 hours total, or about 6 weeks if you took 1-2 hours per day to work on the course.
Do I need any prior coding experience?
Not at all! The course has been designed to be taken by people of any level of coding experience. If you have used an Excel or Google spreadsheet at any point in your life, then you should pick up the SQL concepts in no time!
How long do I have access to SQL101?
You have lifetime access to SQL101.
How do the weekly office hours work?
If you are stuck at any time, you can send an email to me at jason@SQL101.com, and I will reply to you on Monday, Wednesday or Friday between 9am - 12pm EST. Sometimes I will answer on other days or during other time slots, but those are the days and times I will definitely be available. The questions can be about a specific lesson or exercise, more information about a certain topic, or even a question about how to apply SQL in the real world. Anything is fair game. Consider me your mentor.
Disclaimer: Any results listed above or in my marketing material are not always typical and are the result of years of training, experimenting and learning from mistakes. These results are used specifically as examples. Your results will vary depending on a wide variety of variables and factors.
SQL101    |    Copyright ©2018    |    All Rights Reserved     |   Terms & Conditions 
Made In New York City
Powered By ClickFunnels.com