e-learning

SQL with Python

View material

Abstract

This tutorial will introduce you to accessing a SQL database from within Python. Experience with both SQL and Python is a pre-requisite.

About This Material

This is a Hands-on Tutorial from the GTN which is usable either for individual self-study, or as a teaching material in a classroom.

Questions this will address

  • How can I access databases from programs written in Python?

Learning Objectives

  • Write short programs that execute SQL queries.
  • Trace the execution of a program that contains an SQL query.
  • Explain why most database applications are written in a general-purpose language rather than in SQL.

Licence: Creative Commons Attribution 4.0 International

Keywords: Foundations of Data Science, Python, SQL, jupyter-notebook

Target audience: Students

Resource type: e-learning

Version: 7

Status: Active

Prerequisites:

Advanced SQL

Learning objectives:

  • Write short programs that execute SQL queries.
  • Trace the execution of a program that contains an SQL query.
  • Explain why most database applications are written in a general-purpose language rather than in SQL.

Date modified: 2023-11-16

Date published: 2021-10-11

Authors: Avans Hogeschool, Helena Rasche, The Carpentries

Scientific topics: Software engineering

Activity log