Michael Blaha presenting Advanced SQL Queries iCal

Date: This event took place live on October 06 2015

Presented by: Michael Blaha

Location:
Carolina Inn
211 Pittsboro Street
Chapel Hill, North Carolina 27516

Advanced SQL Queries SQL is underutilized in software development. Way too many developers think there is nothing to SQL but store and retrieve. This session will explain the motivations for using advanced SQL. The session will present business situations where we have used advanced SQL queries. For example, we often write meta-SQL, SQL code that generates SQL code. For one project we read an ERwin data dictionary and with meta-SQL generated database comment commands to load comments for each table and column. As another example, we wrote SQL queries to look for time gaps and overlaps in staged data for a data warehouse.

More information about this event is available at: http://datamodelingzone.com/program/#Tuesday-Oct-6


Return to O'Reilly Events