SQL for managers, products and business leaders.

SQL for managers, products and business leaders., available at $19.99, has an average rating of 4, with 24 lectures, 6 quizzes, based on 1 reviews, and has 6 subscribers.

You will learn about How to use SQL for getting data and reports from DataBases Speed up our work with data Google Big Query Cloud database Modify queries of analysts and developers for your buisness needs This course is ideal for individuals who are Product Managers or Managers who works with reports and data or Analysts who works with Excel It is particularly useful for Product Managers or Managers who works with reports and data or Analysts who works with Excel.

Enroll now: SQL for managers, products and business leaders.

Summary

Title: SQL for managers, products and business leaders.

Price: $19.99

Average Rating: 4

Number of Lectures: 24

Number of Quizzes: 6

Number of Published Lectures: 24

Number of Published Quizzes: 6

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: €19.99

Quality Status: approved

Status: Live

What You Will Learn

How to use SQL for getting data and reports from DataBases
Speed up our work with data
Google Big Query Cloud database
Modify queries of analysts and developers for your buisness needs

Who Should Attend

Product Managers
Managers who works with reports and data
Analysts who works with Excel

Target Audiences

Product Managers
Managers who works with reports and data
Analysts who works with Excel

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!

Course Curriculum

Chapter 1: What and why SQL?

Lecture 1: How SQL could help you in your work and career

Lecture 2: Instructor introduction

Lecture 3: How this course structured

Lecture 4: What is SQL?

Chapter 2: Where SQL lives?

Lecture 1: SQL enviroment

Lecture 2: Intorduction to Google Big Query cloud server

Chapter 3: Understanding SQL at 3 simple steps:

Lecture 1: Basic query: SELECT, FROM, WHERE

Lecture 2: Acquaintance of GBQ interface

Lecture 3: Basic queries example

Lecture 4: Table adress logic

Lecture 5: How WHERE clause works

Chapter 4: Making yourself effective in code

Lecture 1: Code style

Lecture 2: Typycal errors and how to work with them

Lecture 3: Column alliases

Lecture 4: How to export your results from GBQ

Chapter 5: Joins

Lecture 1: What is join and how it connects to Excel VLOOKUP

Lecture 2: Left Join

Lecture 3: Right Join

Lecture 4: Join

Lecture 5: Full Join

Lecture 6: Practice in GBQ and Join Tips

Chapter 6: Aggregations

Lecture 1: Modifications to basic query to make aggregations and examples

Lecture 2: What is aggregation function?

Lecture 3: Difference between HAVING and WHERE

Instructors

Kirill Shmidt
Data anaytics and Data science

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 1 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu