|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-data-engineer-etl-testing-basics-foundation/
课程评论：没有评论
SQL 基础：数据工程师 ETL 测试分析 一门可以帮助您年薪近 10 万美元的课程！ SQL（结构化查询语言）是与数据库交互的语言，用于轻松检索数据。随着商业智能和大数据等术语日益普及，企业对掌握 SQL 语言的人才需求将不断增长。 本课程将教授您 SQL 语言的使用方法，通过丰富的视频课程讲解大部分内容，并在每节课后提供带有详细解释的练习题。学完课程后，您将能够从任何数据集中查询和提取有价值的见解。 **使用 MySQL 学习 SQL** 为了做出明智的商业决策，需要正确的数据。而要获取正确的数据，就需要与数据库通信并从中查询数据。SQL（结构化查询语言）正是用于与数据库通信的语言，它能帮助您做出能节省时间和金钱的明智决策。 **为什么选择本课程？** 本课程从最基础的数据库通信概念讲起，将教您如何使用 MySQL 查询和管理数据库。MySQL 是一个免费的开源关系数据库管理系统 (RDBMS)，被众多世界大型组织使用。 每节课都侧重于 SQL 的一个关键主题，视频讲解直观易懂。每节课后都有练习题和测验来巩固您的理解。课程内容层层递进，帮助您构建扎实的 SQL 知识体系。 本课程强调实践，您需要动手编写 SQL 代码来真正掌握知识。此外，课程还提供可下载的学习资源，并设有问答区，方便您提问和与其他学员交流。 **课程目标** * 掌握使用 MySQL Workbench 创建、查询和管理数据库的基础。 * 学习正确的 SQL 语法。 * 了解关系数据库设计概念。 * 掌握使用 SELECT 语句从数据库中查询数据。 * 学习使用列别名增加数据的上下文和含义。 * 学会使用 WHERE 子句过滤数据库查询结果。 * 利用过滤运算符创建高级查询。 * 使用 ORDER BY 关键字对查询结果进行排序。 * 学会如何正确地对数据进行分组并创建用于报表的计算。 * 使用 HAVING 子句过滤数据组。 * 从零开始创建 MySQL 数据库。 * 学习创建表和管理表中的记录。 * 以及更多！
Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.This course will teach you how to use the SQL language.You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems with proper explainations. On completion of the course you will be able to query and extract insights from any dataset.LEARN SQL WITH MySQLIn order to make intelligent business decisions you need the proper data. In order to get the proper data you will need to communicate with and query data within a database. This is where SQL comes into play. SQL stands for Structured Query Language. It's the language used to communicate with a database and more importantly the data needed to make intelligent decisions that will save time and money.WHY THIS COURSEThis SQL course starts with the absolute basic building blocks necessary to communicate effectively with any database. You'll learn how to query and manage a database using MySQL. MySQL is a free open-source relational database management system (RDBMS), used by many of the world's largest organizations.Each section of the course will focus on a key topic of working with SQL. The video lectures have been created so you can follow along as the instructor demonstrates each concept. At the end of each section you can test your understanding through a section quiz and exercise. Once you complete a section the next section will build on the topics of the previous section. This encourages your learning as you build upon the knowledge you learn as you move from one section to the next.This course is not just a sit back and watch the instructor type on the screen kind of course. The lectures and course flow has been designed to help you engage in the topic and participate by writing your own SQL. The TRUE LEARNING happens when you apply what you're learning and try it yourself.The course also contains downloadable resources you can use away from the course as you continue to learn SQL. The QA board found within the course offers you the opportunity to ask questions and get answers from the instructor and interact with the other students enrolled in the course.COURSE OBJECTIVESIn this SQL course you will learn the fundamental building blocks of creating, querying and working with databases using MySQL.Learn Proper SQL Syntax Using the MySQL WorkbenchLearn Relational Database Design ConceptsUse the SQL SELECT Statement in Order to Query Data from a DatabaseUse Column Alias to Give additional Context and Meaning to the DataLearn How to Filtering Database Query Results Using the SQL Where ClauseCreate Advanced Queries by Using the Proper Filter OperatorsUse the SQL ORDER BY Keyword to Sort the Results of a QueryLearn How to Properly Group Data and Create Calculations for ReportingUse the SQL HAVING Clause to Filter within Data GroupsCreate a MySQL Database from ScratchLearn How to Create Tables and Manage Records within the TablesAnd Much More...
