Pular para o conteúdo principal
InicioCódigo juntoData Analysis

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.
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
Relacionado

código junto

Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Jasmin Ludolf's photo

Jasmin Ludolf

código junto

Getting Started in SQL

Learn how to write basic queries in SQL and find answers to business questions.
Kelsey McNeillie's photo

Kelsey McNeillie

código junto

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's photo

Adel Nehme

código junto

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's photo

Richie Cotton

código junto

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's photo

Andy Alseth

código junto

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's photo

John Brazier-Beckett

See MoreSee More