Practical Postgres: Master The Most Important Parts of SQL

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

Learn the most critical parts of postgresql from the ground up.

1. Introduction & Setup

1. Introduction

2. What a Database is & Types of Databases

3. What is SQL

4. Why Postgres

5. Setup Mac.html

6. Setup Windows.html

2. Tables & Data Types

1. What is a Table

2. Common Conventions

3. Data Types

4. Creating Our First Table

5. EXERCISE Creating our first table

6. EXERCISE WALKTHROUGH Creating our first table and nullable columns

3. Basic Operations

1. Types of Operations CRUD

2. Insert statements

3. Select statements

4. Update statements

5. Delete statements

6. Transactions

7. CRUD Quiz.html

4. Robust Conditions

1. Setup.html

2. LIKE & ILIKE

3. OR statements and parenthesis

4. Alias

5. ORDER BY

6. Primary Keys and Indexes

7. EXERCISE Robust Queries

8. Data for exercise.html

9. EXERCISE WALKTHROUGH Robust Queries

5. Table Relationships

1. Why we need relationships

2. Types of Relationships

3. Entity Relationship Diagrams

4. EXERCISE Designing a Database

5. EXERCISE WALKTHROUGH Designing a Database

6. Foreign Keys

7. Leaf Land DB Setup

8. Join statements

9. Schemas

10. EXERCISE Joins

11. EXERCISE WALKTHROUGH Joins

6. Advanced Queries

1. Aggregates & Group By

2. Date Trunc

3. Nested Queries

4. CTES WITH Queries

5. EXERCISE Product Revenue

6. EXERCISE WALKTHROUGH Product Revenue

7. EXERCISE User Insights

8. EXERCISE WALKTHROUGH User Insights

9. EXERCISE Monthly Sales

10. EXERCISE WALKTHROUGH Monthly Sales

7. Advanced UpdatesInserts

1. Creating a shipping schema and table

2. Inserting from query

3. Updating from queries

8. Views

1. Whats a View

2. Creating a View

3. Materialized Views

9. Functions & Triggers

1. What is a Function

2. Creating a Discount Function

3. Using Functions

4. Triggers

5. EXERCISE Functions & Triggers

6. EXERCISE WALKTHROUGH Functions & Triggers

10. Closing & Some More Useful Information

1. JSONB

2. Finding queries with long execution time

3. Database Hosting

4. Datagrip

5. Thank You

139,000 تومان

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

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

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

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