Limit this search to....

T-SQL in One Hour a Day, Sams Teach Yourself
Contributor(s): Balter, Alison (Author)
ISBN: 0672337436     ISBN-13: 9780672337437
Publisher: Sams Publishing
OUR PRICE:   $35.99  
Product Type: Paperback - Other Formats
Published: October 2015
* Not available - Not in print at this time *
Additional Information
BISAC Categories:
- Computers | Databases - General
- Computers | Programming Languages - Sql
Dewey: 005.758
Series: Sams Teach Yourself
Physical Information: 0.9" H x 5.3" W x 8.2" (1.00 lbs) 432 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
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.