SQL Server 2005 Beginners Pack

Beginning SQL Server 2005 Administration




For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book
* How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
* Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
* How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
* A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career


Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express: From Novice to Professional




SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (nonenterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments.

Author Rick Dobson provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications.


Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)




SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.

This book features practical steps to help you overcome issues you're likely to encounter. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server. Further, you'll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.

Additionally, you'll start to program in T-SQL, SQL Server's implementation (and extension) of the SQL programming language, and you'll come away with effective programming techniques using stored procedures and triggers.



Beginning SQL Server 2005 Programming (Programmer to Programmer)




Beginning SQL Server 2005 Programming.


* After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
* Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
* Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
* The companion Web site provides all of the code found in the book