A Beginner's Guide to Data Analysis with SQL

In this session, DataCamp's VP of Media Adel Nehme & co-host of the DataFramed podcast, shows you how to get started with SQL.

3 de abr. de 2024

Code along with us onCode Along

SQL is an essential programming language for data analysis, data science, and data engineering. If you work in data, you need to be able to use it. Even if you don't work in data, a little bit of SQL knowledge can benefit you!

In this session, DataCamp's VP of Media Adel Nehme & co-host of the DataFramed podcast, shows you how to get started with SQL. You'll gain the skills to extract data from a database and perform computations using "SELECT" queries. Topics covered will include filtering rows and columns of data, performing calculations on numerical data, and working with groups of data. You'll gain the skills and confidence to start using SQL for simple data analyses.

Key Takeaways:

Learn how to connect to a database to gain access to its data.
Learn how to extract data from different parts of a database.
Learn how to perform calculations on numerical data.

Resources (including link to code along!)

Temas

Data Analysis

SQL

DataLab

Relacionado

code-along

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.

Jasmin Ludolf

code-along

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.

Kelsey McNeillie

code-along

SQL for Absolute Beginners

Start from the very basics of what SQL is and why it's essential, move through key components such as retrieving data from databases, manipulation of data, and basic SQL queries.

Adel Nehme

code-along

Get Started Analyzing Survey Data with SQL & Python

In this introductory session, you'll explore a survey on business innovation. The focus will be on principles of analyzing survey data, and you'll write some simple SQL for calculations and simple Python for data visualizations.

Richie Cotton

code-along

Data Modeling in SQL

In this live training, you'll learn about data cleaning, shaping and loading techniques and learn about common database schemas for organizing tables for analysis.

Andy Alseth

code-along

Free Trial Performance Analysis in SQL

Learn how to use SQL to analyze marketing data for a free trial of a product

John Brazier-Beckett

See More See More