Summer Reading Sale
 
 

Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »

spacer

Mastering Microsoft SQL Server 2005 (Mastering)

by

Mastering Microsoft SQL Server 2005 (Mastering) Cover

ISBN13: 9780782144024
ISBN10: 0782144020
Condition: Standard
All Product Details

Only 2 left in stock at $9.50!

 

Synopses & Reviews

Publisher Comments:

A Comprehensive Guide to Microsoft's New Express Edition of its Bestselling Database Server

Microsoft's SQL Server 2005 Express Edition is the perfect fit if you're a small business owner, trainer, or student who doesn't need all the bells and whistles of the full version of SQL Server 2005. In this comprehensive guide written by two SQL Server experts, you'll find step-by-step explanations and simplified management tools for

using SQL Server Express in smaller-scale but still mission-critical situations. With a focus on practical tasks, the book thoroughly

covers both database administration and development, smoothly moving you from beginner to advanced subjects.

Coverage Includes

  • Understanding basic database concepts
  • Getting to know database types: file server, client server, relational and more
  • Learning Structured Query Language (SQL) and SQL Server's Transact-SQL
  • Creating efficient and useful databases
  • Writing queries and stored procedures to explore your data
  • Automating the administration of your databases
  • Developing database applications with Visual Basic® Express
  • Using SQL Server Management Studio Express
  • Sharing data between multiple servers
  • Monitoring and optimizing SQL Server Express

Featured on CD

CD includes Microsoft® SQL Server Express and Visual Basic® Express!

Leverage the Experience of Experts through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshootng

Discover Practical Solutions to a Database Administrator's Needs

Reduce Complexity and Build Simple Data-Driven Applications

Synopsis:

SQL Server 2005 Express Edition is a scaled-back version of Microsoft's best-selling database manager, offered as part of the new Visual Studio 2005 Express Edition. It contains new, simplified management tools and development environment, and is provided free of charge--in part to compete with open-source solutions, such as the popular MySQL. It lacks the bells and whistles of the full version, but works as a solution for small-to-medium-size businesses, data-driven web sites, and educational institutions.

Synopsis:

Reduce Complexity and Build Simple Data-Driven Applications

About the Author

Mike Gunderloy has been developing software for over 25 years, during which time he has gained expertise across a wide variety of Microsoft technologies. His books include Mastering SQL Server 2005; Mastering Visual C#®; ADO and ADO.NET Programming; and Coder to Developer.

Susan Sales Harkins is the bestselling author of several database books, including Mastering Dreamweaver® MX Databases. She was formerly an editor-in-chief at The Cobb Group.

Table of Contents

Introduction.

PART I: INTRODUCING SQL SERVER EXPRESS.

Chapter 1. Introduction to SQL Server Express.

Chapter 2. Overview of Database Concepts.

Chapter 3. Overview of SQL Server Express.

Chapter 4. Database Design and Normalization.

PART II: TRANSACT-SQL.

Chapter 5. Transact-SQL Overview and Basics.

Chapter 6. Select Queries.

Chapter 7. Action Queries.

Chapter 8. Topics in Advanced Transact-SQL. 

PART III: DIGGING INTO SQL SERVER EXPRESS.

Chapter 9. Using Management Studio Express.

Chapter 10. Databases.

Chapter 11. Tables.

Chapter 12. Indexing.

Chapter 13. Views.

Chapter 14. Stored Procedures.

Chapter 15. Using Triggers.

PART IV: ADMINISTERING SQL SERVER EXPRESS.

Chapter 16. Basic Administrative Tasks.

Chapter 17. Security and SQL Server Express.

PART V: DEVELOPING APPLICATIONS WITH SQL SERVER EXPRESS.

Chapter 18. Working with Visual Basic Express.

Chapter 19. Accessing Data Using ADO.NET.

Chapter 20. Automating SQL Server Express Using SMO and RMO.

PART VI: ADVANCED SQL SERVER EXPRESS ADMINISTRATION.

Chapter 21. Locking.

Chapter 22. Monitoring anad Optimizing SQL Server Express.

Chapter 23. Replication.

Chapter 24. Service Broker.

Chapter 25. Troubleshooting.

Appendix: Transact-SQL Reference.

Index.

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

shivkantb, October 18, 2006 (view all comments by shivkantb)
Good And Easy to learn SQL SERVER 2005
Was this comment helpful? | Yes | No
(4 of 8 readers found this comment helpful)

Product Details

ISBN:
9780782144024
Author:
Gunderloy, Mike
Publisher:
Sybex
Author:
Harkins, Susan Sales
Subject:
Relational databases
Subject:
Database Management - SQL Server
Subject:
Database design
Subject:
Database Management - General
Subject:
Database & Data Warehousing Technologies
Copyright:
Edition Description:
CD
Series:
Mastering
Publication Date:
20060619
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
600
Dimensions:
8.96x7.54x1.31 in. 1.92 lbs.

Other books you might like

  1. Programming SQL Server 2005 New Trade Paper $54.99
  2. MCTS Self-Paced Training Kit (Exam... Used Hardcover $2.50
  3. Microsoft SQL Server 2005... Used Trade Paper $7.50

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Mastering Microsoft SQL Server 2005 (Mastering) Used Trade Paper
0 stars - 0 reviews
$9.50 In Stock
Product details 600 pages Sybex Inc - English 9780782144024 Reviews:
"Synopsis" by , SQL Server 2005 Express Edition is a scaled-back version of Microsoft's best-selling database manager, offered as part of the new Visual Studio 2005 Express Edition. It contains new, simplified management tools and development environment, and is provided free of charge--in part to compete with open-source solutions, such as the popular MySQL. It lacks the bells and whistles of the full version, but works as a solution for small-to-medium-size businesses, data-driven web sites, and educational institutions.
"Synopsis" by , Reduce Complexity and Build Simple Data-Driven Applications
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.