|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-ultimate-modern-sql-course/
课程评论：没有评论
课程名称：《完整的SQL训练营：掌握现代SQL与Snowflake》 课程概述： 欢迎参加《完整的SQL训练营：掌握现代SQL与Snowflake》！这是您学习现代职场中最需求数据技能的唯一课程。现代数据环境中，SQL无处不在，推动着像MySQL和Postgres这样的关系数据库，支持通过BigQuery和Snowflake等平台的云分析，甚至为大数据工具如Spark和Hadoop提供接口。本课程旨在为任何技能水平的学生提供一个学习所有基本SQL语法和特性的“一站式商店”，深刻理解SQL是如何演变以满足现代需求，例如云计算和大数据。我们将利用强大的云原生数据平台Snowflake，通过理论讲座和动手实践相结合的方式，分析合成数据和实际数据，帮助您成为适应现代世界的SQL专家！课程使用Snowflake提供的免费试用账户，只需几分钟即可设置！ 课程特点： - 6小时以上高质量内容，由约5分钟的短视频组成，确保您获取必要知识，无多余内容。 - 理论讲座中包含架构图、图形、代码片段和概览幻灯片供复习。 - 在Snowflake用户界面中的互动实践，重点在ANSI标准SQL代码。 - 理解合成数据和实际数据的使用体验。 - 附带的SQL代码文件可与动手视频一起运行、编辑和分享。 - 每部分结束时有复习测验，巩固理论和实践概念。 - 讨论现代数据挑战，如大数据和云计算中的SQL应用。 - 课程提供SQL专业讲师的问答支持。 - 完成课程后颁发证书，展示您的专业技能。 课程内容涵盖： 1. 课程设置：创建免费的Snowflake试用账户，下载动手SQL代码，掌握学习方法。 2. SQL与Snowflake的介绍：SQL的历史背景及其在现代数据环境中的作用，Snowflake的简要课程介绍，SQL语言的技术基础及其他数据库概念。 3. 数据定义语言(DDL)：学习创建和修改对象的SQL语句，以及数据类型和约束。 4. 数据操作语言(DML)：生成和修改数据的SQL语句，并了解如何用Snowflake加载大量数据。 5. 查询基础：详细学习选择语句的各个部分及SQL函数的使用。 6. 中级查询：使用JOIN结合表属性，使用子查询模块化SQL代码。 7. SQL查询性能：学习数据库的执行顺序及不同SQL子句的最佳实践。 8. 高级SQL特性：了解窗口函数、公共表表达式(CTE)、事务等高级SQL概念。 9. 处理半结构化数据：学习什么是半结构化数据、其加载方式及查询技巧。 总结： 准备好提升您的SQL技能吗？立即注册，终身访问这门全面的课程，开始掌握现代数据环境的SQL吧！
Welcome to The Complete SQL Bootcamp: Master Modern SQL with Snowflake! The only course you need to learn one of the most in-demand data skills in today's workplace.If we look at our modern data landscape we can see SQL everywhere, powering relational databases like MySQL and Postgres, enabling cloud-based analytics through platforms like BigQuery and Snowflake and even serving as interfaces for Big Data tools like Spark and Hadoop.This course offers a one-stop shop for students of any skill level to learn all the essential SQL syntax and features, grounded in a deep understanding of how SQL has evolved to meet modern demands, such as cloud computing and Big Data. Using the powerful cloud-native data platform Snowflake, we'll analyse synthetic and real-world data through a combination of bite-sized theory lectures and hands-on exercises - equipping you with everything you need to become a SQL expert fit for the modern world! We accomplish this using a FREE trial account provided by Snowflake, which takes just a few minutes to set up!Why Choose This Course? 6+ hours of high-quality content comprised of bite-sized videos of around 5 minutes, so you get what you need without the fluff!Theory lectures that include architectural diagrams, graphics, code snippets, and overview slides to bookmark and study.Interactive hands-on content in the Snowflake UI with a focus on ANSI-standard SQL code.Experience working with and understanding both synthetic and real-world data. A folder full of SQL code to accompany hands-on videos that you can run, edit and share!A review quiz at the end of each section to reinforce the practical and theoretical concepts you've just studied.Learn SQL in the context of modern data challenges like Big Data and the Cloud.The perspective of a SQL professional instructor through the Q & A section.Earn a certificate of completion when you complete the course to showcase your expertise.What Will You Cover?1. Course SetupCreate a free Snowflake trial account.Download the hands-on SQL code.Learn study methods to help it all go in and stay in!2. Introduction to SQL and SnowflakeLearn about SQL's historical context and how it fits into the modern data landscape. Have a crash course on Snowflake, the cloud-native data platform we'll be using for the course. Have an introduction to the technical aspects of the SQL language.Additional database concepts like the object model and access control.3. Data Definition Language (DDL)Learn SQL statements used to create and modify objects: CREATE, USE, SHOW, DESCRIBE, DROP & ALTER. Learn about Data Types.Learn about Constraints.Have an introduction to SQL Syntax Best Practices.4. Data Manipulation Language (DML)Learn about SQL statements to generate and modify data: INSERT, UPDATE, DELETE, TRUNCATE & MERGE.Learn the process of loading large amounts of data with Snowflake features: Stages, File Formats, COPY INTO. 5. Query FundamentalsLearn the many individual clauses of the select statement in detail: SELECT, FROM, WHERE, ORDER BY, GROUP BY & HAVING. Learn about scalar and aggregate SQL functions.Have an introduction to User-defined functions.6. Intermediate QueryingLearn to combine table attributes with the JOIN clause.Learn to modularise our SQL code with Subqueries.Learn about Set Operators to compare result sets.Learn about Conditional Expressions to control the flow of our data. Learn about the View database object. Learn about how to convert from one data type to another with Casting.7. SQL Query PerformanceLearn about the database Order Of Execution to help conceptualise how the database engine processes statements.Learn about best practices when using different SQL clauses: JOIN, ORDER BY, WHERE and GROUP BY.Learn how to use the EXPLAIN command and Snowflake's Query Profile Tool.Learn about Snowflake-specific features for improving query performance: Caching and Materialized Views.8. Advanced SQL FeaturesLearn about Window Functions and Window Frames.Learn about Common Table Expressions (CTEs) and Recursive CTEs.Learn about Transactions.Learn about Collation.Learn about User-defined Functions (UDFs) and Stored Procedures.9. Processing Semi-structured DataHave a crash course into what semi-structured data is. Learn how to load semi-structured data and what their unique considerations are.Learn how to query and access semi-structured data. Learn what functions are unique for accessing semi-structured data.Learn what are the unique considerations for loading binary semi-structured data. One last thing - I'd love to hear from you! Share your experience taking the course by messaging me on Udemy or through LinkedIn. You can find me by searching 'Tom Bailey • Udemy Instructor'.Ready to transform your SQL skills? Enrol now to get lifetime access to this comprehensive course and start mastering SQL for the modern data landscape today!
