|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/the-structured-query-language-sql
课程评论：没有评论
课程名称：《结构化查询语言 (SQL)》 课程概述：在本课程中，您将全面了解结构化查询语言（SQL）。我们将回顾该语言的起源及其概念基础，主要关注学习所有标准SQL命令及其语法，以及如何利用这些命令对关系数据库中的数据进行分析。课程范围不仅包括用于检索数据和创建分析报告的SELECT语句，还涵盖了用于创建和维护数据库对象的DDL（数据定义语言）和DML（数据操作语言）命令。 本课程可作为科罗拉多大学博尔德分校的科学硕士学位（MS-DS）的一部分，通过Coursera平台获取学术学分。MS-DS是一个跨学科的学位，汇聚了应用数学、计算机科学、信息科学等多个部门的教师。该项目采用基于表现的招生方式，无需申请流程，适合计算机科学、信息科学、数学和统计学等领域的本科教育或专业经验广泛的个人。 课程大纲： 1. **SQL简介** 描述：SQL的起源、工作原理及其定义。 2. **基本SELECT语句** 描述：从数据库中检索数据的SELECT语句。 3. **分组函数、小计和子查询** 描述：五个分组函数的使用。 4. **获取多表数据** 描述：使用JOIN从多个表中获取数据。 5. **DDL和DML** 描述：超越SELECT的SQL语句。 6. **高级SQL命令** 描述：一些更高级的SQL功能。 有关MS-DS项目的更多信息，请访问https://www.coursera.org/degrees/master-of-science-data-science-boulder。
Name:Introduction to SQL - Structured Query Language
Description:The origins of SQL, what it is and how it works.
Name:The Basic SELECT Statement
Description:The SELECT statement - retrieving data from your database.
Name:Group Functions, SubTotals, and Subqueries
Description:The five GROUP functions.
Name:Getting Data from Multiple Tables
Description:Using the JOIN.
Name:DDL and DML
Description: SQL Statements: beyond the SELECT.
Name:Advanced SQL Commands
Description:Some more advanced SQL capabilities.
In this course you will learn all about the Structured Query Language ("SQL".) We will review the origins of the language and its conceptual foundations. But primarily, we will focus on learning all the standard SQL commands, their syntax, and how to use these commands to conduct analysis of the data within a relational database. Our scope includes not only the SELECT statement for retrieving data and creating analytical reports, but also includes the DDL ("Data Definition Language") and DML ("Data Manipulation Language") commands necessary to create and maintain database objects. The Structured Query Language (SQL) can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.
