Name: Exploratory Data Analysis in SQL
Brand: DataCamp
SKU: 2014389

Course description

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

Upcoming start dates

1 start date available

Start Anytime!

Self-Paced Online
Online
English

Training Course Content

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.

Why choose DataCamp

More than 14 Million learners worldwide

80% of the Fortune 1000 use DataCamp

DataCamp

Data Science Central UK Limited, 25 Luke Street

EC2A 4EE London

+34000000000

www.datacamp.com

Course homepage

DataCamp

DataCamp offers a comprehensive platform for learning data skills, specializing in training individuals and teams in data science, analytics, and AI. With a focus on interactive, hands-on learning, DataCamp provides courses across key programming languages such as Python, R, SQL,...

Ads

Exploratory Data Analysis in SQL

Course description

Upcoming start dates

Start Anytime!

Upcoming start dates

Training Course Content

Why choose DataCamp

DataCamp

Similar Courses

SQL for Data Analysts

Data Manipulation in SQL

Joining Data in SQL

Associate Data Analyst in SQL

Analyzing Business Data in SQL

Data-Driven Decision Making in SQL

SQL for PostgreSQL

Microsoft SQL Server with Transact-SQL

SQL Fundamentals