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.

Apr 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!)

Topics

Data Analysis

SQL

DataLab

blog

Introducing DataLab

DataCamp is launching DataLab, an AI-enabled data notebook to make it easier and faster than ever before to go from data to insight. Read on to learn more about what makes DataLab unique and our path towards it.

Filip Schouwenaars

3 min

blog

The 4 Best Data Analytics Bootcamps in 2024

Discover the best data analytics bootcamps in 2024, discussing what they are, how to choose the best bootcamp, and you can learn.

Kevin Babitz

5 min

blog

A Guide to Corporate Data Analytics Training

Understand the importance of corporate data analytics training in driving business success. Learn about key building blocks and steps to launch an effective training initiative tailored to your organization's needs.

Kevin Babitz

6 min

podcast

50 Years of SQL with Don Chamberlin, Computer Scientist and Co-Inventor of SQL

Richie and Don explore the early development of SQL, the commercialization and adoption of SQL, how it became standardized, how it evolved and spread via open source, the future of SQL through NoSQL and SQL++ and much more.

Richie Cotton

36 min

code-along

Full Stack Data Engineering with Python

In this session, you'll see a full data workflow using some LIGO gravitational wave data (no physics knowledge required). You'll see how to work with HDF5 files, clean and analyze time series data, and visualize the results.

Blenda Guedes

code-along

Getting Started With Data Analysis in Alteryx Cloud

In this session, you'll learn how to get started with the Alteryx AI Platform by performing data analysis using Alteryx Designer Cloud.

Joshua Burkhow

See More See More