Learn Practical Database Administration
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 .
Install PostgreSQL Server
Load sample database
Create a database
12 Lectures
10 Lectures
13 Lectures
9 Lectures
14 Lectures
6 Lectures
10 Lectures
8 Lectures
5 Lectures
8 Lectures
6 Lectures
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.At Bluelime Learning Solutions, our approach is simple:...
Good for learning
straight to the point
repetitive and slow
The course is best suited for beginners (but not for aspiring DBAs) and it's neatly organized in relevant sections. It is concise and on point.
Improvement -
1. Repetition - In the first few sections, at the beginning of each video, the instructor repeatedly shows how to connect DB and get to the tables. Just irritating and wasting time.
2. Instead of PGADMIN instructor should have used a PSQL CLI tool. It is far better when it comes to efficiency and managing multiple DB clusters.
Just basic introduction about Postgres is given.
Good experience
Dobrze poprowadzony kurs. Wyraźny język angielski lektora. Polecam
good
I left this rating because it served the purpose that I made the subscription, however it didn’t cover much on Mac operations. It’s difficult to practice all on mac. Some functions didn’t work on mac. It can be better. Every other thing was very great. Nice lecture and great content.
Your email address will not be published. Required fields are marked *
Benedict A.
very informative