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이 강좌에 대하여
최근 조회 702,562회
유동적 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
초급 단계
완료하는 데 약 19시간 필요
영어
자막: 영어, 아랍어, 페르시아어
배울 내용
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, access multiple tables
Access databases from Jupyter using Python and work with real world datasets
귀하가 습득할 기술
Cloud DatabasesPython ProgrammingIpythonRelational Database Management System (RDBMS)SQL
유동적 마감일
일정에 따라 마감일을 재설정합니다.
공유 가능한 수료증
완료 시 수료증 획득
100% 온라인
지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.
초급 단계
완료하는 데 약 19시간 필요
영어
자막: 영어, 아랍어, 페르시아어
제공자:
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
In this module, 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.
완료하는 데 2시간 필요
6개 동영상 (총 19분), 1 개의 읽기 자료, 5 개의 테스트
완료하는 데 2시간 필요
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.
완료하는 데 2시간 필요
5개 동영상 (총 22분), 1 개의 읽기 자료, 2 개의 테스트
완료하는 데 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시간 필요
Accessing Databases using Python
In this module you will learn the basic concepts related to using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL, and analyze data using Python.
완료하는 데 3시간 필요
5개 동영상 (총 27분), 1 개의 읽기 자료, 6 개의 테스트
검토
DATABASES AND SQL FOR DATA SCIENCE WITH PYTHON의 최상위 리뷰
DE 제공2019년 12월 27일
Course is god enough. However the last assessment is not. Misprints and not clear questions lead to disappointing marks in the end. Also other students marked assessments based on their understanding.
BS 제공2020년 5월 20일
Amazing course for beginners! The entire course is well structured and has good hands-on assignments. SQL is extremely essential for Database management and fun learning so please do try this one out!
AT 제공2020년 2월 26일
A very useful course with some very interesting datasets/Jupyter notebooks to work through/practice your skills. Offers a good balanced blend between theory and practical/practice. Very good course!
PK 제공2020년 8월 19일
A very useful course with some very interesting datasets/Jupyter notebooks to work through/practice your skills. Offers a good balanced blend between theory and practical/practice. Very good course!
자주 묻는 질문
강의 및 과제를 언제 이용할 수 있게 되나요?
이 수료 과정을 구독하면 무엇을 이용할 수 있나요?
궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.
