Learn Database Administration – PostgreSQL Database Administration (DBA) for Beginners

Learn Database Administration – PostgreSQL Database Administration (DBA) for Beginners
How to Build a Docker Image with MySQL Database
☞ https://morioh.com/p/d8d9e7732952

Secure Node.js, Express.js and PostgreSQL API using Passport.js
☞ https://morioh.com/p/1735531bc3d6

Full-Stack React-App on AWS with PostgreSQL Database
☞ https://morioh.com/p/837ce503dc26

In this video, 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

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

#postgresql #database #administration

Originally published by Gandhi Kumarasamy Sezhian at Udemy
—————————————————-
Social Network for Developers: http://bit.ly/2TFv1y0
Learn Startup: http://bit.ly/2UDotMN
Fanpage: http://bit.ly/2O7RNIB