Membuat tabel ritel

Tim pengembangan bisnis melihat peluang untuk meningkatkan pendapatan di setiap gym dengan menambahkan area ritel. Di toko dalam gym ini, mereka akan menjual barang seperti handuk, sepatu sneakers, dan minuman. Untuk melacak barang yang dijual, mereka memerlukan tabel baru dalam skema CORE_GYM. Untuk membuat tabel ini, mereka datang kepada Anda. Tunjukkan kemampuan Anda!

Latihan ini adalah bagian dari kursus

Tipe Data dan Fungsi di Snowflake

Petunjuk latihan

Buat bidang numerik transaction_id dengan precision 16 dan scale 0.
Definisikan pre_tax_amount sebagai NUMBER yang dapat memiliki dua digit di sebelah kanan tanda desimal dan total 6 digit.
Sertakan kolom tax_rate yang dapat menyimpan angka seperti 28.625; total 5 digit dengan 3 digit di sebelah kanan tanda desimal.

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

CREATE OR REPLACE TABLE retail (
  	-- transaction_id stores 16 total digits with 0 right of the decimal point
    ___ NUMBER(16, 0),
  	-- pre_tax_amount stores up to 6 digits with 2 right of the decimal point
    ___,
  	-- tax_rate stores up to 5 digits with 3 right of the decimal point
    ___,
    transaction_total NUMBER(6, 2)
);

Edit dan Jalankan Kode

Latihan ini adalah bagian dari kursus

Tipe Data dan Fungsi di Snowflake

SkillTag.level.intermediateSkillTag.label

4.9+

Mulai Kursus Gratis

Before you can change the world using Snowflake, you need to know the type of data you'll be working with. You'll start with text data, learning to use it in queries and define columns, plus discover how to retrieve column details from any table. Then you'll master numeric data types and date/time data, understanding precision, scale, and how to convert strings to timestamps.

Exercise 1: Tipe data teks Exercise 2: Apakah itu data teks?Exercise 3: Berolahraga di kota besar Exercise 4: Mendefinisikan data teks Exercise 5: Tipe data numerik Exercise 6: Pilih FLOAT Exercise 7: Membuat tabel ritel

Latihan Saat Ini

Exercise 8: Tipe data tanggal/waktu Exercise 9: Membangun nilai datetime Exercise 10: Zona waktu yang mana?Exercise 11: Kapan Anda check-in?

Now that you know your Snowflake data inside-and-out, it's time to manipulate and transform it. You'll begin with text data manipulation using TRIM, SPLIT, and CONCAT, then master numeric operations like arithmetic and summary measures with SUM and AVG. You'll explore timestamp transformations by extracting components like year or hours, calculating intervals between dates, and create your own custom Snowflake functions (UDFs) to implement personalized logic.

Exercise 1: Manipulating text data Exercise 2: Managing display length Exercise 3: Transforming text data Exercise 4: Motivating member marketing Exercise 5: Numeric calculations Exercise 6: Comparison operators Exercise 7: Adjusting membership prices Exercise 8: What burns more calories?Exercise 9: Manipulating datetime data Exercise 10: Breaking down a timestamp Exercise 11: How long were you at the gym?Exercise 12: Making appointments Exercise 13: User-defined functions in Snowflake Exercise 14: Creating your own Snowflake function Exercise 15: Ranking gym members by efficiency

In this final chapter, you'll crank the heat up with Snowflake's more advanced functionality. You'll start with VARIANT data types (semi-structured data), learning to parse top-level and nested data using dot-notation and bracket-notation, then master common table expressions (CTEs) by building and using multiple CTEs. Finally, you'll wrap up by creating pivoted tables using the PIVOT keyword to transform data into an easy-to-digest format, ready for reports and analysis.

Exercise 1: Flattening Semi-Structured Data Exercise 2: Retrieving nested data Exercise 3: Working with personal info Exercise 4: Building a gym member description Exercise 5: Multiple common table expressions Exercise 6: Identifying high-performers Exercise 7: Comparing senior workouts Exercise 8: Pivoting Data Exercise 9: Evaluating workout length Exercise 10: Is CrossFit a popular workout?Exercise 11: Which workouts burn the most calories?Exercise 12: Congratulations!