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‎.‎