PostgreSQL Database Administration (DBA) for Beginners

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

Learn Practical Database Administration

1. Installing PostgreSQL Server

1. Introduction

2. What is PostgreSQL

3. Who is using PostgreSQL

4. Minimum Installation Requirements

5. Installation versions (Please Read).html

6. Installing PostgreSQL Server version10

7. Installing PostgreSQL on MacOS

8. Installing PgAmin on MacOS

9. Installing PostgreSQL on Linux

10. Installing PgAmin on Linux

11. Connecting to a PostgreSQL Database

12.1 dvdrental.zip

12. Download and load Sample PostgreSQL Database

2. Exploring PostgreSQL Database Objects

1. Server Service

2. Database

3. Table

4. Schema

5. Tablespace

6. Views

7. Functions

8. Cast and Operators

9. Sequences

10. Extensions

3. PostgreSQL Fundamentals

1. Database Concepts

2. PostgreSQL Data Types

3. PostgreSQL Unique Constraint

4. Filtering Data using WHERE clause

5. Getting all data from a table

6. Getting data from a specific column

7. Removing duplicate records

8. Sorting data

9. Grouping data with GROUP BY clause

10. Using HAVING clause

11. Truncating a table

12. Stored Procedures

4. Performing CRUD operations

1. Introduction

2. Create Database with pgadmin tool

3. Create Table with pgadmin tool

4. Create Table Statement

5. Using SELECT statement

6. Using a subquery

7. Using UPDATE Statement

8. Using DELETE statement

9. Using INSERT statement

5. PostgreSQL Operators

1. Comparison Operators

2. BETWEEN Operators

3. NOT BETWEEN Operators

4. LIKE operators

5. NOT operator

6. OR Operator

7. AND Operator

8. Combining AND & OR operators

9. LIMIT Operators

10. IN operator

11. UNION Operator

12. UNION ALL Operator

13. INTERSECT Operator

14. EXCEPT Operator

6. PostgreSQL Table Joins

1. Introduction to Joins

2. INNER Join

3. LEFT Join

4. FULL OUTER Join

5. CROSS Join

6. NATURAL Join

7. PostgreSQL Aggregate Functions

1. Introduction to Aggregate Functions

2. AVG Aggregate Functions

3. COUNT Aggregate Functions

4. MAX Aggregate Functions

5. MIN Aggregate Functions

6. SUM Aggregate Functions

8. PostgreSQL Analytic Functions

1. Introduction to Analytic Functions

2. Creating Sample Tables

3. Using AVG as window function

4. ROW Number functions

5. RANK Functions

6. DENSE RANK Functions

7. First Value Function

8. LAST Function

9. LAG Function

10. LEAD Function

9. PostgreSQL Views

1. Introduction to views

2. Benefits of using views

3. Creating a view

4. Modifying and removing views

5. Updatable View

6. Creating Updatable Views

7. Materialized Views

8. Creating a materialized view

10. PostgreSQL Triggers

1. Introduction to triggers

2. Creating your first trigger - part 1

3. Creating your first trigger - part 2

4. Creating your first trigger - part 3

5. Managing triggers

11. PostgreSQL Role Management

1. Introduction

2. Database Role

3. Role Attributes

4. Role membership

5. Group and user role inheritance

6. Removing Roles

7. Default Roles

8. Defining a role

12. PostgreSQL Database Backup and Restore

1. Introduction

2. Backing up a single database using pg_dump

3. Backing up a single database using pgadmin

4. Restoring a PostgreSQL Database

5. Restoring a database using pgrestore

6. Restoring a database using pgadmin

13. Tablespace Management

1. Introduction

2. Creating a tablespace

3. Changing a tablespace

4. Deleting Tablespace

5. Thank You.html

139,000 تومان

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

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

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

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