PostgreSQL – Complete beginner to advanced course

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

Focused on practical problem solving using PostgreSQL/ postgres. Learn through real time use cases and sample datasets

1. Introduction

1. Introduction

2. SQL use case in Analytics

2. Setting up the environment

1. Installing Postgres for Windows

2. PGAdmin 4 walkthrough

3.1 All sample data files.zip

3.2 loading sample dataset.zip

3. Load the csv files for sample dataset

3. Beginners

1.1 select keyword.zip

1. SELECT, FROM and LIMIT keyword

2.1 create table keyword.zip

2. CREATE and INSERT command

3.1 where keyword.zip

3. WHERE keyword

4.1 order by and limit clause.zip

4. ORDER BY, LIMIT and FETCH keyword

5. Practice Assignment 1.html

6.1 group by and having clause.zip

6. GROUP BY and HAVING command

7.1 use case - finding granularity of any table.zip

7. Use case - Finding the granularity of any table

8.1 joins.zip

8. JOINS in Postgres

9.1 union and union all.zip

9. UNION, UNION ALL, INTERSECT and EXCEPT commands

10. Writing sequence and Execution sequence

11. Practice Assignment 2.html

4. Intermediate

1.1 case when statements.zip

1. CASE WHEN statements

2.1 careful while using where with left join.zip

2. Use case - Careful while using WHERE with OUTER JOINS

3.1 subqueries and exists, all, any keywords.zip

3. Subqueries in Postgres

4.1 cross join use case.zip

4. Use case - CROSS JOINS

5.1 self join and natural join.zip

5. SELF JOIN and NATURAL JOIN

6.1 grouping sets.zip

6. GROUPING SETS, CUBE and ROLLUP commands

7.1 window functions.zip

7. Window Functions

8.1 mode and median.zip

8. Use case - Finding the Mean, Median and Mode

9.1 lead and lag use case.zip

9. Use case - Lag and Lead Window functions

139,000 تومان

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

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

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

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