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.
Offert par
IBMÀ propos de ce cours
694 431 consultations récentes
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Niveau débutant
Approx. 37 heures pour terminer
Anglais
Sous-titres : Anglais, Arabe, Persan
Ce que vous allez apprendre
Analyze data within a database using SQL and Python.
Create a relational database on Cloud and work with tables.
Compare and contrast DDL to DML.
Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.
Compétences que vous acquerrez
- Cloud Databases
- Python Programming
- Ipython
- Relational Database Management System (RDBMS)
- SQL
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Niveau débutant
Approx. 37 heures pour terminer
Anglais
Sous-titres : Anglais, Arabe, Persan
Offert par
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.
Programme de cours : ce que vous apprendrez dans ce cours
2 heures pour terminer
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 heures pour terminer
6 vidéos (Total 19 min), 2 lectures, 5 quiz
5 heures pour terminer
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.
5 heures pour terminer
5 vidéos (Total 22 min), 1 lecture, 5 quiz
7 heures pour terminer
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.
7 heures pour terminer
7 vidéos (Total 32 min), 2 lectures, 8 quiz
6 heures pour terminer
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.
6 heures pour terminer
5 vidéos (Total 27 min), 1 lecture, 9 quiz
Avis
- 5 stars74,69 %
- 4 stars18,76 %
- 3 stars4,05 %
- 2 stars1,09 %
- 1 star1,38 %
Meilleurs avis pour DATABASES AND SQL FOR DATA SCIENCE WITH PYTHON
par TN7 mai 2020
Overall is a nice course. It was a bit confused because Handson Lab related to each other. It would be nicer to have a short remind from previous labs or better to keep labs independently.
par BS20 mai 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!
par RY7 avr. 2020
This " Databases and SQL for Data Science" course was good. I learned too many new things and it really helped me by providing fundamental knowledge regarding databases and SQL.\n\n"
par PK19 août 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!
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
À quoi ai-je droit si je m'abonne à ce Certificat ?
D'autres questions ? Visitez le Centre d'Aide pour les Étudiants.
