PostgreSQL Database Administration (DBA) for Beginners (Udemy.com)

Learn Practical Database Administration

( 93 Reviews )

Created by: Bluelime Learning Solutions

Produced in 2018

What you will learn

Install PostgreSQL Server
Load sample database
Create a database
Create a table
Insert data into tables
Update existing records inside a table
Delete Records in a table
Remove duplicate records
Query data from a table
Create a subquery
Get data from multiple tables
Create and manage roles
Create a view
Create tablespace
Backup and restore database
Filter and sort data
Use various operators
Use aggregate and analytic functions
Create triggers

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 64 / 100

Course Description

PostgreSQL is commonly known as Postgres and it is also open source database.
PostgreSQL is a powerful, open source object-relational database system.
A database administrator's (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.
The PostgreSQL administration covers some of the most important PostgreSQL database server administration activities.
Some of the Key Responsibilities of a Database Administrator includes:

Database Management
Database Backup and restore
Tablespace management
Role Management
Managing users
Securing database via proper role management

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database.
In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.
The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings.

Topics also includes:

Installing PostgreSQL
Loading sample database
Creating database and tables
Performing CRUD operations
Joining Tables
Using aggregate and analytic functions
Creating views and triggers

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

Who this course is for:

Beginner Database Administrators -DBA's
Beginner Data Scientist
Beginner Data Analyst

Time: 11.5h

Instructor Details

Bluelime Learning Solutions

3.2 Rating
93 Reviews

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW) (2021)
3.7 (260 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

17 Beginner C# Walkthrough Projects step by step

17 Beginner C# Walkthrough Projects step by step (2021)
3.9 (189 Reviews)

- Provider: Udemy
- Time: 17h

$11.99

Coding for beginners (2021)
4.0 (117 Reviews)

- Provider: Udemy
- Time: 22h

$11.99

Python and Django Full-Stack Web Development for beginners

Python and Django Full-Stack Web Development for beginners (2021)
4.3 (58 Reviews)

- Provider: Udemy
- Time: 34.5h

$11.99

Learn Java by building 17 projects step by step

Learn Java by building 17 projects step by step (2018)
3.6 (52 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

Full-Stack Web Development For Beginners

Full-Stack Web Development For Beginners (2021)
4.5 (50 Reviews)

- Provider: Udemy
- Time: 36.5h

$11.99

All courses by Bluelime Learning Solutions

Reviews

3.2

93 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Abhijit Mane on 12/27/2020

all Videos are blurred , very irritating to understand what is is teaching and understanding UI and commands.

By Malcolm Stewart on 12/6/2020

Felt like too much fluff and not enough substance, but will persist...

By Akom Brian on 11/6/2020

The course is amazing although I'm a little bit trapped with the clauses. But it has been an amazing experience so far

By Hareesh Kumar Reddy Vaddi on 10/23/2020

Good So far

By chakravarthi PATHRI on 10/16/2020

Was expecting still more on unix systems.
1. configuration
2. schemas
3. creating servers
Not covered well.

By Kunal Kumar on 10/16/2020

Nice content

By Tuan le on 10/10/2020

The teacher just followed the tutorial of postgre website. This course is for beginner and not have practice part at all. Anyway, it's good for anyone doesn't know anything of prostgreSQL.

By Sudheer kumar on 9/26/2020

it is very basic level course. not much useful. did not covered many DBA concepts like configuration variables, replication. advance backup options, architecture etc..

By Abhinav Srivastava on 9/21/2020

Very Good

By Joonas Ahola on 9/3/2020

Pretty good. Like others have said, way too much repetition especially in the beginning of the course. Good refresher of SQL for me, but I was more interested in the latter part of the course and the actual database administrator parts. It was pretty hard and tiring to listen to this teacher and it sounded like his voice was cracking and breaking. He should maybe drink some water before recording or something. Doesn't respond to messages/questions either.

By Donna Ward on 9/2/2020

yes. so far so good

By Peter Tan on 8/15/2020

Would like to see more example instead reading off definition. Also the pace of the course is too slow. I feel like I need a 4x or 6x speed when watching the video.