SQL Databases Using SQLAlchemy: Querying Data

SQLAlchemy 1.3    |    Intermediate
  • 11 Videos | 1h 30m 16s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 13s
    UP NEXT
  • Playable
    2. 
    Filtering Data Using the SQL Between Operator
    10m 48s
  • Locked
    3. 
    Filtering Data Using the Order by, Limit, and Offset Clauses
    8m 26s
  • Locked
    4. 
    Using the fetchone() Method
    8m 8s
  • Locked
    5. 
    Using the fetchmany() Method
    5m 14s
  • Locked
    6. 
    Performing Joins Using the Select Clause
    7m 26s
  • Locked
    7. 
    Performing Joins Using the join() Method
    9m 17s
  • Locked
    8. 
    Using the Group by Clause
    12m 5s
  • Locked
    9. 
    Using the Group by Clause to Calculate Aggregate Statistics
    10m 20s
  • Locked
    10. 
    Using the Having Clause to Perform Filter Operations
    9m 10s
  • Locked
    11. 
    Course Summary
    2m 39s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.