SQL Databases Using SQLAlchemy: Manipulating Data

SQLAlchemy 1.3    |    Intermediate
  • 11 videos | 1h 24m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 25 users Rating 4.5 of 25 users (25)
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 30s
    In this video, learn how to perform simple filter operations using the logical operators AND, OR, and NOT. FREE ACCESS
  • Locked
    3.  Constructing Queries Using SQLAlchemy Methods
    12m 28s
    Learn how to perform filter operations using SQL operators, such as "like", "not like", and "between". FREE ACCESS
  • Locked
    4.  Using the SQL Alter Command
    10m 19s
    In this video, learn how to execute alter operations to add constraints and indices to tables. FREE ACCESS
  • Locked
    5.  Updating Data in Tables
    7m 20s
    In this video, find out how to update data. FREE ACCESS
  • Locked
    6.  Updating Data with Preserved Parameter Order
    9m 9s
    To find out how to perform update operations while preserving the parameter order, consult the documentation. FREE ACCESS
  • Locked
    7.  Deleting and Recreating a Table
    7m 47s
    Learn how to drop a table, recreate it, and insert rows into it. FREE ACCESS
  • Locked
    8.  Using Logical Operators to Filter Data
    6m 12s
    In this video, you will explore different ways to query data using logical operators. FREE ACCESS
  • Locked
    9.  Filtering Data Using Subqueries
    11m 56s
    In this video, you will learn how to filter data using two tables with a parent-child relationship. FREE ACCESS
  • Locked
    10.  Adding SQL Foreign Key Constraints
    5m 2s
    In this video, you will learn how to add a foreign key constraint to tables. FREE ACCESS
  • 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 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

Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM
Rating 4.4 of 31 users Rating 4.4 of 31 users (31)
Course Operations with petl: Introduction
Rating 4.6 of 36 users Rating 4.6 of 36 users (36)
Course SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Rating 4.7 of 27 users Rating 4.7 of 27 users (27)