Discovering SQL
Discover best practices for turning data into information you can use Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. ...
Discover best practices for turning data into information you can use Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. ...
Professional Microsoft SQL Server 2012 Integration Services
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published. ...
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published. ...
Working with NHibernate 3.0
This book provides examples using the IQuery, ICriteria, QueryOver, and LINQ to NHibernate API's within the context of an example Guitar Store inventory program. The reader is walked through the creation of a Microsoft SQL Server 2008 database, the creation of a Visual Studio 2010 solution consisting of 3 projects (a Window Presentation Foundation (WPF), a Console Application, and a Class Library). Each one utilizes the .NET 4.0 framework. Then the reader is walked through the steps required to configure and use the many features available contained within NHibernate 3.2. Further instructions and examples exist for the insertion of parent / child relationships, Session management, entity states (transient, persistent and detached), deletion, caching, and batching. ...
This book provides examples using the IQuery, ICriteria, QueryOver, and LINQ to NHibernate API's within the context of an example Guitar Store inventory program. The reader is walked through the creation of a Microsoft SQL Server 2008 database, the creation of a Visual Studio 2010 solution consisting of 3 projects (a Window Presentation Foundation (WPF), a Console Application, and a Class Library). Each one utilizes the .NET 4.0 framework. Then the reader is walked through the steps required to configure and use the many features available contained within NHibernate 3.2. Further instructions and examples exist for the insertion of parent / child relationships, Session management, entity states (transient, persistent and detached), deletion, caching, and batching. ...
iOS 5 Programming Cookbook
Now you can overcome the vexing, real-life issues you confront when creating apps for the iPhone, iPad, or iPod Touch. By making use of more than 100 new recipes in this updated cookbook, you'll quickly learn the steps necessary for writing complete iOS apps, whether they're as simple as a music player or feature a complex mix of animations, graphics, multimedia, a database, and iCloud storage. If you're comfortable with iOS SDK, this cookbook will teach you how to use hundreds of iOS techniques. Each recipe provides a clear solution with sample code that you can use right away. ...
Now you can overcome the vexing, real-life issues you confront when creating apps for the iPhone, iPad, or iPod Touch. By making use of more than 100 new recipes in this updated cookbook, you'll quickly learn the steps necessary for writing complete iOS apps, whether they're as simple as a music player or feature a complex mix of animations, graphics, multimedia, a database, and iCloud storage. If you're comfortable with iOS SDK, this cookbook will teach you how to use hundreds of iOS techniques. Each recipe provides a clear solution with sample code that you can use right away. ...
Just Spring Data Access
JDBC has simplified database access in Java applications, but a few nagging wrinkles remain - namely, persisting Java objects to relational databases. With this book, you'll learn how the Spring Framework makes that job incredibly easy with dependency injection, template classes, and object-relational-mapping (ORM). Through sample code, you'll discover how Spring streamlines the use of JDBC and ORM tools such as Hibernate, the Java Persistence API (JPA), and Java Data Objects (JDO). If you're a Java developer familiar with Spring and want to advance your data access skills, this book shows you how. ...
JDBC has simplified database access in Java applications, but a few nagging wrinkles remain - namely, persisting Java objects to relational databases. With this book, you'll learn how the Spring Framework makes that job incredibly easy with dependency injection, template classes, and object-relational-mapping (ORM). Through sample code, you'll discover how Spring streamlines the use of JDBC and ORM tools such as Hibernate, the Java Persistence API (JPA), and Java Data Objects (JDO). If you're a Java developer familiar with Spring and want to advance your data access skills, this book shows you how. ...
Seven Databases in Seven Weeks
Data is getting bigger and more complex by the day, and so are the choices in handling that data. As a modern application developer you need to understand the emerging field of data management, both RDBMS and NoSQL. Seven Databases in Seven Weeks takes you on a tour of some of the hottest open source databases today. In the tradition of Bruce A. Tate's Seven Languages in Seven Weeks, this book goes beyond your basic tutorial to explore the essential concepts at the core each technology. Redis, Neo4J, CouchDB, MongoDB, HBase, Riak and Postgres. With each database, you'll tackle a real-world data problem that highlights the concepts and features that make it shine. You'll explore the five data models employed by these databases-relational, key / value, columnar, document and graph-and which kinds of problems are best suited to each. ...
Data is getting bigger and more complex by the day, and so are the choices in handling that data. As a modern application developer you need to understand the emerging field of data management, both RDBMS and NoSQL. Seven Databases in Seven Weeks takes you on a tour of some of the hottest open source databases today. In the tradition of Bruce A. Tate's Seven Languages in Seven Weeks, this book goes beyond your basic tutorial to explore the essential concepts at the core each technology. Redis, Neo4J, CouchDB, MongoDB, HBase, Riak and Postgres. With each database, you'll tackle a real-world data problem that highlights the concepts and features that make it shine. You'll explore the five data models employed by these databases-relational, key / value, columnar, document and graph-and which kinds of problems are best suited to each. ...
Learning Rails 3
If you're a web developer or designer ready to learn Rails, this unique book is the ideal way to start. Rather than throw you into the middle of the framework's Model-View-Controller architecture, Learning Rails 3 works from the outside in. You'll begin with the foundations of the Web you already know, and learn how to create something visible with Rails' view layer. Then you'll tackle the more difficult inner layers: the database models and controller code. All you need to get started is HTML experience. Each chapter includes exercises and review questions to test your understanding as you go. ...
If you're a web developer or designer ready to learn Rails, this unique book is the ideal way to start. Rather than throw you into the middle of the framework's Model-View-Controller architecture, Learning Rails 3 works from the outside in. You'll begin with the foundations of the Web you already know, and learn how to create something visible with Rails' view layer. Then you'll tackle the more difficult inner layers: the database models and controller code. All you need to get started is HTML experience. Each chapter includes exercises and review questions to test your understanding as you go. ...
Programming Hive
Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoop's data warehouse infrastructure. You'll quickly learn how to use Hive's SQL dialect - HiveQL - to summarize, query, and analyze large datasets stored in Hadoop's distributed filesystem. This example-driven guide shows you how to set up and configure Hive in your environment, provides a detailed overview of Hadoop and MapReduce, and demonstrates how Hive works within the Hadoop ecosystem. You'll also find real-world case studies that describe how companies have used Hive to solve unique problems involving petabytes of data. Use Hive to create, alter, and drop databases, tables, views, functions, and indexes;Customize data formats and storage options, from files to external databases;Load and extract data from tables - and use queries, grouping, filtering, joining, and other conventional query methods;Gain best practices for creating ...
Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoop's data warehouse infrastructure. You'll quickly learn how to use Hive's SQL dialect - HiveQL - to summarize, query, and analyze large datasets stored in Hadoop's distributed filesystem. This example-driven guide shows you how to set up and configure Hive in your environment, provides a detailed overview of Hadoop and MapReduce, and demonstrates how Hive works within the Hadoop ecosystem. You'll also find real-world case studies that describe how companies have used Hive to solve unique problems involving petabytes of data. Use Hive to create, alter, and drop databases, tables, views, functions, and indexes;Customize data formats and storage options, from files to external databases;Load and extract data from tables - and use queries, grouping, filtering, joining, and other conventional query methods;Gain best practices for creating ...
MongoDB in Action
MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you'll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You'll also love the deep explanations of each feature, including replication, auto-sharding, and deployment. ...
MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you'll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You'll also love the deep explanations of each feature, including replication, auto-sharding, and deployment. ...
MongoDB: The Definitive Guide
How does MongoDB help you manage a huMONGOus amount of data collected through your web application? With this authoritative introduction, you'll learn the many advantages of using document-oriented databases, and discover why MongoDB is a reliable, high-performance system that allows for almost infinite horizontal scalability. Written by engineers from 10gen, the company that develops and supports this open source database, MongoDB: The Definitive Guide provides guidance for database developers, advanced configuration for system administrators, and an overview of the concepts and use cases for other people on your project. Learn how easy it is to handle data as self-contained JSON-style documents, rather than as records in a relational database. ...
How does MongoDB help you manage a huMONGOus amount of data collected through your web application? With this authoritative introduction, you'll learn the many advantages of using document-oriented databases, and discover why MongoDB is a reliable, high-performance system that allows for almost infinite horizontal scalability. Written by engineers from 10gen, the company that develops and supports this open source database, MongoDB: The Definitive Guide provides guidance for database developers, advanced configuration for system administrators, and an overview of the concepts and use cases for other people on your project. Learn how easy it is to handle data as self-contained JSON-style documents, rather than as records in a relational database. ...