Master t-sql database design, development, and administration the easy way-hands-on! In just one hour a day, you'll build all the skills you need to create effective database applications with t-sql and sql server. With this complete tutorial, you'll quickly master the basics and then move on to more advanced features and concepts: * learn the fundamentals of t-sql from the ground up, one step at a time * succeed with the newest versions of t-sql, sql server, and sql server management studio * use t-sql effectively as both an application developer and dba * master powerful stored procedures, triggers, transactions, and user-defined functions (udfs) * systematically optimize and secure your sql server databases learn on your own time, at your own pace * no previous t-sql or database programming experience required * learn how to design efficient, reliable sql server databases * define efficient tables, table relationships, fields, and constraints * make the most of t-sql's select and update statements * work effectively with simple and complex views and joins * master stored procedure techniques every developer should know * build and use powerful user-defined functions (udfs) * secure databases with authentication, roles, permissions, and principals * configure, maintain, and tune sql server for maximum reliability, performance, and value * back up, restore, and audit databases * optimize databases with the sql server profiler, system monitor, and index tuning wizard * leverage valuable insight and time saving techniques from a world renowned database expert register your book at informit.Com/register for access to source code, example files, updates, and corrections as they become available.