Author(s) : Adam Machanic, Hugo Kornelis, Lara Rubbelke
Publisher : Apress
Year : May 2007
ISBN-10 : 159059729X
ISBN-13 : 9781590597293
Language : English
Pages : 445
File type : PDF
Size : 5.8 MB (book + source code)

This book, at its core, is all about building your own set of tools from which you can draw inspiration as you work with SQL Server. I try to explain not only the hows of each concept described herein, but also the whys. And in many examples throughout the book, I attempt to delve into the process I took for finding what I feel is the optimal solution. My goal is to share with you how I think through problems. Whether or not you find my approach to be directly usable, my hope is that you can harness it as a means by which to tune your own development methodology.

This book is arranged into three logical sections. The first four chapters deal with software development methodologies as they apply to SQL Server. The next three chapters get into advanced features specific to SQL Server. And the final four chapters are more architecturally focused, delving into specific design and implementation issues around some of the more difficult topics I’ve encountered in past projects.

The primary purpose of this book is to bring Microsoft SQL Server developers back into the software development fold. These pages stress rigorous testing, well-thought-out architectures, and careful attention to interdependencies. Proper consideration of these areas is the hallmark of an expert software developer—and database professionals, as the core members of any software development team, simply cannot afford to lack this expertise.

Author(s) : Dan Wood, Chris Leiter, Paul Turley
Publisher : Wrox
Year : Nov 2006
ISBN 10 : 0470047046
ISBN 13 : 9780470047040
Language : English
Pages : 574
File type : PDF
Size : 4.6 MB

This book, as the title suggests, is all about database administration. But what is database administration? Database administrators are more and more often being called upon to perform duties that are not strictly �administrative� in nature. Along with typical administrative duties such as backups, database maintenance, and user management, database administrators are increasingly being asked to perform tasks such as building complex data transformations for data import, building distributed data solutions, and, with the release of SQL Server 2005, maintaining the security and integrity of the database while enabling the integration of managed code into the database engine.

This book lays the foundation by covering in detail the most common database administrative tasks. It also introduces you to many of the more advanced areas that enterprise database administrators need to be familiar with. Read these pages carefully, and apply what you learn. From here, move on to more complex jobs and tasks. The opportunities for talented and hard-working database administrators are virtually unlimited.

Our primary audience is IT professionals (both developers and administrators) who have found themselves responsible for the management and maintenance of a SQL Server 2005 database. You may have been responsible for a SQL Server 2000 database and were just getting used to that when your company decided to move to SQL Server 2005. The new features and new tool set can be intimidating.

Author(s) : Michael "Monty" Widenius, David Axmark, MySQL AB
Publisher : O'Reilly
Year : Jun 2002
ISBN 10: 0596002653
ISBN 13: 9780596002657
Language : English
Pages : 814
File type : PDF
Size : 2.5 MB

This highly regarded and comprehensive reference manual comes directly from the members of the MySQL team. The book covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. No serious MySQL user should be without this book.

MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.

Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL.

Author(s) : Sikha Bagui, Richard Earp
Publisher : Auerbach
Year : Jun 2003
ISBN 10 : 0849315484
ISBN 13 : 9780849315480
Language : English
Pages : 264
File type : PDF
Size : 3 MB

Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests).

The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers.

This book is intended to be used by database practitioners and students for data modeling. It is also intended to be used as a supplemental text in database courses, systems analysis and design courses, and other courses that design and implement databases. Many present-day database and systems analysis and design books limit their coverage of data modeling. This book not only increases the exposure to data modeling concepts, but also presents a detailed, step-by-step approach to designing an ER diagram and developing the relational database from it.

Author(s) : Paul Wilton and John W. Colby
Publisher : Wrox
Year : Mar 2005
ISBN 10 : 0764577328
ISBN 13 : 9780764577321
Language : English
Pages : 528
File type : PDF
Size : 3.6 MB (book + source code)

This book starts right from the basics with databases and SQL. Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases.

If you have some previous experience with databases and SQL, then you�ll have a head start and you may want to just skim Chapter 1. You�ll need to follow its instructions for creating the book�s example database, as this is used for all the examples throughout the book.

This book will look at Structured Query Language, or SQL as it�s usually abbreviated. SQL works with a database to create the database and to insert and extract data. Therefore, it�s essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that you�re equipped to create an effective database.

The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However, while standards are great, what�s available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.