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



Download link

rapidgator.net:


uploadgig.com:


nitroflare.com:


[b][/b]: