SQL Databases Using SQLAlchemy: Manipulating Data

SQLAlchemy 1.3    |    Intermediate
  • 11 Videos | 1h 28m 42s
  • 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

  • Playable
    1. 
    Course Overview
    1m 59s
    UP NEXT
  • Playable
    2. 
    Using Where Clauses to Filter the Output of Select Queries
    9m 30s
  • Locked
    3. 
    Constructing Queries Using SQLAlchemy Methods
    12m 28s
  • Locked
    4. 
    Using the SQL Alter Command
    10m 19s
  • Locked
    5. 
    Updating Data in Tables
    7m 20s
  • Locked
    6. 
    Updating Data with Preserved Parameter Order
    9m 9s
  • Locked
    7. 
    Deleting and Recreating a Table
    7m 47s
  • Locked
    8. 
    Using Logical Operators to Filter Data
    6m 12s
  • Locked
    9. 
    Filtering Data Using Subqueries
    11m 56s
  • Locked
    10. 
    Adding SQL Foreign Key Constraints
    5m 2s
  • Locked
    11. 
    Course Summary
    2m 31s

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.

YOU MIGHT ALSO LIKE