The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL . This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle. This course teaches you everything you need to know to begin working with databases today!

Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.

Learn the basics of syntax in SQL, how to extract and wrangle data, and use querying tables in relational databases like MySQL, SQL Server, and PostgreSQL.

Introduction to SQL

Intro to Python for Data Science (edX 1.1)

Intro to Python for Data Science (edX 1.2)

Intro to Python for Data Science (edX 2.1)

Intro to Python for Data Science (edX 2.2)

Intro to Python for Data Science (edX 2.3)

Intro to Python for Data Science (edX 3.1)

Intro to Python for Data Science (edX 3.2)

Intro to Python for Data Science (edX 3.3)

Intro to Python for Data Science (edX 4.2)

Intro to Python for Data Science (edX 4.3)

Lab exercises on Basic Plots with matplotlib.

Intro to Python for Data Science (edX 5.1)

Intro to Python for Data Science (edX 5.2)

Intro to Python for Data Science (edX 5.3)

Lab exercises on Boolean Logic & Control Flow.

Intro to Python for Data Science (edX 6.1)

Intro to Python for Data Science (edX 6.2)

After all of the hard work of acquiring data and getting them into a form you can work with, you ultimately want to make clear, succinct conclusions from them. This crucial last step of a data analysis pipeline hinges on the principles of statistical inference. In this course, you will start building the foundation you need to think statistically, speak the language of your data, and understand what your data is telling you. The foundations of statistical thinking took decades to build, but can be grasped much faster today with the help of computers. With the power of Python-based tools, you will rapidly get up-to-speed and begin thinking statistically by the end of this course.

Build the foundation you need to think statistically and to speak the language of your data.

Statistical Thinking in Python (Part 1)

Now that you've learned the basics of SQL in our <a href="https://learn.datacamp.com/courses/introduction-to-sql">Introduction to SQL</a> course,  it's time to supercharge your queries using joins and relational set theory. In this course, you'll learn all about the power of joining tables while exploring interesting features of countries and their cities throughout the world. You will master inner and outer joins, as well as self joins, semi joins, anti joins and cross joins—fundamental tools in any PostgreSQL wizard's toolbox. Never fear set theory again after learning all about unions, intersections, and except clauses through easy-to-understand diagrams and examples. Lastly, you'll be introduced to the challenging topic of subqueries. You will be able to visually grasp these ideas by using Venn diagrams and other linking illustrations.

Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.

Discover all the fundamental in PostgreSQL, like inner, outer self, semi, anti, and cross joins, as well as unions, intersections, and except clauses.

Data Science Courses

Data Science Tracks

Our Learning Experience

@nguyenthanhdatpl93

Workspace Publications (0)

Completed Tracks (0)

Completed courses (16)

Completed Projects (0)