только у нас скачать шаблон dle скачивать рекомендуем

Фото видео монтаж » Видео уроки » Видео уроки web-design » Sql For Managers, Products And Business Leaders.

Sql For Managers, Products And Business Leaders.

Sql For Managers, Products And Business Leaders.

Sql For Managers, Products And Business Leaders.
Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 215.40 MB | Duration: 0h 45m



How to start to use and understand SQL in 1 hours

What you'll 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

Requirements
Basic knowledge of web browser

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 databaseWe 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 WHEREI 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!

Overview
Section 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?

Section 2: Where SQL lives?

Lecture 5 SQL enviroment

Lecture 6 Intorduction to Google Big Query cloud server

Section 3: Understanding SQL at 3 simple steps

Lecture 7 Basic query: SELECT, FROM, WHERE

Lecture 8 Acquaintance of GBQ interface

Lecture 9 Basic queries example

Lecture 10 Table adress logic

Lecture 11 How WHERE clause works

Section 4: Making yourself effective in code

Lecture 12 Code style

Lecture 13 Typycal errors and how to work with them

Lecture 14 Column alliases

Lecture 15 How to export your results from GBQ

Section 5: Joins

Lecture 16 What is join and how it connects to Excel VLOOKUP

Lecture 17 Left Join

Lecture 18 Right Join

Lecture 19 Join

Lecture 20 Full Join

Lecture 21 Practice in GBQ and Join Tips

Section 6: Aggregations

Lecture 22 Modifications to basic query to make aggregations and examples

Lecture 23 What is aggregation function?

Lecture 24 Difference between HAVING and WHERE

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

HOMEPAGE


 https://www.udemy.com/course/sql-for-managers-products-and-business-leaders/  


DOWNLOAD


https://rapidgator.net/file/ff0a5d1babf13cb8a15baa4544b92818/SQL_for_managers_products_and_business_leaders.rar.html
https://uploadgig.com/file/download/2878bc0bcaFEAa96/SQL_for_managers_products_and_business_leaders.rar
Poproshajka




Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.