SQL Databases Using SQLAlchemy: Manipulating Data
SQLAlchemy 1.3
| Intermediate
- 11 videos | 1h 24m 12s
- Includes Assessment
- Earns a Badge
When you need access to data in a relational database while coding in Python, SQLAlchemy provides an ideal abstraction layer. SQLAlchemy supports several database types. In this course, you'll work with MySQL. You'll start by learning how to construct and invoke select-from-where queries from Python using the SQLAlchemy core API. You'll then use the and_, or_, and not_ functions from the Expressions API, before learning how to alter tables by adding and dropping columns and constraints. Following on, you'll practice deleting data and drop tables from SQLAlchemy. You'll then specify foreign key constraints to define parent-child relationships. To finish off, you'll perform simple select-from-where queries with logical and relational operators from SQLAlchemy, add and drop columns and constraints, and define foreign-key constraints and parent-child relationships.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Perform simple filter operations using logical operators
Perform filter operations using sql operators, such as like, not like, and between
Execute alter operations to add constraints and indices to tables
Perform update operations on data
Perform update operations while preserving the parameter order -
Drop a table, recreate it, and insert rows into it
Explore different ways to use logical operators for querying data
Filter data using two tables with a parent-child relationship
Add a foreign key constraint between tables
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 59s
-
9m 30sIn this video, learn how to perform simple filter operations using the logical operators AND, OR, and NOT. FREE ACCESS
-
3. Constructing Queries Using SQLAlchemy Methods12m 28sLearn how to perform filter operations using SQL operators, such as "like", "not like", and "between". FREE ACCESS
-
4. Using the SQL Alter Command10m 19sIn this video, learn how to execute alter operations to add constraints and indices to tables. FREE ACCESS
-
5. Updating Data in Tables7m 20sIn this video, find out how to update data. FREE ACCESS
-
6. Updating Data with Preserved Parameter Order9m 9sTo find out how to perform update operations while preserving the parameter order, consult the documentation. FREE ACCESS
-
7. Deleting and Recreating a Table7m 47sLearn how to drop a table, recreate it, and insert rows into it. FREE ACCESS
-
8. Using Logical Operators to Filter Data6m 12sIn this video, you will explore different ways to query data using logical operators. FREE ACCESS
-
9. Filtering Data Using Subqueries11m 56sIn this video, you will learn how to filter data using two tables with a parent-child relationship. FREE ACCESS
-
10. Adding SQL Foreign Key Constraints5m 2sIn this video, you will learn how to add a foreign key constraint to tables. FREE ACCESS
-
11. Course Summary2m 31s
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.
