SQL for Data Science with R
About this Course
A majority of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language for communicating with and extracting data from databases. A working knowledge of databases and the SQL language is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and to help you learn and apply foundational knowledge of the SQL and R languages. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning, which means you will work with real databases, real data science tools, and real-world datasets. You will also create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. And you will learn how to access databases from Jupyter notebooks using SQL and R. No prior knowledge of databases, SQL, R, or programming is required.Created by: IBM
Level: Introductory
Related Online Courses
In this course, you will learn how to organize your data within the Microsoft Office Excel software tool. Once organized, we will discuss data cleaning. You will learn how to identify outliers and... more
El análisis exploratorio de datos (EDA, por sus siglas en inglés, Exploratory Data Analysis) es el proceso o tratamiento estadístico al cual se someten los datos de una muestra con la que se bu... more
In this course, you will learn about the characteristics of CER/PCOR, compare and contrast CER/PCOR studies and randomized controlled trials, and you will hear how PCOR researchers have overcome a... more
Causal diagrams have revolutionized the way in which researchers ask: What is the causal effect of X on Y? They have become a key tool for researchers who study the effects of treatments,... more
Demystify complex big data technologies Compared to traditional data processing, modern tools can be complex to grasp. Before we can use these tools effectively, we need to know how to handle big... more
Powered by
