Trainer

12 yrs exp

Duration

25 Sessions

Recordings

40 hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

To Learn about the unique features of Snowflake and job market is very good

Who should go for this training?
The following professionals can go for this course:

Anyone Can learn ( Basic SQL knowledge is desirable)

What are the pre-requisites for this Course?

Basic SQL knowledge is desirable

Course Overview

Course Content

Expand All
  • Snowflake History
  • Introduction to Snowflake
  • Architecture of Snowflake (Services Layer, Compute Layer, Storage Layer)
  • Snowflake Registration
  • SnowSQL
  • Setting up the Config file
  • Introduction to Compute Layer
  • Introduction to the Virtual Warehouses
  • Types of Staging (Internal, External)
  • Internal Stage (User Stage, Table Stage, Named Stage)
  • Loading the data into Different Stages
  • Loading multiple files into User Stage by creating a folder using regular expressions
  • Listing the stages (User, Table, Named)
  • Creating a Snowflake Managed Internal Stage
  • Loading the data into the internal stage
  • Introduction to the external stage
  • Explanation on AWS Console.
  • Examples on S3 Service in AWS
  • Create a Bucket, User, Folder, Role, Policy in AWS
  • Upload the files and list all the files in SF
  • Options available in Copy Into command
  • Introduction of loading the data in the snowflake
  • loading a single file into a table
  • loading the selected files into a table
  • Introduction of Tables
  • Different type of the tables and differences
  • Design Considerations based on the environment
  • Introduction to Data Retention Policy
  • Introduction to the Snowpipe
  • Create a bucket and Folder in AWS
  • Creating a Role for Snowpipe
  • S3 Policy Assignment to the Role
  • Creating the Staging, Integration, pipe, Event configuration, Notification in AWS
  • Creating the Storage Account, Container, Queue, Event, Notification, Pipe in Azure
  • Creating the Bucket, Folder, Storage Integration Object, External storage in Google Cloud
  • Introduction of Time Travel
  • Data Life Cycle and Time Travel operations
  • Time Travel SQL Extensions, Parameters, Offset
  • Timestamp, Statement, Un Drop
  • Retrieving the Historical Data
  • Introduction of Cloning
  • Cloning of Tables
  • Cloning Database and Schemas
  • Discussing Fail Safe
  • Querying the Space for Table, Time Travel and Fail Safe
  • Introduction to the streams
  • Creating and identifying the key Aspects of Stream
  • METADATA$ACTION, METADATA$UPDATE, METADATA$ROW_ID
  • Load the Data into the Targe Table
  • Insert, Update, Delete - Related to stage Table data
  • Introduction to the Tasks
  • Introduction to the Schedules in Tasks
  • Create a Task (Stand Alone Task)
  • Create a dependent, Parent, Child tasks
  • Order of resuming and suspending the tasks.
  • Scheduling the Tasks
  • Introduction to caching
  • Types of Cache
  • Clustering in Snowflake
  • Introduction to Data Sharing, Reader Account
  • Inbound and Outbound Shares
  • Data Sharing with External snowflake Accounts
  • Data Market Place (Inbound, Outbound)
  • Introduction to Pre-Defined Roles
  • Introduction to Custom Roles
  • Creating Users, Custom Roles
  • Understanding about Privileges
  • Introduction to the Functions
  • Introduction to Stored Procedures
  • Automation of COPY_HISTORY using a procedure
  • Realtime scenarios realted to functions and procedures
  • Examples realted to Java script Procedures/Functions
  • Introduction of Materialized Views
  • Refreshing the MVIEWS
  • Create and Query the Data from the External Tables
  • Querying JSON Data.
  • Introduction on how to communicate between Python and Snowflake using connector.
  • Querying the table from Python.
  • Load data from Oracle to Snowflake using Informatica Cloud
  • Introduction to Informatica Cloud.
  • Installation and configuration.
  • Creating Mappings and Tasks to load the data from Oracle to Snowflake
  • Load data from Oracle to Snowflake using Hevodata
  • Introduction to Hevodata.
  • Installation and configuration.
  • Creating Sources and Targets to load the data from Oracle to Snowflake.
  • Spark scenarios related to Snowflake
  • Interview Preparation
  • Project Discussion
Brochure Download

Modes of Training

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : Certifed Professional with 12 yrs exp, delivered 40+ batches.
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 12 yrs exp
  • 25 Live classroom sessions
  • Reading material and Lab activity guide
  • Online Cloud access for practice
  • 60 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Certified technical assistance
26-Dec

8:00am to 9:30am IST

30 Days (Mon-Fri)

01-Jan

8:00am to 9:30am IST

30 Days (Mon-Fri)

03-Jan

8:00am to 9:30am IST

30 Days (Mon-Fri)

₹20,000/- ₹14,000/- 30%OFF

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 12 yrs exp
  • 25 Virtual online sessions
  • Access for 40 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • Online Cloud access for practice
  • 60 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
25-Dec

8:00am to 9:30am IST

30 Days (Mon-Fri)

31-Dec

8:00am to 9:30am IST

30 Days (Mon-Fri)

03-Jan

8:00am to 9:30am IST

30 Days (Mon-Fri)

18 % OFF ₹ 22,000/- $213 ₹18,000/-

SELF-PACED LEARNING

This Course Includes:
  • Access for 40 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • Online Cloud access for practice
  • 60 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

₹15,000/-

Our Instructor

Bala Krishna

Snowflake Trainer
  • 5 Instructor Rating
  • 132 Reviews
Bala Krishan is a Certified IT professional with 12 yrs of experience in the industry. Worked on multiple projects in different domains like Finance, Telecom and Insurance.

Having around 9 Years of teaching experience, trained more than 100+ batches with technologies into Oracle, OFSAA, Informatica, Power BI and Snowflake.

Currently working as a Solution Architect and having expertise in multiple technologies and Tools like Oracle, Mongodb, Snowflake, Informatica, OFSAA, Python, Pyspark,  Airflow, Autosys.

Certifications : 
-  Microsoft Certified: Azure Data Engineer Associate
-  Oracle Database SQL Certified Expert
-  Oracle PL/SQL Developer Certified Associate
-  Oracle Certified Professional, Java EE 5 Web COmponent Developer - JPN

Demo Video

No Video Found

No Demo Video

Certification Guidence

  • This course is designed for clearing the SNOWPRO CORE CERTIFICATION.
  • This entire course content and our trainers helps you to get expertise and clear the certification program easily.
  • You will be awarded with Akswave course completion certificate after the course completion.
AksWave Certificate
Further details related to Snowpro Core Certification find here.

Faq

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that particular session.
  • Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

You can contact our support team, or just drop an email to online@akswave.com with your queries.

For practical execution, our trainer/technical team will provide server access details to the student.

The course material and recorded videos which are provided during the course period. Anytime you can access them online.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.


Visit our website regularly to check discount offers time to time. However, we provide discount for single participant & special discount for 2 or more participants.

Live-Online training is where you can have live session with the trainer and clarify queries parallelly. Pre-recorded sessions are the recorded videos that will be provided to you so that you can see, listen and learn anytime at your feasible place. For doubts in the videos you can mail the trainer regarding the same.


If request for cancelation is made within 2 days of enrolment for class, 100% refunded. If request made after 2 days, then Refund is made after deduction of administration fee.


Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8