SQL Databases Using SQLAlchemy: Querying Data

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description

SQLAlchemy, an object-relational mapper (ORM) library available in Python, provides application developers with the same might and capability of SQL. In this course, you'll learn how to take advantage of some of the more complex queries available in this library.

You'll start by constructing queries using dates, the current date, order by, and limit clauses. You'll then learn how to leverage the fetch methods from the cursor provided via the ResultProxy object. You'll perform joins using the .join method on the column object. You'll also specify group by and having clauses in your SQL queries

By the end of this course, you'll be able to implement SQL order by and limit operations using SQLAlchemy Core APIs, work with dates, customize iteration over cursor results, perform joins, and implement group by and having clauses.

Expected Duration (hours)
1.4

Lesson Objectives

SQL Databases Using SQLAlchemy: Querying Data

discover the key concepts covered in this course

perform select query operations using the between operator

filter data using the order by, limit, and offset clauses

identify the purpose of and use the fetchone() method

use the fetchmany() function to retrieve the output of a select query

join data from multiple tables

perform inner and outer joins

group data using the group by clause

calculate aggregate statistics using group by

filter grouped and aggregated data using the having clause

summarize the key concepts covered in this course

Course Number:
it_pysdsadj_03_enus

Expertise Level
Intermediate