DataCamp

Exploratory Data Analysis in SQL

Engineering and Technology

Short Description

Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.

Long Description

Once you have gained access to a database, the next step in your SQL journey involves building upon your existing skills. This includes joining tables, utilizing basic functions, grouping data, and employing subqueries. In order to effectively explore a database and its data, it is essential to familiarize yourself with various data types such as numeric, character, and date/time. By utilizing data from reputable sources such as Stack Overflow, Fortune 500 companies, and 311 help requests from Evanston, IL, you will gain practical experience in working with these data types. Furthermore, you will learn how to utilize functions to aggregate, summarize, and analyze data directly within the database, eliminating the need to export data to external tools. Even in the presence of errors and inconsistencies within the data, you will acquire the skills to identify common problems and implement strategies to clean up messy data. Upon completion of this course, you will be equipped to confidently explore your own PostgreSQL databases and effectively analyze the data contained within them.

Course Details

Duration
4 hours
Difficulty
Advanced
Format
Short Course
Price
USD39.00
Course Link
More Information
DataCamp
Description
DataCamp is an online learning platform that offers interactive courses and tutorials for data science and analytics. It provides a wide range of courses covering topics such as Python, R, SQL, machine learning, data visualization, and more. The platform offers a hands-on learning experience through coding exercises and projects, allowing users to practice and apply their skills in real-world scenarios. DataCamp also offers a personalized learning experience with adaptive learning technology that adjusts the course content based on the user's skill level and progress. It is widely used by individuals, professionals, and organizations to enhance their data science skills and stay up-to-date with the latest trends and technologies in the field.