Ships from: Murphy, TX
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
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
| Ch. 1 | Introduction to SQL Server Express | 3 |
| Ch. 2 | Overview of database concepts | 11 |
| Ch. 3 | Overview of SQL Server Express | 29 |
| Ch. 4 | Database design and normalization | 43 |
| Ch. 5 | Transact-SQL overview and basics | 65 |
| Ch. 6 | Select queries | 101 |
| Ch. 7 | Action queries | 131 |
| Ch. 8 | Topics in advanced transact-SQL | 151 |
| Ch. 9 | Using management studio express | 185 |
| Ch. 10 | Databases | 215 |
| Ch. 11 | Tables | 235 |
| Ch. 12 | Indexing | 263 |
| Ch. 13 | Views | 273 |
| Ch. 14 | Stored procedures | 299 |
| Ch. 15 | Using triggers | 315 |
| Ch. 16 | Basic administrative tasks | 341 |
| Ch. 17 | Security and SQL Server Express | 375 |
| Ch. 18 | Working with Visual Basic Express | 397 |
| Ch. 19 | Accessing data using ADO.NET | 417 |
| Ch. 20 | Automating SQL Server Express using SMO and RMO | 445 |
| Ch. 21 | Locking | 471 |
| Ch. 22 | Monitoring and optimizing SQL Server Express | 489 |
| Ch. 23 | Replication | 501 |
| Ch. 24 | Service broker | 511 |
| Ch. 25 | Troubleshooting | 529 |
| App. A | Transact-SQL reference | 539 |
Overview
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 ...