Dynamic SQL
This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It's also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice ...
This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It's also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice ...
Digital Video Editing Fundamentals
This compact visual guide covers concepts central to digital video using the affordable Corel Video Studio Ultimate X9 software package as well as open source digital video editing package Editshare Lightworks 12. Digital Video Editing Fundamentals builds on the essential concepts of digital imaging, audio, illustration, and painting, and gets more advanced as chapters progress, covering what digital video new media formats are best for use with Android Studio, Java and JavaFX, iOS and HTML5. Furthermore, the author covers the key factors regarding the data footprint optimization work process, streaming versus captive assets, and why these are important. ...
This compact visual guide covers concepts central to digital video using the affordable Corel Video Studio Ultimate X9 software package as well as open source digital video editing package Editshare Lightworks 12. Digital Video Editing Fundamentals builds on the essential concepts of digital imaging, audio, illustration, and painting, and gets more advanced as chapters progress, covering what digital video new media formats are best for use with Android Studio, Java and JavaFX, iOS and HTML5. Furthermore, the author covers the key factors regarding the data footprint optimization work process, streaming versus captive assets, and why these are important. ...
Building Arduino Projects for the Internet of Things
This is a book about building Arduino-powered devices for everyday use, and then connecting those devices to the Internet. If you're one of the many who have decided to build your own Arduino-powered devices for IoT applications, you've probably wished you could find a single resource - a guidebook for the eager-to-learn Arduino enthusiast - that teaches logically, methodically, and practically how the Arduino works and what you can build with it. Building Arduino Projects for the Internet of Things: Experiments with Real-World Applications is exactly what you need. Written by a software developer and solution architect who got tired of hunting and gathering various lessons for Arduino development as he taught himself all about the topic, this book gives you an incredibly strong foundation of Arduino-based device development, from which you can go in any direction according to your specific development needs and desires. Readers are introduced to the building blocks of IoT, and t ...
This is a book about building Arduino-powered devices for everyday use, and then connecting those devices to the Internet. If you're one of the many who have decided to build your own Arduino-powered devices for IoT applications, you've probably wished you could find a single resource - a guidebook for the eager-to-learn Arduino enthusiast - that teaches logically, methodically, and practically how the Arduino works and what you can build with it. Building Arduino Projects for the Internet of Things: Experiments with Real-World Applications is exactly what you need. Written by a software developer and solution architect who got tired of hunting and gathering various lessons for Arduino development as he taught himself all about the topic, this book gives you an incredibly strong foundation of Arduino-based device development, from which you can go in any direction according to your specific development needs and desires. Readers are introduced to the building blocks of IoT, and t ...
Beginning SQL Queries, 2nd Edition
Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well. ...
Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporting on large data sets in order to generate knowledge to drive business decisions. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Every relational database supports SQL for its expressiveness in writing queries underlying reports and business intelligence dashboards. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare Churcher's book, Beginning SQL Queries, 2nd Edition, lays well. ...
Apple Watch App Development
Wearable are the next wave of mobile technology and with the release of Apple's WatchKit SDK, a whole new world of exciting development possibilities has opened up. Apple Watch App Development introduces you to the architecture and possibilities of the Apple Watch platform, as well as an in-depth look at how to work with Xcode playgrounds. Benefit from a rapid introduction to the Swift programming language so you can quickly begin developing apps with the WatchKit framework and the Xcode Development IDE. Get to grips with advanced topics such as notifications, glances, iCloud, Apple pay, closures, tuples, protocols, delegates, concurrency, and using Swift Playgrounds, with each concept is backed up with example code that demonstrates how to properly execute it. Finally, discover how to package and deploy your Watch application to the Apple AppStore. By the end of this book, you will have a good understanding of how to develop apps for the Apple Watch platform, and synchronize dat ...
Wearable are the next wave of mobile technology and with the release of Apple's WatchKit SDK, a whole new world of exciting development possibilities has opened up. Apple Watch App Development introduces you to the architecture and possibilities of the Apple Watch platform, as well as an in-depth look at how to work with Xcode playgrounds. Benefit from a rapid introduction to the Swift programming language so you can quickly begin developing apps with the WatchKit framework and the Xcode Development IDE. Get to grips with advanced topics such as notifications, glances, iCloud, Apple pay, closures, tuples, protocols, delegates, concurrency, and using Swift Playgrounds, with each concept is backed up with example code that demonstrates how to properly execute it. Finally, discover how to package and deploy your Watch application to the Apple AppStore. By the end of this book, you will have a good understanding of how to develop apps for the Apple Watch platform, and synchronize dat ...
Getting Started with SQL
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs. ...
Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you're a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases. Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you'll also discover how to efficiently design and manage databases to meet your needs. ...
Java XML and JSON
This is your one-stop guide to mastering the XML metalanguage and JSON data format along with significant Java APIs for parsing and creating XML/JSON documents (and more). The first six chapters focus on XML along with the SAX, DOM, StAX, XPath, and XSLT APIs. The remaining four chapters focus on JSON along with the mJson, GSON, and JsonPath APIs. Each chapter in Java XML and JSON ends with select exercises designed to challenge your grasp of the chapter's content. An appendix provides the answers to these exercises. ...
This is your one-stop guide to mastering the XML metalanguage and JSON data format along with significant Java APIs for parsing and creating XML/JSON documents (and more). The first six chapters focus on XML along with the SAX, DOM, StAX, XPath, and XSLT APIs. The remaining four chapters focus on JSON along with the mJson, GSON, and JsonPath APIs. Each chapter in Java XML and JSON ends with select exercises designed to challenge your grasp of the chapter's content. An appendix provides the answers to these exercises. ...
JSON Quick Syntax Reference
This compact quick scripting syntax reference on JSON covers syntax and parameters central to JSON object definitions, using the NetBeans 8.1 open source and Eclipse IDE software tool packages. JSON Quick Syntax Reference covers the syntax used in the JSON object definition language, logically organized by topical chapters, and getting more advanced as chapters progress, covering structures and file formats which are best for use with HTML5. Furthermore, this book includes the key factors regarding the data footprint optimization work process, the in-lining of .CSS and .JS files, and why a data footprint optimization work process is important. ...
This compact quick scripting syntax reference on JSON covers syntax and parameters central to JSON object definitions, using the NetBeans 8.1 open source and Eclipse IDE software tool packages. JSON Quick Syntax Reference covers the syntax used in the JSON object definition language, logically organized by topical chapters, and getting more advanced as chapters progress, covering structures and file formats which are best for use with HTML5. Furthermore, this book includes the key factors regarding the data footprint optimization work process, the in-lining of .CSS and .JS files, and why a data footprint optimization work process is important. ...
Mastering PhoneGap Mobile Application Development
PhoneGap is a useful and flexible tool that enables you to create complex hybrid applications for mobile platforms. In addition to the core technology, there is a large and vibrant community that creates third-party plugins that can take your app to the next level. This book will guide you through the process of creating a complex data-driven hybrid mobile application using PhoneGap, web technologies, and third-party plugins. A good foundation is critical, so you will learn how to create a useful workflow to make development easier. From there, the next version of JavaScript (ES6) and the CSS pre-processor SASS are introduced as a way to simplify creating the look of the mobile application. Responsive design techniques are also covered, including the flexbox layout module. As many apps are data-driven, you'll build an application throughout the course of the book that relies upon IndexedDB and SQLite. You'll also download additional content and address how to handle in-app purcha ...
PhoneGap is a useful and flexible tool that enables you to create complex hybrid applications for mobile platforms. In addition to the core technology, there is a large and vibrant community that creates third-party plugins that can take your app to the next level. This book will guide you through the process of creating a complex data-driven hybrid mobile application using PhoneGap, web technologies, and third-party plugins. A good foundation is critical, so you will learn how to create a useful workflow to make development easier. From there, the next version of JavaScript (ES6) and the CSS pre-processor SASS are introduced as a way to simplify creating the look of the mobile application. Responsive design techniques are also covered, including the flexbox layout module. As many apps are data-driven, you'll build an application throughout the course of the book that relies upon IndexedDB and SQLite. You'll also download additional content and address how to handle in-app purcha ...
OS X App Development with CloudKit and Swift
This book is your step-by-step guide to learning OS X app development using CloudKit and Swift. All the development will be done using Apple's Swift 2 programming language. You'll see how to define data for your app and build a prototype with Sketch 3 and Keynote. Using CloudKit to store OS X application data, and separate public and private data, readers will learn how to control which data can or cannot be changed in a public data store. OS X App Development with CloudKit and Swift takes you from prototyping your app with Sketch 3 all the way through building a data-driven app using CloudKit, and everything in between. ...
This book is your step-by-step guide to learning OS X app development using CloudKit and Swift. All the development will be done using Apple's Swift 2 programming language. You'll see how to define data for your app and build a prototype with Sketch 3 and Keynote. Using CloudKit to store OS X application data, and separate public and private data, readers will learn how to control which data can or cannot be changed in a public data store. OS X App Development with CloudKit and Swift takes you from prototyping your app with Sketch 3 all the way through building a data-driven app using CloudKit, and everything in between. ...