《24小时sql 2005 教程》(SQL Server 2005 Express in 24 Hours)

中文名: 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