|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-the-complete-guide/
课程评论：没有评论
**课程名称：** SQL 完全指南：从入门到高级 **课程概述：** 本课程旨在教授学员如何实际运用SQL语言。随着数据领域的飞速发展，SQL已成为包括营销、金融、人力资源等非技术领域在内的多个专业领域的重要技能。通过本课程，您将学习SQL的基础知识到高级应用，并通过实践案例深入理解并掌握SQL，为您的职业发展增加市场竞争力。 **课程亮点：** * **循序渐进的学习方法：** 从基础概念到高级主题，有效提升您的SQL能力。 * **注重实践应用：** 通过实际操练，帮助您立即将所学知识应用于实际工作。 * **跨平台通用性：** 课程使用PostgreSQL数据库进行教学，但所学知识可应用于MySQL、Oracle、SQL Server、Redshift等所有SQL数据库。 **主要学习内容：** * 数据库、模式 (schema) 和表 (table) 的概念 * SQL基础与中间操作（WHERE, ORDER BY, 逻辑运算符, 条件语句） * 使用聚合函数 (aggregate functions) 和 GROUP BY 命令对数据进行分组 * 使用 HAVING 命令过滤聚合数据 * 各种类型的 SQL JOIN (Inner, Left, Right, Cross, Full) * 字符串函数 * 日期和时间函数 * 数学函数 * 子查询 (Subqueries) * 公共表表达式 (CTEs - Common Table Expressions) * 窗口函数 (Window Functions) * SQL 高级主题 * 查询性能优化 **加入我们，共同学习，从SQL入门到精通！ 立即查看免费预览视频，获取更多课程详情！**
Learn how to work with SQL for real with this course!In recent years the data area has grown a lot and has been in great demand, the SQL language has been one of the requirements in several professional areas outside the technological scope, for example in some companies in the areas of marketing, finance, HR, they use SQL to carry out analyzes and make decisions! Learning SQL nowadays is essential to increase your chances in the job market.You will learn with an effective method, from basic to advanced and understand SQL by applying it in practice with practical examples, and you will be ready to apply it immediately in the real world. In this course we will use the PostgreSQL database to execute our queries, but this knowledge can be applied to any database that uses SQL, such as MySQL, Oracle, SQL Server, Redshift...What will you learn:Concepts about Databases, schemes and tablesBasic and Intermediate SQL (WHERE command, ORDER BY command, Logical Operators, Conditionals)Group data with aggregate functions using the GROUP BY commandFilter aggregated data with HAVING commandPerform all types of SQL JOINs (Inner, Left, Right, Cross, Full...)String functionsDate and Time functionsMathematical functionsSubqueriesCTEs (Common Table Expressions)Window FunctionsSQL Advanced TopicsPerformance Improvements on QueriesLet's learn together, from basic to advanced of SQL! Check out the free preview videos for more information about the complete guide!
