An Animated Guide: SQL from Beginner to Advanced
Presented: Tuesday September 3, 2019, 8:00am-5:00pm
Russ Lavery is a frequent and multiple award-winning presenter at SAS Users Groups. He has presented all over the U.S., in Europe, and in Asia. He is a contractor and lives outside of Philadelphia. His hobbies include SAS, statistics, reading, salsa, bachata and tai chi.
SQL has been difficult to learn because SQL has been a “black box”. The historical teaching method has been to have the student run dozens of SQL queries until s/he recognizes a pattern – but it has been impossible to explain why results come out as they do. This seminar shows a graphical model of previously undocumented PROC SQL internal processes and makes PROC SQL easy to learn.
The major deliverable of this seminar is the graphical representation of the SQL process and we use that graphical model to develop rules for describing, and predicting, the SQL process. These descriptive rules translate directly into coding rules and allow a programmer to quickly code PROC SQL queries.