SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes

SQLAlchemy 1.3    |    Intermediate
  • 9 Videos | 1h 16m 14s
  • Includes Assessment
  • Earns a Badge
Likes 18 Likes 18
With a good grip on the use of SQLAlchemy in querying data in SQL tables, you are now ready to perform multi-table joins and use more powerful SQL abstractions. In this course, you'll perform multi-table joins by chaining the .join methods on different tables. You'll also simplify join syntax using aliases. You'll then create and query views and learn how insertions into views are propagated from the view to the underlying tables. Moving on, you'll create indexes and examine their metadata. You'll then differentiate between simple and composite indexes. By the end of the course, you'll be able to perform multi-table joins by chaining .join methods, create and query views, correctly insert data into underlying tables using views, create indexes, and interpret index metadata.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    filter data using the some and all clauses
    perform three-way joins in tables
    create SQL views on underlying tables
    query views using the where clause
  • insert data into views
    create SQL indexes on tables
    create custom and composite indexes
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 46s
    UP NEXT
  • Playable
    2. 
    Using the Some and All SQL Operators
    10m 10s
  • Locked
    3. 
    Performing Three-way Joins
    10m 59s
    FREE ACCESS
  • Locked
    4. 
    Creating SQL Views
    9m 6s
    FREE ACCESS
  • Locked
    5. 
    Querying SQL Views Using the Where Clause
    9m 46s
    FREE ACCESS
  • Locked
    6. 
    Inserting Data into Views
    10m 58s
    FREE ACCESS
  • Locked
    7. 
    Understanding SQL Indices
    10m 46s
    FREE ACCESS
  • Locked
    8. 
    Creating Composite Indices
    8m 41s
    FREE ACCESS
  • Locked
    9. 
    Course Summary
    3m 2s
    FREE ACCESS

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

COURSE Database Fundamentals: Working with SQL Commands
COURSE SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Likes 14 Likes 14  
COURSE Database Fundamentals: Understanding Relational Database Management Systems