PostgreSQL Database Administration for Beginners - Full Course
Learn Practical Database Administration. PostgreSQL Database Administration (DBA) for Beginners. The skills and confidence to work with PostgreSQL .
Learn PostgreSQL - Full Course for Beginners
☞ https://morioh.com/p/bbbcd1d2654e
PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)
☞ https://morioh.com/p/dd5f7e14c5c8
SQL Tutorial for Beginners - Advanced SQL Tutorials
☞ https://morioh.com/p/1b62e45ab7c7
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.
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 #Morioh
Видео PostgreSQL Database Administration for Beginners - Full Course канала DataZ
Learn PostgreSQL - Full Course for Beginners
☞ https://morioh.com/p/bbbcd1d2654e
PERN Stack Course - Build a Yelp clone (Postgres, Express, React, Node.js)
☞ https://morioh.com/p/dd5f7e14c5c8
SQL Tutorial for Beginners - Advanced SQL Tutorials
☞ https://morioh.com/p/1b62e45ab7c7
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.
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 #Morioh
Видео PostgreSQL Database Administration for Beginners - Full Course канала DataZ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Learn the Basics of SQL using TeamSQL](https://i.ytimg.com/vi/LVD736VW5HI/default.jpg)
![Learn SQL Queries – Database Query Tutorial for Beginners](https://i.ytimg.com/vi/j-PwH5e9OHE/default.jpg)
![Learn Advanced SQL Tutorials](https://i.ytimg.com/vi/KTK4spSnfKw/default.jpg)
![Azure Databricks for Everyone: A Comprehensive Course (Part 1)](https://i.ytimg.com/vi/K6A564oWiG4/default.jpg)
![Redis Commands Tutorial for Beginners](https://i.ytimg.com/vi/drwjV9c2I4k/default.jpg)
![MongoDB Tutorial for Beginners](https://i.ytimg.com/vi/yxKxCooMceg/default.jpg)
![Databricks SQL: A Comprehensive Guide for Data Analysts (Part 2/2)](https://i.ytimg.com/vi/w0Qz-LbYatM/default.jpg)
![Learn SQL Injection: Perform Penetration Testing Step by Step](https://i.ytimg.com/vi/K7R0WgX6xMk/default.jpg)
![Introduction to Databases and SQL](https://i.ytimg.com/vi/uIk4gokqGPA/default.jpg)
![SQL Database Tutorial for Beginners - Full Course](https://i.ytimg.com/vi/ZllC-PWbMfQ/default.jpg)
![Database Fundamentals for Beginners - Full Course](https://i.ytimg.com/vi/vCZzKLtLj2g/default.jpg)
![SQL Tutorial for Data Analysis: Reporting and Analysis](https://i.ytimg.com/vi/6agiSo08vdc/default.jpg)
![What is GraphQL | GraphQL Tutorial for Beginners](https://i.ytimg.com/vi/1K2WNKUm7b4/default.jpg)
![Complete SQL Bootcamp for Data Science (Part 1/2)](https://i.ytimg.com/vi/ikYI4n76K0M/default.jpg)
![Getting Started with Oracle Autonomous Database](https://i.ytimg.com/vi/NrKjRNGT1N4/default.jpg)
![A Beginner's Guide to SQL](https://i.ytimg.com/vi/PAoNIR72AT4/default.jpg)
![MySQL Database Tutorial for Beginners - Full Course (Part 2/2)](https://i.ytimg.com/vi/wUOX-yOVs50/default.jpg)
![Advanced SQL Tutorial for Beginners](https://i.ytimg.com/vi/CxRU7uiQqBU/default.jpg)
![SQL for Data Science Tutorial | Learn SQL Database for Data Science](https://i.ytimg.com/vi/1_aAXpyaXMg/default.jpg)
![Amazon Relational Database Service (RDS) Tutorial for Beginners](https://i.ytimg.com/vi/qK3Rnxs4ceU/default.jpg)
![MongoDB Tutorial for Beginners - Full Course](https://i.ytimg.com/vi/GFaKsrfQkAc/default.jpg)