Data Manipulation in SQL
|
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
So you’ve learned how to aggregate and join data from tables in your database—now what? How do you manipulate, transform, and make the most sense of your data? This intermediate-level course will teach you several key functions necessary to wrangle, filter, and categorize information in a relational database, expand your SQL toolkit, and answer complex questions. You will learn the robust use of CASE statements, subqueries, and window functions—all while discovering some interesting facts about soccer using the European Soccer Database.
User Reviews
Be the first to review “Data Manipulation in SQL”
Related Products
Intermediate SQL Server
In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.
Analyzing Business Data in SQL
Learn to write SQL queries to calculate key metrics that businesses use to measure performance.
Intro to SQL
Use SQL to create, access, and update tables of data in a relational database.
Learn SQL: Multiple Tables
Combine data stored across multiple tables using joins, unions, and temporary tables.
Full-Stack Engineer
A full-stack engineer can get a project done from start to finish, back-end to front-end.
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
There are no reviews yet.