$19.99 | Created by Vaga Notes | Last updated 8/2019Duration: 2 hours | Video: h264, 1280×720 | Audio: AAC, 44 KHz, 2 Ch | 1.8 GBGenre: eLearning | Language: English + Sub | 37 lecturesWhat you’ll learnSignin and Signup into SnowFlakeFamiliarize yourself with the SnowFlake UISetup the Comand Line Client of SnowFlakeFigure out your account name (Yes, this can be tricky)SnowFlake ArchitectureHow to create databases, tables and warehousesLoad data into a table using a CSVQuery Data using the Command Line ClientLearn how to use the different SnowFlake DataTypes, Numbers, Boolean, String etc.
Manage Permissions in SnowFlake, work with roles, privileges and usersRequirementsAn Internet connectionA working Computer with either Windows/MacOS or LinuxA desire to learn and Crush It!Elementary knowledge of SQL can help you, but not neededDescriptionTired of having insufficient resources when you need them? Tired of managing servers and planning wayyyy in advance to storage and computation power? Welcome to SnowFlake.
Whether you are a Software Architect looking for a way to switch over you’re conventional databases to the cloud or a developer looking for a one stop shop to manage your entire data storage and computation framework SnowFlake is the solution for you.
It’s layered architecture gives it unique advantages which make it one of the best cloud database hosting platforms out there.
You will get a quick grasp on SnowFlake.
It is one of the best set of cloud database storage tools out there, with the ability to design and develop scalable databases for free.
Everything is well documented and separated, so you can find what you need.
Assignments and Quizzes will make sure you stay on track and test your knowledge.
The course will have a combination of theory and practical examples.
\nIntroductionSign In and Signup for SnowFlake.
Get Familiar with the User Interface, so it doesn’t look like a strange land to you as we continue on our journey.
Setting up the Command LineInstall and Setup SnowFlake on the command line.
Learn how to use some basic commands.
In order to sign up you will need your account name, which we will help you figure out.
SnowFlake ArchitectureUnderstand why we use SnowFlake, the multi tier architecture which gives SnowFlake an edge over traditional DataWarehousing.
SnowFlake uses the SAAS methodology, understand what that means and how it compares to it’s competitors.
(PAAS and IAAS).
Net Session 1Ready to do your drills? Delve right into the heart of SnowFlake.
Login, create databases and tables for your use.
Create warehouses for computation power, which is flexible and scalable.
Create a CSV file with some sample data, which you will load and query from in a database.
Data TypesFirst familiarize yourself with why we use datatypes and what they are.
Then use them while creating tables and inserting data.
Everything from Strings, Numbers to Boolean types.
Roles and PermissionsPermissions in SnowFlake are governed by roles and privileges.
Create roles, and users and assign privileges to them.
\n\n\n\n\n\nWho this course is for:Students trying to get a quick grasp of SnowFlakeDevelopers looking to learn Cloud Computing and SnowFlakeDevelopers and Software Architects who have used another tool to store their data and are now looking to move over to SnowFlakeDevs looking to store data on a SAAS platform like SnowFlake
