可配置联接 从新手到大师的所有人的概述、提示、技巧和流程.ppsx

1、Query Me This!Configurable Joins Overview,Tips,Tricks,and Processes for Everyone from Novice to MasterChuck WilsonUniversity of ChicagoEnrollment and Student AdvancementQuery me this!Enrollment and Student AdvancementWho is this for?Enrollment and Student Advancement Query Masters(Very familiar with

2、 the data.Builds the difficult queries.)Query Builders(Can build queries but needs help with complexity.)Query Adapters(Altering and adapting existing queries to fit needs.)Query Runners(Go to query,click a button,and say run little query run!)There Are Four(4)PrimaryCategories of Query Users Out th

3、ereEnrollment and Student AdvancementBut Why Configurable Joins?Enrollment and Student AdvancementIt Seems So Much More WorkTo Do The Same Thing!Enrollment and Student AdvancementIt Seems So Much More WorkTo Do The Same Thing!Enrollment and Student AdvancementIt Seems So Much More WorkTo Do The Same

4、 Thing!Enrollment and Student AdvancementIts Not As Complex As It SeemsAnd You Get So Much More!Enrollment and Student AdvancementTrade In Your Old QueriesFor a Faster More Accurate Model!What Do We Get?Enrollment and Student AdvancementLets CompareEnrollment and Student AdvancementLets CompareQuery

5、 BasesQuick and easy if you know the names of the exports and filters you are looking for.Variable speeds depending on SQL construction.Some fields require configuration.Limited quantities of exports for repetitive fields.Requires custom SQL to expand.Reliant upon supplied naming conventions or SQL

6、analysis to know exactly what it is doing.Configurable JoinsQuick and easy if you set up templates and libraries.Streamlined for faster processing.Most fields are already included for use with a quick refresh.Can join as many tables or subqueries as desired.Can better control how you want your expor