15 Best Data Science Courses Datacamp You Need to Know in 2023

In this skill track, you will learn about relational databases, their structure, how to begin an analysis using simple SQL commands to select and summarize columns from database tables, how to use basic comparison operators, combine multiple criteria, match patterns in text. You will also learn how to use aggregate functions to summarize data and gain useful insights and how to sort and group your results. In this skill track, you will learn intermediate SQL such as several key functions necessary to wrangle, filter, and categorize information in a relational database. You will get to know how to create queries for analytics and data engineering with window functions by using flight data. You will also get an understanding of how to use built-in PostgreSQL functions in your SQL queries to manipulate different types of data including strings, characters, numeric, and date/time.