|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-the-complete-developers-guide-mysql-postgresql/
课程评论：没有评论
课程名称：SQL - 完整开发者指南（MySQL，PostgreSQL） 课程概述：SQL是您可以学习的最重要的查询语言！它被许多流行的关系数据库管理系统使用，如MySQL或PostgreSQL。此外，它也被数据分析和大数据框架及工具（例如Apache Spark）广泛采用。掌握SQL将为您开辟无尽的机会与职业道路，无论您是从事关系数据库工作，还是成为数据科学家，SQL都是关键技能！本课程从基础开始，以极高的详细程度教授SQL。同时，该课程提供两条主要学习路径：完整课程路径和快速概述路径。完整课程路径将逐步学习所有关键特性和概念，而快速概述路径则在数小时内教授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 or PostgreSQL. Additionally it's also used by data analysis and big data frameworks and tools like Apache Spark.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!This course teaches you SQL from the ground up and in extremely high detail! In addition, this course comes with two main paths that you can take: The "Complete Course" path where you go through the entire course, step by step, learning about ALL the key features and concepts you have to knowThe "Quick Summary" path where you will learn the key SQL essentials within a few hoursBoth paths are included in this course (i.e. with one single purchase) and you can switch between them or take both - simply as it makes most sense for you! Just dive into the free first course section to learn all about this course and these two paths (and how to take them).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!
