PostgreSQL Database Administration (DBA) for Beginners
4.4 /5- Offered byUDEMY
PostgreSQL Database Administration (DBA) for Beginners at UDEMY Overview
Duration | 11 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
PostgreSQL Database Administration (DBA) for Beginners at UDEMY Highlights
- Install PostgreSQL Server
- Load sample database, create databases, tables, 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, view, tablespace, and triggers
- Get data from multiple tables, create and manage roles
- Backup and restore database, filter and sort data, and learn to use various operators
- Use aggregate and analytic functions
PostgreSQL Database Administration (DBA) for Beginners at UDEMY Course details
- Beginner Database Administrators -DBA's
- Beginner Data Scientist
- Beginner Data Analyst
- Installing PostgreSQL
- Loading sample database
- Creating database and tables
- Performing CRUD operations
- Joining Tables
- Using aggregate and analytic functions
- Creating views and 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.
- 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.
PostgreSQL Database Administration (DBA) for Beginners at UDEMY Curriculum
Install PostgreSQL Server
Introduction
What is PostgreSQL?
Who is using PostgreSQL
Minimum Installation Requirements
Installation versions (Please Read)
Installing PostgreSQL Server version10
Connecting to a PostgreSQL Database
Download and load sample PostgreSQL Database
Download PostgreSQL version 9.6
Install PostgreSQL 9.6 on windows
Verify PostgreSQL 9.6 installation
Installing PostgreSQL 9.6 on Mac OS X
Connecting to PostgreSQL 9.6 database
Load sample database on PostgreSQL 9.6
Exploring PostgreSQL Database Objects
Server Service
Database
Table
Schema
Tablespace
Views
Functions
Cast and Operators
Sequences
Extensions
PostgreSQL Fundamentals
Database Concepts
PostgreSQL Data Types
PostgreSQL Unique Constraint
Filtering Data using WHERE clause
Getting all data from a table
Getting data from a specific column
Removing duplicate records
Sorting data
Grouping data with GROUP BY clause
Using HAVING clause
Truncating a table
Stored Procedures
Performing CRUD Operations
Introduction
Create Database with pgadmin tool
Create Table with pgadmin tool
Create Table Statement
Using SELECT statement
Using a subquery
Using UPDATE Statement
Using DELETE statement
Using INSERT statement
PostgreSQL Operators
Comparison Operators
BETWEEN Operators
NOT BETWEEN Operators
LIKE operators
NOT operator
OR Operator
AND Operator
Combining AND & OR operators
LIMIT Operators
IN operator
UNION Operator
UNION ALL Operator
INTERSECT Operator
EXCEPT Operator
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?