Mastering Microsoft SQL Server 2005 Express Edition

ISBN-10: 0782144020
ISBN-13: 9780782144024
Category: Computers
Pages: 600
Language: English
Published: 2006-06-19
Publisher: Sybex
Authors: Susan Sales Harkins, Mike Gunderloy

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

Get the book

Similar books

Mastering Microsoft Sql Server 2005, Express Edition
By Gunderloy Harkins
Written by the author of the bestselling Mastering SQL Server 2000, this book has an easy learning curve for beginners, but doesn't stop there.
Mastering Microsoft SQL Server 2005
By Mike Gunderloy, Joseph L. Jorden, David W. Tschanz
... EXEC sp_addumpdevice 'disk', 'Test_Backup', 'c:\Test_Backup.dat' BACKUP DATABASE TEST TO Test_Backup Ira-mama . '"li 3w Q ---~ I filo» 3mm 9mm Duh-Isl In' IMWITGIJ _ 'Eva —W i i _ we .9; : - 'Bi: “'1 in on' (W 'Mnngms'wnm cum 0.
Mastering Microsoft Visual Web Developer 2005 Express Edition
By John Mueller
Powerful Web Development Technologies, Now Made Simple For anyone who wants to build a professional website with minimal trouble, Visual Web Developer 2005 Express Edition is the solution. This book...
MASTERING MS VISUAL WEB DEVELOPER 2005 EXPRESS ED
By John Paul Mueller
Mastering Visual Web Developer 2005, Express Edition, approaches the new product comprehensively to uncover all it has to offer. This book has an easy learning curve for beginners, but doesn't stop there.
Mastering Microsoft Visual Basic 2005 Express Ed.
By Evangelos Petroutsos, Acey J.Bunch
Written by the author of the bestselling Mastering Visual Basic .NET, this book has an easy learning curve for beginners, but doesn't stop there.
Mastering Microsoft Windows 7 Administration
By William Panek, Tylor Wentworth
In this chapter you'll learn how to install Windows 7 because, as you already know, before you can master any ... Windows 7 0 Determine which version of Windows 7 to install 0 Install the Windows 7 operating system Q Migrate users from ...
Mastering Microsoft Windows 7 Administration
By Tylor Wentworth
A comprehensive guide for IT administrators deploying Windows 7 Using a task-focused approach and clear, no-nonsense instructions, this book delivers all the information you'll need to deploy and manage Windows 7 efficiently and securely.
Mastering VMware Infrastructure 3
By Chris McCain
Incorporating a shared storage back-end helps eliminate many of the network failure issues that administrators find themselves ... Choosing the right RAID level for a LUN is therefore an integral part of your VI3 implementation.
Mastering Web Development with Microsoft Visual Studio 2005
By John Paul Mueller
NET 2.0. For example, Microsoft has made it easier to add security to your Web application. ASP.NET 2.0 includes both credential storage and ... Chapter 18 tells you more about creating secure applications using Visual Web Developer.
Mastering Microsoft Virtualization
By Jeffrey L. Buller, Tim Cerling
This option runs msinfo32, which displays a window with hardware resources, components, and software environment. sconfig does not have an equivalent. ... Q} 6% $ Chapter 3 Creating and Managing Virtual Machines. Master It Install the ...