info@cloudhill.in +91 8919464699

SF Basic Level

Syllabus

Core Concepts

Data Loading/Unloading

Performance

Scaling

Security

Data Types

Connectors

Continuous Data Protection

Extensibility

Account Management

Subject Area Breakdown

Overview and Architecture: 28%

Virtual Warehouses: 18%

Storage and Protection: 15%

Data Movement (Loading and Unloading): 14%

Account and Security: 12%

Performance and Tuning: 9%

Semi-Structured: 4%

Detailed Subject Area

sf Overview and Architecture

  • Overview of Key Features
  • Introduction to Semi-Structured Data
  • Bringing Together Structured and Semi-Structured Data
  • Semi-Structured Data Types
  • Querying Semi-Structured Data
  • Continuous Data Protection
  • Fast Clone
  • A Quick Look at Zero-copy Cloning
  • Using Persisted Query Results

Overview and Architecture

  • Overview of Key Features
  • Introduction to Semi-Structured Data
  • Bringing Together Structured and Semi-Structured Data
  • Semi-Structured Data Types
  • Querying Semi-Structured Data
  • Continuous Data Protection
  • Fast Clone
  • A Quick Look at Zero-copy Cloning
  • Using Persisted Query Results
Pricing & Regions
  • Regions
  • Editions & Pricing
  • Release
Security
  • Access Control
  • Role Hierarchy and Privilege Inheritance
  • Multi-Factor Authentication (MFA)
  • Data Encryption
  • Network Security & Policies
  • Federated Authentication & SSO
Architecture
  • Database Storage
  • Query Processing
  • Cloud Services
  • Cloud Platform
  • Data Lifecycle
  • Data Protection
Interface & Connectivity
  • sf WebUI
  • SnowSQL (CLI)
  • Connector Ecosystem
  • Partner Connector Ecosystem
Catalog & Objects
  • Database & Schema
  • Tables
  • Views
  • Data Types
Data Sharing
  • Sharing Configuration & Access Control options
  • Secure Data Sharing
  • Providers, Consumers & Reader Accounts
  • Creating & Managing Shares
Compute
  • Warehouses & Types
  • Warehouse Sizing & Scaling
  • Credit Usage
  • Warehouse Management
  • Warehouse Caching
  • Warehouse Monitoring
Storage
  • Micro partitions
  • Metadata
  • Clustering
  • Data Storages – Cost & Retention
  • Table Types, File Formats
  • Storage Monitoring
Continuous Data Protection
  • Time Travel, Fail Safe
  • Data Encryption
  • Security – Network Policies
  • Multi-Factor-Authentication (MFA)
  • Federated Authentication & SSO
Data Loading
  • Stages, file format,pipe
  • Loading Consideration & Load Management
  • Continuous Load Options – Snowpipe
  • Error handling & Troubleshooting
Data Unloading
  • Unloading data from sf to External Cloud Storage(S3,GCS,AZURE BLOB)
  • Unloading data from sf to Internal sf Storage
  • Unloading data from sf to Local / Network
  • Drive Data Unloading Considerations
Semi Structured Data
  • Different Formats, Variant Table Type
  • Native Syntax, Flattening Data
Performance Management
  • Query Performance & Analysis
  • SQL optimization
  • Load Testing
  • Clustering
  • Query Profile
  • Caching
Account Management
  • Managing Your sf Account
  • WAREHOUSE & Storage credit usage
  • Materialized Views
  • Auto /Re Clustering
  • DR & Replication
  • Information Schema
  • Differences Between Account Usage and Information Schema
Back To Top