BEGIN:VCALENDAR
PRODID:-//github.com/rianjs/ical.net//NONSGML ical.net 4.0//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:America/Phoenix
X-LIC-LOCATION:America/Phoenix
END:VTIMEZONE
BEGIN:VEVENT
DESCRIPTION:<p>For over 40 years\, SQL has remained the gold standard for 
 querying and manipulating data. While NoSQL databases are becoming more w
 idely used\, SQL remains a valuable skill in developers' toolbelts due to
  how prolific the language remains.<br /> <br /> However\, despite its ma
 turity\, efficient and simple solutions are not always obvious in SQL. In
  this presentation\, we'll be solving several scenarios based on real-wor
 ld problems. Together we'll discuss common issues\, why basic approaches 
 fall short\, and how applying more advanced SQL techniques provides a bet
 ter alternative. While this presentation will focus specifically on T-SQL
 \, the techniques we'll be covering are applicable to other variants of S
 QL as well. <br /> <br /> Topics covered:</p>\n<ul>\n<li><strong>Performa
 nce</strong> - Avoid row-by-agonizing-row (RBAR) approaches and use set-b
 ased solutions by leveraging a numbers table and by using window function
 s.</li>\n<li><strong>Functionality</strong> - Navigate hierarchical data 
 using recursive common table expressions (CTEs).</li>\n<li><strong>Consis
 tency</strong> - Avoid common concurrency pitfalls by strategically apply
 ing the appropriate isolation level within your query.</li>\n</ul>\n<p>Ap
 plying these same techniques to other problems you may encounter in the f
 uture will lead to creative and elegant solutions.</p>
DTEND;TZID=America/Phoenix:20181006T104500
DTSTAMP:20260608T171114Z
DTSTART;TZID=America/Phoenix:20181006T094500
GEO:33.293070;-111.796620
LOCATION:Chandler - Gilbert Community College - IRN-229
ORGANIZER:
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:<p>For over 40 years\, SQL has remained the gold standard for quer
 ying and manipulating data. While NoSQL databases are becoming more widel
 y used\, SQL remains a valuable skill in developers' toolbelts due to how
  prolific the language remains.<br /> <br /> However\, despite its maturi
 ty\, efficient and simple solutions are not always obvious in SQL. In thi
 s presentation\, we'll be solving several scenarios based on real-world p
 roblems. Together we'll discuss common issues\, why basic approaches fall
  short\, and how applying more advanced SQL techniques provides a better 
 alternative. While this presentation will focus specifically on T-SQL\, t
 he techniques we'll be covering are applicable to other variants of SQL a
 s well. <br /> <br /> Topics covered:</p>\n<ul>\n<li><strong>Performance<
 /strong> - Avoid row-by-agonizing-row (RBAR) approaches and use set-based
  solutions by leveraging a numbers table and by using window functions.</
 li>\n<li><strong>Functionality</strong> - Navigate hierarchical data usin
 g recursive common table expressions (CTEs).</li>\n<li><strong>Consistenc
 y</strong> - Avoid common concurrency pitfalls by strategically applying 
 the appropriate isolation level within your query.</li>\n</ul>\n<p>Applyi
 ng these same techniques to other problems you may encounter in the futur
 e will lead to creative and elegant solutions.</p>
UID:ff865a1b-4eb4-4747-b561-a0937710a62e
END:VEVENT
END:VCALENDAR