v

您的位置:VeryCD教育计算机


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

  • 状态: 精华资源
  • 摘要:
    发行日期2006年06月16日
    对白语言英语
  • 时间: 2006/07/25 21:46:12 发布 | 2006/07/25 21:46:12 更新
  • 分类: 教育  计算机 

mailman

精华资源: 21

全部资源: 27

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名24小时sql 2005 教程
英文名SQL Server 2005 Express in 24 Hours
发行日期2006年06月16日
地区美国
对白语言英语
简介

IPB Image

写的清楚,而且实用。本书的作者是一个专家级的人物。他清楚详细的介绍了基本概念。

代码
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
IPB Image
"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

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有35网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。