|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sql-practical-introduction-for-querying-databases
课程评论：没有评论
课程名称：SQL：数据库查询的实用入门 课程概述：世界上大部分的数据都存储在数据库中。SQL（结构化查询语言）是一种强大的编程语言，用于与数据库中的数据进行通信和操作。对于希望在数据工程、数据仓库、数据分析、数据科学或商业智能领域开始职业生涯的任何人来说，了解数据库和SQL是必不可少的。本课程旨在帮助您学习和应用SQL语言的基础和中级知识。 课程大纲： 1. **入门SQL**： - 描述：在此模块中，您将被介绍到数据库的基本概念。您将创建一个云上的数据库实例，并学习一些基本的SQL语句。还将进行实际操作，亲自编写和练习基本的SQL语句。 2. **关系数据库和表的介绍**： - 描述：在该模块中，您将探索数据库、表及它们之间关系的基本概念。您将创建一个数据库实例，学习能够创建和操作表的SQL语句，并在自己的实时数据库上进行实践。 3. **中级SQL**： - 描述：在此模块中，您将学习如何使用字符串模式和范围来搜索数据，以及如何在结果集中对数据进行排序和分组。您还将练习构造嵌套查询，并执行选择语句以访问多个表中的数据。 4. **处理真实世界的数据集、期末项目与考试**： - 描述：在此任务中，您将使用来自芝加哥市的多个真实数据集。您将被问到一些问题，帮助您理解数据，就像在现实世界中一样。您将根据SQL查询和结果的正确性进行评估。 5. **数据工程师的高级SQL**： - 描述：本模块涵盖一些对数据工程师非常有用的高级SQL技术。如果您正在跟随数据工程轨道，必须完成此模块。在此模块中，您将学习如何通过视图、事务、存储过程和连接等高级SQL技术构建更强大的查询。 通过本课程，您将掌握SQL的基础知识，并在实际数据处理中应用这些技能，为您在数据领域的职业生涯奠定坚实的基础。
Name:Getting Started with SQL
Description:In this module, you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.
Name:Introduction to Relational Databases and Tables
Description:In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.
Name:Intermediate SQL
Description:In this module, you will learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.
Name:Working with real-world data sets, Final Project & Exam
Description:In this assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real wold. You will be assessed on the correctness of your SQL queries and results.
Name:Advanced SQL for Data Engineers
Description:This module covers some advanced SQL techniques that will be useful for Data Engineers. If you are following the Data Engineering track, you must complete this module. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.
Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and manipulating data in databases. A working knowledge of databases and SQL is a must for anyone who wants to start a career in Data Engineering, Data Warehousing, Data Analytics, Data Science or Business Intelligence. The purpose of this course is to help you learn and apply foundational and intermediate knowledge of the SQL language, and become
