What Will I Learn?
In this video you will learn how to use The is null, is not null, upper and lower commands on tables created in the POSTGRE SQL Database.
You will learn to use is null and is not null using multiple terms.
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 be able to use some commands in more than one condition.
With this application, you will find rows that are missing column information in your existing table.In this video I've shown how to collect the numbers in the selected fields.
With this application, you will see that the text in your table will also change from uppercase to lowercase and from lowercase to uppercase.
Commands I Use
• İs null: Allows you to show blank rows in the table.
• İs not null: Allows you to show full rows in a table.
• Upper: The writings in the selected field in the table to uppercase converts.
• Lower: Converts the captions in the selected section of the table to lowercase.
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