SQL Databases Using SQLAlchemy: Chaining Joins, Views, & Indexes
SQLAlchemy 1.3
| Intermediate
- 9 Videos | 1h 16m 14s
- Includes Assessment
- Earns a Badge
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 coursefilter data using the some and all clausesperform three-way joins in tablescreate SQL views on underlying tablesquery views using the where clause
-
insert data into viewscreate SQL indexes on tablescreate custom and composite indexessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 46sUP NEXT
-
2.Using the Some and All SQL Operators10m 10s
-
3.Performing Three-way Joins10m 59s
-
4.Creating SQL Views9m 6s
-
5.Querying SQL Views Using the Where Clause9m 46s
-
6.Inserting Data into Views10m 58s
-
7.Understanding SQL Indices10m 46s
-
8.Creating Composite Indices8m 41s
-
9.Course Summary3m 2s
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.