Flylib.com
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130
BUY ON AMAZON
Microsoft SQL Server 2005: Database Essentials Step by Step
Back Cover
About
Introduction
How This Book Is Organized
Finding Your Best Starting Point in This Book
Conventions and Features in This Book
System Requirements
Sample Files
Support for This Book
Part I: Introduction to Database Development with Microsoft SQL Server 2005
Chapter 1: Introducing Database Development with Microsoft SQL Server 2005
Introducing Database Systems
Defining the Architecture of a Database Application
Conclusion
Chapter 2: Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment
Recommended Productivity Tools
Recommended Development Tools
Microsoft SQL Server 2005 Editions
Installing SQL Server 2005
Conclusion
Chapter 2 Quick Reference
Chapter 3: Reviewing Microsoft SQL Server 2005 Management Tools
Introduction
Using SQL Server Books Online
Using SQL Server Configuration Manager
Using SQL Server Surface Area Configuration
Using SQL Server Management Studio
Using SQL Server Profiler
Using Database Engine Tuning Advisor
Using SQLCmd
Conclusion
Chapter 3 Quick Reference
Part II: How to Create a Microsoft SQL Server 2005 Database
Chapter 4: Gathering and Understanding Business Requirements before Creating Database Objects
Understanding Business Processes and User Interaction Requirements
Understanding Business Data and Its Lifetime
Predicting the Volume of Information to Store and Manage and Predicting Database Utilization
Conclusion
Chapter 4 Quick Reference
Chapter 5: Designing a Database to Solve Business Needs
Designing a Database Conceptually
Designing a Database Logically to Leverage the Relational Engine
Physically Creating a Database
Conclusion
Chapter 5 Quick Reference
Part III: How to Query Data from Microsoft SQL Server 2005
Chapter 6: Reading Microsoft SQL Server 2005 Data from Client Applications
Introducing Microsoft Data Access Components
Introducing the .NET SQL Server Data Provider
Introducing SQL Native Client
Conclusion
Chapter 6 Quick Reference
Chapter 7: Selecting the Data You Need
Selecting Data from a Single Table
Selecting Data from Multiple Tables
Reading Single Values
Reading Relational and XML Data
Querying XML and Relational Data Using XQuery
Sorting Data
Conclusion
Chapter 7 Quick Reference
Chapter 8: Creating Views to Encapsulate Queries
Selecting Data from a Single View
Mixing Data from Views and Tables
Working with Views within Client Applications
Conclusion
Chapter 8 Quick Reference
Chapter 9: Retrieving Data Using Programmable Objects
Introduction
Working through a Simple Problem
Common Language Runtime UDFs and Procedures
Conclusion
Chapter 9 Quick Reference
Part IV: How to Modify Data in Microsoft SQL Server 2005
Chapter 10: Inserting Data in Microsoft SQL Server 2005
Using the INSERT Statement
Inserting Data through Views
Importing Data into SQL Server 2005
Using Integration Services to Insert Data
Encapsulating Insert Operations in Stored Procedures
Triggering Actions Automatically when Inserting Data
Dealing with Errors when Inserting Data
Inserting Data from ADO.NET
Conclusion
Chapter 10 Quick Reference
Chapter 11: Deleting Data from Microsoft SQL Server 2005
Deleting Data through Views
Encapsulating Delete Operations in Stored Procedures
Dealing with Errors
Deleting Data from ADO.NET
Conclusion
Chapter 11 Quick Reference
Chapter 12: Updating Data from Microsoft SQL Server 2005
Updating Data through Views
Encapsulating Update Operations in Stored Procedures
Triggering Actions Automatically when Updating Data
Dealing with Errors
Updating Data from ADO.NET
Conclusion
Chapter 12 Quick Reference
Index
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
List of Figures
List of Tables
List of Sidebars
CD Content
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130
BUY ON AMAZON
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 1.2 Install SSH Windows Clients to Access Remote Machines Securely
Step 2.1 Use the OpenSSH Tool Suite to Replace Clear-Text Programs
Step 3.3 Use WinSCP as a Graphical Replacement for FTP and RCP
Step 5.2 Troubleshooting Common OpenSSH Errors/Problems
Conclusion
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 14. Make Free Maps of the United States Online
Hack 39. View Your Photo Thumbnails on a Flash Map
Hack 46. Map Global Weather Conditions
Hack 54. Create Your Own Maps for a Garmin GPS
Hack 57. Connect to Your GPS from Multiple Applications
File System Forensic Analysis
Standard File Attributes
Group Descriptor Tables
UFS1 Group Descriptor
Block and Fragment Bitmaps
Bibliography
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Executing Corporate Strategy with Lean Six Sigma
Success Story #4 Stanford Hospital and Clinics At the forefront of the quality revolution
Service Process Challenges
First Wave Service Projects
Java Concurrency in Practice
Thread Safety
Immutability
Composing Objects
Executing Tasks in Threads
Read-write Locks
MPLS Configuration on Cisco IOS Software
Penultimate Hop Popping
Cell-Mode MPLS
Overview of Inter-Provider VPNs
Command Reference
Case Study 8: Implementing Hub and Spoke Topologies with EIGRP
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies