What Will I Learn?
In this video you will learn how to use The distinct, avg, left, right and concat commands on tables created in the POSTGRE SQL Database. With these commands, you will learn to use the information in the database more efficiently. With these commands, you will see the information in the database reaching the desired result in less time.
Requirements
Your computer should be one of the following operating systems.
• Windows 32 - 64
• Linux
• MacOS
• The PostgreSQL program is required to run this application.
PostgreSQL download link: https://www.postgresql.org/download/
Difficulty
• Intermediate
Description
The content of this video includes the detailed use of PostgreSQL, a database management system.
This application will also see how the most commonly used commands work in the database created with postgre SQL.
With this application, you will see how to edit the data in the table. And you will see how to handle these data.
With this application, you will find the average of the column with numeric data.
With this application, you will see how to create a list by taking one from each type of information in a column.
With this application, you will see as much information as you want in the column you select.
With this application, you will see Adding information with a single code to the entire column of your choice.
Video Tutorial - English Language - 720p
Curriculum
• Creating and updating a database with PostgreSQL (TR)
• Associating two tables created in the database with PostgreSQL (TR)
• Associating 3 tables created in the database with PostgreSQL with primary key and Foreign key (TR)
• Create an application using with As, In, Like and Limit commands on the Postgresql database (ENG)
• Create an application using with Max, Min, Sum and Group By commands on the Postgresql database (ENG)
Posted on Utopian.io - Rewarding Open Source Contributors