|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-fundamentals-for-business-intelligence/
课程评论：没有评论
课程名称：商业智能的SQL基础 课程概述：许多人对SQL有一定的了解，但在面对现实世界的商业问题时，我们对数据库课程的模糊记忆往往会令人失望！本视频课程将引导您提升到中级SQL水平，让您在特定商业查询的背景下编写可维护和复杂的SQL。课程将从导入第一个数据集——DVD租赁数据库开始，接着探索并实践各种SQL子句和连接类型。课程中的基本概念示例都以实践和动手练习为指导。整个过程中不允许使用“虚无”例子，而是将现实问题带入教育场景。您还将学习如何将外部数据导入数据库，而不会过多担心数据库管理员的功能与考虑。此外，您还将了解如何将数据导入流行的商业智能工具（如Excel和Tableau），并进一步优化分析，同时讨论数据的解读。到课程结束时，您将提升SQL技能，并学会如何根据数据集回答商业问题。 作者简介：杰弗瑞·詹姆斯自2006年以来一直活跃于分析和数据领域。他扎根于数字营销和网页分析，并将分析技术应用于从客户价值分析到财务预测、机器学习和流程自动化等各种问题。他在掌握过程中经历了不少错误，深刻理解初学者的心态。
Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down! This video course will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. You will start by importing our first dataset which will be the DVD rental database. We then will explore and put into practice various SQL clauses and Join types. All examples of fundamental concepts are tightly guided by practical and hands-on exercises. No "Foo Bar" allowed anywhere, just problems from the wild, brought into the educational space. You will also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations. You'll also find out how to take the data into popular BI tools (Excel and Tableau) and refine the analysis further while discussing the interpretation of the data. By the end of the course, you will have developed your SQL skills and learnt how to answer business questions from the set of data. About the Author Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he's applied analytical techniques to problems ranging from customer value analysis to financial forecasting, machine learning and process automation. He's made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
