SQL for Data Science with R

About

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.

What you will learn

• Write basic SQL statements: CREATE, DROP, SELECT, INSERT, UPDATE, DELETE

• Filter, sort, group results, use built-in functions, compose nested queries, access multiple tables

• Access databases from Jupyter using R and SQL to query real-world datasets

Skills you learn

• SQL (Programming Language)
• Communications
• Relational Databases
• Jupyter
• Data Science
• R (Programming Language)

Auto Summary

Unlock the power of databases with "SQL for Data Science with R," a foundational course by edX. Perfect for beginners, this 21-hour course emphasizes practical, hands-on learning, guiding you through SQL and R applications in data science. You'll work with real datasets, create a cloud-based database, and run SQL queries in Jupyter notebooks. Ideal for aspiring data scientists, this course offers a starter subscription and requires no prior programming knowledge.