|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/join-together-now-write-t-sql-joins-using-sql-server/
课程评论：没有评论
Essential SQL: Join Together Now, Write Complex Queries 本课程旨在帮助学习者掌握SQL中的JOIN语句，并能处理更复杂的查询。 **学习目标：** * **跨平台兼容：** 学习编写可在MySQL, PostgreSQL, SQL Server, Oracle, 和 SQLite中使用的JOIN语句。 * **掌握INNER JOIN：** 学习并理解INNER JOIN的用法。 * **理解OUTER JOIN：** 学习LEFT OUTER JOIN和RIGHT OUTER JOIN的区别和用法。 * **掌握FULL OUTER JOIN：** 理解FULL OUTER JOIN的概念，并学会如何通过其他语句模拟其效果。 * **探索其他JOIN类型：** 了解SELF JOIN, CROSS JOIN, NON-EQUI JOIN等Joining类型，并知道何时使用它们。 * **解决实际问题：** 学会运用不同的JOIN类型解决实际的查询问题。 * **理解JOIN差异：** 区分INNER JOIN和OUTER JOIN的关键不同。 * **利用NON-EQUI JOIN：** 使用NON-EQUI JOIN解决诸如计算运行总计等问题。 * **整合多表数据：** 学会从两个或多个表中合并列到单个结果中。 * **判断OUTER JOIN的使用时机。** **课程优势：** * **克服学习障碍：** 针对SQL学习中容易遇到的困惑和迷茫，提供清晰的学习路径。 * **高效学习：** 避免浪费时间学习无关紧要的特性，专注于核心技能。 * **建立信心：** 帮助学习者建立信心，确信自己在正确的学习方向上。 * **学习乐趣：** 将学习SQL JOIN的过程变得有趣。 **课程成果：** 完成本课程后，学习者将能深入理解JOIN在SQL中的重要性，克服对JOIN的恐惧，并能独立编写能够合并多表数据的复杂SQL查询。
In this Course you will Learn to:Write join statements that work with MySQL, PostgreSQL, SQL Server, Oracle, and SQLite.Write Inner Joins.Learn to write outer joins, and know the difference between a right and left outer join.Understand when and how to use a full outer join. You even be able to reproduce the result of a full outer join using other statements!Learn about other types of joins such as self joins, cross joins, non-equi joins, and outer joins, and when it is appropriate to use them.Use different types of joins to solve real-world query problems.Understand the key differences between inner and outer joins.Use non-equi joins to solve interesting problems such as calculating running totals.Combine columns from two or more tables into a single result.Know when to use an outer join.Learning SQL Should Not Be Out of Your ReachWith so much information available on the Internet it's easy to get confused. You want to continue learning SQL but don't know where to start. SQL is deceptive, mysterious, especially if not explained well.But it doesn't have to be this way!Nothing is worse thanBeing excited to learn something new but not knowing where to start.Wasting time learning the wrong features.Being overwhelmed with options and not know which to use.Imagine HavingKnowledge - Knowing how to quickly use joins to take your SQL to the next level.Confidence - Feeling good that you're on the right track.Accomplishment - Having a sense of accomplishment that you've learned something most cannot.Fun - Having fun learning SQL inner and outer joins!By the time you've completed this course you'll have an appreciation of joins, overcome your fear, and able to write queries combining data from multiple tables.Now that's cool!
