Publisher's Synopsis
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
