SQL Databases Using SQLAlchemy: Chaining Joins Views & Indexes

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 youll perform multi-table joins by chaining the .join methods on different tables. Youll also simplify join syntax using aliases. Youll then create and query views and learn how insertions into views are propagated from the view to the underlying tables. Moving on youll create indexes and examine their metadata. Youll then differentiate between simple and composite indexes. By the end of the course youll 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.