Radical Technologies
Call :+91 8055223360 | 8103400400

SNOWFLAKES

Snowflake is a cloud-based elastic data warehouse or Relational Database Management System (RDBMS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. Snowflake supports both transformation during (ETL) or after loading (ELT). Snowflake works with a wide range of data integration tools, including Informatica, Talend, Tableau, Matillion and others.

Satisfied Learners

SNOWFLAKES TRAINING IN PUNE | BANGALORE | KERALA | ONLINE

SNOWFLAKES COURSE CONTENT

1)creation and uses of databases

2)creation and uses of schemas

3)creation and uses of warehouses

3a)scaling of warehouses up and down,in and out

3b)auto resume and auto suspend.

3b) creation of scaling policies in warehouses

 

4 Creation of tables(All types)

a)standard tables

b)transient tables

c)temporary tables

d)external tables.

 

5 DDL and DML commands in snowflake including parameters including(retention, alter session ,get_ddl command ,show parameters)

6 Auto commit and manual commit of DML commands.

7 adding and removing constraints including not null constraint.

8 drop and undrop database objects .

9 Using retention time and failsafe in different snowflake editions.

10 queryid and query tag in snowflake and using them for monitoring performance

11 creation of views and secure views.

12 materialized views and secure materialized view.

13 roles of sysadmin,account admin and secureadmin.

14 creation of masking policy and applying on tables.(for data security)

15 revoker role and current_role

16 creation and using user defined functions and returning values (one or entire table data)

17 Creation of stages(Internal,user and table)

18 Using different symbols for different stages.(While accessing the stage)

19 using put command to load data from files to stages.

20 Creation of file formats.(CSV and JSON format)

21 json file  loading .using copy command and merge statement

22 csv file loading using copy command and merge statements

23 uses of information schema in snowflake.

24 Creation of procedures.

25 executing procedures using call command.

26 Creation of streams for monitoring load process and consuming streams

27 Automation of procedures and sql commands using tasks.

28 resuming and suspending tasks.

29 Data unloading of json files from target tables to staging tables and finally using get command to download in local systems .and using object_construct.

30 remove command to delete data from stage tables  for both csv and json formats

31  Data unloading of csv  files from target tables to staging tables and finally using get command to download in local systems.

32 user creation and role creation

33 defining roles and granting to users

34 grants to users for schemas ,datbases ,warehouses ,stages,tables and other database objects.

35 Creation of resource monitor for warehouse monitoring and sending notifications to end users.

36  Creation of datamodels using constraints(primary key,unique,not null etc.

37 Creation and uses of snowpipes.

38 refreshing snowpipes  using tasks.

39  ( different DWH cocepts)-SCD1,SCD2,SCD3,datamart, snowflake schema,star schema,fact tables ,dimension tables ,factless fact tables, fully additive and semi additive fact tables.

Our Courses

Drop A Query

    Call Now ButtonCall Us