SQL Databases Using SQLAlchemy: Querying Data

SQLAlchemy 1.3    |    Intermediate
  • 11 videos | 1h 25m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 22 users Rating 4.5 of 22 users (22)
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

  • 2m 13s
  • 10m 48s
    In this video, find out how to perform select query operations using the "between" operator. FREE ACCESS
  • Locked
    3.  Filtering Data Using the Order by, Limit, and Offset Clauses
    8m 26s
    In this video, find out how to filter data using the order by, limit, and offset clauses. FREE ACCESS
  • Locked
    4.  Using the fetchone() Method
    8m 8s
    In this video, you will learn how to identify the purpose of and use the fetchone() method. FREE ACCESS
  • Locked
    5.  Using the fetchmany() Method
    5m 14s
    In this video, learn how to use the fetchmany() function to retrieve the output of a select query. FREE ACCESS
  • Locked
    6.  Performing Joins Using the Select Clause
    7m 26s
    Learn how to join data from multiple tables together. FREE ACCESS
  • Locked
    7.  Performing Joins Using the join() Method
    9m 17s
    In this video, you will learn how to perform inner and outer joins. FREE ACCESS
  • Locked
    8.  Using the Group by Clause
    12m 5s
    In this video, find out how to group data using the GROUP BY clause. FREE ACCESS
  • Locked
    9.  Using the Group by Clause to Calculate Aggregate Statistics
    10m 20s
    Learn how to calculate aggregate statistics using the group by function. FREE ACCESS
  • Locked
    10.  Using the Having Clause to Perform Filter Operations
    9m 10s
    In this video, you will learn how to filter grouped and aggregated data using the HAVING clause. FREE ACCESS
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 20 users Rating 4.3 of 20 users (20)
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
Rating 4.4 of 25 users Rating 4.4 of 25 users (25)