--> Skip to main content

PostgreSQL Database Administration (DBA) for Beginners

postgresql-database-administration-dba-for-beginners

PostgreSQL Database Administration (DBA) for Beginners - 
Learn Practical Database Administration

  • Created by Bluelime Learning Solutions
  • English [Auto]

Preview this Course GET COUPON CODE


What you'll 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

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

100% Off Udemy Coupon . Free Udemy Courses . Online Classes
Comment Policy: Please write your comments that match the topic of this page post. Comments containing links will not be displayed until they are approved.