Create an application using with Ceil, Floor, Greatest, Least, Mod, Pow and Sqrt commands on the Postgresql database

in #utopian-io7 years ago (edited)

What Will I Learn?
In this video you will learn how to use The ceil, floor, greatest, least, mod, pow and sqrt commands on tables created in the POSTGRE SQL Database. These commands are all about math. You'll learn how to do many mathematical operations. 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. In this video you will see how to do many mathematical operations.

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.
In this video you will see how to do many mathematical operations.
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 see how to complete the odd numbers in the selected column up or down.
You will find the largest and smallest of the numbers given by this application.
With this application you will find the rest of the partition process.
With this application, you will find the square or cube of a number that you want. You will also see the implementation of this operation to the columns.
With this application, you will find the square root of a number that you want. You will also see the implementation of this operation to the columns.

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)

Create an application using with İs Null, İs Not Null, Upper and Lower commands on the Postgresql database (ENG)

Create an application using with Substring, Length, Round and Replace commands on the Postgresql database (ENG)

Create an application using with Distinct, Avg, Left, Right and Concat commands on the Postgresql database (ENG)

GitHub Address Of Application



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Güzel ve bilgilendirici

teşekkür ederim

Your contribution cannot be approved because it does not follow the Utopian Rules.

Hi, this is the reason your contribution was rejected

  • Tutorials must be technical instructions that teach non-trivial aspects of an open-source project. Everything in this tutorial is very trivial and of little to no value - the use of simple commands that you show in all your videos, like ceil(), are already extremely straight-forward and well documented. It is also not unique to PostgreSQL and ubiquitous. Moreover the linked repository for all your PostgreSQL tutorials is a development repository for the PostgreSQL cookbook, I'm pretty sure the correct repository is this one instead.

I recommend you stop making SQL tutorials where you pick 4-6 simple commands and execute them, as they will not be accepted since they are too trivial. Try to think of something that will be considered a valuable contribution to Utopian.io.

You can contact us on Discord.
[utopian-moderator]

you're making the conditions difficult so we don't make a project. utopian won't be able to find anyone to do the project soon.