Create an application using with Max, Min, Sum and Group By commands on the Postgresql database
What Will I Learn?
In this video you will learn how to use The max, min, sum and group by commands on tables created in the POSTGRE SQL Database.
You will learn how to use the sum and group by command together.
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. You will also see the names of the cells shown with the commands.
With this application, you will find the maximum and minimum values of the selected fields. You will see naming the maximum and minimum values.
Commands I Use
• Max: You can use the max command to calculate the maximum value of the selected cells.
• Min: You can use the Min command to find the minimum value in the selected cells.
• Sum: With the Sum command, you will find the total value of the selected cells.
• Group By: The Group by command allows you to see the cells associated with each other together.
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)
• Max, Min, Sum and Group By commands (ENG)
Posted on Utopian.io - Rewarding Open Source Contributors
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Thank you..
Güzel bir paylaşım olmuş .
teşekkür ederim.
güzel paylaşım teşekkür ederim
beğenmene sevindim
Hey @omur61 I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x