SQL Server to Snowflake Migration for Power BI Developers
A comprehensive guide for Power BI developers to seamlessly migrate SQL Server databases to Snowflake and leverage its capabilities for enhanced data analytics.
...
Introduction to Snowflake for SQL Server Professionals
Unit 1: Snowflake Fundamentals
Unit 2: Getting Started with Snowflake
Unit 3: Snowflake for SQL Server Pros
Snowflake Data Types and SQL Syntax Differences
Unit 1: Data Type Mapping
Unit 2: SQL Syntax Variations
Unit 3: SQL Query Practice
Assessing Your SQL Server Database for Migration
Unit 1: Defining the Migration Scope
Unit 2: Analyzing Database Characteristics
Unit 3: Identifying Compatibility Issues
Choosing a Migration Strategy
Unit 1: Understanding Migration Strategies
Unit 2: Hybrid and Strategic Considerations
Unit 3: Strategy Selection and Planning
Preparing Your SQL Server Database for Migration
Unit 1: Data Cleansing and Transformation
Unit 2: Data Quality and Performance Optimization
Unit 3: Data Masking and Anonymization
Extracting Data from SQL Server
Unit 1: Introduction to Data Extraction from SQL Server
Unit 2: BCP in Detail
Unit 3: SSIS Deep Dive
Unit 4: Optimizing Data Extraction
Unit 5: Advanced Extraction Techniques
Data Transformation and Staging
Unit 1: Introduction to Data Transformation and Staging
Unit 2: Data Cleansing Techniques
Unit 3: Data Transformation Rules and Validation
Unit 4: Data Type Conversion and Format Changes
Unit 5: Advanced Transformation Techniques
Loading Data into Snowflake
Unit 1: Introduction to Data Loading
Unit 2: Loading Data with SnowSQL
Unit 3: Continuous Loading with Snowpipe
Unit 4: Optimizing Data Loading
Snowflake Data Loading Options and Best Practices
Unit 1: File Formats and Loading Options
Unit 2: Error Handling and Data Loading Best Practices
Unit 3: Monitoring and Troubleshooting
Validating Data Migration
Unit 1: Planning and Preparation
Unit 2: Data Comparison Techniques
Unit 3: Identifying and Resolving Discrepancies
Unit 4: Automation and Reporting
Migrating SQL Server Schemas to Snowflake
Unit 1: Schema Migration Fundamentals
Unit 2: DDL Conversion and Table Creation
Unit 3: Views, Indexes, and Constraints
Unit 4: Advanced Schema Objects and Considerations
Migrating SQL Server Stored Procedures and Functions
Unit 1: Understanding Stored Procedure and Function Migration
Unit 2: Rewriting Stored Procedures and Functions in Snowflake
Unit 3: Snowflake Stored Procedures and UDFs
Unit 4: Testing and Validation
Snowflake Security and Access Control
Unit 1: Snowflake Security Fundamentals
Unit 2: Implementing Access Control
Unit 3: Advanced Security Features
Unit 4: Security Integrations and Monitoring
Optimizing Snowflake Performance
Unit 1: Understanding Snowflake Performance
Unit 2: Clustering Keys and Data Organization
Unit 3: SQL Optimization Techniques
Snowflake Cost Management
Unit 1: Understanding Snowflake's Cost Model
Unit 2: Monitoring Snowflake Usage and Costs
Unit 3: Optimizing Snowflake Resource Consumption
Connecting Power BI to Snowflake
Unit 1: Setting Up the Connection
Unit 2: DirectQuery vs. Import Mode
Unit 3: Optimizing Power BI Queries
Unit 4: Troubleshooting Connections
Building Power BI Reports and Dashboards with Snowflake Data
Unit 1: Connecting to Snowflake and Basic Report Building
Unit 2: Data Modeling and Advanced Visualizations
Unit 3: Interactive Dashboards and Performance Optimization
Power BI DirectQuery vs. Import Mode with Snowflake
Unit 1: Understanding Power BI Data Connectivity Modes
Unit 2: Pros, Cons, and Use Cases
Unit 3: Choosing and Configuring the Right Mode
Incremental Refresh in Power BI with Snowflake
Unit 1: Understanding Incremental Refresh
Unit 2: Configuring Incremental Refresh
Unit 3: Advanced Incremental Refresh Techniques
Unit 4: Optimizing Performance and Refresh Policies
Power BI Dataflows with Snowflake
Unit 1: Introduction to Power BI Dataflows and Snowflake
Unit 2: Creating and Configuring Power BI Dataflows with Snowflake
Unit 3: Transforming and Cleansing Data in Dataflows
Unit 4: Using Dataflows as a Data Source for Power BI Reports
Unit 5: Advanced Dataflow Techniques
Advanced Power BI and Snowflake Integration Techniques
Unit 1: Custom Visuals and DAX
Unit 2: Row-Level Security
Unit 3: Snowflake Integration
Unit 4: Advanced Analytics
Unit 5: Optimization and Best Practices
Automating Snowflake Tasks with SnowSQL and Scripting
Unit 1: Introduction to SnowSQL
Unit 2: Scripting with SnowSQL
Unit 3: Scheduling and Advanced Automation
Using Snowflake's Data Sharing Capabilities
Unit 1: Understanding Snowflake Data Sharing
Unit 2: Sharing Data in Snowflake
Unit 3: Consuming Shared Data
Unit 4: Advanced Data Sharing Scenarios
Leveraging Snowflake's Data Marketplace
Unit 1: Introduction to Snowflake Data Marketplace
Unit 2: Integrating and Using Data Marketplace Data
Unit 3: Advanced Data Marketplace Concepts
Snowflake Time Travel and Data Recovery
Unit 1: Understanding Snowflake Time Travel
Unit 2: Querying Historical Data with Time Travel
Unit 3: Data Recovery with Time Travel
Snowflake Cloning for Development and Testing
Unit 1: Understanding Snowflake Cloning
Unit 2: Cloning in Action
Unit 3: Practical Applications of Cloning
Unit 4: Advanced Cloning Techniques
Monitoring and Auditing Snowflake Activity
Unit 1: Snowflake Monitoring Fundamentals
Unit 2: Advanced Monitoring Techniques
Unit 3: Auditing and Security
Disaster Recovery and Business Continuity with Snowflake
Unit 1: Understanding Snowflake's DR/BC
Unit 2: Configuring Replication
Unit 3: Testing and Failover
Unit 4: Ensuring Business Continuity
SQL Server Agent Jobs to Snowflake Tasks
Unit 1: Understanding SQL Server Agent Jobs and Snowflake Tasks
Unit 2: Converting SQL Server Agent Job Steps to Snowflake Tasks
Unit 3: Scheduling and Managing Snowflake Tasks
Unit 4: Advanced Snowflake Task Management
Change Data Capture (CDC) Strategies for Snowflake
Unit 1: CDC Fundamentals
Unit 2: CDC with Snowflake Features
Unit 3: CDC with 3rd Party Tools
Data Governance and Data Quality in Snowflake
Unit 1: Data Governance Fundamentals in Snowflake
Unit 2: Defining Data Quality Rules and Standards
Unit 3: Snowflake's Data Quality Features
Automated Testing for Snowflake Migrations
Unit 1: Introduction to Automated Testing
Unit 2: Setting Up Your Testing Environment
Unit 3: Writing Automated Tests
Unit 4: Automating the Testing Process
Unit 5: Advanced Testing Techniques
Handling Large Object (LOB) Data Migration
Unit 1: Understanding LOB Data and Migration Challenges
Unit 2: Techniques for Migrating LOB Data
Unit 3: Optimizing LOB Storage and Retrieval in Snowflake
Unit 4: Addressing Performance Issues and Best Practices
Migrating from SQL Server Analysis Services (SSAS) to Snowflake
Unit 1: Understanding the Shift from SSAS to Snowflake
Unit 2: Preparing for SSAS Migration
Unit 3: Migrating SSAS Data to Snowflake
Unit 4: Leveraging Snowflake's Analytical Capabilities
Unit 5: Post-Migration Considerations
Migrating SQL Server Reporting Services (SSRS) Reports to Power BI with Snowflake
Unit 1: Understanding the Migration Landscape
Unit 2: Converting SSRS Reports to Power BI
Unit 3: Optimizing Power BI Reports for Snowflake
Unit 4: Addressing Compatibility and Advanced Topics
Using External Functions in Snowflake
Unit 1: Introduction to External Functions
Unit 2: Creating and Deploying External Functions
Unit 3: Calling External Functions and Use Cases
Unit 4: Advanced Topics
Unit 5: Real-World Examples
Snowflake and Data Science Workloads
Unit 1: Snowflake for Data Science
Unit 2: Machine Learning in Snowflake
Unit 3: Advanced Data Science Techniques
Snowflake's Support for Unstructured Data
Unit 1: Introduction to Unstructured Data in Snowflake
Unit 2: Querying Unstructured Data in Snowflake
Unit 3: Integrating Unstructured and Structured Data
Real-time Data Streaming to Snowflake
Unit 1: Introduction to Real-Time Data Streaming
Unit 2: Snowpipe for Continuous Data Ingestion
Unit 3: Alternative Streaming Tools & Techniques
Unit 4: Real-Time Data Analysis & Power BI
Advanced SQL Optimization Techniques for Snowflake
