Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Wednesday, February 2, 2011

MySQL Admin Cookbook


MySQL Admin Cookbook
 PDF | 376 pages |  10,45 Mb

MySQL Admin Cookbook /by Daniel Schneller (Author), Udo Schwedt (Author) .MySQL is the most popular open-source database and is also known for its easy set up feature. However, proper  configuration beyond the default settings still is a challenge, along with some other day-to-day maintenance tasks such as backing up and restoring, performance tuning, and server  monitoring. These tasks have not been covered thoroughly in the default documentation.
This book provides both step-by-step recipes and relevant background information on these  topics and more. It covers everything from basic to advanced aspects of MySQL  administration and configuration. One of the things you are really going to love about this  book is that all recipes are based on real-world experience and were derived from proven  solutions used in an enterprise environment.

This book shows you everything you need to know about MySQL Administration. You will learn  to set up MySQL replication to manage load balancing and deal with online backup and fail-over scenarios. As you consider the benefits of backing up, you might like to back up your  database efficiently with advanced techniques covered in this book.

Who this book is written for

This book is for ambitious MySQL users as well as professional data center database  administrators. Beginners as well as experienced administrators will profit from this  cookbook and get fresh ideas to improve their MySQL environments. Detailed background  information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational  database schema. Readers are expected to have a basic understanding of the SQL language and  database concepts in general.


Monday, August 30, 2010

SQL Clearly Explained


SQL Clearly Explained, Third Edition 
480 pages | PDF | 3,5 MB

Although the core of the SQL language remains relatively unchanged, the most recent release of the SQL standard (SQL:2008) includes two sets of extensions: 1) support for object-relational databases and 2) support for XML. The second edition of this book included some material about the object-relational extensions. However, that set of commands has been greatly extended and the new edition takes that into account. The XML extensions are entirely new to the third edition. A chapter on basic relational concepts will be also added to broaden the audience and make the book more complete in its own right.

All of the chapters will be revised to be sure they are up to date. Chapter 10 ("Views, Temporary Tables, and Indexes") from the second edition will be expanded to include common table expression (CTEs). The material in the existing Chapter 14 ("Unimplemented SQL-92 Features 251") will be disbursed through the chapters where the particular type of operation is discussed. While the content throughout will be updated where necessary, the existing organizational structure through chapter 14 will remain largely intact because this coverage represents the stable portion of the SQL language.

There will be two NEW chapters at the beginning of the book. Chapter 1 ("The Relational Data Model") covers the relational data model conceptual material; Chapter 2 ("Manipulating Relations with Relational Algebra") covers the relational algebra material that will be pulled from the retrieval chapters. Part 5 ("Non-relational SQL Extensions") will now include the non-relational SQL extensions in three chapters. Chapter 17 (NEW) will cover XML. Chapter 18 will contain the object-relational conceptual material from the original chapter 15 and chapter 19 (NEW) will cover SQL object-relational support. (Some of chapter 19 will come from the second edition, however, a great deal of object-relational support has been added to the current standard and therefore needs to be added.) The other NEW chapter is Chapter 14, which covers triggers and stored procedures. This material was missing from previous editions. Many readers should find it a useful addition.

•Demonstrates how to formulate SQL queries and how queries are processed to maximize performance of the database management system Explains use of SQL to enter, modify or delete data to maintain database structural elements Covers in great detail new SQL application for XML to meet the growing XML usage in development of online content

Download Link

Tuesday, December 29, 2009

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit:


The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit:
Database Implementation and Maintenance
696 pages | PDF | 7 Mb

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005. SQL Server 2008 is a much more significant update than SQL Server 2005, because it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization.

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit prepares readers for the Microsoft Certified Technology Specialist exam: SQL Server 2008, Implementation and Maintenance.

This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success.
Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.
Complete study package offers Syngress proven pedagogy including practice exams via the book's companion site