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 of this title 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[registered] Express; using SQL Server Management Studio Express; sharing data between multiple servers; and, monitoring and optimizing SQL Server Express. CD includes Microsoft[registered] SQL Server Express and Visual Basic[registered] Express! This title helps to: 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.