Sams Teach Yourself T-SQL in One Hour a Day（Paperback）

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.

以每天一小時的方式，輕鬆地掌握T-SQL資料庫設計、開發和管理技巧！透過實際操作，您將在短時間內建立所需的技能，並使用T-SQL和SQL Server創建有效的資料庫應用程式。這本完整的教程將讓您快速掌握基礎知識，並深入研究更高級的功能和概念，包括：

- 逐步從頭開始學習T-SQL的基礎知識
- 成功使用最新版本的T-SQL、SQL Server和SQL Server Management Studio
- 將T-SQL有效地應用於應用程式開發和資料庫管理
- 掌握強大的儲存過程、觸發器、交易和使用者定義函數（UDFs）
- 系統化地優化和保護您的SQL Server資料庫

您可以根據自己的時間和進度進行學習，無需任何T-SQL或資料庫程式設計經驗。您將學習如何設計高效、可靠的SQL Server資料庫，定義高效的表格、表格關聯、欄位和約束條件，充分利用T-SQL的SELECT和UPDATE語句，有效地使用簡單和複雜的視圖和連接，掌握每個開發人員都應該了解的儲存過程技巧，建立和使用強大的使用者定義函數（UDFs），通過身份驗證、角色、權限和主體保護資料庫，以及配置、維護和調整SQL Server以實現最大的可靠性、性能和價值，備份、還原和審核資料庫，使用SQL Server Profiler、系統監視器和索引調整精靈優化資料庫，並從世界知名的資料庫專家那裡獲得寶貴的見解和節省時間的技巧。

請在informit.com/register註冊您的書籍，以獲取源代碼、示例文件、更新和更正資訊。