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

  • 2m 46s
  • 10m 10s
    During this video, you will learn how to filter data using the "some" and "all" clauses. FREE ACCESS
  • Locked
    3.  Performing Three-way Joins
    10m 59s
    In this video, find out how to perform joins on three tables. FREE ACCESS
  • Locked
    4.  Creating SQL Views
    9m 6s
    Find out how to create SQL views on underlying tables. FREE ACCESS
  • Locked
    5.  Querying SQL Views Using the Where Clause
    9m 46s
    In this video, you will query views using the WHERE clause. FREE ACCESS
  • Locked
    6.  Inserting Data into Views
    10m 58s
    In this video, learn how to insert data into views. FREE ACCESS
  • Locked
    7.  Understanding SQL Indices
    10m 46s
    Learn how to create indexes on SQL tables. FREE ACCESS
  • Locked
    8.  Creating Composite Indices
    8m 41s
    Learn how to create custom and composite indexes. FREE ACCESS
  • Locked
    9.  Course Summary
    3m 2s

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 Database Fundamentals: Database Administration Basics
Course QlikView: Creating Line Charts, Combo Charts, Pivot Tables, & Block Charts
Likes 17 Likes 17  
Course Microsoft Azure Fundamentals: Databases & Data Analytics
Likes 229 Likes 229  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Likes 14 Likes 14  
Course Database Fundamentals: Getting Started with SQL
Course SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
Likes 21 Likes 21