ViewTube

Do you struggle to understand complex queries?

Whenever I see a long query, or one with a lot of columns, or lots of joins, or many subqueries, it can seem overwhelming.

My first thought is, what on Earth is this query doing?

But over time, as I saw more and more of these complex queries, they got easier to understand.

There are three things that I do whenever I encounter a complex query to understand what the query is doing and what the results mean.

On Wednesday at 2 PM, I’ll be sending an email that includes:

- what these three things are
- how they help me
- how you can use them for complex queries you find

Enter your email on this page to get the email with all of the details on these techniques:

Here’s the page:  https://www.databasestar.com/value/?utm_source=ytcom&utm_medium=youtube&utm_campaign=post2 

Only 24 hours to go!

My Black Friday 2024 Course Bundle is available for the next 24 hours only.

It includes my three most popular courses (SQL Simplified, Effective Database Design, Write Faster SQL) and you get a 50% discount from the regular price.

I don’t know when I’ll offer this bundle again…

So if you want to improve your SQL skills and your career, and get better at your job, check out this bundle:  https://databasestar.mykajabi.com/offers/oPBtEzjc 

You know that special deal I mentioned a couple of days ago?

Well, here it is.

My Black Friday 2024 Course Bundle:  https://databasestar.mykajabi.com/offers/oPBtEzjc 

I’ve bundled three of my most popular courses together:

- SQL Simplified: learn the fundamentals of SQL
- Effective Database Design: learn how to design an effective and robust database and create it with SQL
- Write Faster SQL: learn how to improve the performance of your SQL queries

All courses are shown in the four vendors I teach (Oracle, SQL Server, MySQL, and Postgres), come with a 30-day money back guarantee, include PDF versions of the course and other bonuses.

You can get this bundle for 50% off the full price of the courses.

This is the largest discount I’ve ever done.

However… it’s only available for the next 48 hours.

Find out more here:  https://databasestar.mykajabi.com/offers/oPBtEzjc 

Heads up…

You probably know Black Friday is approaching.

So, I’m putting together a special deal for my courses.

I’ll be releasing more information about this deal on Thursday, so keep an eye out for that. 

What database vendors and tools do you use?

I've just created a short survey to find out more about the database community and the tools, databases, and operating systems that are used.

It's a short 4-question survey, that you can fill out here:  https://docs.google.com/forms/d/e/1FAIpQLSfUDCOLJGiA_F1w51XoXTMpKYsZC0wWy1ksFpVzo3F6-FYz7g/viewform?usp=sf_link 

I'll be creating a blog post on my website and a YouTube video to summarise the results.

If you could take two minutes to fill out this short survey, it would be appreciated!

Here's the link again:

 https://docs.google.com/forms/d/e/1FAIpQLSfUDCOLJGiA_F1w51XoXTMpKYsZC0wWy1ksFpVzo3F6-FYz7g/viewform?usp=sf_link 

Thanks! 

Do you often forget the syntax for SQL commands, and have to Google them?

I do this all the time.

If you do the same, then you’ll love the SQL Cheat Sheets I have created.

They are a range of PDF files that list the common SQL keywords, functions, and concepts across several vendors (MySQL, Postgres, Oracle, and SQL Server - separate PDFs for each vendor).

You can have this file open as you work with SQL and use it as a reference, saving you time.

You can get your copy of the cheat sheets here:

 https://www.databasestar.com/get-sql-cheat-sheets/?utm_source=ytcom&utm_medium=youtube&utm_campaign=post1 

I'm hosting a free webinar, called "How to Understand Why Your SQL Is Slow: The First Step to Faster SQL".
You can register here:  https://databasestar.mykajabi.com/webinar-register 
You'll learn how to see the steps the database takes when running your query, how to make sense of what you're seeing, and how to know where to focus your improvements. 

What database or SQL topics do you want to see me create a video for?