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

SQLAlchemy 1.3    |    Intermediate
  • 9 videos | 1h 16m 14s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 20 users Rating 4.4 of 20 users (20)
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 SQL Databases Using SQLAlchemy: Using the SQLAlchemy ORM
Rating 4.4 of 31 users Rating 4.4 of 31 users (31)
Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Rating 4.7 of 27 users Rating 4.7 of 27 users (27)
Course SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
Rating 4.4 of 24 users Rating 4.4 of 24 users (24)
Course Querying with Joins
Rating 4.6 of 89 users Rating 4.6 of 89 users (89)