Brief Introduction
Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries.
Description
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.
Knowledge
- 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
The Python Mega Course: Build 10 Real World Applications
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Go from zero to hero in Python in weeks! Learn Python the easy way by building real-life Python programs! exe or ....
Data Analytics: SQL for newbs, beginners and marketers
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Dominate data analytics, data science, and big data It is becoming ever more important that companies make data-driven decisions. I’m going to let you in on a little secret....
Statistics Primer for Data Scientist's
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Lay the Foundation: Insights & Corporate Roles, Discrete & Continuous random variables, Descriptive Stats & Percentile! ” - Josh Wills Statistics for Data Science...
Data Analysis with R Programming
- 4.8
-
![]()
![]()
![]()
![]()
![]()
This course is the seventh course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs....
