В книге описана одна из самых популярных реляционных систем управления базами данных MySQL Вместо простого обзора возможностей MySQL, автор показывает, как можно максимально эффективно использовать эту СУБД. На примере двух тестовых баз данных он приводит рецепты решения проблем, с которыми вы обязательно столкнетесь при практическом использовании MySQL. Вы научитесь интегрировать MySQL с программными средствами, разработанными сторонними компаниями, такими как компиляторы языков РНР и Perl, которые позволяют с помощью запросов к базе данных создавать динамические Web-страницы. Кроме того, здесь приведен обширный справочник по типам столбцов, операторам, функциям, синтаксическим конструкциям языка SQL интерфейсам С API, Perl DBI и РНР API.
В книге предоставлена уникальная информация, которую вряд ли можно получить где-нибудь еще. Книга рассчитана на пользователей и разработчиков систем клиент/сервер на основе MySQL. Эта книга содержит:
Общую информацию по MySQL и языку запросов SQL; Описание типов данных MySQL и их применение; Советы по оптимизации запросов; Полный курс обучения процедуре создания клиентских программ на языке программирования С; Руководство по использованию интерфейсов Perl DBI и РНР APIдля создания приложений, работающих из командной строки и Web-приложений; Советы по вопросам администрирования (ведение учетных записей пользователей, резервное копирование, восстановление после сбоев и безопасность) ; Помощь в выборе провайдерадоступа к MySQL; Полная справка по типам данных MySQL, операторам, функциям и утилитам; Полные справочники по программным интерфейсам MySQL С API, Perl DBI API и РНР;
Databases » MySql: SQL Server 2005 Management and Administration
Author: free book city | Date: 26 February 2008 | Views: 271
SQL Server 2005 Management and Administration
Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more.
Databases » MySql: PostgreSQL 8 for Windows (Database Professional's Library)
Author: free book city | Date: 19 February 2008 | Views: 151
PostgreSQL 8 for Windows (Database Professional's Library)
PostgreSQL 8 for Windows (Database Professional's Library) McGraw-Hill Osborne Media; 1 edition | ISBN: 0071485627 | 400 pages | March 22, 2007 | PDF | 3 Mb
The easiest way to set up a PostgreSQL database server on Windows
Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database.
Databases » MySql: MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
Author: free book city | Date: 18 February 2008 | Views: 144
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam Que; 1 edition | ISBN: 0789735881 | 456 pages | August 10, 2006 | CHM | 2 Mb
The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like: * Complete coverage of all 70-431 exam objectives * Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips * Access to MeasureUp practice questions and innovative testing software * The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center * Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications
MySql, PHP: PHP & MySQL Web Development All-in-One Desk Reference For Dummies
Author: free book city | Date: 17 February 2008 | Views: 412
PHP & MySQL Web Development All-in-One Desk Reference For Dummies
Janet Valade, Bill Ballad “PHP & MySQL Web Development All-in-One Desk Reference For Dummies " For Dummies | 2008-01-29 | ISBN:0470167777 | 646 pages | PDF | 3,5 Mb
Webmasters and Web programmers around the world know that PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating dynamic, database-driven Web sites for eCommerce and content management. In fact, PHP is used in one of every three Web sites on the Internet and MySQL has been downloaded millions of times. PHP and MySQL provide a freely downloadable and widely supported alternative to ASP.NET. Written by the bestselling author of PHP & MySQL For Dummies, this book provides six discreet minibooks that show you not only how to program in PHP, create and administer a MySQL database, and manipulate MySQL data via a Web interface, but also shows you how to create a secure Web site, and how to code the most popular Web applications, such as login programs and shopping cart applications.