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.
ofrecido por
Habilidades en redes de IBMAcerca de este Curso
870.547 vistas recientes
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Nivel principiante
Aprox. 37 horas para completar
Inglés (English)
Subtítulos: Inglés (English), Árabe (Arabic), Persa
Qué aprenderás
Analyze data within a database using SQL and Python.
Create a relational database on Cloud and work with tables.
Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.
Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.
Habilidades que obtendrás
- Cloud Databases
- Python Programming
- Ipython
- Relational Database Management System (RDBMS)
- SQL
Fechas límite flexibles
Restablece las fechas límite en función de tus horarios.
Certificado para compartir
Obtén un certificado al finalizar
100 % en línea
Comienza de inmediato y aprende a tu propio ritmo.
Nivel principiante
Aprox. 37 horas para completar
Inglés (English)
Subtítulos: Inglés (English), Árabe (Arabic), Persa
ofrecido por
Habilidades en redes de 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 - Qué aprenderás en este curso
2 horas para completar
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 completar
6 videos (Total 19 minutos), 2 lecturas, 5 cuestionarios
5 horas para completar
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 horas para completar
5 videos (Total 22 minutos), 1 lectura, 5 cuestionarios
7 horas para completar
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 horas para completar
7 videos (Total 32 minutos), 2 lecturas, 8 cuestionarios
6 horas para completar
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 horas para completar
5 videos (Total 27 minutos), 1 lectura, 9 cuestionarios
Reseñas
- 5 stars74,74 %
- 4 stars18,67 %
- 3 stars4,03 %
- 2 stars1,11 %
- 1 star1,41 %
Principales reseñas sobre DATABASES AND SQL FOR DATA SCIENCE WITH PYTHON
por PK19 de ago. 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 IA21 de feb. de 2021
The course served as a good SQL refresher and I love the that I get to run all the exercise and assignment on IBM cloud. That really saved me a lot of stress. Good foundational course overall.
por RK6 de ene. de 2022
Most of it really good. I think joins should be covered in the base material and there should be less of an emphasis on sub-queries. The Peer Reviewed final was a little confusing in its questioning.
por YM21 de mar. de 2020
Great introduction to basic manipulation of SQL tables and working with the IBM DB2 databases by connecting to them with iPython. Very straightforward explanations and very enjoyable tasks.
Preguntas Frecuentes
¿Cuándo podré acceder a las lecciones y tareas?
¿Qué recibiré si me suscribo a este Certificado?
¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.
