Complete Intro to SQL & PostgreSQL

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

1. Introduction

1. Introduction

2. SQL Setup with Docker

2. Databases and Tables

1. SQL Overview & Creating a Database

2. Creating & Populating a Table

3. Altering a Table & Postgres Data Types

3. SQL Commands

1. Inserting Data and Managing Conflicts

2. Updating & Deleting Data

3. Selecting, Paginating, & Using Where Clauses

4. Using LIKE, ILIKE, & SQL Functions

5. node-postgres & SQL Injection

6. Ingredients API Exercise

7. Ingredients API Solution

4. Joins and Constraints

1. Understanding Relationships & Joins

2. Left, Right, & Outer Joins

3. Natural & Cross Joins

4. Foreign Keys & Managing References

5. Many-to-Many Relationship

6. Using the CHECK Constraint

7. Using the DISTINCT Statement

8. Recipes Exercise

9. Recipes Solution

5. JSONB

1. JSON vs. JSONB

2. Adding JSONB to Recipes Table

3. When to Use JSONB

6. Aggregation

1. Understanding Aggregation

2. Filtering Aggregates with HAVING

7. Functions Triggers and Procedures

1. Storing Queries with Functions

2. Functions vs. Procedures

3. Calling Functions with Triggers

8. The Movie Database

1. The Movie Database Setup

2. The Movie Database Exercise

3. The Movie Database Solution Most Money

4. The Movie Database Solution Keanu Reeves

5. The Movie Database Solution Most Revenue

6. The Movie Database Solution Most Keywords

7. The Movie Database Solution Most Movies

8. Setup pgAdmin

9. Query Performance

1. Analyzing Queries with EXPLAIN

2. Identifying what to Index

3. Creating an Index

4. Using a GIN Index

5. Creating a Partial Index

6. Indexing a Derivative Value

10. Views, Subqueries & Arrays

1. Creating Views & Inserting Data

2. Joining Between Views

3. Optimizing Queries with Materialized Views

4. Indexing Materialized Views

5. Using Subqueries

6. Creating an Array from a Subquery

11. Transactions, Window Functions, and Self Join

1. Transactions

2. Window Functions

3. Self Join

12. Wrapping Up

1. Wrapping Up

139,000 تومان

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

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

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

شناسه: 35926

حجم: 2995 مگابایت

مدت زمان: 440 دقیقه

تاریخ انتشار: 20 مرداد 1403