|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-essentials-for-anyone/
课程评论：没有评论
课程名称：SQL基础 - 一种全新的SQL学习方式，适合所有人！ 概述：大多数SQL课程采用老旧的教学方式，我在很久以前就设法找到了一种更佳的学习方法，更容易、更快速地掌握SQL。现在，你有机会也能学习这种方法！ 课程内容： 1. SQL的五大基本原理 2. 如何运用这五大原理指导SQL查询的开发和理解 3. 理解内连接和外连接的读写技能 4. 理解分组和聚合函数的读写技能 5. 使用连接和分组模式来验证数据假设并探索数据 为什么学习SQL？SQL是一项高需求的技能，我身为数据专业人士，深知此项技能可以为你提供许多高薪的工作机会。许多非数据专业人士也希望更好地掌握SQL，因为它是很多工作的重要部分！ 这门课程的特别之处在于，大多数SQL课程只是冗长地列出代码、语法及其描述，而没有实际应用或如何将它们结合起来的教学。许多人即便修过SQL课程，仍未能掌握基本概念，如连接和分组。本课程的目标是帮助你建立一种可重复的查询方法，并教你应该关注数据集的哪些属性，以确保理解、查询成功和数据准确性。 此外，本课程比大多数课程更短，因为传统课程往往尝试教会你所有内容，而大多数内容并不必要，甚至会导致困惑。本课程专注于SQL的精髓，降低了学习的威慑感，能够满足大多数查询的需求。 适合人群： - 想学习SQL或提升SQL技能的任何人 - 学过其他SQL课程仍不理解连接或分组的人 - 希望更快、更轻松掌握SQL的人 - 对SQL教学方式感到挫败或对自己SQL能力没有信心的人 - 学生、开发者、数据专业人士、数据科学家、经理、会计、市场人员、报告撰写者等 先决条件：需要具备现代Windows计算机，以便安装软件进行课程中的实例和实验，虽然这不是绝对必要的，但我强烈推荐这样做。本课程为初学者级别，不要求从零开始，但学习者需了解数据库并能写出非常基本的查询，比如从一个表中提取数据并使用条件过滤。 不要再等了！我非常期待用这种新方法教大家SQL，并希望它能在你需要使用SQL时帮助到你。享受30天退款保证，你没有任何损失的风险！
Most SQL courses I've seen teach it in the same old way that I struggled with when I first learned SQL. I set out a long time ago to come up with a better way to approach the topic that would be much easier and faster to learn. This new method has worked well and now you have the chance to learn from this method also! What You'll LearnThe five fundamentals of SQL - The theory behind SQLHow to use the five fundamentals to guide your SQL query development and understandingHow to read, write, and understand inner and outer joinsHow to read, write, and understand groupings and aggregate functionsUse joins and grouping patterns that will help you validate data assumptions and explore dataWhy Learn SQL?SQL is a skill that is in high demand. Take it from me, I am a data professional and there is certainly no shortage of great paying jobs and career paths using data and SQL. I've also interacted with many people that are not data professionals, that all wished they knew SQL better because it was a part of their job as well! What's So Special About This Course?There are a lot of SQL courses out there. Most of the time it's basically a long winded list of code, syntax, and descriptions of what things are, but with no real application or teaching on how they work together and what's really going on. In other words, nobody actually understands it well enough to query their own databases after the class is over. It also takes years of practice to really "get it." I can personally attest to this problem. When I took my first database class in college, I didn't do very well and I even decided I'd never deal with databases again. It was very frustrating! This class aims to fix this issue by teaching you how to approach any query in a repeatable process, and to teach you what properties of a dataset to pay attention to in order to assure understanding, query success, and data accuracy.I've also found that most people that already know SQL (and some are pretty good at it!) still struggle with understanding the primary concepts in this course, joins and groupings. Most people just guess at which join type to use, see what the results look like, and hope for the best. This course is the fix for that. After going through this course you should have no doubt in your mind at all which join to use, why you're using it, and have a similar confidence with groupings and aggregate functions as well. If you can understand these two main concepts(joins and groupings), just about everything else in SQL is based on these two concepts and SQL becomes easy. That's why this course contains mostly material on these two areas, they really are the essentials of SQL!Finally, this course is shorter than most. Other courses will try and teach you everything. In my experience, this is counterproductive because 80% or more of what was in the course is not used or even necessary, and serves to be even more confusing and overwhelming. By shortening this course to teach the essentials, the course is a lot less intimidating, and it's all you need for most queries.Who Should Take This CourseAnyone that wants to learn SQL or enhance their skills with SQLAnyone that has taken another SQL class and still can't seem to understand how joins or groupings workAnyone that wants to learn SQL faster and easierAnyone that is frustrated with how SQL was taught to you or if you're just not that confident in your SQL abilitiesStudents, developers, budding data professionals, data scientists, managers, accountants, marketers, report writers, etc.PrerequisitesYou need a modern Windows computer with access to install software in order to do the examples and labs in this course because it is based on SQL Server. This is technically optional, but I highly recommend doing the labs to get the most benefit from this course.This course doesn't start at absolute zero, but it is a beginner level course. Before you start this course you should know what a database is, and be able to write and understand very basic queries. By very basic, I'm talking about being able to pull data from one table and filter the rows with a where clause. Once you can do that, you're ready to learn joins and start this course. What Are You Waiting For?I'm excited to teach people SQL with this new method I created and I sincerely hope that it will serve you well any time you need to use SQL! I have already helped many others using this method with great results. I invite you to give this course a try. With the 30 day money back guarantee, you can't lose!
