SQL for Data Science with R
Data Analytics and Visualization with Excel and R,
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'll learn
- Create and access a database instance on cloud
- 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
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 6 weeks |
Effort | 6 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructor | Rav Ahuja |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Learn-to-Swim Instructor $45k
Learn iOS Development $53k
Learn Android Development $66k
Epic LEARN Administrator 2 $104k
Content Editor - Creative Cloud Learn Contractor $119k
Senior Content Editor - Creative Cloud Learn $157k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 6 weeks |
Effort | 6 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructor | Rav Ahuja |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science |
Tags | Data Analysis & Statistics |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course