關於此課程：Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python. No prior knowledge of databases, SQL, Python, or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course. LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.
此課程適用人群：This course is designed for anyone interested in learning SQL, especially those who want to apply SQL for data science. Therefore it is ideal for those aspiring to become data scientists. It is also suitable for those who want to become data analysts, data engineers, database administrators, or a database developers. This course is for beginners in SQL and Data Science. It does not require any prior knowledge of SQL, databases, Python, or programming.
製作方： IBM
教學方： Rav Ahuja, Data Science Program Manager
IBM
| 基本信息 | |
| 級別 | 初級 |
| 承諾學習時間 | 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 個視頻, 5 個閱讀材料, 2 個練習測驗
- 視頻: Introduction to Databases
- 視頻: How to create a Database instance on Cloud?
- Reading: Hands-on LAB: Provision a Cloud hosted Database instance
- LTI Item: OPTIONAL: Applying IBM Cloud Promo Code
- 視頻: CREATE Table Statement
- 視頻: SELECT Statement
- Reading: Count, Distinct, Limit
- 視頻: 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
- Cuestionario de práctica: Practice Quiz: Review of Relational Database Concepts
- Cuestionario de práctica: 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
- Cuestionario de práctica: Practice Quiz: Review of Database Constraints
- Cuestionario de práctica: 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.
3 個閱讀材料
- Reading: Working with real-world data sets
- Reading: Built-in Functions, Dates, Timestamps
- LTI Item: Hands-on Lab 1: Querying real world datasets
- LTI Item: Jupyter notebook with problems for Peer Reviewed Assignment
- Reading: IBM Digital Badge
已評分: Peer Reviewed Assignment
常見問題解答
運作方式
Trabajo del curso
Cada curso es como un libro de texto interactivo, con videos pregrabados, cuestionarios y proyectos.
Ayuda de tus compañeros
Conéctate con miles de estudiantes y debate ideas y materiales del curso, y obtén ayuda para dominar los conceptos.
Certificados
Obtén reconocimiento oficial por tu trabajo y comparte tu éxito con amigos, compañeros y empleadores.
製作方
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.
價格
| 購買課程 | |
|---|---|
| 訪問課程材料 | 可用 |
| 訪問評分的材料 | 可用 |
| 收到最終成績 | 可用 |
| 獲得可共享的課程證書 | 可用 |
評分和審閱
Good course!
Great on basic of SQL and using Python to work with Database
This is a very good database course. I would have preferred more problem sets.
ZM
I really enjoyed most of this course, but I most liked that the solutions are provided. The explanations and readings were really good in this course.