PostgreSQL Database Administration Masterclass

Focused View

AD Chauhdry (AD Maths Plus Academy),Tayyab Rashid

5:04:03

126 View

1. Introduction

1. Introduction.mp4

03:46

2. Introduction to PostgreSQL

1. Introduction to PostgreSQL.mp4

03:37

2. What is SQL.mp4

02:31

3. Features of PostgreSQL

1. PostgreSQL & other Query Languages.mp4

01:32

2. Key Differences.mp4

03:06

3. Features of PostgreSQL.mp4

08:09

4. Use and Installation

1. Uses of PostgreSQL.mp4

03:43

2. Installation of PostgreSQL.mp4

04:56

3. Setup.mp4

06:00

5. Database and Querying in PosrgreSQL

1. Installation.mp4

06:55

2. Loading Database.mp4

09:42

3. Querying and Filtering data.mp4

13:15

6. Querying data

1. Querying data.mp4

11:14

2. Querying Data.mp4

16:26

3. Querying Data.mp4

13:35

7. Filtering Data

1. Filtering Data.mp4

10:08

2. Filtering Data.mp4

07:59

8. Joining Multiple Tables

1. Joining Multiple Tables.mp4

08:56

2. Joining Tables.mp4

09:39

9. Joining and Grouping Tables

1. Joining Tables.mp4

10:42

2. Joining Tables.mp4

16:27

3. Joining Tables.mp4

05:07

4. Grouping Data.mp4

06:35

10. Set Operations in PostgreSQL

1. Set Operation.mp4

08:38

2. Set Operation.mp4

04:06

3. Joining Tables.mp4

18:32

11. Backup and Restore using PostgreSQL

1. Grouping Data & Set Operation.mp4

17:21

2. Modifying Data.mp4

50:21

3. Backup & Restore Database.mp4

21:05

Description

Learn PostgreSQL Database Administration and enhance your new skills in data management

What You'll Learn?

Table of Content
Introduction to PostgreSQL
Installation of PostgreSQL
Querying and Filtering data
Filtering Data
Set Operations in PostgreSQL
Joining Tables
Grouping Data & Set Operation
Introduction to PostgreSQL

Who is this for?

For those who want to learn postgreSQL

More details

Description
The PostgreSQL Database Administration Masterclass is an advanced course designed for experienced database administrators and developers who want to deepen their knowledge of PostgreSQL database management. The course is led by experienced instructors who have extensive hands-on experience with PostgreSQL and other database management systems.
During the course, students will learn advanced techniques for managing and optimizing PostgreSQL databases, including database design, schema management, query optimization, and high availability. The course will also cover advanced topics such as performance tuning, backup and recovery, and security.
Specific topics covered in the course may include:
PostgreSQL architecture and internals
Installing and configuring PostgreSQL
Database design and schema management
Query optimization and performance tuning
Backup and recovery strategies
High availability and clustering
Security and access control
Monitoring and troubleshooting PostgreSQL databases
PostgreSQL extensions and advanced features
The course will be taught through a combination of lectures, hands-on exercises, and group discussions. Students will have access to a dedicated PostgreSQL environment for practicing and applying what they learn throughout the course.
By the end of the course, students will have a deep understanding of PostgreSQL database management and be able to apply their knowledge to real-world scenarios. They will also be prepared to take on advanced roles as PostgreSQL database administrators or developers.
AD CHAUHDRY
TAYYAB RASHID
Who this course is for:
For those who want to learn postgreSQL

User Reviews

Rating

average 0

Total votes0

Focused display

If there is a walking encyclopedia of Calculus, Quantum Physics, Astronomy and solving differential equations, then it should be called Ad Chauhdry. Ad Chauhdry is a researcher of mathematics for over 15 years in which he’s contributed with articles in several scientific journals with good impact factor. His work also includes teaching post-graduate students, so you can trust his teaching and researching experience. Apart from working in an academic environment, Ad Chauhdry has also established an online and offline academy called AD Maths Plus Academy. 20k+ students have enrolled in AD Maths Plus courses. With Ad Chauhdry, you may jump into learning how to solve Calculus problems, and how to understand the quantum physics, Astronomy, solution of differential equations and then transfer your skills into learning Python, Machine learning and others applicable areas on Udemy. He’s also created a course for you to get a grasp of Educational Psychology, so you can build a solid foundation for further learning of personal skills. Ad Chauhdry reveals the secrets of maths and Calculus underlying so many things in economics, technology development, etc. If you want to see it for yourself, you have an excellent opportunity to get such things explained by an experienced mathematician, scientist, researcher, and educator – Ad.

Tayyab Rashid

Instructor's Courses

If there is a walking encyclopedia of Python, Data Science, Data Analysis, and Mathematics, then it should be called Tayyab Rashid.Tayyab Rashid is a researcher of Data Analytics for over 15 years in which he’s contributed articles in several scientific journals with good impact factors. His work also includes teaching data analytics to post-graduate students, so you can trust his teaching and research experience.With Tayyab Rashid, you may jump into learning how to solve data analytic problems, and how to understand machine learning, deep learning, and solution to problems in data analysis and then transfer your skills into learning Python, Machine learning, and other applicable areas on Udemy. Tayyab Rashid reveals the secrets of maths and Calculus underlying so many things in economics, technology development, etc. If you want to see it for yourself, you have an excellent opportunity to get such things explained by an experienced data scientist, researcher, and educator – Tayyab Rashid.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.