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.
oferecido por
IBMInformações sobre o curso
676.276 visualizações recentes
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Nível iniciante
Aprox. 19 horas para completar
Inglês
Legendas: Inglês, Árabe, Persa
O que você vai aprender
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
Habilidades que você terá
Cloud DatabasesPython ProgrammingIpythonRelational Database Management System (RDBMS)SQL
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Nível iniciante
Aprox. 19 horas para completar
Inglês
Legendas: Inglês, Árabe, Persa
oferecido por
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.
Programa - O que você aprenderá com este curso
2 horas para concluir
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 horas para concluir
6 vídeos (Total 19 mín.), 1 leitura, 5 testes
2 horas para concluir
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 horas para concluir
5 vídeos (Total 22 mín.), 1 leitura, 2 testes
3 horas para concluir
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 horas para concluir
7 vídeos (Total 32 mín.), 2 leituras, 4 testes
3 horas para concluir
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 horas para concluir
5 vídeos (Total 27 mín.), 1 leitura, 6 testes
Avaliações
Principais avaliações do DATABASES AND SQL FOR DATA SCIENCE WITH PYTHON
por BS20 de Mai de 2020
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!
por DE27 de Dez de 2019
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.
por AT26 de Fev de 2020
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!
por SA22 de Abr de 2020
The lessons were short and easy to follow, providing all the basics as well as a few more advanced topics, to get student quickly up-to-speed on databases and SQL and their application in D/S realm.
Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
O que recebo ao me inscrever para este certificado?
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.
