|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-marketers-data-analytics-data-science-big-data/
课程评论：没有评论
课程名称：完整SQL训练营：数据科学、分析与市场营销 课程概述： 在当今的商业环境中，数据驱动决策变得越来越重要。随着大数据和数据科学的兴起，我们面临着海量的数据。SQL作为数据分析的基本语言之一，被广泛应用于MySQL、Postgres、SQLite、Microsoft SQL Server、Oracle等流行数据库，以及Hive和Cassandra等大数据解决方案中。许多高层市场营销人员和产品经理都掌握了数据操作的技巧，以获取重要的洞察力，让您不再需要等候软件工程师的答复，而是可以使用SQL直接找到答案。 在本课程《完整SQL训练营：数据科学、分析与市场营销》中，我们将从基础知识开始，包括如何在Mac、Linux或Windows上安装SQL，以及什么是关系数据库。接下来，我们将进行基本操作，如创建表格和将数据加载到表中。同时，我们将学习多种SQL命令，并通过索引来提高查询速度。 掌握SQL命令后，我们将进行高级示例，回答市场营销人员和商业人士常见的问题，比如客户在销售漏斗中的流失情况，以及哪个地点的收入最高。在最后一部分，我们将对Spark进行高级SQL查询，Spark是MapReduce的继任者，同时也是一个运行在Hadoop之上的大数据框架。我将教您如何快速在Amazon EC2上安装Spark、创建集群并运行SQL查询，让您能够在大数据环境中应用之前学习的知识。 如果您想了解如何使用SQL优化销售漏斗、分析行业的季节性趋势，并在Hadoop上运行SQL查询，那就快来加入我的SQL课程吧！掌控数据分析、数据科学和大数据！ 学习小贴士： - 将视频速度调至2倍，以加快学习效率。 - 进行手写笔记，这将显著提高您对信息的记忆能力。 - 在讨论区积极提问，越多越好！ - 自己动手写代码，而不是仅仅观看代码。
It is becoming ever more important that companies make data-driven decisions.With big data and data science on the rise, we have more data than we know what to do with.One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, SQLite, Microsoft SQL Server, Oracle, and even big data solutions like Hive and Cassandra.I'm going to let you in on a little secret. Most high-level marketers and product managers at big tech companies know how to manipulate data to gain important insights. No longer do you have to wait around the entire day for some software engineer to answer your questions - now you can find the answers directly, by yourself, using SQL!In this course, The Complete SQL Bootcamp for Data Science, Analytics, and Marketing, we'll start from the basics - installing SQL onto your Mac, Linux, or Windows machine and explaining what a relational database is. Next, we'll look at basic tasks like creating tables and loading data into those tables. We will look at a wide variety of SQL commands and I will show you how to speed things up using indexes.Once you know all the SQL commands we will start doing advanced examples - answering questions marketers and business people often have, like where are customers dropping off in our sales funnel? And which of our locations has the highest revenue?In the last section, we'll do Advanced SQL queries on Spark, the big data framework that is the successor to MapReduce and also runs on top of Hadoop. I will teach you how to install Spark, create a cluster very quickly on Amazon EC2, and run SQL queries, allowing you to apply everything you learned up until this point in a big data environment.Do you want to know how to optimize your sales funnel using SQL, look at the seasonal trends in your industry, and run a SQL query on Hadoop? Then join me now in my new class on SQL! Dominate data analytics, data science, and big data!TIPS (for getting through the course):Watch it at 2x to learn twice as fast!Take handwritten notes. This will drastically increase your ability to retain the information.Ask lots of questions on the discussion board. The more the better!Write code yourself, don't just sit there and look at my code.
