|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-the-fundamentals-of-sql-with-python/
课程评论：没有评论
Coursera课程“Job-Ready SQL in an Afternoon”旨在帮助学员快速掌握SQL技能，为技术面试和实际工作做好准备。 课程内容涵盖： * **SQL基础知识**: 介绍关系模型、数据库模式、数据类型以及数据库表的组织结构。 * **环境搭建**: 指导学员在本地搭建Postgres数据库并导入数据，为实际操作提供数据支持。 * **SQL入门**: 学习创建数据库和表、插入和选择数据、数据过滤及结果排序等基本SQL操作。 * **高级SQL**: 深入学习聚合函数、子查询、JOIN（连接）、UNION（联合）以及窗口函数等进阶SQL概念。 完成本课程后，学员将能够自信地在技术面试和日常工作中运用SQL进行数据处理和管理。
SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today's world. Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.In this course we'll be learning SQL. We'll start by going through some fundamental knowledge like learning about the relational model, as well as what schemas are, the different data types available, and how database tables are organized. Then we'll go ahead and set up our own local Postgres database and populate it with data so that we have data to run queries against. Once our setup is done we're then ready to directly jump into writing SQL code.We'll start with the basics like creating databases and tables, inserting and selecting data, and performing filtering and result ordering. This way we can make sure we're comfortable with how the data is laid out and that we feel good performing the basic operations that usually make up all queries.Then we'll jump deeper into SQL by learning about aggregations, subqueries, joins, unions, and window functions.By the end of this course you should be ready to successfully apply your SQL knowledge in both technical interviews as well as on the job.
