Mastering Microsoft SQL Server 2005 Express Edition
Express Edition
1st Edition
Published on 1. April 2006
Book
Paperback/Softback
600 pages
978-0-7821-4402-4 (ISBN)
Description
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(r) Express
* Using SQL Server Management Studio Express
* Sharing data between multiple servers
* Monitoring and optimizing SQL Server Express
Featured on CD
CD includes Microsoft(r) SQL Server Express and Visual Basic(r) 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
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(r) Express
* Using SQL Server Management Studio Express
* Sharing data between multiple servers
* Monitoring and optimizing SQL Server Express
Featured on CD
CD includes Microsoft(r) SQL Server Express and Visual Basic(r) 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
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley & Sons Inc
Target group
Adult education
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23 cm
Width: 19 cm
Weight
884 gr
ISBN-13
978-0-7821-4402-4 (9780782144024)
Schweitzer Classification
Persons
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#(r); ADO and ADO.NET Programming; and Coder to Developer.
Susan Sales Harkins is the bestselling author of several database books, including Mastering Dreamweaver(r) MX Databases. She was formerly an editor-in-chief at The Cobb Group.
Susan Sales Harkins is the bestselling author of several database books, including Mastering Dreamweaver(r) MX Databases. She was formerly an editor-in-chief at The Cobb Group.
Content
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.
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.