Snowflake Hands-on Essentials Series Part 2 - Collaboration, Marketplace and Cost Estimation

Why should you take Snowflake Hands-on Essentials SeriesPart 2 - Collaboration, Marketplace and Cost Estimation course?

At the end of this course, the learner will be able use Snowflake to:

• Browse the Snowflake Marketplace and gain access to data sets offered by data providers.
• Create data shares and make them available to other Snowflake Accounts.
• Use the Organizational Admin role to create and manage Snowflake Accounts.
• Estimate and control Snowflake costs.
• Use a wide range of basic SQL DML commands.
• Write and run a User Defined Table Function (UDTF).

Who should take Snowflake Hands-on Essentials SeriesPart 2 - Collaboration, Marketplace and Cost Estimation course?

• Designed for people new to Snowflake or new to database work in general. The course can be used by managers who simply want to understand what Snowflake is generally capable of, or it can be used by those considering a career or as a data professional. Likewise, seasoned data professionals find the courses in this series a quick and easy introduction to tasks they are already familiar with, in a tool they are not.

Curriculum for the Snowflake Hands-on Essentials SeriesPart 2 - Collaboration, Marketplace and Cost Estimation Course

• Data Sharing and Collaboration:
  • Exploring Snowflake's data sharing capabilities.
  • Creating and managing data listings through Provider Studio.
  • Utilizing shared data from other Snowflake accounts.
  • Understanding how to share data with business partners.
  • Working with inbound shares.
  • Practical exercises on how to combine local and shared data.
• Snowflake Marketplace:
  • Navigating and utilizing the Snowflake Marketplace.
  • Discovering and accessing data sets from various providers.
  • Integrating Marketplace data into existing workflows.
  • Combining Marketplace data with internal data for analysis.
  • Practical application of adding free data sets from data providers, and combining that data with local data.
• Cost Estimation and Optimization:
  • Understanding Snowflake's cost categories.
  • Implementing cost control measures using Resource Monitors.
  • Analyzing and monitoring Snowflake costs.
  • Learning cost estimation techniques.
  • Practical application of setting up resource monitors, and understanding cost implications of different actions.

Tools you will learn in Snowflake Hands-on Essentials SeriesPart 2 - Collaboration, Marketplace and Cost Estimation course

• Set Name and image on Account User Profile.
• Drop a database.
• Use the Shared Data menu to “get” a share and add it to your account.
• View databases coming from shares and their origins on the Shared Data page.
• Use the ALTER command to rename a database.
• Create and rename a worksheet.
• Use the Place Name in Editor shortcut.
• Grant Imported Privileges on a Shared database.
• Export data into a .csv file.
• Troubleshoot permission-related missing objects.
• View usage of SQL DISTINCT, GROUP BY and ORDER BY.
• Set your user’s default role.
• Check a Role’s access to warehouses.
• Grant Usage privileges on a warehouse to a given role.
• Set your user’s default warehouse.
• Create a local database named UTIL_DB.
• Given the code, create an API Integration.
• Given the code, create a user-defined function.
• Use the SHOW command with the IN ACCOUNT clause.
• Given a cloud, region, and web tool, find the cost per credit.
• Navigate the to Cost Mgmt page within Snowflake UI and find credits used.
• Using the web tool and Cost Mgmt page, convert cost per credit x credits used to a dollar amount.
• Create INTL_DB (code provided).
• Create INTL_WH (cp).
• Create the INT_STDS_ORG_3166 table (cp).
• Create File Format UTIL_DB.PUBLIC.PIPE_DBLQUOTE_HEADER_CR (cp).
• Write and run a COPY INTO to load the table.
• Create the Currencies table (cp).
• Create the Country to Currency mapping table (cp).
• Create File Format UTIL_DB.PUBLIC.CSV_COMMA_LF_HEADER (cp).
• Load the tables.
• CHALLENGE LAB: Create a view with name, column headers and example data given.
• Use SQL ALTER TABLE…RENAME TO.
• Use SQL TRUNCATE.
• Using the web tool and Cost Mgmt page, convert cost per credit x credits used to a dollar amount.
• Use OrgAdmin role to create a second account in the Trial org.
• Switch between two Snowflake Accounts.
• CHALLENGE: Modify profile settings.
• Create a data listing with daily replication.
• Get a Private Share sent to your account.
• Add a Data Dictionary to a Listing.
• Add a Sample query to a listing.
• Convert a standard view to a secure view.
• Edit a Share.
• Use the Cost Mgmt Page of the App to explore cost by account, by service and by usage type.
• Use the Cost Mgmt Page to view usage subtypes (color coded).
• Given an Edition, Cloud and Region, find the cost per month for a terabyte of data.
• Given an Edition, Cloud and Region, find the cost per credit.
• Given a cost per credit, warehouse size and number of hours, find the cost accrued.
• Create a Resource Monitor at the Account Level.
• Create a Resource Monitor at the Warehouse Level.
• View Usage Categories and other cost related information.
• Use the Snowflake Data Marketplace to find a listing.
• Use the Snowflake Data Marketplace to “get” a listing.
• Explore a database added to your account via a Data Marketplace listing.
• BASIC SQL PRACTICE:
• Use the DISTINCT keyword in a SQL Query.
• Use the LIKE Operator in a SQL Query.
• Use the LEFT Function in a SQL Query.
• Use the wildcard operator (%) in a SQL Query.
• Use the IN Operator in a SQL Query.
• Use MIN and MAX functions in a SQL Query.
• Use a JOIN statement in a SQL Query.
• Use the AVG function in a SQL Query.
• Use the GROUP BY clause in a SQL Query.
• Use the ORDER BY clause in a SQL Query.
• Create a new Account within your existing Org.
• Edit the User Profile of the new Account.
• Given SQL statements in a large block, be able to run and check them separately.
• Create and use a local SQL Variable.
• Create a Listing that contains only a Secure Function.
• Call a UDTF from a share on local data.
• Use the PARSE_HEADER File Format Property.
• Use the ERROR_ON_COLUMN_COUNT_MISMATCH File Format Property.
• Use the MATCH_BY_COLUMN_NAME COPY INTO Property.
• Use SQL UPDATE statement with a SELECT (and a UDTF).
• Use SQL Select * for one table in a join but not the other.
• Setting a local variable using a SQL statement.
• Observe BLOCK Scripting concepts including DECLARE, BEGIN, END, FOR.
• Observe use of the CURSOR Key word.
• Given a list of strategies, recognize Cost-related best practices.