Back to Freecodecamp

Reading Data from Databases

curriculum/challenges/english/blocks/data-analysis-with-python-course/5e9a093a74c4063ca6f7c163.md

latest949 B
Original Source

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

--questions--

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