关于此课程： SQL is a powerful language which is used for communicating with databases. Before you step into the field of data science, it is vitally important that you set yourself apart by mastering the foundations of SQL. The purpose of this course is to introduce relational database concepts and help you learn and apply knowledge of the SQL language. Learners will also practice building and running SQL queries hands-on using a cloud-based environment as well as learn how to access databases from Jupyter notebooks using Python. If you choose to take this course and earn the Coursera course certificate, you will also earn an IBM digital badge upon successful completion of the course.
此课程适用人群： This course is designed for anyone interested in learning SQL, especially those who want to apply SQL for data science. Taking this course does not require any prior knowledge of SQL or databases.
制作方： IBM
教学方： Rav Ahuja, Data Science Program Manager
IBM Cognitive Class
教学方： Hima Vasudevan, Data Scientist
IBM Digital Business Group
| 基本信息 | 课程 4（共 4 门，Introduction to Data Science Specialization ） |
| 级别 | Beginner |
| 承诺学习时间 | 3-4 weeks of study, 2-4 hours/week. |
| 语言 | English |
| 硬件要求 | Only browser access is required. Access to cloud based environment will be provided for hands-on labs. |
| 如何通过 | 通过所有计分作业以完成课程。 |
| 用户评分 |
授课大纲
第 1 周
Week 1 - Introduction to Databases and Basic SQL
In Week 1 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.
11 个视频, 4 个阅读材料, 2 个练习测验
- 视频: Introduction to Databases
- 视频: How to create a Database instance on Cloud?
- Reading: Hands-on LAB: Provision a Cloud hosted Database instance
- 视频: CREATE Table Statement
- 视频: SELECT Statement
- 视频: INSERT Statement
- 视频: UPDATE and DELETE Statements
- Reading: Hands-on LAB: Composing and Running basic SQL queries
- Reading: About this Optional lesson
- 视频: Information and Data Models
- 视频: Types of Relationships
- 视频: Mapping Entities to Tables
- 视频: Relational Model Concepts
- Reading: Additional Reading
- Practice Quiz: Practice Quiz: Review of Relational Database Concepts
- Practice Quiz: Optional Not Graded Quiz on Relational Concepts
已评分: Databases
已评分: Basic SQL
第 2 周
Week 2 - Advanced SQL
By the end of this module you will: (1) earn how to use string patterns and ranges to search data, how to sort and group data in result sets, as well as (2) learn how to work with multiple tables in a relational database using join operations.
10 个视频, 4 个阅读材料, 2 个练习测验
- 视频: Sorting Result Sets
- 视频: Grouping Result Sets
- Reading: Hands-on LAB: String Patterns, Sorting & Grouping
- 视频: Join Overview
- 视频: Inner Join
- 视频: Left Outer Join
- 视频: Right Outer Join
- 视频: Full Outer Join
- Reading: Hands-on LAB: JOINs
- Reading: About this Optional lesson
- 视频: Relational Model Constraints
- 视频: Relational Model Constraints - Advanced
- Reading: Additional Information on Keys and Constraints
- Practice Quiz: Practice Quiz: Review of Database Constraints
- Practice Quiz: Optional Not Graded Quiz on Constraints
已评分: String Patterns, Ranges, Sorting and Grouping
已评分: JOIN operations
第 3 周
Week 3 - Accessing Databases using Python
After completing the lessons in this week, you will learn how to explain the basic concepts related to using Python to connect to databases and then create tables, load data, query data using SQL and analyze data using Python
5 个视频
- 视频: Writing code using DB-API
- 视频: Connecting to a database using ibm_db API
- LTI Item: Hands-on LAB 1: Connecting to a database instance
- 视频: Creating tables, loading data and querying data
- LTI Item: Hands-on LAB 2: Creating tables, inserting and querying Data
- LTI Item: Hands-on Tutorial: Accessing databases with SQL magic
- 视频: Analyzing data with Python
- LTI Item: Hands-on LAB 3: Analyzing a real world data set
已评分: Database access from Python
第 4 周
Week 4: Course Assignment
As a hands-on Data Science 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 like a data scientist would. You will be assessed both on the correctness of your SQL queries and results.
2 个阅读材料
- Reading: Working with real-world data sets
- LTI Item: Jupyter notebook with problems for Peer Reviewed Assignment
- Reading: IBM Digital Badge
已评分: Peer Reviewed Assignment
常见问题解答
运作方式
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
制作方
IBM
IBM offers a wide range of technology and consulting services; a broad portfolio of middleware for collaboration, predictive analytics, software development and systems management; and the world's most advanced servers and supercomputers. Utilizing its business consulting, technology and R&D expertise, IBM helps clients become "smarter" as the planet becomes more digitally interconnected. IBM invests more than $6 billion a year in R&D, just completing its 21st year of patent leadership. IBM Research has received recognition beyond any commercial technology research organization and is home to 5 Nobel Laureates, 9 US National Medals of Technology, 5 US National Medals of Science, 6 Turing Awards, and 10 Inductees in US Inventors Hall of Fame.
价格
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
评分和审阅
