Programming Study日本語

Disclosure: We earn a commission from Udemy when you buy a course through links on this page.

SQL for Data with Snowflake

SQL for Data with Snowflake

Udemy · English

About this course

Language
English
Category
Provider
Udemy
Data updated

Learn SQL from scratch and use it the way real data teams do, on Snowflake, one of the leading cloud data platforms.SQL is the one skill every data analyst, data scientist and data engineer is expected to have. This hands-on, beginner-friendly SQL course takes you from your first SELECT statement to advanced SQL and full Snowflake projects, with practical examples, assignments and three role-based capstone projects. What you will learnSQL foundations: SELECT, WHERE, ORDER BY, GROUP BY and HAVING, the relational model, keys, schemas, views and data typesSnowflake essentials: architecture, virtual warehouses, creating databases and tables, loading data with stages and COPY INTO, Time Travel and Zero-Copy CloningSQL joins: INNER, LEFT, RIGHT, FULL OUTER and CROSS JOIN, and when to use eachSubqueries and CTEs: write readable, modular queries with the WITH clauseSQL window functions: running totals, rankings and moving averages with ROW_NUMBER, RANK, DENSE_RANK, LAG and PARTITION BYData cleaning with SQL: remove duplicates, handle missing values and NULLs, fix inconsistent formats and data typesData transformation with SQL: calculated columns, flags, PIVOT and CASE WHEN segmentationELT pipelines on Snowflake: automate SQL transformations with Snowflake tasks and stored proceduresThree capstone projects, one for each data roleData Analyst: answer leadership's questions on an e-commerce business, revenue by region, product and category, and top customers. Data Scientist: build a machine-learning-ready feature dataset to predict which c…

Courses in the same category