Book details
Paperback: 462 pages
Publisher: Addison Wesley (13 Dec 2000)
Language English
ISBN-10: 0201703319
ISBN-13: 978-0201703313


Book Description

The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.


Synopsis

The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more.Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.



For more free books download visit this blog daily



Download






.

Book Details
Paperback: 504 pages
Publisher: Wrox (December 5, 2005)
Language: English
ISBN-10: 0764574906
ISBN-13: 978-0764574900

Book Description

The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements


From the Back Cover
Database design involves how to best structure the tables and queries that are used with databases in order to provide optimum performance, storage, manageability, and flexibility. With relational databases, you can use those tables to organize your data and retrieve information from your database. This book provides you with an easy-to-understand explanation of designing and building relational database models to do just that.
The numerous step-by-step examples and a helpful case study simplify a potentially complex subject and present it to you in an organized, understandable manner. You'll find out why relational database models became necessary in the first place, and how the relational database model was devised. Ultimately, you'll discover how to make much better use of your database by applying what you've learned about building the database model.


For more free books download visit this blog daily



Download




.

Product Details


Paperback: 767 pages
Publisher: McGraw-Hill Osborne Media; 2 edition (December 12, 2005)
Language: English
ISBN-10: 0072262397
ISBN-13: 978-0072262391


Product Description
Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

From the Back Cover
Generate and distribute comprehensive, integrated reports
Transform disparate corporate data into business intelligence with help from this hands-on guide. Microsoft SQL Server 2005 Reporting Services explains how to create, manage, and deliver traditional and interactive reports with this powerful server-based reporting solution. Written by a member of the Reporting Services development team, the book covers the entire report-building and distribution process and offers complete details on all the product's integrated features. Improve business decision-making in your organization by getting the right information to the right people at the right time.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS

Install and set up SQL Server 2005 Reporting Services
Use the SELECT query to extract report data from your data sources
Add charts, images, and other graphics
Generate reports using the Report Wizard and from scratch
Maintain a secure, managed environment
Integrate reports with desktop and web applications
Enable end-user access to reports via the Report Server and its Report Manager web interface
Export reports to other presentation and data exchange rendering formats


For more free books download visit this blog daily


Download





.

Binding: Softcover

Publisher: Sams

ISBN-13: 9780672311109

ISBN: 0672311100

Description: Fair. A tradition of southern quality and service. All books guaranteed at the Atlanta Book Company.

With SQL (Structured Query Language) you can create tables within a database, add and delete data, query for information, change system settings, and trigger actions based on changes to the database. Whether you're a programmer, administrator, or database designer, Sams Teach Yourself SQL in 21 Days, Second Edition provides all the information needed to fully understand this powerful tool and use it to its fullest potential. Using step-by-step instructions, real-world examples, and expert advice, you'll improve your productivity and take your skills to new heights.



For more free books download visit this blog daily


Download


OR


Download




.