Courses
Web Development
Business
Design
Marketing
IT & Software
Photography
Music
View All Courses
Log in Sign Up
Call us
800 388 80 90
329 Queensberry Street,
North Melbourne VIC 3051, Australia.
hi@educrat.com
Popular Categories
Web Development Data Science Design Business Marketing Programming
image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659
Log in Sign up
Home
All courses
PostgreSQL Database Administration (DBA) for Beginners
PostgreSQL
Development
Database Design & Development

PostgreSQL Database Administration (DBA) for Beginners

Learn Practical Database Administration

4.5
(519)
5933 enrolled on this course
Last updated 11/2021
None
image
₹ 2499.0
₹ 3999.0
Buy Now
30-Day Money-Back Guarantee
Lessons
20
Quizzes
3
Duration
13 Hours
Skill level
Beginner
Language
English
Certificate
Yes
Full lifetime access
Yes

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

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Installing PostgreSQL Server
12
1.1-Introduction
1.2-What is PostgreSQL
1.3-Who is using PostgreSQL
1.4-Minimum Installation Requirements
1.5-Installation versions (Please Read)
1.6-Installing PostgreSQL Server version10
1.7-Installing PostgreSQL on MacOS
1.8-Installing PgAmin on MacOS
1.9-Installing PostgreSQL on Linux
1.10-Installing PgAmin on Linux
1.11-Connecting to a PostgreSQL Database
1.12-Download and load Sample PostgreSQL Database
2-Exploring PostgreSQL Database Objects
10
2.1-Server Service
2.2-Database
2.3-Table
2.4-Schema
2.5-Tablespace
2.6-Views
2.7-Functions
2.8-Cast and Operators
2.9-Sequences
2.10-Extensions
3-PostgreSQL Fundamentals
13
3.1-Database Concepts
3.2-Please Note
3.3-PostgreSQL Data Types
3.4-PostgreSQL Unique Constraint
3.5-Filtering Data using WHERE clause
3.6-Getting all data from a table
3.7-Getting data from a specific column
3.8-Removing duplicate records
3.9-Sorting data
3.10-Grouping data with GROUP BY clause
3.11-Using HAVING clause
3.12-Truncating a table
3.13-Stored Procedures
4-Performing CRUD operations
9
4.1-Introduction
4.2-Create Database with pgadmin tool
4.3-Create Table with pgadmin tool
4.4-Create Table Statement
4.5-Using INSERT statement
4.6-Using SELECT statement
4.7-Using a subquery
4.8-Using UPDATE Statement
4.9-Using DELETE statement
5-PostgreSQL Operators
14
5.1-Comparison Operators
5.2-BETWEEN Operators
5.3-NOT BETWEEN Operators
5.4-LIKE operators
5.5-NOT operator
5.6-OR Operator
5.7-AND Operator
5.8-Combining AND & OR operators
5.9-LIMIT Operators
5.10-IN operator
5.11-UNION Operator
5.12-UNION ALL Operator
5.13-INTERSECT Operator
5.14-EXCEPT Operator
6-PostgreSQL Table Joins
6
6.1-Introduction to Joins
6.2-INNER Join
6.3-LEFT Join
6.4-FULL OUTER Join
6.5-CROSS Join
6.6-NATURAL Join
7-PostgreSQL Aggregate Functions
6
7.1-Introduction to Aggregate Functions
7.2-AVG Aggregate Functions
7.3-COUNT Aggregate Functions
7.4-MAX Aggregate Functions
7.5-MIN Aggregate Functions
7.6-SUM Aggregate Functions
8-PostgreSQL Analytic Functions
10
8.1-Introduction to Analytic Functions
8.2-Creating Sample Tables
8.3-Using AVG as window function
8.4-ROW Number functions
8.5-RANK Functions
8.6-DENSE RANK Functions
8.7-First Value Function
8.8-LAST Function
8.9-LAG Function
8.10-LEAD Function
9-PostgreSQL Views
8
9.1-Introduction to views
9.2-Benefits of using views
9.3-Creating a view
9.4-Modifying and removing views
9.5-Updatable View
9.6-Creating Updatable Views
9.7-Materialized Views
9.8-Creating a materialized view
10-PostgreSQL Triggers
5
10.1-Introduction to triggers
10.2-Creating your first trigger - part 1
10.3-Creating your first trigger - part 2
10.4-Creating your first trigger - part 3
10.5-Managing triggers
11-PostgreSQL Role Management
8
11.1-Introduction
11.2-Database Role
11.3-Role Attributes
11.4-Role membership
11.5-Group and user role inheritance
11.6-Removing Roles
11.7-Default Roles
11.8-Defining a role
12-PostgreSQL Database Backup and Restore
6
12.1-Introduction
12.2-Backing up a single database using pg_dump
12.3-Backing up a single database using pgadmin
12.4-Restoring a PostgreSQL Database
12.5-Restoring a database using pgrestore
12.6-Restoring a database using pgadmin
13-Tablespace Management
5
13.1-Introduction
13.2-Creating a tablespace
13.3-Changing a tablespace
13.4-Deleting Tablespace
13.5-Thank You

You May Like

10,000+ unique online course list designs

SQL Masterclass: SQL for Data Analytics
4.5
(13816)
SQL Masterclass: SQL for Data Analytics
icon
54 lessons
icon
N/A
icon
Beginner
S.A
Start-Tech Academy
$3999.0
$3999.0
Intro To PostgreSQL Databases With PgAdmin For Beginners
4.5
(6490)
Intro To PostgreSQL Databases With PgAdmin For Beginners
icon
2 lessons
icon
N/A
icon
Beginner
J.E
John Elder
$2699.0
$2699.0
Learn The Basics of PostgreSQL For Beginners
4.4
(52)
Learn The Basics of PostgreSQL For Beginners
icon
10 lessons
icon
N/A
icon
Beginner
U
Unknown
$1499.0
$1499.0