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
38.592 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
No prior knowledge of databases, SQL, R, or programming is required.
Aprox. 28 horas para completar
Inglés (English)
SubtÃtulos: Inglés (English)
¿PodrÃa tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negociosQué aprenderás
Create and access a database instance on the cloud
Compose and execute basic SQL statements - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
Construct SQL statements to filter, sort, group results, use built-in functions, compose nested queries, access multiple tables
Analyze data from Jupyter using R and SQL by combining SQL and R skills to query real-world datasets
Habilidades que obtendrás
- Data Science
- Select (Sql)
- Relational Databases (RDBMS)
- R Programming
- Data Analysis
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
No prior knowledge of databases, SQL, R, or programming is required.
Aprox. 28 horas para completar
Inglés (English)
SubtÃtulos: Inglés (English)
¿PodrÃa tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?
Prueba Coursera para negocios
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
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 horas para completar
5 videos (Total 17 minutos), 1 lectura, 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
6 videos (Total 27 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
5 horas para completar
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.
5 horas para completar
10 videos (Total 27 minutos), 2 lecturas, 9 cuestionarios
Reseñas
- 5 stars55,55Â %
- 4 stars22,22Â %
- 3 stars11,11Â %
- 2 stars3,70Â %
- 1 star7,40Â %
Principales reseñas sobre SQL FOR DATA SCIENCE WITH R
por AN11 de abr. de 2022
Very useful course for those who wants to learn SQL.
por HD4 de mar. de 2022
This skills in this course are easy to learn, the simplicity of the materials is what I like the most about IBM courses.
por OM31 de may. de 2022
I really like the course. Only I think that need to improve the final project, inlcude a little more information in each problem.
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.
