SQL Databases Using SQLAlchemy: Querying Data
SQLAlchemy 1.3
| Intermediate
- 11 videos | 1h 25m 46s
- Includes Assessment
- Earns a Badge
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 48sIn this video, find out how to perform select query operations using the "between" operator. FREE ACCESS
-
3. Filtering Data Using the Order by, Limit, and Offset Clauses8m 26sIn this video, find out how to filter data using the order by, limit, and offset clauses. FREE ACCESS
-
4. Using the fetchone() Method8m 8sIn this video, you will learn how to identify the purpose of and use the fetchone() method. FREE ACCESS
-
5. Using the fetchmany() Method5m 14sIn this video, learn how to use the fetchmany() function to retrieve the output of a select query. FREE ACCESS
-
6. Performing Joins Using the Select Clause7m 26sLearn how to join data from multiple tables together. FREE ACCESS
-
7. Performing Joins Using the join() Method9m 17sIn this video, you will learn how to perform inner and outer joins. FREE ACCESS
-
8. Using the Group by Clause12m 5sIn this video, find out how to group data using the GROUP BY clause. FREE ACCESS
-
9. Using the Group by Clause to Calculate Aggregate Statistics10m 20sLearn how to calculate aggregate statistics using the group by function. FREE ACCESS
-
10. Using the Having Clause to Perform Filter Operations9m 10sIn this video, you will learn how to filter grouped and aggregated data using the HAVING clause. FREE ACCESS
-
11. Course Summary2m 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.
