Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle including its testing and refactoring Build productive database solutions and use them in Java applications A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL Who This Book Is For If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary. Readers should, however, know SQL. What You Will Learn Learn concepts of data modelling and relation algebra Install and set up PostgreSQL database server and client software Implement data structures in PostgreSQL Manipulate data in the database using SQL Implement data processing logic in the database with stored functions, triggers and views Test database solutions and assess the performance Integrate database with Java applications Detailed knowledge of the main PostgreSQL building objects, most used extensions Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring In Detail PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems. The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework. Style and approach An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

Packed with expert advice and practical examples of effective store design and report creation to help you make better decisions, formulate more effective strategies, and measure your success. This book is for anyone administering an osCommerce site, including webmasters, content managers, store owners, and marketing managers, who do not need to understand PHP or MySQL to benefit from this book. The tips and techniques described in this book can be applied to any small, medium sized e-commerce site. This is not an implementation guide; developers implementing osCommerce-based e-commerce sites would benefit from reading Deep Inside osCommerce: The Cookbook.

This book uses many hands-on examples to show you how to use ODP.NET and Oracle Developer Tools from within Visual Studio 2005 to access Oracle Database 10g. The book is written for professional .NET developers who need to work with and take full advantage of Oracle Database 10g using Visual Studio 2005. Developers are expected to be familiar with Visual Basic.NET 2005 and have minimum knowledge of Oracle SQL and PL/SQL.

With this book in hand, you will be able to set up and manage a Community Server solution. You will learn how to create blogs, forums, photo galleries, and file galleries, and use tools such as the built-in RSS reader and RSS roller in a step-by-step manner. This book will provide your with a clear and concise overview of Community Server and will impart the knowledge necessary to enable you to run and manage a Community Server solution. This book is aimed at the Community Server administrator with a base level of technical competence and confidence, but no prior sysadmin or developer experience or knowledge. No knowledge of ASP.NET programming is required for using this book. What is essential is your own passion for your target community and your desire to provide the best platform possible to that audience.

The author draws on his experience to offer the reader valuable advice on the best practices. Providing only necessary theoretical background, the book takes a practical approach, presenting case studies and plenty of illustrative examples. This book is aimed at Linux Network administrators with some understanding of Linux security threats and issues, or any one interested in securing their systems behind a firewall. Basic knowledge of Linux is presumed but other than that this book shows you how to do the rest, from configuring your system to dealing with security breaches.

This book is a comprehensive and well structured tutorial on using PEAR Installer, but it is also much more than that. As the creator of the latest versions of the PEAR Installer (1.4.0+) , the author is passionate about the benefits of a well managed development and deployment process. The book shows how the PEAR Installer works in detail, and then takes you through a comprehensive tour of how you can apply it all stages of the development lifecycle, with practical examples and advice throughout. It will build your technical skills and understanding, and also widen your perspective on managing an effective development process. The book is not just for PHP developers who want to understand how the PEAR Installer works, and what it can do for them, but more generally for PHP developers seeking a better way to deploy their applications and manage updates. It does assume that you have a good working knowledge of PHP development, and are dealing with projects of a sufficient scale and complexity to warrant an investment in a structure process.

You can use this book to help you set up and administer a DotNetNuke portal, even if you have a limited knowledge of ASP.NET. You will learn how to setup and administer an example site, stepping through all the tasks to ease your learning. If you are a developer, this book will help you extend the DotNetNuke portal by first helping you understand how the core framework works and then show you how to create custom modules and skins. A rudimentary knowledge of VB.NET programming is assumed, but the emphasis is not on becoming a better VB.NET programmer but on taming DotNetNuke. This book has been written for both the beginner wanting to set up a website and also ASP.NET developers with a grasp of VB.NET who want a deeper understanding of how to work with DotNetNuke. To work with the DotNetNuke code, you will need access to Visual Web Developer Express or Visual Studio .NET 2005. No prior knowledge of DotNetNuke is assumed.

Using a highly graphical, practical style the experienced authors show you how to get the most out of vBulletin. This book is written for new and intermediate users of vBulletin, who want to manage and maintain a vBulletin discussion forum as easily as possible. No experience of web programming is required.

This book is for web developers willing to build better web applications. A basic knowledge of PHP, XML, JavaScript and MySQL, or a strong will to learn-as-you-type, is assumed.

The book is uniquely practical. A richly textured case study is used throughout the book. Although some aspects of the Airport Passenger Services business process are simplified for sake of clarity and efficiency, it provides a comprehensive practical grounding for theoretical UML knowledge. The case study itself was developed in partnership with employees of Zurich Airport. The book was written for business analysts, technical architects and developers. It does not require detailed programming knowledge, nor is prior experience of UML mandatory. It shows how, with UML, simple models of business processes and specification models can be created and read with little effort.

This practical tutorial-based book is filled with information about the architecture, functionality, and extensions of Microsoft Windows Server 2012 Dynamic Access Control.If you are an IT consultant/architect, system engineer, system administrator, or security engineers planning to implement Dynamic Access Control in your organization, or have already implemented it and want to discover more about the abilities and how to use them effectively, this book will be an essential resource. You should have some understanding of security solutions, Active Directory, Access Privileges/ Rights and Authentication methods, and a fundamental understanding of Microsoft technologies. Programming knowledge is not required but can be helpful for using PowerShell or the APIs to customize your solution.

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

This is a practical and light-hearted guide to get to grips with creating your first games, with easy-to-follow, step-by-step tutorials using the award winning Unity engine.If you’ve ever wanted to enter the world of independent game development but have no prior knowledge of programming or game development, then this is the book for you. Game developers transitioning from other tools like GameMaker and Flash will find this a useful tool to get them up to speed on the Unity engine, as will anyone who has never handled the Unity engine before.

Google Maps API Cookbook follows a fast-paced, high-level, structured cookbook approach, with minimal theory and an abundance of practical, real-world examples explained in a thorough yet concise manner to help you learn quickly and efficiently.Google Maps API Cookbook is for developers who wish to learn how to do anything from adding a simple embedded map to a website to developing complex GIS applications with the Google Maps JavaScript API. It is targeted at JavaScript developers who know how to get by but who are also seeking the immediacy of recipe-based advice.

An in-depth tutorial that teaches you the basics of data-driven applications, and how to design and implement them using Ext JS.If you are an intermediate in Sencha Ext JS, "Ext JS Data-Driven Application Design" is the tutorial for you. You need to be familiar with JavaScript and have basic operational knowledge of MySQL. If you want to be able to systematically construct an application from the first step to implementation, this book will be useful for you.

This is a step-by-step tutorial that covers the basics of working with the MicroStrategy platform.If you are a BI developer who would like to use MicroStrategy to build BI apps, this book is ideal for you. This book is also for mid-management executives who need to analyze data and Excel files that are too complicated to manage. A basic concept of BI is assumed.

A practical guide, packed with illustrations, that will help you become proficient with Hudson and able to utilize it how you want.If you are a Java developer or administrator who would to like automate some of the mundane work required to build and test software and improve software quality, this is the book for you. If you are a development manager or tester, you can also benefit from learning how Hudson works by gaining some insight into test results and historical trends.

Pentaho Data Integration Cookbook Second Edition is written in a cookbook format, presenting examples in the style of recipes.This allows you to go directly to your topic of interest, or follow topics throughout a chapter to gain a thorough in-depth knowledge.Pentaho Data Integration Cookbook Second Edition is designed for developers who are familiar with the basics of Kettle but who wish to move up to the next level.It is also aimed at advanced users that want to learn how to use the new features of PDI as well as and best practices for working with Kettle.

This book is written in a Cookbook style targeted towards an advanced audience. It covers the advanced topics of data visualization in Python.Python Data Visualization Cookbook is for developers that already know about Python programming in general. If you have heard about data visualization but you don't know where to start, then this book will guide you from the start and help you understand data, data formats, data visualization, and how to use Python to visualize data.You will need to know some general programming concepts, and any kind of programming experience will be helpful, but the code in this book is explained almost line by line. You don't need maths for this book, every concept that is introduced is thoroughly explained in plain English, and references are available for further interest in the topic.

The book will follow aA standard tutorial approach, and will beas a complete guide detailing the major aspects of PhantomJS with particular focus on Website website Testingtesting.This book is written forIf you are a JavaScript developers who are is interested in developing applications that interact with various web services, and doing that using a headless browser, then this book is ideal for you. This book iswill also be good for you if you are planning to create a headless browser testing for your web application. Basic understanding of JavaScript is assumed.

This book is full of step-by-step example-oriented tutorials which will show readers how to integrate Solr in PHP applications using the available libraries, and boost the inherent search facilities that Solr offers.If you are a developer who knows PHP and is interested in integrating search into your applications, this is the book for you. No advanced knowledge of Solr is required. Very basic knowledge of system commands and the command-line interface on both Linux and Windows is required. You should also be familiar with the concept of Web servers.