|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-essentials/
课程评论：没有评论
课程名称：SQL基础：SQL语言初学者指南 课程概述：本课程提供了您开始编写SQL查询所需的一切知识。学习SQL的简短答案是——如果您掌握SQL，您将始终能够找到工作！因为它在多种职业角色中被广泛应用，例如：数据分析师、数据科学家、数据工程师、数据库/数据仓库开发人员和设计师、软件质量保证工程师等。虽然SQL语言看似简单，但某些主题可能会导致错误，如NULL值、重复行和缺失行等。本课程将涵盖常见错误及其避免方法。 您将学习适用于大多数关系数据库的SQL语法。在实践练习中将使用PostgreSQL，但这些知识可以轻松迁移到其他数据库，如PostgreSQL、Oracle、Microsoft SQL Server、MySQL、Teradata等。所有符合ANSI标准的SQL数据库中标准SQL是相同的。 为什么选择本课程？因为课程是基于作者丰富的行业经验编制的，专注于数据分析工作日常使用的主题和功能。 课程特点： - 高质量的视频讲座 - 手动制作的英文字幕（而非自动生成） - 练习测试 - 实践练习以测试和增强您的知识（附有详解答案） - 还有更多内容！ 期待在课程中见到您！欢迎查看免费的预览视频以获取更多信息！
The course has everything you need to start writing your own SQL queries.Why learn SQL? Short answer is - if you know SQL well, you'll always be able to find a job! That's because it is used in a variety of different job roles:- Data Analysts- Data Scientists, Data Engineers- Database / Datawarehouse Developers and Designers- Software Quality Assurance Engineers- And more!The SQL language seems simple - and that's true. However, some topics can cause mistakes - things like NULL values, duplicate rows and missing rows, etc. This course covers the frequent mistakes, and how to avoid them.You will learn SQL syntax applicable to most relational databases. In the practice exercises you will use PostgreSQL, but the knowledge is easily transferable to other databases: PostgreSQL, Oracle, Microsoft SQL Server, MySQL, Teradata and so on. The standard SQL is the same in all ANSI-compliant SQL databases.Why this course? Because it was made based on the author's experience from the industry - so the course focuses on the topics and features that are really used on a day-to-day basis for data analysis. Features:- High-quality video lectures- English subtitles (closed captions) hand-made for you (NOT auto-generated)- Practice tests- Practice exercises to test and enhance your knowledge (with explained solutions)- And more!I'll be happy to see you inside the course. Check out the free preview videos for more information!
