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.
제공자:
IBM이 강좌에 대하여
최근 조회 19,910회
유연한 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
초급 단계
완료하는 데 약 16시간 필요
영어
자막: 영어
배울 내용
Create and access a database instance on cloud
Write basic SQL statements: CREATE, DROP, SELECT, INSERT, UPDATE, DELETE
Filter, sort, group results, use built-in functions, compose nested queries, access multiple tables
Access databases from Jupyter using R and SQL to query real-world datasets
귀하가 습득할 기술
- Data Science
- Select (Sql)
- Relational Databases (RDBMS)
- R Programming
- Tables (Database)
유연한 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
초급 단계
완료하는 데 약 16시간 필요
영어
자막: 영어
제공자:
IBM
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
강의 계획표 - 이 강좌에서 배울 내용
완료하는 데 2시간 필요
Getting Started with SQL
Structured Query Language, or SQL, provides a standard language for selecting and manipulating data in a relational database. Understanding SQL is a foundational skill that you must have when applying data science principles in R because SQL is the key to helping you unlock insights about the information stored deep inside relational databases. In this module, you will learn some basic SQL statements and practice them hands-on on a live database.
완료하는 데 2시간 필요
5개 동영상 (총 17분), 1 개의 읽기 자료, 5 개의 테스트
완료하는 데 3시간 필요
Introduction to Relational Databases and Tables
In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.
완료하는 데 3시간 필요
6개 동영상 (총 27분), 1 개의 읽기 자료, 3 개의 테스트
완료하는 데 3시간 필요
Intermediate SQL
In this module, you will learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.
완료하는 데 3시간 필요
7개 동영상 (총 32분), 2 개의 읽기 자료, 4 개의 테스트
완료하는 데 3시간 필요
Getting Started with Databases using R
In this module, you will learn the benefits of using R to connect to relational databases and how to persist R database objects in files. You’ll also learn some of the similarities between R data frames and relational databases, including how data types compare and when you must convert from one type to another to improve the effectiveness of your data analysis. Finally, you’ll learn different methods for connecting to a database from R.
완료하는 데 3시간 필요
10개 동영상 (총 27분), 2 개의 읽기 자료, 7 개의 테스트
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
이 수료 과정을 구독하면 무엇을 이용할 수 있나요?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
