|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-solve-real-world-data-problems-with-sql-queries/
课程评论：没有评论
SQL：用SQL查询解决现实世界数据问题 本课程专注于Structured Query Language (SQL)，一种用于访问和操作数据库的标准语言。SQL自1980年代起成为ANSI和ISO标准，并且在各种数据库系统中广泛应用。 尽管数据领域不断出现新的术语，如数据湖、数据科学、物联网、机器学习等，但SQL仍然是处理这些新兴技术的基础。学习SQL是一项具有终身价值的技能，因为它相对稳定且应用广泛。 本课程强调“边做边学”的学习方法，通过解决实际应用中的SQL问题来加深理解和掌握。课程设计了具有挑战性的实践问题，重点是数据分析和报告。通过解决这些以商业为导向、以订单数据库为背景的问题，学员将能够： * **掌握SQL思维方式**：学习如何分析数据问题，分解为基本要素，并编写清晰、优雅的SQL解决方案。 * **提升SQL编码能力**：通过精心设计的练习，提高编写高质量SQL代码的能力。 * **积累实战经验**：解决常见的数据挑战，学习最有效、最有用的技术。 * **循序渐进**：课程将引导学员逐步掌握从入门级到高级别的SQL SELECT语句，涵盖数据分析和报告的需求。 通过本课程的学习，学员将获得解决现实世界数据问题的技能和经验，从而在数据相关领域获得更好的职业发展。
SQL stands for Structured Query Language. SQL lets you access and manipulate databases.SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987. Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!. SQL is a standard language for storing, manipulating and retrieving data in databases. The world of computer technology changes very quickly, and databases are no exception.The latest data-related buzzwords are data lakes, data science, the Internet of Things (IOT), data wrangling, machine learning, etc. Buzzwords that have been around a little longer are big data, cloud data, ETL, data analytics, dashboards, business intelligence, etc. But...what basic, fundamental skill do you need, in order to work with any of these new database technologies? SQL! SQL is necessary for almost everything data related. Database systems have been around since the 1970's and are used extensively at all companies and organizations. And to work with these databases at anything other than a very basic level, you need to understand and write SQL. And unlike some other technologies and programming languages (which change very frequently), SQL is much more stable. Once you learn it, it's a skill you can use for a lifetime.To really absorb and be able to apply your learning, you need to do real-world problems. Being presented with a SQL problem, and working through that problem will help you understand and remember concepts and principles like nothing else. L earning how to think through a data problem, break it down to the fundamentals, and craft an elegant, readable solution in SQLIt requires practice and experience. And most of the time, that level of practice and experience only comes from years of real world work with large datasets. But by working though the carefully crafted problem sets in this course, you can develop skills equivalent to those years of experience. And these skills will help you get the job you want.The SQL Practice Problems will teach you how to "think" in SQL, how to analyze data problems, figure out the fundamentals, and work towards a solution that you can be proud of. It contains challenging problems, that hone your ability to write high quality SQL code. With SQL Practice Problems, you'll get experience solving some of the most common challenges you'll run into with data, and the best, most useful techniques to solve them.It has data analysis and reporting oriented challenges that are designed to step you through introductory, intermediate and advanced SQL Select statements, with a "learn-by-doing" technique. The problems are business oriented, and use an order database. Working through the problems and absorbing the techniques presented-this is what will give you the skill and experience you need to solve real-life data problems.
