The Complete Beginner to Advanced PostgreSQL Course 2024

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

Database Design Principles, Normalization, Entity relationship modelling, Common table expressions (CTES), ACLs, RLs

1. Introduction

1. Course structure

2. How to make the most out of this course

3. How to install pgAdmin 4

4. what is relational databases

5. How to create a database and delete a database

6. Introduction to some of the basic SQL Commands

Files.zip

2. Data Types and Operators

1. What are data types and how to work with them

2. What are primary keys

3. what are Operators and Functions and how to implement both of them

3. Database Design and Management

1. what is Database Design Principles

2. Introduction to normalization and implementation

3. Explanation of REFERENCES keywords

4. Introduction to entity relationship modeling

5. Introduction to one to one relationship

6. Introduction to one to many relationship

7. Introduction to Many to many relationship

8. What are constraints in postgreSQL

9. Example of constraints in postgreSQL

10. Introduction to indexes in postgreSQL

11. Introduction to transactions in postgreSQL

Files.zip

4. Manipulating and retrieving data

1. How to filter in postgreSQL

2. How to sort in postgreSQL

3. Introduction to join in PostgreSQL

4. Introduction to LIKE clause

5. Introduction to ILIKE clause

6. Introduction to distinct

7. Introduction to limit and offset

8. Deep dive into subqueries in PostgreSQL

9. Introduction to NOT EXISTS clause

10. Introduction to EXISTS clause

11. Introduction to HAVING clause

12. What is upsert in PostgreSQL

13. Time to test knowledge.html

Files.zip

5. Advanced SQL Features

1. How to add a new column into existing table

2. Introduction to Common Table Expressions (CTEs) with implementation

3. Introduction to window function with implementation

4. Introduction to RANK() function with implementation

5. Introduction to procedure in postgreSQL

6. Introduction to Recursive Queries with implementation

7. Time to test knowledge.html

Files.zip

6. Advanced Database Administration

1. Introduction to User Management and Permissions

2. How to create users and roles in postgreSQL

3. What is ACLs

4. How to list users and roles

5. Introduction to RLs

6. how to list all Row-level security

Files.zip

7. Some other advanced concepts

1. Introduction to Transaction Isolation

2. What is MVCC

3. Introduction to Savepoints

4. What is Deadlocks

5. What is VACUUMM

6. what is The EXPLAIN statement

7. Examples of query tuning

8. Introduction to ANALYZE keywords

Files.zip

8. Thank you

1. Thank you

54,900 تومان

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

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

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

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