Chandra Data Engineer
No reviews yet

• ₹15000
• Duration: 50 days
• Delivery mode: Online
• Group size: 6 - 10
• Instruction language: English
• Certificate provided: Yes

My Self Chandra having 11 plus years of experience in IT industry and relevant 5years of experience in Snowflake and azure data engineer and I will teach snowflake with AWS, Azure and GCP cloud service provides, duration of this course is 50 days.

During the sessions Below contents will be covered
SQL:
1. SQL Commands/Statements. 8. Constraints
1. DDL Commands 1)Primary key
2. DML Commands 2) Foreign Key
3. DQL Commands 3) Not Null
4. DCL Commands 4) Unique
5. TCL Commands
2. Clauses 9. Joins
a) Where Clause 1) Equi join
b) Group by Clause 2) Outer joins
c) Having Clause a) left outer join
d) Order by Clause b) Right Outer join
3. Operators c) Full outer join
a) Arithmetic Operators 3) Self Join
b) Comparison Operators 4) Cross join
c) Logical Operators
4. Functions
a) Numeric Functions
b) String Functions
c) Date Functions
d) Aggregation Functions
e) Miscellaneous Functions
5. Set Operators
a) Union
b) Union all
c) Intersect
d) Minus
6. Sub Queries
a) Co-Related Sub queries
b) Non Co-related Sub queries

Snowflake
1. Snowflake Introduction
 Snowflake Introduction
 Snowflake Web Sign Up
 Cloud providers to snowflake
 Snowflake editions
2. Architecture
 Shared disk and shared nothing architecture
 Centralized storage
 Compute
 Cloud service
3. Snowflake Virtual warehouse
 Creating Warehouse
 Explanation on properties of warehouses
 Warehouses sizes
 Multi cluster warehouses
 Compute cost optimization
 Multi ware housing modes
 Auto scale
 Maximized
 Scaling policy
 Standard policy
 Economy Policy
 Auto Resume & Auto Suspend

4. Snowflake objects
 Warehouse
 Database
 Schema
 Tables
 Views
 Stages
 File formats
 Sequences
 Pipes
 Stored procedures
 UDF's

5. Types of tables
 Permanent
 Transient
 Temporary
 External
 Dynamic tables

6. Views
 Regular views
 Materialized views
 Secured views
 MV securied
7. Data Organization in snowflake storage
 Micro partitions
 Prunning process
 Clustering
 Data clustering
 Clustering Keys
 Reclustering
8. Stages
 User stage
 Table stage
 Named internal stage
 External stage
9. Loading / Unloading Data From AWS, Azure & GCP
 Overview of Data Loading/Unloading
 Data Loading/Unloading Considerations
 Preparing to Load/Unload Data
 Bulk Loading/Unloading from a Local File System
 Bulk Loading/Unloading from Amazon S3
 Bulk Loading /Unloading from Microsoft Azure
 Bulk Loading /Unloading from GCP
 Loading Continuously Using Snow pipe
 Loading Using the Web Interface (Limited)
 Transforming Data during a Load
 Validation modes
 Validate table functions

10. Storage Integration from AWS/Azure/GCP to Snowflake
11. Time Travel
 Timestamp
 Query Id
 Offset
 Fail Safe
12. Snow sqlCLI
 Installation
 Configuring Snow SQL
 Data loading
 Bulk data load
 Staging the data

13. Sequences
 Creating sequences UI/ SQL

14. Types of caches
 Metadata cache
 Result cache
 Warehouse cache

15. Continuous load
 Snow pipe
 Snow pipe configuration
 Integration with cloud storage
 Error handling
16. Zero Copy Clone
17. Task - Schedulers
 How to create a task
 How to create a child task
 How to alter parent & child tasks
 Schedule a task using cron
 History of task
 Calling producer
 Limitations of tasks
18. Streams
 Types of streams
 Uses cases on streams
19. Snowflake Data Sharing
 Snowflake Data Sharing
 Snowflake Secure Views
 Data Sharing with Non-snowflake Users
 Data Sharing Using Web UI
20. Data pipe lines
 Delta/incremental & historical load implementation
21. Procedures
 Java
 SQL
22. Setting up load monitoring
23. Resource monitors
24. Snowflake Security
 Snowflake compliance
 Column level security
 Dynamic data masking
 External tokenization
25. Administration
 Roles in Snowflakes
 RBAC (Role based Access control)
 DAC (Discretionary access control)
 Default roles in snowflake
 Roles commands -- SQL
 Pricing Costs
 Storage costs
 Compute costs
 Cloud service cost & data transfer costs

PYTHON
 Introduction,
 identifiers
 keywords
 installation and setup
 data types
 Fundamental
 Collection data types
 Functions
 Arguments
 Modules
 Packages
 Control Flow
 Logging Module
 File Handling in Python
 Exception Handling