Create an application using with İs Null, İs Not Null, Upper and Lower 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 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)

GitHub Address Of Application



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

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

Thank you..

good articles that should be published. I ask permission to resteem your post

Thank you. you can resteem, of course.

İlaç gibi paylaşım.Tamda bugünlerde postgresql çalışıyorum.Benim için iyi oldu.Aslında belkide geç kaldım artık no sql konuşulmaya başladı insanlar.

teşşekkür ederim. Geç kalmadın sql programlarının birçoğu rahatlıkla kullanılabilir.

You got a 4.52% upvote from @whalebuilder courtesy of @omur61. Join @whalebuilder family at our Discord Channel. Don't let your precious stake(SP) go stale...Make it do more so you have to do less. Deligate it to @whalebuilder by clicking on one of the ready to delegate links: 50SP | 100SP | 250SP | 500SP | 1000SP | 5000SP | custom amount.

Hey @omur61 I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

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

Good post 😎

Thank you