Coursera 笔记

Module 01 · Getting Started with SQL

Course Overview课程概述

Coursera ↗

The course is structured into 6 weeks, each focusing on a specific topic.
课程分为 6 周，每周专注于一个特定主题。

**Week 1: Getting started with SQL **第 1 周：SQL 入门

This week will let you learn the basics of SQL and databases. You will also learn how to query tables in a database.
本周将让您学习 SQL 和数据库的基础知识。您还将学习如何查询数据库中的表。

**Week 2: Introduction to Relational Databases and Tables **第 2 周：关系数据库和表简介

This week is all about relational databases, creating tables, and modifying their contents.
本周主要涉及关系数据库、创建表以及修改表内容。

**Week 3: Intermediate SQL **第 3 周：中级 SQL

In this module, you will learn more about different types of SQL queries, functions, string patterns, grouping, and sorting.
在本模块中，你将学习更多关于不同类型的 SQL 查询、函数、字符串模式、分组和排序。

**Week 4: Accessing databases with Python **第 4 周：使用 Python 访问数据库

This week, you will learn the nuances of accessing databases using Python libraries and SQL magic in Jupyter Notebooks.
本周，您将学习使用 Python 库和 Jupyter Notebooks 中的 SQL 魔法访问数据库的细微差别。

**Week 5: Course Assignment **第 5 周：课程作业

This week is designed to give you an understanding of how to deal with real-world datasets and complete an assignment which tests your skills acquired throughout the course.
本周旨在让您了解如何处理实际数据集，并完成一个测试您在整个课程中获得的技能的作业。

Week 6: Bonus Module: Advanced SQL for Data Engineers 第 6 周：奖励模块：数据工程师的高级 SQL

In this additional module, you will learn how to apply advanced queries in SQL, like Views, Stored Procedures, and ACID transactions.
在这个附加模块中，你将学习如何应用高级 SQL 查询，例如视图、存储过程和 ACID 事务。

This course can be applied to multiple Specializations or Professional Certificates programs. Completing this course will count towards your learning in any of the following programs:
本课程可应用于多个专业认证或专业证书项目。完成本课程将计入以下任何项目中的学习进度：

Upon completion of the course, you will receive a shareable certificate that you can add to your LinkedIn profile.
完成课程后，您将获得一份可分享的证书，可以添加到您的领英个人资料中。