Engineering and Technology
Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.
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.
by DataCamp
Learn how to explore what's available in a database: the tables, relationships between them, and dat...
by DataCamp
Enhance your reports with Power BI's Exploratory Data Analysis (EDA). Learn what EDA is for Power BI...
by DataCamp
Learn how to explore, visualize, and extract insights from data using exploratory data analysis (EDA...
by DataCamp
Learn how to use graphical and numerical techniques to begin uncovering the structure of your data.
by DataCamp
Use data manipulation and visualization skills to explore the historical voting of the United Nation...
by DataCamp
Explore HR data analysis in Tableau with this case study.
by DataCamp
Learn how to explore, visualize, and extract insights from data.
by DataCamp
Take vital steps towards mastery as you apply your statistical thinking skills to real-world data se...
by DataCamp
Take your reporting skills to the next level with Tableau’s built-in statistical functions.
by DataCamp
Apply your skills to import, analyze and visualize Human Resources (HR) data using Power BI.