Szkolenie Snowflake dla programistów

Infoshare is the largest tech community in CEE and the organizer of the leading tech conference in Gdańsk. It connects startups, investors, corporations, and innovation enthusiasts. It promotes entrepreneurship, knowledge sharing, and networking. Through events, competitions, and programs, it supports the development of the tech ecosystem in Poland and the region.

Snowflake is a modern relational database that enables efficiency and unlimited data size along with queries. It is well-suited for creating large, scalable databases. The platform is cloud-based, allowing for the creation of large data warehouses. It features a very high level of security.

• For database programmers.
• For UI designers, administrative analysts, and developers.

Mastering SQL in the context of Snowflake, covering an overview of the language and practical exercises with Snowflake structures, as well as issues related to data loading using Snowpipe, using SnowSQL, and data integration and loading. Practical tasks in the context of administrative analytics, using Snowlight. Mastering the modeling method and working with semi-structured data, including non-tabular data formats like JSON, and practical applications of SQL for such data structures.

You will learn about the architecture and capabilities of Snowflake — a modern cloud-based relational database that enables efficient work with large, scalable data warehouses. You will master the use of Snowflake ecosystems and integrations and manage data in a cloud environment. You will learn task automation, which includes Q&A sessions. We will discuss security and permissions. Exercises on reading and writing data. The skills acquired will allow for the protection and sharing of data, as well as optimizing performance and scaling the platform.

1. OVERVIEW AND ARCHITECTURE
    • general description of Snowflake architecture as a tool

2. ECOSYSTEMS AND CONNECTIONS TO SNOWFLAKE
    • detailed discussion of individual layers of the platform
    • discussion of connection possibilities to Snowflake

3. SQL IN SNOWFLAKE
    • overview of SQL language
    • SQL exercises in Snowflake structures

4. SEMI-STRUCTURED DATA IN SNOWFLAKE
    • discussion of modeling methods for semi-structured data
    • SQL exercises in Snowflake structures for non-tabular data (JSON)

5. TASK AUTOMATION IN SNOWFLAKE
    • discussion of methods for automating processes
    • exercises on task automation in the Snowflake environment

6. Q&A SESSION

7. SECURITY AND PERMISSIONS
    • discussion of roles in the context of using Snowflake
    • exercises on granting and reading permissions for individual levels

8. DATA LOADING
    • discussion of data loading issues using Snowpipe
    • discussion of SnowSQL as a platform administration tool
    • tasks related to data integration and loading

9. DATA PROTECTION AND SHARING
    • discussion of data protection and sharing issues
    • practical tasks

10. PERFORMANCE AND SCALING
     • discussion of optimization methods in the Snowflake platform
     • practical tasks

11. ACCOUNT & RESOURCE MANAGEMENT IN THE CONTEXT OF ANALYTICS (SNOWLIGHT)
     • discussion of Snowlight as a new UI and its analytical capabilities
     • practical tasks in the context of administrative analytics

12. Q&A SESSION

16 h/2 days