3.72 out of 5
3.72
77 reviews on Udemy

PostgreSQL Database Administration (DBA) for Beginners

Learn Practical Database Administration
Instructor:
Bluelime Learning Solutions
4,039 students enrolled
English [Auto-generated]
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

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 .

Installing PostgreSQL Server

1
Introduction
2
What is PostgreSQL
3
Who is using PostgreSQL
4
Minimum Installation Requirements
5
Installation versions (Please Read)
6
Installing PostgreSQL Server version10
7
Connecting to a PostgreSQL Database
8
Download and load Sample PostgreSQL Database
9
Download PostgreSQL version 9.6
10
Install PostgreSQL 9.6 on windows
11
Verify PostgreSQL 9.6 installation
12
Installing PostgreSQL 9.6 on Mac OS X
13
Connecting to PostgreSQL 9.6 database
14
Load sample database on PostgreSQL 9.6

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

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
Using ORDER BY clause
10
Grouping data with GROUP BY clause
11
Using HAVING clause
12
Truncating a table
13
Stored Procedures

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

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

PostgreSQL Table Joins

1
Introduction to Joins
2
INNER Join
3
LEFT Join
4
FULL OUTER Join
5
CROSS Join
6
NATURAL Join

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

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

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

PostgreSQL Triggers

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.7
3.7 out of 5
77 Ratings

Detailed Rating

Stars 5
28
Stars 4
13
Stars 3
20
Stars 2
6
Stars 1
10
026aa4dfb27599ef40f725a66f8ee25e
30-Day Money-Back Guarantee

Includes

11 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion