SQL for managers, products and business leaders.

Description

Have you ever had a need for getting data and been stuck with your IT or analyst who needs time to process your request? Well, you need no more. You can drastically increase your productivity and shorten waiting time if you could write simple SQL for yourself!

This course is designed to give you an easy introduction to SQL which allows you to get value from databases right after the course. No unnecessary programming details, just what you need to extract and work with data.

We are going to talk about SQL basics which are useful for data extraction and main manipulations. If you are an analyst yourself this course will be useful for you because this will give a nice and meaningful start in your journey into the depth of SQL. You could practice them on the platform or ask for access from me to practice on my Google Big Query demo server to get a hand on a real database

We are going to talk not only about code but also about the SQL environment, where exactly you can encounter it. I will familiarise you with one of the most popular cloud-based databases Google Big Query. This experience will allow you to understand intuition and reuse this knowledge in different databases and SQL dialects.

Then we will discuss the code and practice it on some analytic-related tasks. We are going to find out how to extract, join, and aggregate data. Then we are going to discuss important concepts of code style and typical errors.

In this course:

- What is SQL

- SQL environment

- Basic SQL query

- Logic behind filtering (where)

- Aliases

- Typical errors and how to resolve them

- Join (left, right, full) and aggregations

- Functions

- Difference between HAVING and WHERE

I am an 8+ year expert in Data analytics and work a lot with SQL, R, Python, Excel, and BI tools. Also, I am a team lead and responsible to onboard new analysts and teaching people across my organization to be more data savvy. Now I can help you to be more data-savvy!

TAKE THIS COURSE