|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-absolute-beginners/
课程评论：没有评论
课程名称：《完全适合绝对初学者的SQL课程》 课程概述：您是否决定学习SQL，或者想了解SQL，但不知道从何开始？您是数据/商业分析师或数据科学家，希望通过使用结构化查询语言（SQL）提升数据技能？那么，这门课程就是为您量身打造的！本课程将作为您进入SQL编程世界的第一步，我们会深入研究SQL查询的概念，了解MySQL用户界面，并与多个数据集进行互动。 课程内容包括以下几个方面： - 随着每一步讲解，进行代码练习，逐步积累SQL知识。 - 通过各类难度的问题和实操练习来检验自己的学习成果。 - 分析真实数据集，理解从问题到SQL代码解决方案的思考过程。 本课程着重实践，而不是教授所有可能的函数，我们将慢慢学习所有基础知识，从零开始构建我们的知识体系。我们将利用案例研究巩固每个概念，以便您在实际项目中更容易应用这些概念。 课程结束时，您将能够使用SQL创建和操作数据表。学习过程中，我们还将掌握一些重要的SQL语句，如GROUP BY、INSERT INTO和CREATE TABLE等。 完成课程后，您将能够： - 使用SQL连接不同的表。 - 创建自己具有适当结构的表。 - 根据数据特征使用不同的数据类型。 - 使用现有表中的数据创建新列。 - 编写子查询，构建复杂的指令。 加入成千上万的专业人士和学生，踏上这段SQL之旅，发现这一查询语言的强大魅力。课程将根据学生的反馈不断更新。
So, you've decided that you want to learn SQL or you want to get familiar with it, but don't know where to start? Or are you a data/business analyst or data scientist that wants to power up your data skills by performing queries with Structured Query Language?Then, this course was designed just for you! This course was designed to be your first step into the SQL programming world! We will delve deeper into the concepts of SQL queries, understand the MySQL user interface and play around with several datasets. This course contains lectures around the following groups: Code along lectures where we will go step-by-step in each instruction, compounding our SQL knowledge.Test your knowledge with questions and practical exercises with different levels of difficulty!Analyze real datasets and understand the thought process from question to SQL code solution!This course was designed to be focused on the practical side of coding in SQL - instead of teaching you every possible function out there, we'll learn all the fundamentals slowly and build our knowledge from scratch. We'll use a case study to cement every concept we will learn, so that you can have a hands-on learning process, making it easier to apply the concepts in your projects.At the end of the course you should be able to use SQL to build and manipulate tables. Along the way we will also learn the most important SQL statements such as GROUP BY, INSERT INTO or CREATE TABLE.Here are some examples of things you will be able to do after finishing the course:Join different tables using SQL;Create your own tables with the appropriate structure.Use different data types according to their characteristics.Create columns using data available from your existing tables.Use subqueries, building complex instructions.Join thousands of professionals and students in this SQL journey and discover the amazing power of this querying language. This course will be constantly updated based on students feedback.
