
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…











