Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863
This one-day hands-on seminar lets you test and challenge your query skills while learning tips, tricks and best practices for quality and performant SQL Server queries.
Note: This is an interactive and hands-on class. The number of puzzles and topics will vary.
Rule #1! Know your data! How do you know if you have the right answer? Here we will look at steps to study a database.
Rule #1! Know your data! Is your data “clean”? Is “KE” really a state? Are “AB-100” and “AB100” the same product? Should nulls be treated as zeros or just ignored?
Should you use temp tables? How about subqueries and Common Table Expressions? Here we will look at taking complex queries and breaking them in to smaller more manageable, and often independently testable, components. And of course… Rule #1! Know your data!
Does mixing integers with money impact your query results? How about mixing varchar, varchar(max) and char? And don’t forget Rule #1!
1 Day Course