Tabel apa saja yang ada di database Anda?

Anda tidak harus hanya mengandalkan pengetahuan tentang tabel apa saja yang ada. Sebagai gantinya, Anda dapat melakukan kueri pada pg_catalog.pg_tables untuk membuat daftar semua tabel yang ada di database Anda.

Tentu saja, ini akan mencantumkan setiap tabel, termasuk tabel sistem, jadi idealnya Anda ingin membatasi hasil pada skema tempat data Anda berada, yang dalam kasus ini adalah 'public'.

Catatan: Tabel sistem ini khusus untuk PostgreSQL, tetapi tabel serupa ada untuk database lain (lihat slide).

Latihan ini adalah bagian dari kursus

Menerapkan SQL pada Masalah Dunia Nyata

Petunjuk latihan

Daftarkan tabel-tabel yang ada di database Anda dengan melakukan kueri pada tabel: pg_catalog.pg_tables.
Saring kueri agar hasilnya hanya memuat entri dengan schemaname bernilai 'public'.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

SELECT * 
FROM ___
___;

Edit dan Jalankan Kode

Latihan ini adalah bagian dari kursus

Menerapkan SQL pada Masalah Dunia Nyata

SkillTag.level.intermediateSkillTag.label

4.9+

Mulai Kursus Gratis

You will review some of the most commonly used SQL commands to ensure you are prepared to tackle both real-world problems as well as every exercise covered in this course.

Exercise 1: Essential SQL Exercise 2: Review the essentials Exercise 3: Practice the essentials Exercise 4: Transforming your results Exercise 5: Transform numeric & strings Exercise 6: Extract what you need Exercise 7: Working with aggregate functions Exercise 8: Aggregating finances Exercise 9: Aggregating strings Exercise 10: Which tables?

How do you find the data you need in your database in order to answer real-world business questions? Here you will learn how to use system tables to explore your database. You will use these tables to create a new tool that contains a list of all tables and columns in your database. Finally, you will create an Entity Relationship Diagram (ERD) which will help you connect multiple tables.

Exercise 1: Temukan tabel yang tepat Exercise 2: Membatasi pencarian Anda dengan LIMIT Exercise 3: Tabel mana yang digunakan?Exercise 4: Tabel apa saja yang ada di database Anda?

Latihan Saat Ini

Exercise 5: Tentukan pendapatan bulanan Exercise 6: Gabungkan tabel yang benar Exercise 7: Kolom apa saja yang ada di basis data Anda?Exercise 8: Sebuah VIEW untuk semua kolom Anda Exercise 9: Menguji VIEW baru Anda Exercise 10: Rata-rata durasi film menurut kategori Exercise 11: Join yang kompleks Exercise 12: Bangun diagram hubungan entitas Exercise 13: Film mana yang paling sering disewa?

Working with SQL to solve real-world problems will oftentimes require you to do more than retrieve the data you need, oftentimes you will need to manage the data in your database. This includes creating data, updating it and, when necessary, deleting it.

Exercise 1: Store your data Exercise 2: Storing new data Exercise 3: Using existing data Exercise 4: TABLE vs VIEW Exercise 5: Update your data Exercise 6: What should you modify?Exercise 7: Update the price of rentals Exercise 8: Updated based on other tables Exercise 9: Delete your data Exercise 10: Deleting all table data Exercise 11: Delete selected records Exercise 12: A family friendly video store

How do you ensure that the SQL scripts you write will be easy to understand for anyone who needs to read them? This chapter will cover approaches you can leverage to ensure that your code clearly conveys your intent, is readable by others and follows best practices.

Exercise 1: Convey your intent Exercise 2: How to convey our intent Exercise 3: Clarify the intent of this query Exercise 4: Fix this query - intent Exercise 5: Write readable code Exercise 6: How to make code easier to read Exercise 7: Make this query easier to read - Part I Exercise 8: Make this query easier to read - Part II Exercise 9: Avoid common mistakes Exercise 10: What are the don'ts of writing SQL code?Exercise 11: Apply best practices to your code Exercise 12: Recap