From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,800 courses taught by industry experts.
Databases and schemas: Part 2 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Databases and schemas: Part 2
- In the last video, we started learning about databases and schemas. This would probably be a much more exciting and mysterious video if we were about to cover databases and schemes, but I think you'll find that schemas are exciting and mysterious in their own way. Let's get back to it, and start putting our knowledge into practice. (graphics swooshing) Okay, now it's time to exercise our database and schema muscles. First, we'll create a database using the UI. Go to the data tab in the left hand menu, click databases, and then click plus database. We'll name the database test database, and click create. Now we can see the new database. And if we click on it and then click on schemas, we'll see it only has the two schemas that you automatically get when you create any database, public and information schema. Now, let's drop this database by clicking the three dots at the top and selecting drop. If we refresh our screen, we'll see it's gone. We can do all of those things through…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.