24小时sql 2005 教程 SQL Server 2005 Express in 24 Hours

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: 24小时sql 2005 教程 英文名: SQL Server 2005 Express in 24 Hours 发行日期: 2006年06月16日 地区: 美国 对白语言: 英语 概述:

写的清楚，而且实用。本书的作者是一个专家级的人物。他清楚详细的介绍了基本概念。 代码 Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize： SQL Server stored procedures 存储过程 Functions 函数 Triggers using T-SQL, VB.NET, and C# 触发器。使用T-SQL, VB.NET, and C# Part 1: Introduction to SQL Server Hour 1. Basic Relational Database Design 关系型数据库设计基础 Database Basics 数据库基层 System Versus User Objects 系统和用户对象 Table Basics 表基础 Relational Database Design Concepts 关系型数据库设计理念 Database Diagram Basics 数据库图表基础 View Basics 视图基础 Stored Procedure Basics 存储过程基础 User-Defined Function Basics 函数基础 Trigger Basics 触发器 SQL Server Stored Procedures Versus Transact-SQL Statements Stored on Local Computers sql服务器存储过程与Transact-SQL语句 Summary Q&A Workshop Activities Hour 2. SQL Server Basics sql 服务器基础 Versions of SQL Server 2005 Available sql 2005 介绍。 Installing SQL Server Express 安装 Getting Started with the SQL Server Management Studio Express SQL Server Management Studio Express 入门 Summary 摘要 Q&A Workshop Activities Hour 3. Getting to Know the SQL Server Management Studio Microsoft SQL Server Management Studio Express Creating a SQL Server Database Summary Q&A Workshop Activities Part 2: Working with Tables, Views, and Stored Procedures 表，视图 和存储过程 Hour 4. SQL Server Tables 表 Creating SQL Server Tables Working with Constraints Identity Columns Working with Computed Columns Working with User-Defined Data Types Adding and Modifying Indexes Summary Q&A Workshop Activities Hour 5. Working with Table Relationships 表格关系 An Introduction to Relationships Working with Database Diagrams Working with Table Relationships How to Designate Table and Column Specifications How to Add a Relationship Name and Description How to Determine when Foreign Key Relationships Constrain the Data Entered in a Column Designating Insert and Update Specifications Summary Q&A Workshop Activities Hour 6. Getting to Know the SELECT Statement Introducing T-SQL Working with the SELECT Statement Adding on the FROM Clause Including the WHERE Clause Using the ORDER BY Clause Adding the DISTINCT Keyword Working with the FOR XML Clause Creating Top Values Queries Summary Q&A Workshop Activities Hour 7. Building SQL Statements Based on Multiple Tables Working with Join Types Working with the GROUP BY Clause Including Aggregate Functions in Your SQL Statements Taking Advantage of the HAVING Clause Summary Q&A Workshop Activities Hour 8. Modifying Data with Action Queries Modifying Data with Action Queries Summary Q&A Workshop Activities Hour 9. Getting to Know the T-SQL Functions Working with Numeric Functions Taking Advantage of String Functions Exploring the Date/Time Functions Working with Nulls Summary Q&A Workshop Activities Hour 10. Working with SQL Server Views An Introduction to Views Using T-SQL to Create or Modify a View Summary Q&A Workshop Activities Hour 11. Creating Complex Views Creating Views Based on Data in Multiple Tables Views and Subqueries Views and Outer Joins Views and Top Values Sorting View Results Views and Functions Views and Built-in Functions Using Views to Secure Data Modifying Data in a View Modifying Views Renaming Views Deleting Views Indexed Views Optimizing the Views That You Build Summary Q&A Workshop Activities Hour 12. Using T-SQL to Design SQL Server Stored Procedures The Basics of Working with Stored Procedures Declaring and Working with Variables Controlling the Flow Summary Q&A Workshop Activities Hour 13. Important Stored Procedure Techniques The SET NOCOUNT Statement Using the @@ Functions Working with Parameters Modifying Data with Stored Procedures Errors and Error Handling Stored Procedures and Transactions Summary Q&A Workshop Activities Hour 14. Stored Procedure Special Topics Stored Procedures and Temporary Tables Stored Procedures and Security Building and Working with User-Defined Functions Creating and Working with Triggers Summary Q&A Workshop Hour 15. ADO.NET and SQL Server The History of Data Access The Basics of ADO.NET Building Queries That Modify Data Summary Q&A Workshop Activities Hour 16. Using VB to Design SQL Server Stored Procedures Executing a Simple Stored Procedure Declaring and Working with Variables Controlling Program Flow Working with Parameters Modifying Data with Stored Procedures Summary Q&A Workshop Activities Hour 17. Visual Basic .NET Special Topics Working with Temporary Tables Including Error Handling in the Stored Procedures that You Build Using Transactions to Protect Your Data Summary Q&A Workshop Activities Hour 18. Using C# to Design SQL Server Stored Procedures Executing a Simple Stored Procedure Declaring and Working with Variables Controlling Program Flow Working with Parameters Modifying Data with Stored Procedures Summary Q&A Workshop Activities Hour 19. C# Special Topics Working with Temporary Tables Including Error Handling in the Stored Procedures That You Build Using Transactions to Protect Your Data Summary Q&A Workshop Activities Hour 20. Debugging the Stored Procedures That You Write Harnessing the Power of the Immediate Window Invoking the Debugger Using Breakpoints to Troubleshoot Stepping Through Code Setting the Next Statement to Execute Viewing the Call Stack Working with the Locals Window Working with Watch Expressions Summary Q&A Workshop Activities Part 3: Security and Administration 安全与管理 Hour 21. SQL Server Authentication The Basics of Security Types of Authentication Available How to Create Logins How to Create Roles Summary Q&A Workshop Activities Hour 22. SQL Server Permissions Validation The Types of Permissions Available Getting to Know Table Permissions Getting to Know View Permissions Getting to Know Stored Procedure Permissions Getting to Know Function Permissions Implementing Column-Level Security Summary Q&A Workshop Activities Hour 23. Configuring, Maintaining, and Tuning SQL Server Selecting and Tuning Hardware How to Configure and Tune SQL Server How to Maintain Your Databases How to Maintain Tables and Other Objects Summary Q&A Workshop Activities Hour 24. Performance Monitoring Executing Queries in SQL Server Management Studio Express Displaying and Analyzing the Estimated Execution Plan for a Query Adding Indexes to Enable Queries to Execute More Efficiently Setting Query Options Summary Q&A Workshop Activities Appendix A. Using the NorthWind Sample Database File What You Need to Know About Installing the Sample Database Files Attaching to the NorthWind Sample Database File Index 写的清楚，而且实用。本书的作者是一个专家级的人物。他清楚详细的介绍了基本概念。 每一章设计为一个小时。（当然，你如果愿意可以多花些时间） 我相信你可以通过读这本书，而轻松的管理sql服务器。本书有以下包含： 存储过程 函数 触发器。 《A Developer Guide to SQL Server 2005》 电子书: [eBook] 类型： 电子书 文件大小： 17.5M 适用平台： 95/98/Me/NT/2000/XP/.Net/ 书名：A Developer's Guide to SQL Server 2005 出版日期：2006-04-28 ISBN:032138218 语言：英文 格式：CHM 简介: SQL Server 2005开发指南. From the Back Cover

"I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or XML background and suddenly had an urgent need to learn it. SQL Server 2005 is too big of a release to learn from the books online. Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as painlessly as possible. Basically, it's one-stop shopping for serious developers who have to get up to speed quickly. I'll keep this one on my desk--not on my bookshelf. Well done, Bob and Dan!" --Dr. Tom Moreau SQL Server MVP and Monthly Columnist SQL Server Professional, Brockman Moreau Consulting Inc. "A SQL book truly for developers, from two authorities on the subject. I'll be turning to this book first when I need to understand a component of SQL Server 2005." --Matt Milner Instructor Pluralsight "An excellent book for those of us who need to get up to speed on what's new in SQL Server 2005. The authors made sure this book includes the final information for the release version of the product. Most other books out now are based on beta versions. It covers key areas from XML and SQLCLR to Notification Services. Although the wide variety of information is great, my favorite part was the advice given on when to use what, and how performance is affected." --Laura Blood Senior Software Developer Blue Note Computing, Inc. "SQL Server 2005 is a massive release with a large number of new features. Many of these features were designed to make SQL Server a great application development platform. This book provides comprehensive information about the SQL Server features of most interest to application developers. The lucid text and wealth of examples will give a developer a clear understanding of how to use SQL Server 2005 to a whole new class of database applications. It should be on every SQL Server developer's bookshelf." --Roger Wolter Solutions Architect Microsoft Corporation "While there will be a lot of good books on SQL Server 2005 development, when people refer to the 'bible,' they'll be talking about this book." --Dr. Greg Low Senior Consultant Readify Pty Ltd "SQL Server 2005 is loaded with new features and getting a good overview is essential to understand how you can benefit from SQL Server 2005's features as a developer. Bob and Dan's book goes beyond enumerating the new SQL Server 2005 features, and will provide you with lots of good examples. They did a good job striking a balance between overview and substance." --Michiel Wories Senior Program Manager, SQL Server Microsoft Corporation Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide--accurate, comprehensive, and packed with examples. A Developer's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005's key innovations. It draws on exceptional cooperation from Microsoft's SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases. You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product. Key coverage includes Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance Writing procedures, functions, triggers, and types in .NET languages Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax Effectively using the XML data type and XML queries Implementing native SQL Server 2005 Web Services Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS) Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications [通过安全测试] 杀毒软件：卡巴斯基反病毒 版本： Personal Pro 5.0.227 病毒库：2006-06-04 00:37:45 共享条件：电信ADSL 2M带宽，上载理论64K，平均50K。 共享时间：一般是晚上8－12点在线，除非线路故障或者机器故障，偶尔全天在线。 共享服务器：一般在DonkeyServer No2