Snowflake Course
Call us directly at , : +91-7095447721, +91-9533344772 for paying the fees, seasonal discounts or any other information.
Register here for any FREE demos for this course and many other courses.
What you will get when you take this course:
- World-class course content taught live by the experts Mr Sowryaa sir and Dr R Nageswara Rao.
- Zoom link for the class daily from course start to end date to your mail.
- Opportunity to clarify your doubts at the end of each class.
- Placement Assistance by posting available jobs, exclusively for Datatechs students.
- Certificate of Completion upon successful completion of the course.
Syllabus
- Introduction to Database
- Types of SQL Commands
- SQL Operators
- Keys in SQL
- Joining the tables
- Ordering and Grouping
- Aggregate functions in SQL
- Data Warehouse
- Data Warehouse vs Database
- Data warehouse as a Service
- Database Storage or Centralized Storage
- Query Processing or Multi-Cluster Compute
- Cloud Services
- Installing SnowSQL
- Connecting to Snowflake using SnowSQL from CLI
- Basic SnowSQL commands
- Columnar Storage
- Micro-partitions
- Meta Data
- Data Clustering
- Authentication & Access Control
- Infrastructure Manager
- Metadata Manager
- Security Manager
- Edition
- Compute Costs
- Storage Costs
- Additional services
- Stage Types
- External Stage
- Internal Stages
- Key Features of Sequences
- Creating a Sequence
- Using Sequences in SQL Statements
- Viewing the Current Value of a Sequence
- Modifying a Sequence
- Dropping a Sequence
- Use Cases for Sequences
- Example: Full Use Case
- Data Loading Types: Bulk loading, Continuoius Loading
- COPY command: Simple Transformations, Data Loading & Transform
- Loading Semi-structured data into Snowflake
- Permanent Tables
- Transient Tables
- Temporary Tables
- External Tables
- Create External Stage
- Secure Views
- Materialized Views
- Key Features of Snowpipe
- Steps to Create Snowpipe
- Snowpipe with AWS
- Snowpipe with Azure
- Use Cases
- Types of UDFs: Scalar, Tabular
- Alter Task
- Sample Tasks
- Cron
- DAG - Directed Acyclic Graph
- Task History
- Trouble shooting Tasks
- Metadata of Streams
- Working of Streams
- Consuming data from Streams
- Types of Streams
- Streams with Tasks
- Retention Period
- Querying Historical data
- Restoring Object
- Fail-safe