|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-crash-course-for-beginners-learn-sql-with-mysql/
课程评论：没有评论
课程名称：SQL速成课程 - 学习MySQL中的SQL 概述：SQL是您可以学习的最重要的查询语言！它被许多流行的关系数据库管理系统如MySQL使用，同时也被数据分析和大数据框架（如Apache Spark）所应用。因此，掌握SQL将为您打开无数的机会和职位，无论您是从事关系数据库工作，还是成为数据科学家，SQL都是关键！因为SQL是一种标准化的语言，学习它将帮助您在各种场景中应用。 本课程将通过探讨两种最流行的数据库系统：MySQL和PostgreSQL，深入了解SQL的各个关键特性。所有查询和命令示例都针对这两种数据库系统进行展示，确保您在任一环境中都能自如使用SQL！完成此课程后，您将能够编写自己的（简单或复杂的）SQL查询，创建基本或高级的数据库和表结构，并处理各种形状和复杂性的数据。 具体学习内容包括： - SQL是什么以及核心语法的样子 - 如何编写SQL命令 - 如何安装MySQL和PostgreSQL及其各种客户端 - 如何创建和构造数据库表 - 可使用的数据类型及其应用场景 - 如何执行CRUD操作：创建、读取、更新和删除数据 - 如何向表中插入数据 - 如何查询和筛选数据 - 为什么要将数据拆分到多个表中（以及如何实现） - 如何将数据合并到组合结果集中 - 如何编写基本和更复杂的查询 - 如何聚合和分组数据 - 如何使用内置数据库函数处理数字、文本或日期 - 如何通过索引优化数据库 - 还有更多！ 探索完整的课程大纲，了解课程内容，并观看免费的预览部分，了解本课程将如何帮助您！该课程还提供30天退款保障，让您可以无风险体验。我们期待您加入我们的课程，共同探索SQL的奥秘！
SQL is THE most important query language you can learn!It's used by many popular relational database management systems like MySQL. But it's also used by data analysis and big data frameworks and tools like Apache Spark.Hence knowing SQL opens up an endless amount of opportunities and jobs - no matter if you're going to work with relational databases or if you're becoming a data scientist, knowing SQL will be key!SQL is a standardized language and therefore learning SQL will help you apply it in all kinds of contexts. Nonetheless, different database systems also support different aspects of SQL or bring their own variations of the SQL language. Therefore, this course dives into SQL by exploring all key features at the example of the two most popular database systems: MySQL and PostgreSQL. All query and command examples are shown for both database systems, ensuring that you feel comfortable working with SQL in either environment!This course will enable you to write your own (simple or complex) SQL queries, create basic or advanced databases and table structures and work with data of different shape and complexity!In detail, you will learn:What exactly SQL is and how the core syntax looks likeHow to write SQL commandsHow to install MySQL & PostgreSQL as well as various clientsHow to create and structure database tablesWhich data types you may use and when to use which data typeHow to perform CRUD operations: Create, Read, Update & Delete DataHow to insert data into tablesHow to query and filter dataWhy you should split data across multiple tables (and how to do that)How to join (merge) data into combined result setsHow to write basic and more complex queriesHow to aggregate and group dataHow to use built-in database functions to work with numbers, text or datesHow to optimize databases with indexesAnd much, much more!Explore the full course curriculum to get a thorough overview of the course content and watch the free preview section to learn how this course will help you!This course also comes with a 30 day refund period, so that you can try it risk-free:)We'd love to welcome you on board of this course and explore SQL together with you!
