---
id: 5e9a093a74c4063ca6f7c163
title: Reading Data from Databases
challengeType: 11
videoId: MtgXS1MofRw
bilibiliIds:
  aid: 890546354
  bvid: BV1JP4y1h7gk
  cid: 409020851
dashedName: reading-data-from-databases
---

# --description--

*Instead of using notebooks.ai like it shows in the video, you can use Google Colab instead.*

More resources:

-  <a href="https://github.com/krishnatray/RDP-Reading-Data-with-Python-and-Pandas" target="_blank" rel="noopener noreferrer nofollow">Notebooks on GitHub</a>
-  <a href="https://colab.research.google.com/github/googlecolab/colabtools/blob/master/notebooks/colab-github-demo.ipynb" target="_blank" rel="noopener noreferrer nofollow">How to open Notebooks from GitHub using Google Colab.</a>

# --question--

## --text--

What method does a `Cursor` instance have and what does it allow?

## --answers--

The `Cursor` instance has a `.run()` method which allows you to run SQL queries.

---

The `Cursor` instance has a `.select()` method which allows you to select records.

---

The `Cursor` instance has an `.execute()` method which will receive SQL parameters to run against the database.

## --video-solution--

3

