SQL Databases Using SQLAlchemy: Querying Data

SQLAlchemy an object-relational mapper (ORM) library available in Python provides application developers with the same might and capability of SQL. In this course youll learn how to take advantage of some of the more complex queries available in this library. Youll start by constructing queries using dates the current date order by and limit clauses. Youll then learn how to leverage the fetch methods from the cursor provided via the ResultProxy object. Youll perform joins using the .join method on the column object. Youll also specify group by and having clauses in your SQL queries By the end of this course youll 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.