infyni

Live Snowflake Data Warehouse & amp, Cloud Analytics

Unlock the potential of Snowflake Data Warehouse & Cloud Analytics in our live, interactive course. Master the art of harnessing the capabilities of Snowflake for efficient data warehousing and cloud-based analytics.

Live Course

Live Class: Friday, 12 Jan

Duration: 25 Hours

Enrolled: 0

Offered by: infyni

Live Course
$1500 50% off

$750

Enroll Now

About Course

Transformative journey into the realm of modern data management with our Live Snowflake Data Warehouse & Cloud Analytics course. Explore the power and versatility of Snowflake, the cloud-based data platform revolutionizing analytics. Gain hands-on experience in setting up, managing, and optimizing Snowflake for scalable, high-performance data warehousing. Discover the art of deriving actionable insights from your data through cutting-edge cloud analytics techniques. Participants will engage in practical exercises, case studies, and real-world scenarios, enabling them to apply Snowflake's features effectively for data warehousing and cloud-based analytics.

Skills You Will Gain

Snowflake Architecture & Setup Data Loading & Transformation Snowflake Administration & Security Querying & Performance Optimization Data Warehousing Best Practices Snowflake & Cloud Analytics Tools Integration

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
1 Snowflake
  • Key Concepts & Architecture
  •  Cloud Platforms
  •  Snowflake Editions
  •  Overview of Key Features
  •  Overview of the Data Lifecycle
  •  Continuous Data Protection
  • Overview of the Ecosystem
  • SnowSQL (CLI Client)
  • Installing SnowSQL
  • Configuring SnowSQL
  • Connecting Through SnowSQL
  • Using SnowSQL
  • JDBC Driver
  • Downloading / Integrating the JDBC Driver
  • Configuring and Using the JDBC Driver
  • JDBC Driver Diagnostic Service
  • ODBC Driver
  • Downloading the ODBC Driver
  • Installing and Configuring the ODBC Driver for Windows
  • Overview of Data Loading/Unloading
  • Data Loading/Unloading Considerations
  • Preparing Load/Unload Data
  • Bulk Loading/Unloading from a Local File System
  • Bulk Loading/Unloading from Amazon S3
  • Loading Continuously Using Snowpipe
  • Loading Using the Web Interface
  • Querying Data in Staged Files
  • Using the Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data
  • Snowflake Time Travel & Fail-safe
  • Introduction to Data Sharing
  • Data Providers
  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage
  • Understanding Snowflake Data Transfer Billing
  • Monitoring Account-level Credit and Storage Usage
  • Working with Resource Monitors
  • Parameter Management
  • User Management
  • Snowflake caching features
  • Performance tuning
  • Best practices
  • RBAC Hierarchy
  • Task and Scheduling
  • Snowflake with Python
  • Spark with snowflake (pre-requiste : spark)
  • Intro to DBT and matiilion
  • Accessing snowflake in BI tools
  • Intro to snowpro certification

...
ANANDH KUMAR@AK
About Instructor

Big Data & Hadoop Spark Consultant and also a mentor & Corporate trainer in Information Technology for more then sixteen years. Have been training people across the world in ETL, OLAP and Big data applications.Currently leading the team of engineers in web development, IOT,Machine learning and Data Science as Chief at Dataz , Chennai.

0

Rating

0

Review

78

Students

2

Courses