linux basics +DevOps+AWS+python basics

Linux basics and commands, real time trouble shooting, 

Git

Github

Jenkins

Maven

Apache Tomcat

Nexus

Sonar qube

Pipeline code

Docker

Ansible

Terraform

Kubernetes

Prometheus

Garafana

cAdvisor

Node exporter 

Zabbix doc

Load balancer realtime usage nginx

Each topic with real time scenario based explanation and hadsson from scratch. 

Project explanation

Each topic handson

Each topic real time interview questions.

Realtime tools 

Putty, mputty, mobaexterm, winscp, Filezilla, putty gen. 

Aws

_______

Ec2

S3

Iam

Elb

Auto scalling

Sns

Sqs

Cloud watch

Cloudfront

Vpc

Elastic beanstalk

Rds

Aws cli

Route 53

Ecr

Ecs

Fargate

Cidr

Lambda

Python basics

Python modules

Boto3 package to automate infrastructure

*Course* : linux basics +DevOps+AWS+python basics

*Duration*: 5 months

Monday to friday

Time : 9pm to 10pm IST 

More information

Shekar real time training

Interview Questions on Snowflake

Snowflake being relatively new most of the interview questions would be based on how you have implemented and used it in your project.

Some which I could recall are -

1. Snowflake Architecture and it's various components

2. Data loading and challenges faced

3. Data loading include copy command, how do you create stages, various stage - table/internal/external.

4. How does stages differ from each other.

5. How to create external stage referencing S3 bucket/ADSL

6. Scenarios like how do you handle duplicates as integrity constraints are not enforced in SF.

7. What are warehouses and how do you design it.

8. Performance optimization - Auto Scaling, Caching and clustering

9. Scenarios where you have used time travel feature.

10. UDF and how have you used it.

11. Restrictions in SF as compared to RDBMS database.

12. If you have worked on migration what are challenges faced and how did you overcome it.

13. Task, streams implementation scenario.

14. Structured/semi- structured files how have you loaded them.

15. Volume of data you have handled.

16. Architecture of your project.

17. Orchestration of SF pipelines - tools being used for it.

18. How do you handle transactional transactions in Snowflake.

19. Snowpipe

20.Data Unloading.

21. Role based access management - important to have knowledge on this.

22. How does normal views and materials views differ in Snowflake 

There can be various scenario based question based on what you explain about your project and how knowledgeable interviewer  is.

With Snowflake you need to have basic to intermediate knowledge on cloud technology and orchestration will be add on.