Learn how to work with Google Sheets, CSV files, and sample datasets within DataLab. By the end of the chapter, you'll be able to query both raw CSV files and stored DataFrames or Queries using SQL cells.

Connecting with files

Connecting a Google Sheet

Connecting a CSV file

Querying a CSV file

Querying our data

Counting fields

Storing a DataFrame

Query modes

Querying stored data

Storing and reusing a query

Storing and reusing a DataFrame

Querying data in DataLab

Explore how to turn your data into visual insights and leverage the AI assistant to boost your productivity in DataLab. You'll end the course by discovering management features like scheduling and version control.

Visualizing your data

Using the chart cell

Visualizing with AI

Adjust an AI visualization

Using the AI assistant

Generate code with AI

Fix your code with AI

Managing your workbook

Restoring a workbook

Scheduling your workbook

SQL analysis with DataLab

Congratulations!

Visualization and AI automation

sales_data. csv

Take your DataLab skills to the next level in this hands-on course where you'll build on your DataLab knowledge, but this time with SQL! You'll learn about how to connect datasets for SQL queries without complicated integrations, how to make use of different query modes to parameterize your queries, and boost your analysis and workflow with the AI features to enhance your current SQL skills. By the end, you'll be able to create your first SQL analysis in a notebook.

<h2>Elevate your DataLab skills with SQL</h2><br><p>After learning the fundamentals of DataLab in the introductory course, this course focuses on the SQL features that allow you to make the most out of this AI-powered data notebook for your analysis, reporting, and more. You'll see how to get started with a SQL analysis using data found in Google Sheets or CSV files without complicated installations or integrations. You'll use the different query modes in the notebook to simplify otherwise complex querying by saving queries and outputs and reusing them.</p><br>
<h2>Boost your productivity with AI</h2><br><p>With the basics down, you'll move on to leveraging the AI features to help you visualize your data without any code! You'll also learn how to use the AI assistant to generate or fix your SQL code and learn about some cool automation and version control features. By the end of the course, you'll be equipped with the skills to make a SQL project, report, or analysis that combines text, code, and visualizations.</p>

Introduction to DataLab

Intermediate SQL

Elevate your analysis with this hands-on course using SQL with  DataLab workbooks.

DataLab with SQL

Senior Data Science and AI Content Developer, DataCamp

Parameterizing queries

Starting query

Parameterizing with DataFrames

Parameterizing with DataFrames on DataLab

Parameterized queries

Adding Python

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_41681/subtitles/course_41681_a39148e0f4a7f896b5b8411a259062e0.vtt

Querying data in DataLab - Querying stored data

Querying stored data

Create Your Free Account