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.

Text data types

Is that text data?

Working out in the big city

Defining text data

Numeric data types

Go with the FLOAT

Creating a retail table

Datetime data types

Building datetime values

Which timezone?

When did you check in?

Data types

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.

Memanipulasi data teks

Mengelola panjang tampilan

Mengubah data teks

Memotivasi pemasaran anggota

Perhitungan numerik

Operator perbandingan

Menyesuaikan harga keanggotaan

Mana yang membakar lebih banyak kalori?

Memanipulasi data datetime

Memecah sebuah timestamp

Berapa lama Anda berada di gym?

Menjadwalkan janji

Fungsi yang ditentukan pengguna di Snowflake

Membuat fungsi Snowflake Anda sendiri

Memeringkat anggota gym berdasarkan efisiensi

Manipulating Data

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.

Flattening Semi-Structured Data

Retrieving nested data

Working with personal info

Building a gym member description

Multiple common table expressions

Identifying high-performers

Comparing senior workouts

Pivoting Data

Evaluating workout length

Is CrossFit a popular workout?

Which workouts burn the most calories?

Congratulations!

Advanced Snowflake techniques

Kuasai dasar-dasar Snowflake, dimulai dari tipe data. Anda akan memahami berbagai tipe data yang dapat disimpan oleh Snowflake, serta operasi yang dapat dilakukan pada data tersebut. Setelah memahami berbagai tipe data Snowflake, Anda akan mulai memanipulasi dan mentransformasi data dengan fungsi seperti TRIM, AVG, SUM, dan DATEDIFF. Anda bahkan akan mendefinisikan fungsi Anda sendiri untuk menyesuaikan dan memperlancar manipulasi data.

Setelah Anda nyaman memanipulasi dan mentransformasi data, Anda akan menambahkan beberapa alat praktis ke dalam peranti kerja Anda. Anda akan mempelajari cara terbaik untuk meratakan data semi-terstruktur dan membangun multiple common table expressions. Sebelum menuntaskan kursus ini, Anda akan menguasai teknik memutar (pivot) data di Snowflake.

Data Manipulation in Snowflake

Pelajari tipe data dan fungsi Snowflake untuk mengolah teks, angka, dan tanggal.

Tipe Data dan Fungsi di Snowflake

Pelajari tipe data dan fungsi Snowflake untuk memanipulasi teks, angka, dan tanggal saat membangun fungsi kustom dan tabel pivot.

Associate Data Engineer di Snowflake

Operator perbandingan

Tipe Data dan Fungsi di Snowflake

Latihan interaktif langsung