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.
Databases for Data Scientists 专项课程科罗拉多大学波德分校课程信息
195,882 次近期查看
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 2 门课程（共 3 门）
初级
Successful completion of Relational Database Design (Databases for Data Scientists, Course 1) recommended.
完成时间大约为25 小时
英语（English）
字幕：英语（English）
您将学到的内容有
The origins and historical basis for SQL
Standard SQL use and syntax
How to code SQL queries in order to analyze data stored in relational databases
您将获得的技能
- Data Science
- Database (DBMS)
- Database Application
- SQL (Structured Query Language)
- database administration
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 2 门课程（共 3 门）
初级
Successful completion of Relational Database Design (Databases for Data Scientists, Course 1) recommended.
完成时间大约为25 小时
英语（English）
字幕：英语（English）
提供方
科罗拉多大学波德分校
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
立即开始攻读硕士学位
此 课程 隶属于 科罗拉多大学波德分校 提供的 100% 在线 Master of Science in Data Science。
如果您被录取参加全部课程，您的课程将计入您的学位学习进程。
授课大纲 - 您将从这门课程中学到什么
完成时间为 2 小时
Introduction to SQL - Structured Query Language
The origins of SQL, what it is and how it works.
完成时间为 2 小时
5 个视频 （总计 64 分钟）, 1 个阅读材料, 3 个测验
完成时间为 5 小时
The Basic SELECT Statement
The SELECT statement - retrieving data from your database.
完成时间为 5 小时
5 个视频 （总计 78 分钟）, 6 个阅读材料, 5 个测验
完成时间为 4 小时
Group Functions, SubTotals, and Subqueries
The five GROUP functions.
完成时间为 4 小时
3 个视频 （总计 49 分钟）, 4 个阅读材料, 6 个测验
完成时间为 4 小时
Getting Data from Multiple Tables
Using the JOIN.
完成时间为 4 小时
4 个视频 （总计 44 分钟）, 4 个阅读材料, 5 个测验
审阅
- 5 stars86.44%
- 4 stars11.86%
- 2 stars1.69%
来自THE STRUCTURED QUERY LANGUAGE (SQL)的热门评论
由 AB 提供May 12, 2022
Great to begin with and good for students trying to learn SQL Basics
由 KT 提供Apr 6, 2022
this course has made the SQL pretty much interesting
由 WD 提供May 11, 2022
A good kick-start course for SQL. I have gained a lot of SQL knowledge in this course including practical terms.
由 CO 提供May 18, 2022
Very good and well structured. Good tutor as well. Thanks Alan Paradise
关于 Databases for Data Scientists 专项课程
Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development. In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.
常见问题
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
有助学金吗？
还有其他问题吗？请访问 学生帮助中心。
