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

What Will I Learn?
In this video you will learn how to use The substring, length, round and replace commands on tables created in the POSTGRE SQL Database. With these commands, you will learn to use the information in the database more efficiently.

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 the information in the table in a different way. And you will see the section you want to display in the table.

With this application, you will see the full number of fractional data.
with this application, you will find out how many characters of the information in the column you want.

Commands I Use
• Substring: Shows the information in the column by limiting it.
• Length: Finds the number of characters of the information in the column.
• Round: Counts the fractional numbers as integers.
• Replace: Allows you to display the contents of the data that we have specified in the table differently.

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)

GitHub Address Of Application

---

Posted on Utopian.io - Rewarding Open Source Contributors

---