A cikin wannan labarin za ku koya yadda ake ƙirƙirar tebur a pgAdmin, Mai sarrafa bayanan PostgreSQL wanda ke ba ku damar tsarawa da sarrafa bayanan ku ta hanya mai sauƙi. Ƙirƙirar teburi mataki ne na asali yayin aiki tare da bayanan bayanai, tunda shine inda zaku adana da tsara bayanan a cikin aikace-aikacenku. Tare da pgAdmin, wannan tsari yana da sauri kuma mai sauƙi, kuma a cikin wannan labarin za mu jagorance ku mataki-mataki don ku iya sarrafa wannan kayan aiki a cikin lokaci kaɗan.

- Mataki-mataki ➡️ Yadda ake ƙirƙirar tebur a pgAdmin?

• Mataki na 1: Bude pgAdmin akan kwamfutarka.
• Mataki na 2: A cikin kayan aiki, danna maɓallin "Sabuwar Tambaya" don buɗe sabuwar taga tambaya.
• Mataki na 3: A cikin sabuwar taga tambayar, rubuta lambar SQL mai zuwa don ƙirƙirar tebur:
• Mataki na 4: ƘIRƘIRA TEBURI table_name (
  sunan shafi na 1 nau'in bayanai,
  sunan shafi na 2 nau'in bayanai,
  …
  );
• Mataki na 5: Sauya sunan_table_name tare da sunan da kuke so don teburin ku kuma sunan shafi na 1 nau'in bayanai tare da suna da nau'in bayanai na ginshiƙin farko na teburin ku.
• Mataki na 6: Ci gaba da maye gurbin sunan shafi na 2 nau'in bayanai tare da suna da nau'in bayanan sauran ginshiƙan teburin ku, raba su ta waƙafi.
• Mataki na 7: Da zarar ka rubuta lambar don ƙirƙirar tebur, danna maɓallin "Run" a cikin kayan aiki don gudanar da tambaya.
• Mataki na 8: Shirya! An ƙirƙiri teburin ku a cikin pgAdmin.

Tambaya da Amsa

Tambayoyin da ake yawan yi game da Yadda ake Ƙirƙirar Tebura a cikin pgAdmin

1. Yadda ake samun damar pgAdmin?

1. Buɗe burauzar yanar gizonku.
2. Shigar da pgAdmin URL.
3. Shiga tare da bayanan mai amfani.

2. Yadda ake ƙirƙirar bayanai a pgAdmin?

1. Zaɓi uwar garken da kake son haɗawa da shi.
2. Dama danna kan "Databases".
3. Zaɓi "Create" sannan kuma "Database".

3. Yadda ake buɗe tambaya a pgAdmin?

1. Zaɓi rumbun adana bayanai da kuke son gudanar da tambayar a kai.
2. Dama danna kuma zaɓi "Tambaya Tool".
3. Fara rubuta tambayar SQL ɗinku a cikin edita.

4. Yadda ake ƙirƙirar tebur a pgAdmin ta amfani da SQL?

1. Bude tambaya a cikin editan pgAdmin.
2. Buga umarnin CREATE TABLE sannan sunan tebur da sunayen ginshiƙai da nau'ikan bayanai.
3. Gudanar da tambaya don ƙirƙirar tebur.

5. Yadda ake shigar da bayanai a cikin tebur a pgAdmin?

1. Bude teburin da kake son ƙara bayanai zuwa gare shi.
2. Danna "Duba Data" sannan "Duk Layukan".
3. Shigar da bayanai a cikin sel masu dacewa.

6. Yadda za a share tebur a pgAdmin?

1. Zaɓi teburin da kake son gogewa a cikin bishiyar abu.
2. Dama danna kuma zaɓi "Drop."
3. Tabbatar da gogewar tebur.

7. Yadda ake kwafi tebur a pgAdmin?

1. Dama danna kan teburin da kake son kwafa.
2. Zaɓi "Rubutun" sannan "KIRKIYAR Rubutun."
3. Gudanar da rubutun don ƙirƙirar kwafin tebur.

8. Yadda za a gyara tebur a pgAdmin?

1. Zaɓi teburin da kake son gyarawa.
2. Dama danna kuma zaɓi "Properties".
3. Yi canje-canjen da ake so a cikin taga kaddarorin tebur.

9. Yadda ake nemo tsarin tebur a pgAdmin?

1. Dama danna kan teburin da kake son shawara.
2. Zaɓi "Rubutun" sannan "KIRKIYAR Rubutun."
3. Duba rubutun don ganin tsarin tebur.

10. Yadda ake fitarwa tebur daga pgAdmin?

1. Dama danna kan teburin da kake son fitarwa.
2. Zaɓi "Ajiyayyen..." kuma zaɓi zaɓin fitarwa da ake so.
3. Fitar da tebur bisa ga abubuwan da kuke so.