PostgreSQL For Beginners: Learn PostgreSQL From Scratch

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

Learn Everything About PostgreSQL From Scratch To Use It In Real-World.

1. Introduction

1. Course Inroduction

2. Instructions.html

2. Basics of PostgreSQL

1. What is Database

2. What is PostreSQL

3. Quiz - 1.html

3. Setup

1. PostgreSQL Installation

2. Setup PSQL

4. Basics of PostgreSQL

1. How to Create Database

2. How to Connect to Databases

3. A Very Dangerous Command

4. How To Create Tables

5. Insert Into

6. Quiz - 2.html

5. How to work with real-world Database

1. Create Dummy Database

2. Select From

3. Order By

4. Distinct

5. Where Clause and AND

6. Comparison Operators

7. Limit, Offset & Fetch

8. IN

9. Between

10. Like And iLike

11. Group By

12. Group By Having

13. Adding New Table And Data Using Mockaroo

14. Quiz - 3.html

6. Functions in PostgreSQL

1. Calculating Min, Max & Average

2. AVG & SUM

3. Basics of Arithmetic Operators

4. Alias

5. Coalesce

6. NULLIF

7. Timestamps And Dates Course

8. Adding And Subtracting With Dates

9. Extracting Fields From Timestamp

10. Age Function

11. Quiz - 4.html

7. Keys, Constraints, Update, Delete & Joins

1. What Are Primary Keys

2. Unique Constraints

3. How to Delete Records

4. How to Update Records

5. On Conflict Do Nothing

6. What Is A RelationshipForeign Keys

7. Inner Joins

8. Left Joins

9. Deleting Records With Foreign Keys

10. Quiz - 5.html

8. Extended Features

1. Exporting Query Results to CSV

2. Serial & Sequences

139,000 تومان

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

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

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

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