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. ...
Beginning iOS Game Development
Want to start writing games for the iPhone and iPad, but you're new to iOS development? This book provides the starting point. No matter your experience level with iOS programming, this beginner's guide covers the technologies you need to know to get started creating fun iOS games. The coverage begins with the tools you'll need, including Xcode and Interface Builder, then gives you a tutorial in C and Objective-C, the languages you'll need to develop for iOS. Then you'll learn how to use the Cocoa Foundation framework and the Model-View-Controller architecture. Once you have the foundation in place, you'll move on to the libraries you need to add graphics, animation and sound, control user interaction, and even allow players to play head-to-head across a network. Learning how to create games should be nearly as much fun as playing them, so this book offers a complete, playable game in nearly every chapter. Each game is created in simple, easy-to-understand parts, building to a full gam ...
Want to start writing games for the iPhone and iPad, but you're new to iOS development? This book provides the starting point. No matter your experience level with iOS programming, this beginner's guide covers the technologies you need to know to get started creating fun iOS games. The coverage begins with the tools you'll need, including Xcode and Interface Builder, then gives you a tutorial in C and Objective-C, the languages you'll need to develop for iOS. Then you'll learn how to use the Cocoa Foundation framework and the Model-View-Controller architecture. Once you have the foundation in place, you'll move on to the libraries you need to add graphics, animation and sound, control user interaction, and even allow players to play head-to-head across a network. Learning how to create games should be nearly as much fun as playing them, so this book offers a complete, playable game in nearly every chapter. Each game is created in simple, easy-to-understand parts, building to a full gam ...
SharePoint 2010 at Work
If you work with SharePoint, you may have discovered that there are countless tricks for using this platform to solve real-world problems - and you certainly wouldn't mind learning some of them. That's the purpose behind EndUserSharePoint, a community site that lets end users share ingenious new ways for putting SharePoint to work. This insightful and entertaining book presents a compilation of popular, well-written articles from the site, published by contributors for people who use SharePoint at their companies but don't have access to its technical server side. Each engaging story puts you into the narrative as a participant, rather than a passive observer, so you can easily visualize the situation and share the "aha!" solution with the author. Learn some tricks, gain some insight - and have fun doing it. ...
If you work with SharePoint, you may have discovered that there are countless tricks for using this platform to solve real-world problems - and you certainly wouldn't mind learning some of them. That's the purpose behind EndUserSharePoint, a community site that lets end users share ingenious new ways for putting SharePoint to work. This insightful and entertaining book presents a compilation of popular, well-written articles from the site, published by contributors for people who use SharePoint at their companies but don't have access to its technical server side. Each engaging story puts you into the narrative as a participant, rather than a passive observer, so you can easily visualize the situation and share the "aha!" solution with the author. Learn some tricks, gain some insight - and have fun doing it. ...
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. ...
Professional Android Sensor Programming
This book shows Android developers how to exploit the rich set of device sensors - locational, physical (temperature, pressure, light, acceleration, etc.), cameras, microphones, and speech recognition - in order to build fully human-interactive Android applications. Whether providing hands-free directions or checking your blood pressure, Professional Android Sensor Programming shows how to turn possibility into reality. The authors provide techniques that bridge the gap between accessing sensors and putting them to meaningful use in real-world situations. They not only show you how to use the sensor related APIs effectively, they also describe how to use supporting Android OS components to build complete systems. Along the way, they provide solutions to problems that commonly occur when using Android's sensors, with tested, real-world examples. Ultimately, this invaluable resource provides in-depth, runnable code examples that you can then adapt for your own applications. ...
This book shows Android developers how to exploit the rich set of device sensors - locational, physical (temperature, pressure, light, acceleration, etc.), cameras, microphones, and speech recognition - in order to build fully human-interactive Android applications. Whether providing hands-free directions or checking your blood pressure, Professional Android Sensor Programming shows how to turn possibility into reality. The authors provide techniques that bridge the gap between accessing sensors and putting them to meaningful use in real-world situations. They not only show you how to use the sensor related APIs effectively, they also describe how to use supporting Android OS components to build complete systems. Along the way, they provide solutions to problems that commonly occur when using Android's sensors, with tested, real-world examples. Ultimately, this invaluable resource provides in-depth, runnable code examples that you can then adapt for your own applications. ...
Real-World Solutions for Developing High-Quality PHP Frameworks and Applications
Learn to develop high-quality applications and frameworks in PHP Packed with in-depth information and step-by-step guidance, this book escorts you through the process of creating, maintaining and extending sustainable software of high quality with PHP. World-renowned PHP experts present real-world case studies for developing high-quality applications and frameworks in PHP that can easily be adapted to changing business requirements. They offer different approaches to solving typical development and quality assurance problems that every developer needs to know and master. - Details the process for creating high-quality PHP frameworks and applications that can easily be adapted to changing business requirements. - Covers the planning, execution, and automation of tests for the different layers and tiers of a Web application. - Demonstrates how to establish a successful development process. - Shares real-world case studies from well-known companies and their PHP experts. ...
Learn to develop high-quality applications and frameworks in PHP Packed with in-depth information and step-by-step guidance, this book escorts you through the process of creating, maintaining and extending sustainable software of high quality with PHP. World-renowned PHP experts present real-world case studies for developing high-quality applications and frameworks in PHP that can easily be adapted to changing business requirements. They offer different approaches to solving typical development and quality assurance problems that every developer needs to know and master. - Details the process for creating high-quality PHP frameworks and applications that can easily be adapted to changing business requirements. - Covers the planning, execution, and automation of tests for the different layers and tiers of a Web application. - Demonstrates how to establish a successful development process. - Shares real-world case studies from well-known companies and their PHP experts. ...
Excel Formulas and Functions For Dummies, 2nd Edition
Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work. You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. ...
Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work. You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. ...
Java For Dummies, 5th Edition
Java is the platform-independent, object-oriented programming language used for developing web and mobile applications. The revised version offers new functionality and features that have programmers excited, and this popular guide covers them all. This book helps programmers create basic Java objects and learn when they can reuse existing code. It's just what inexperienced Java developers need to get going quickly with Java 2 Standard Edition 7.0 (J2SE 7.0) and Java Development Kit 7.0 (JDK 7). ...
Java is the platform-independent, object-oriented programming language used for developing web and mobile applications. The revised version offers new functionality and features that have programmers excited, and this popular guide covers them all. This book helps programmers create basic Java objects and learn when they can reuse existing code. It's just what inexperienced Java developers need to get going quickly with Java 2 Standard Edition 7.0 (J2SE 7.0) and Java Development Kit 7.0 (JDK 7). ...
Building Web Apps for Google TV
By integrating the Web with traditional TV, Google TV offers developers an important new channel for content. But creating apps for Google TV requires learning some new skills - in fact, what you may already know about mobile or desktop web apps isn't entirely applicable. Building Web Apps for Google TV will help you make the transition to Google TV as you learn the tools and techniques necessary to build sophisticated web apps for this platform. This book shows you how Google TV works, how it fits into the web ecosystem, and what the opportunities are for delivering rich content to millions of households. ...
By integrating the Web with traditional TV, Google TV offers developers an important new channel for content. But creating apps for Google TV requires learning some new skills - in fact, what you may already know about mobile or desktop web apps isn't entirely applicable. Building Web Apps for Google TV will help you make the transition to Google TV as you learn the tools and techniques necessary to build sophisticated web apps for this platform. This book shows you how Google TV works, how it fits into the web ecosystem, and what the opportunities are for delivering rich content to millions of households. ...
MacRuby: The Definitive Guide
Want to build native Mac OS X applications with a sleek, developer-friendly alternative to Objective-C? MacRuby is an ideal choice. This in-depth guide shows you how Apple's implementation of Ruby gives you access to all the features available to Objective-C programmers. You'll get clear, detailed explanations of MacRuby, including quick programming techniques such as prototyping. Perfect for programmers at any level, this book is packed with code samples and complete project examples. If you use Ruby, you can tap your skills to take advantage of Interface Builder, Cocoa libraries, the Objective-C runtime, and more. If you're a Cocoa developer, you'll learn how to improve your productivity with MacRuby. ...
Want to build native Mac OS X applications with a sleek, developer-friendly alternative to Objective-C? MacRuby is an ideal choice. This in-depth guide shows you how Apple's implementation of Ruby gives you access to all the features available to Objective-C programmers. You'll get clear, detailed explanations of MacRuby, including quick programming techniques such as prototyping. Perfect for programmers at any level, this book is packed with code samples and complete project examples. If you use Ruby, you can tap your skills to take advantage of Interface Builder, Cocoa libraries, the Objective-C runtime, and more. If you're a Cocoa developer, you'll learn how to improve your productivity with MacRuby. ...