SQL for managers, products and business leaders.

سرفصل های دوره

How to start to use and understand SQL in 1 hours

1 - What and why SQL

1 - How SQL could help you in your work and career

2 - Instructor introduction

3 - How this course structured

4 - What is SQL

2 - Where SQL lives

5 - SQL enviroment

6 - Intorduction to Google Big Query cloud server

3 - Understanding SQL at 3 simple steps

7 - Basic query SELECT FROM WHERE

8 - Acquaintance of GBQ interface

9 - Basic queries example

10 - Table adress logic

11 - How WHERE clause works

4 - Making yourself effective in code

12 - Code style

13 - Typycal errors and how to work with them

14 - Column alliases

15 - How to export your results from GBQ

5 - Joins

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

17 - Left Join

18 - Right Join

19 - Join

20 - Full Join

21 - Practice in GBQ and Join Tips

6 - Aggregations

22 - Modifications to basic query to make aggregations and examples

23 - What is aggregation function

24 - Difference between HAVING and WHERE

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training