SQL Queries for Mere Mortals, 4th Edition
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box". In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all y ...
SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think "outside the box". In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all y ...
Cross Over to HTML5 Game Development
Break into the most lucrative platform in the world by adding HTML5 game development to your current skillset. Zarrar Chishti has trained developers from a wide range of programming disciplines to cross over into HTML5 game development. Whatever your vocation, whether it be an Application Databases Systems developer or a Professional Web developer, with this book you will learn to evolve your current coding skills to become eligible for the biggest gaming platform in the world. From the first chapter you will see encouraging results immediately as you power through a challenging and fun project that has been uniquely designed and developed for this book. With the relentless backing of the giants of the industry including Apple and Google, HTML5 is rapidly becoming the leading technology for game development. Furthermore nearly every mobile device, tablet and PC system offer full support to the latest games developed in HTML5. Never before has there been such a widely accepted pl ...
Break into the most lucrative platform in the world by adding HTML5 game development to your current skillset. Zarrar Chishti has trained developers from a wide range of programming disciplines to cross over into HTML5 game development. Whatever your vocation, whether it be an Application Databases Systems developer or a Professional Web developer, with this book you will learn to evolve your current coding skills to become eligible for the biggest gaming platform in the world. From the first chapter you will see encouraging results immediately as you power through a challenging and fun project that has been uniquely designed and developed for this book. With the relentless backing of the giants of the industry including Apple and Google, HTML5 is rapidly becoming the leading technology for game development. Furthermore nearly every mobile device, tablet and PC system offer full support to the latest games developed in HTML5. Never before has there been such a widely accepted pl ...
Practical Scala DSLs
Build domain specific languages (DSLs) using Java's most popular functional programming language: Scala. This book introduces the basics of Scala and DSLs using a series of practical examples. In Practical Scala DSLs, you'll learn to create pragmatic and complete code examples that explain the actual use of DSLs with Scala: a web API and microservices; a custom language; a mobile app; a Forex system; a game; and cloud applications. At the end of this unique book, you'll be able to describe the differences between external and internal DSLs; understand when and how to apply DSLs; create DSLs using Scala; and even create a DSL using another programming language. Build DSLs in Scala; Write a web API and microservices; Create a custom language; Apply DSLs to mobile apps development, a Forex trading system, game development, and more; Discover the role of DSLs in cloud development; Integrate DSLs as part of a DevOps program or structure; Build internal and external DSLs. ...
Build domain specific languages (DSLs) using Java's most popular functional programming language: Scala. This book introduces the basics of Scala and DSLs using a series of practical examples. In Practical Scala DSLs, you'll learn to create pragmatic and complete code examples that explain the actual use of DSLs with Scala: a web API and microservices; a custom language; a mobile app; a Forex system; a game; and cloud applications. At the end of this unique book, you'll be able to describe the differences between external and internal DSLs; understand when and how to apply DSLs; create DSLs using Scala; and even create a DSL using another programming language. Build DSLs in Scala; Write a web API and microservices; Create a custom language; Apply DSLs to mobile apps development, a Forex trading system, game development, and more; Discover the role of DSLs in cloud development; Integrate DSLs as part of a DevOps program or structure; Build internal and external DSLs. ...
Beginning Serverless Computing
Learn the basics of serverless computing and how to develop event-driven architectures with the three major cloud platforms: Amazon Web Services, Microsoft Azure, and Google Cloud. This hands-on guide dives into the foundations of serverless computing, its use cases, and how to apply it using developer tools such as Node.js, Visual Studio Code, Postman, and Serverless Framework. You will apply the fundamentals of serverless technology from the ground up, and come away with a greater understanding of its power and how to make it work for you. This book teaches you how to quickly and securely develop applications without the hassle of configuring and maintaining infrastructure. You will learn how to harness serverless technology to rapidly reduce production time and minimize your costs, while still having the freedom to customize your code, without hindering functionality. Upon completion, you will have the knowledge and resources to build your own serverless application hosted in AWS ...
Learn the basics of serverless computing and how to develop event-driven architectures with the three major cloud platforms: Amazon Web Services, Microsoft Azure, and Google Cloud. This hands-on guide dives into the foundations of serverless computing, its use cases, and how to apply it using developer tools such as Node.js, Visual Studio Code, Postman, and Serverless Framework. You will apply the fundamentals of serverless technology from the ground up, and come away with a greater understanding of its power and how to make it work for you. This book teaches you how to quickly and securely develop applications without the hassle of configuring and maintaining infrastructure. You will learn how to harness serverless technology to rapidly reduce production time and minimize your costs, while still having the freedom to customize your code, without hindering functionality. Upon completion, you will have the knowledge and resources to build your own serverless application hosted in AWS ...
Web Applications on Azure
Build .NET apps on Microsoft Azure services that can grow to Internet scale. Learn how you can make smart application architecture decisions and follow best practices so that your website can handle tens of thousands of concurrent users and deliver your content globally. Author Rob Reagan takes you through key Azure technologies targeted toward building web applications, and along the way shares his lessons learned in scaling out a real-world web application. After an overview of web application building blocks, the book dives into relational and NoSQL data storage options on Azure, including Azure Table Storage and CosmosDB. You'll then discover how to make best use of Redis Cache, Web Jobs, Messaging Queues, and more, alongside other tips, tricks, and troubleshooting advice for when things go wrong. The book concludes with a thorough exploration of best practices for deployment at scale. Develop scalable architecture patterns on Azure with ASP.NET MVC; Understand the pros and c ...
Build .NET apps on Microsoft Azure services that can grow to Internet scale. Learn how you can make smart application architecture decisions and follow best practices so that your website can handle tens of thousands of concurrent users and deliver your content globally. Author Rob Reagan takes you through key Azure technologies targeted toward building web applications, and along the way shares his lessons learned in scaling out a real-world web application. After an overview of web application building blocks, the book dives into relational and NoSQL data storage options on Azure, including Azure Table Storage and CosmosDB. You'll then discover how to make best use of Redis Cache, Web Jobs, Messaging Queues, and more, alongside other tips, tricks, and troubleshooting advice for when things go wrong. The book concludes with a thorough exploration of best practices for deployment at scale. Develop scalable architecture patterns on Azure with ASP.NET MVC; Understand the pros and c ...
Quicken for Windows, Eighth Edition
Take control of your personal finances using the best practices and time-saving tips in Quicken 2018 for Windows The Official Guide! Find out the most effective methods for tracking your income, expenses, savings, transactions, investments, and so much more. Endorsed by the makers of Quicken, this practical resource shows you, step by step, how to take full advantage of the software's powerful features, including the Quicken mobile app. You'll also get professional advice to help you reduce debt, stay on budget, save money, invest wisely, and plan for a secure financial future. Customize Quicken for your preferences; Track income and expenses; Automate transactions and tasks; Record bank and credit card transactions; Use online banking features; Reconcile checking, savings, and credit card accounts; Track investments and optimize your portfolio; Monitor your assets, loans, and net worth; Evaluate your financial position; Reduce debt, save money, and plan for retirement; Simplify ...
Take control of your personal finances using the best practices and time-saving tips in Quicken 2018 for Windows The Official Guide! Find out the most effective methods for tracking your income, expenses, savings, transactions, investments, and so much more. Endorsed by the makers of Quicken, this practical resource shows you, step by step, how to take full advantage of the software's powerful features, including the Quicken mobile app. You'll also get professional advice to help you reduce debt, stay on budget, save money, invest wisely, and plan for a secure financial future. Customize Quicken for your preferences; Track income and expenses; Automate transactions and tasks; Record bank and credit card transactions; Use online banking features; Reconcile checking, savings, and credit card accounts; Track investments and optimize your portfolio; Monitor your assets, loans, and net worth; Evaluate your financial position; Reduce debt, save money, and plan for retirement; Simplify ...
Data Integration Life Cycle Management with SSIS
Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history. Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. Generate dozens of SSIS packages in minutes to speed your integration projects; Reduce the execution of related groups of SSIS packages to a single command; Successfully handle SSIS catalog deployments and their projects; Monitor the execut ...
Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history. Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices. Generate dozens of SSIS packages in minutes to speed your integration projects; Reduce the execution of related groups of SSIS packages to a single command; Successfully handle SSIS catalog deployments and their projects; Monitor the execut ...
The Definitive Guide to AdonisJs
Learn everything you need to master the AdonisJs framework, including topics such as interacting with a database, rendering templates, writing asynchronous code, and hosting sites with SSL. Along the way, you'll see how to build a commerce application, which lists products and allows shoppers to register and purchase those products. The site will feature a product catalog, a shopping cart, user registration and login, and profile management. The Definitive Guide to AdonisJs also covers how to create a front-end build chain, so that you can use a modern front-end framework, such as React. You'll discover how to connect your front end to the server, so that data and transactions can be shared between the two. Finally, you'll see how to secure and deploy the application to a virtual private server, including how to apply for and install an SSL certificate and start accepting payments. After reading and using this book, you'll know all you need about AdonisJs. You'll have the tools t ...
Learn everything you need to master the AdonisJs framework, including topics such as interacting with a database, rendering templates, writing asynchronous code, and hosting sites with SSL. Along the way, you'll see how to build a commerce application, which lists products and allows shoppers to register and purchase those products. The site will feature a product catalog, a shopping cart, user registration and login, and profile management. The Definitive Guide to AdonisJs also covers how to create a front-end build chain, so that you can use a modern front-end framework, such as React. You'll discover how to connect your front end to the server, so that data and transactions can be shared between the two. Finally, you'll see how to secure and deploy the application to a virtual private server, including how to apply for and install an SSL certificate and start accepting payments. After reading and using this book, you'll know all you need about AdonisJs. You'll have the tools t ...
Learn Salesforce Lightning
Refer to this invaluable how-to guide for basic training on Salesforce Lightning. Salespeople and technical users and consultants will no longer have to resort to learning the interface on their own, which is very time consuming. Learn Salesforce Lightning is a step-by-step visual guide that offers immediate and valuable solutions to the new set of UI tools included in Lightning. With chapters broken down into easily absorbed topics, you walk through the entire process of managing your daily activities within Salesforce, as well as basic customizations and system management. The book explains the primary use cases for Lighting, and simplifies some of the more complex features, such as opportunity stage management and the new dashboard builder. Topics covered include: Sales and service management; Lightning Apps on the AppExchange; Lightning dashboards and reports; Lightning security; Lightning Process Builder and more. ...
Refer to this invaluable how-to guide for basic training on Salesforce Lightning. Salespeople and technical users and consultants will no longer have to resort to learning the interface on their own, which is very time consuming. Learn Salesforce Lightning is a step-by-step visual guide that offers immediate and valuable solutions to the new set of UI tools included in Lightning. With chapters broken down into easily absorbed topics, you walk through the entire process of managing your daily activities within Salesforce, as well as basic customizations and system management. The book explains the primary use cases for Lighting, and simplifies some of the more complex features, such as opportunity stage management and the new dashboard builder. Topics covered include: Sales and service management; Lightning Apps on the AppExchange; Lightning dashboards and reports; Lightning security; Lightning Process Builder and more. ...
Oracle Incident Response and Forensics
Take the right steps when a breach of your Oracle Database environment becomes known or suspected. You will learn techniques for discerning how an attacker got in, what data they saw, and what else they might have done. This book helps you understand forensics in relation to Oracle Database, and the tools and techniques that should be used to investigate a database breach. You will learn the measures to put in place now to make it harder for an attack to be successful, and to aid in the detection and investigation of future attacks. You will know how to bring together tools and methods to create a holistic approach and investigation when an event occurs, helping you to be confident of your ability to react correctly and responsibly to threats against your organization's data. Detect when breaches have or may have occurred; React with confidence using an organized plan; Determine whether a suspected breach is real; Determine the scope of data that has been compromised; Preserve ev ...
Take the right steps when a breach of your Oracle Database environment becomes known or suspected. You will learn techniques for discerning how an attacker got in, what data they saw, and what else they might have done. This book helps you understand forensics in relation to Oracle Database, and the tools and techniques that should be used to investigate a database breach. You will learn the measures to put in place now to make it harder for an attack to be successful, and to aid in the detection and investigation of future attacks. You will know how to bring together tools and methods to create a holistic approach and investigation when an event occurs, helping you to be confident of your ability to react correctly and responsibly to threats against your organization's data. Detect when breaches have or may have occurred; React with confidence using an organized plan; Determine whether a suspected breach is real; Determine the scope of data that has been compromised; Preserve ev ...