|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-advanced-sql-course-2021/
课程评论：没有评论
**Coursera 高级 SQL 课程总结** 本课程专为已有 SQL 基础并希望将查询技能提升至高级水平的学习者而设计。无需安装任何软件，课程将使用基于网络的 Oracle APEX 平台，并提供云端虚拟数据库。虽然以 Oracle APEX 为例，但课程内容强调了 Oracle, MySQL, Microsoft SQL Server 等主流数据库管理系统之间的关键差异，使学习者掌握的知识可广泛应用于所有支持 SQL 的平台。 **课程内容涵盖：** * 分析函数 (Analytical Functions) * 正则表达式 (Regular Expressions - RegEx) * 物化视图 (Materialized Views) * GROUP BY 语句的扩展 * 相关子查询 (Correlated Subqueries) * 公共表表达式 (Common Table Expressions - CTEs) * 层次查询 (Hierarchical Queries) * 数据清洗 (Data Cleansing) * 数据操作 (Data Manipulation) 课程以简短、精炼的讲座形式呈现，力求全面且易于学习。每个章节都精心设计，包含测验、作业和真实世界场景，以帮助学习者巩固和发展实践技能。 讲师拥有超过十年的专业经验，曾为多家上市公司提供咨询服务，并广泛应用于 Oracle, MySQL, Microsoft SQL Server 等多个数据库管理系统。期待您的加入！
If you have some experience with SQL and want to develop your query skills to the next level from intermediate to advanced then this is the perfect course for you!No downloads or software installation required. We will be using Oracle APEX which is a web-based application - you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.This course will cover:Analytical (Window) FunctionsRegular Expressions (RegEx)Materialized ViewsExtensions to Group ByCorrelated SubqueriesCommon Table ExpressionsHierarchical QueriesData CleansingData ManipulationThe lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Each section of the course has been specifically tailored to give the optimal learning experience, sections are packed with quizzes, assignments and real world type scenarios to give you an opportunity to develop your practical skills.As your instructor I have 10+ years of professional experience consulting and working for a range of publicly listed companies. I have worked extensively across multiple database management systems including Oracle, MySQL and Microsoft SQL Server. I hope to see you enrolled in the course!
