This presentation discusses the SQL best practices that are critically important as databases get bigger and more complex. This presentation will discuss the SQL writing techniques, table cardinality, index factors, and other consideration that make your SQL run faster. You will learn through this presentation SQL best practices tuning tips, the real life issues, and agile SQL considerations for working with Spring Batch, Docker Containers and other agile tools.
This presentation was developed for application developers to help them understand high performance SQL factors for running against tables that contain billions of rows. These SQL techniques, table factors and index considerations discussed show how small critical factors can make a big performance difference against big data tables. SQL functions, UDFs, common table expressions CTE and other SQL techniques are only some of the factors that need to be considered in the SQL development cycle. This presentation will help you understand all these SQL performance factors and the best practices used to get the fastest SQL results from your biggest tables.
About our special guest:
Dave Beulke and Associates is a customer-focused and results-oriented DB2 consulting, DB2 training and education and software company specializing in overall performance for all aspects of information technology. We specialize in IBM’s DB2 database running on any platform and help companies reduce CPU demands by as much as 40%, saving our customers millions of dollars. Through focused DB2 performance consulting engagements, we have improved computing performance of systems, databases, application and SQL reducing total cost of ownership and eliminating the need to upgrade computing hardware.
Stay safe, stay healthy, wash your hands, and visit http://www.DataViewShow.com for more free education. We love subscribers and appreciate your thumbs up!
WATCH THE REPLAY
97% of our HUGE live audience learned something! What will you learn?
GET A PDF
A PDF makes great reference material, but you are cheating yourself if you don’t watch the video above! Dave elaborates key points and addresses several audience questions! Get the PDF here!