ONLINE • LIFETIME ACCESS • NO PRE-REQUISITES

straight-to-sql.jpeg

READY TO START A CAREER IN DATA?

You've come to the right place! Learning SQL can definitely enhance your career. A top 5 in-demand tech skill, it’s a sure way to secure a job in Big Data.


THIS COURSE WILL TEACH YOU EVERYTHING YOU NEED TO KNOW ABOUT SQL:

JPEG image-43BD35058C47-1.jpeg
JPEG image-6A63B50EF38A-1.jpeg
 
JPEG image-ED7D71A66265-1.jpeg
JPEG image-6FD76DD2E0D3-1.jpeg

I'M Walter, YOUR instructor

Me_FullBody.JPG

I'VE BEEN HELPING PEOPLE MASTER SQL AND DATABASES. 
HERE'S HOW I CAN HELP YOU.

I've worked with SQL and databases for over 18 years, helping organizations such as Target, NYC Transit Authority and Bank of America successfully leverage and understand their data using SQL.

I remember how intimidating SQL was when I first started studying it. While I've definitely learned SQL the hard way, I knew it didn’t have to be so daunting, so I decided to create my own course, teaching SQL in a very approachable way, with real-life examples and concepts. I created a course that I would’ve wanted when I first started out. With my course I've helped hundreds of people get introduced to the basic principles of SQL!

With STRAIGHT TO SQL I am committed to helping aspiring job seekers learn SQL and break into a career in Big Data.

OUR CURRICULUM

click on a module below to see more

Get Your Gear!


  1. The Crime
  2. For Mac Users Only
  3. UInstall SQL Server 2017 SP1 Express Edition (5:33)
  4. Download Digital Evidence (1:52)
  5. Environment Orientation (8:12)
  6. Reading the Case Notes
  7. Your Investigation Strategy

MODULE 1: What the #@! is SQL?


  1. The Breakdown
  2. Tweaking Your Settings (4:26)
  3. Adding Comments & why this is sooo important (6:12)
  4. Loading our Database File (6:45)
  5. Getting Familiar with your Database (4:51)
  6. Let's break a query down, back 2 basics (15:25)
  7. Keeping it real by using field Aliases and sorting with ORDER BY (4:08)
  8. Common Rookie mistakes (4:13)
  9. Quiz

MODULE 2: Chopping Up Data.


  1. The Breakdown
  2. The WHERE clause - Finding numeric data (6:40)
  3. Date Criteria
  4. More tricks with WHERE clause (6:05)
  5. The WHERE clause - Finding text data & using Wildcards (8:57)
  6. The WHERE clause - Finding data using Dates (11:16)
  7. The WHERE clause - Intro to Date Functions (4:33)
  8. More OPERATORS. Introducing the AND and OR (6:35)
  9. How to create a Calculated Column (5:36)
  10. More tricks with Calculated Columns (10:30)
  11. Even more - Some tips with Calculated Columns (6:15)
  12. The CASE statement (10:15)
  13. Filtering results using the CASE statement (4:20)
  14. A look at Data Types (4:45)
  15. Data Analysis Quiz

MODULE 3: Dating and Relationships.


  1. The Breakdown
  2. How do Tables Relate - Intro to Joins? (5:02)
  3. How do Tables Relate? (8:16)
  4. Looking at the INNER JOIN (7:09)
  5. Joining more Tables with the INNER JOIN (9:02)
  6. The INNER JOIN Explained (6:33)
  7. The LEFT JOIN Explained (4:55)
  8. The RIGHT JOIN Explained (4:55)
  9. Quiz

MODULE 4: Dysfunctional Families.


  1. The Breakdown
  2. Intro to FUNCTIONS (8:03)
  3. More Functions and understanding Parameters (9:22)
  4. Using one function with another (Nesting) (9:25)
  5. Gluing Text together (Concatenating) (6:28)
  6. Concatenating with different Data Types (14:47)
  7. Breaking up Text (7:51)
  8. More tricks to effectively Break up Text (9:07)
  9. Even more tricks to Break up strings of Text (8:41)
  10. One more trick - Reformatting our broken up text (3:14)
  11. Adjusting the format of Dates (9:26)
  12. Figuring out the difference between dates (6:49)
  13. Figuring out the difference between dates Accurately (6:41)
  14. PT 2 - Figuring out the difference between dates Accurately (6:56)
  15. Quiz

MODULE 5: Group Therapy.


  1. The Breakdown
  2. Aggregate Functions (8:58)
  3. Using Aggregate Functions with different data types (Caution) (12:17)
  4. Grouping Data - The GROUP BY keyword (6:53)
  5. Filtering Grouped Data (6:18)
  6. Grouping By more than one Column (5:28)
  7. Data Analysis Quiz

MODULE 6 (ADVANCED): Subway Station Sub-query and Views.


  1. The Breakdown
  2. Intro to the Sub-Query (12:19)
  3. Sub-Queries in the SELECT clause (5:09)
  4. More fun with sub-queries - Adding the WHERE clause (4:57)
  5. Sub-queries without an Aggregate Function (4:34)
  6. Using the IN clause with Sub-queries (4:35)
  7. SQL Server Views (6:59)
  8. Data Analysis Quiz

 

PRICING

JPEG image-9E69B9B29D7E-1.jpeg
 

FAQ

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

How long do I have access to the course?

How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

What equipment/tools will I need to complete the course?

The only equipment you will need is a computer, either Windows or Mac. We recommend macOS Sierra. The earliest Windows OS we recommend is Windows 8.

What do I do if I need help?

If you have a question related to this course, email walter@sqltrainingwheels.com. Thanks!

How long is the course?

Plan to take about six weeks to complete the course. There are 53 videos totaling over six hours of content. Most videos are 5–10 minutes long, with the shortest video around 2 minutes and the longest about 15 minutes.