DataCamp
FreeExploratory Data Analysis in SQL
4.8(4,746)183k studentsINTERMEDIATEEnglish
Korshub's take
The Korshub Take
This intermediate SQL course teaches you how to perform exploratory analysis directly inside relational databases. Working with datasets from Stack Overflow, Fortune 500 companies, and city municipal requests, you will learn to clean, aggregate, and analyze data in PostgreSQL without relying on external tools.
Who It's For
Data analysts and SQL developers who already know basic joins and queries and want to perform advanced in-database exploration and data cleaning.
Key Takeaways
- Data Types & Functions: Explore numeric, character, and date/time data types using built-in aggregation functions.
- In-Database Cleaning: Detect common errors, handle missing values, and normalize inconsistent data directly in SQL.
- Real-World PostgreSQL Practice: Analyze datasets from Stack Overflow, Fortune 500 lists, and municipal 311 service logs.
About this course
You have access to a database. Now what do you do? Building on your existing skills joining tables, using basic functions, grouping data, and using subqueries, the next step in your SQL journey is learning how to explore a database and the data in it. Using data from Stack Overflow, Fortune 500 companies, and 311 help requests from Evanston, IL, you'll get familiar with numeric, character, and date/time data types. You'll use functions to aggregate, summarize, and analyze data without leaving the database. Errors and inconsistencies in the data won't stop you! You'll learn common problems to look for and strategies to clean up messy data. By the end of this course, you'll be ready to start exploring your own PostgreSQL databases and analyzing the data in them.
The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.
The course glossary can be found on the right in the resources section.
To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.
Advertisement
