|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sqldatabases/
课程评论：没有评论
课程名称：SQL与数据库设计A-Z：学习MS SQL Server和PostgreSQL 课程概述： 您是否对数据科学或数据分析的职业感兴趣？无论如何，您在工作中必然会接触到数据库。那么，您该如何与数据库进行交互呢？答案很简单：使用SQL。SQL代表结构化查询语言，是组织数据库、向其输入数据以及按需提取数据的主要工具之一。在本课程中，您将学习如何在一种流行的SQL变体PostgreSQL中创建查询。即使您在工作场所使用不同的变体（例如Oracle、SQL Server或MySQL），您在本课程中获得的技能也可以轻松迁移。 那么，市面上有很多SQL课程，是什么让这门课程脱颖而出呢？这门课程的独特之处在于，除了学习SQL，您还将掌握数据库设计的概念。我们将涵盖以下主题： - OLAP与OLTP数据库（在线分析处理与在线事务处理）：您将准确理解这两种数据库设计的异同及其原因。 - 数据库的规范化：我们将展示规范化的理论，并共同一步步实践如何规范化数据库。 了解数据库是如何设计的并不是数据科学家或分析师的必备技能，然而，这是一项巨大的附加优势。这些技能将使您更好地与数据库互动，更快地从数据中得出结果和提取见解。本课程专为数据科学家和分析师设计，如果您想推动您的数据科学职业发展，这门课程就是为您准备的！期待在课堂上与您相见，Kirill与Ilya。
Are you interested in a career in Data Science or Data Analytics? In that case, inevitably you are going to encounter databases in your work. But how do you interact with databases? The answer is simple: SQL SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request. In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL. And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable. But there are many SQL courses out there, so the question is: What makes this course stand out? The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design. We will cover off topics such as: - OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ - Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step Why is that important? Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit. These skills will allow you to better interact with databases and derive results and extract insights from your data faster. This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you! We look forward to seeing you inside, Kirill & Ilya
