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
Learn Node-SQLite
Learn how to interact with a SQL database from within your JavaScript programs!
Learn SQL: Multiple Tables
Combine data stored across multiple tables using joins, unions, and temporary tables.
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Learn How to Use AI for SQL
Learn to generate SQL with AI, transform natural language to SQL, and utilize LLMs for SQL operations in our innovative course.
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
There are no reviews yet.