Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
- page 1
Buy on amazon.com >>
N
<< Previous book
Next page >>
1
2
Microsoft SQL Server 2005: Database Essentials Step by Step
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
1
2
Buy on amazon.com >>
N
<< Previous book
Next page >>