Computer & Internet

Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple and powerful queries built on common table expressions (CTEs) and window functions. These new features in MariaDB and MySQL help you to write queries without having to wade through a quagmire of brittle self-joins and other crazy techniques from the past. Your queries will generate correct results, be more readable and less brittle in the face of unexpected data, and you’ll be able to adapt them quickly in the face of changing business requirements.

The fully revised, updated and extended 4th edition of the hugely popular web development book - includes CSS, HTML5, jQuery and the mysqli extension.

About This Book A professional, step-by-step approach to forensic analysis complete with key strategies and techniques Analyze the most popular Android applications using free and open source tools Learn forensically-sound core data extraction and recovery techniques

About This Book Focus on Android instrumentation testing to ensure full application coverage Apply testing techniques and utilize tools to improve Android application development Build intensively tested and bug free Android applications

Learn how to program your nifty new $35 computer to make a web spider, a weather station, a media server, and more. This book explores how to make a variety of fun and even useful projects, from a web bot to search and download files to a toy to drive your pets insane.

About This Book Use Node.js to satisfy the core backend requirements of modern apps, including user management, security, data access, and real-time data communication Build practical real-world mobile applications, which will give you the necessary knowledge to build your very own mobile solutions Step-by-step development of projects using Ionic Framework as the frontend and Node.js for the backend supported by a MongoDB database

Gain the R programming language fundamentals for doing the applied statistics useful for data exploration and analysis in data science and data mining. This book covers topics ranging from R syntax basics, descriptive statistics, and data visualizations to inferential statistics and regressions. After learning R’s syntax, you will work through data visualizations such as histograms and boxplot charting, descriptive statistics, and inferential statistics such as t-test, chi-square test, ANOVA, non-parametric test, and linear regressions.

Learn to build Rails-based web applications using all the latest features offered in Rails 5.2. Author Stefan Wintermeyer begins by teaching the basics of Ruby 2.5 before proceeding through all aspects of Rails, utilizing clean, succinct examples – rather than a single large application.

Build Android apps using the popular and efficient Android Studio 3 suite of tools, an integrated development environment (IDE) with which Android developers can now use the Kotlin programming language. With this book, you’ll learn the latest and most productive tools in the Android tools ecosystem, ensuring quick Android app development and minimal effort on your part. Along the way, you’ll use Android Studio to develop apps tier by tier through practical examples. These examples cover core Android topics such as Activities, Intents, BroadcastReceivers, Services and AsyncTask. Then, you’ll learn how to publish your apps and sell them online and in the Google Play store.

Explore key scenarios required for building quality Ionic apps quickly and easily and bring them to the iOS and Android mobile ecosystem.

Apply analytics to business problems using two very popular software tools, SAS and R. No matter your industry, this book will provide you with the knowledge and insights you and your business partners need to make better decisions faster.

About This Book Build ready-to-deploy apps with less iterations and shorter development times Adopt the lean startup methodologies to develop iOS and Android apps that shine in the App Store This hands-on guide puts continuous innovation into practice to develop successful mobile apps

Summary Kotlin in Action guides experienced Java developers from the language basics of Kotlin all the way through building applications to run on the JVM and Android devices. Foreword by Andrey Breslav, Lead Designer of Kotlin. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

Google has officially announced Kotlin as a supported language to write Android Apps.These are amazing news for Android developers, which now have the ability to use a modern and powerful language to make their job easier and funnier.But this comes with other responsibilities.

Learn to design and create video games using the Java programming language and the LibGDX software library. Working through the examples in this book, you will create 12 game prototypes in a variety of popular genres, from collection-based and shoot-em-up arcade games to side-scrolling platformers and sword-fighting adventure games. With the flexibility provided by LibGDX, specialized genres such as card games, rhythm games, and visual novels are also covered in this book.

Whether it’s the iPod Nano, iPod Shuffle, video iPod, or some other variation, iTunes and iPods go together like treble and bass. It’s so easy to purchase the latest music and videos, download podcasts, and even keep track of your calendar on your iPod—so why wouldn’t you? But if it’s so easy, why do you need iPod & iTunes For Dummies? iPods now come in everything from 1GB to 80GB models and play movies, store photos, function as a spare hard drive, and even wake you up in the morning. If this is your first one, you’ll find no better place to get acquainted with it than in this bestselling book. If you’ve just purchased a brand-new iPod, you’ll find this Fifth Edition packed with valuable tidbits about the latest and greatest features. You’ll discover how to:

When you carry an iPhone, you carry the power to get things done. Your pocket-sized device can keep you in touch with your friends, connect you to the world, maintain your schedule, access movies and music, and record your life in pictures and video. And that's just scratching the surface of what an iPhone can do!

The iPhone boot camp for getting the most out of your device iPhone For Dummies is the ultimate user-friendly guide to the iPhone! Whether you're new to the iPhone or just want to get more out of it, this book will show you the essentials you need to know to take full advantage of the major features. Dive into Utilities to customize your iPhone for the way you use it, and learn new ways to use familiar apps and tools. Whether your phone is new, old, or somewhere in between, this book has you covered; friendly, easy-to-read instructions cover the iPhone's newest features as well as the classic functions that have been there from the beginning. You'll learn how to solve common problems, save on data usage by connecting to WiFi, and keep your information safe using the iPhone's various security features. Quickly and easily migrate your information from another phone, and learn how to organize your contacts, photos, music, apps, and more. Learn just what your iPhone can do for you, and use each and every feature to the fullest!

Discover all the incredible things your iPad can do! So you have an iPad and you're excited to use it, but where do you begin? With this fun and friendly guide, of course! Veteran For Dummies author Nancy Muir walks you through using your iPad for e-mail, video, travel, navigation, reading, games, and more with this all-new update to the bestselling iPad For Seniors For Dummies. Written in the fun-but-straightforward For Dummies style, this helpful guide shares easy-to-follow tips and advice on the latest iPad hardware and operating system and introduces you to some of iPad’s most popular features like Siri, FaceTime, Safari, Maps, Reminders, and Photos to name a few.