|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-postgresql-learning-by-real-examples/
课程评论：没有评论
Coursera 课程《Mastering PostgreSQL: Learning By Real Examples》是一门面向软件工程师和数据分析师的课程，旨在深入学习关系型数据库和 SQL。课程内容涵盖了从基本到高级的 SQL 概念和理论，特别强调通过真实示例进行“边学边练”的学习方式。 本课程以 PostgreSQL 为载体，但教学的 SQL 理论同样适用于 SQL Server、MySQL 等其他关系型数据库。课程使用了包含学生、课程、注册和讲师记录的示例数据库，通过大量实例贯穿始终，包括讲座和练习，让学习者能够即时巩固所学知识。 **课程内容亮点包括：** * **数据检索与操作：** SELECT 语句、聚合函数、内置函数、日期函数、CRUD 操作。 * **数据关联与结构：** JOIN 操作、Schema 设计、数组、JSON 在 PostgreSQL 中的应用。 * **高级查询技巧：** 子查询、各种 JOIN 类型、CASE 语句、窗口函数、正则表达式。 * **性能优化：** 查询优化策略、索引、查询计划分析、常见性能问题规避。 * **实际应用：** 将 SQL 技能应用于解决实际问题，数据建模和查询设计的最佳实践。 **学习目标：** * **掌握基础查询语法：** 熟练运用 SELECT, FROM, WHERE, GROUP BY, ORDER BY 等，实现数据过滤、排序和基本函数应用。 * **提升高级查询能力：** 能够编写复杂的查询，包括子查询、多表连接、聚合函数、CASE 语句、窗口函数及正则表达式。 * **优化查询性能：** 理解并运用索引、查询计划等技术，编写高效的 SQL 查询。 * **解决实际问题：** 将所学知识应用于真实场景，设计高效准确的数据查询。 本课程强调数据在应用程序中的核心作用，旨在帮助学员通过扎实的 SQL 查询能力，构建更优化的应用程序。
This is a course intended for software engineers and data analysts that want to learn more about Relational Databases and SQL It covers both basic and advanced SQL concepts and theories. The course is intended for both Junior and Senior Level Engineers and is purely focused on SQL and writing queries.PostgreSQL will be used in this course. But the theories you learn can be applied in any Relational Database such as SQL Server or MySqlAll the sections are explained by one or more examples. I used a sample database that had students, courses, registrations and instructors records. Learning by doing examples is a much better technique than just studying a theory.This course contains lectures and exercises. You'll get immediate practice on all of the different topics and features that you learn!You will learn about:Selecting DataAggregate FunctionsBuilt in FunctionsJoinsDatesSchema and DataCRUD OperationsTransactionsArrays in PostgresJSONs in PostgresAnd More!Data is the core of an application. Any application that you see on your phone or on your website uses some storage somewhere. Having a good database design and queries is very crucial for any application. This course focuses mainly on the querying part. At the end of the course, you should be able to:Master basic query syntax and functionality: Students will learn the syntax of basic SQL queries, including SELECT, FROM, WHERE, GROUP BY, and ORDER BY. They will also gain an understanding of how to filter and sort data, and how to use basic functions and operators.Develop proficiency in advanced querying techniques: Students will learn how to write more complex queries, including subqueries, inner and outer joins, and aggregations. They will also learn how to use advanced functions and operators such as CASE statements, window functions, and regular expressions.Optimize queries for performance: Students will learn how to optimize queries for faster execution, including indexing strategies, query planning and execution, and common performance issues to avoid.Apply queries to real-world scenarios: Students will learn how to apply their query skills to solve real-world problems. They will also explore best practices for data modeling and query design to ensure their queries are accurate and efficient.
