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)
Posted on Utopian.io - Rewarding Open Source Contributors