Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease Key Features Work with temporal tables to access information stored in a table at any time Get familiar with the latest features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality Book DescriptionMicrosoft SQL Server 2017 uses the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By learning how to use the features of SQL Server 2017 effectively, you can build scalable apps and easily perform data integration and transformation. You'll start by brushing up on the features of SQL Server 2017. This Learning Path will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You'll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. Toward the concluding chapters, you'll discover how to develop SSIS packages designed to maintain a data warehouse using the data flow and other control flow tasks. By the end of this Learning Path, you'll be equipped with the skills you need to design efficient, high-performance database applications with confidence. This Learning Path includes content from the following Packt books: SQL Server 2017 Developer's Guide by Milos Radivojevic, Dejan Sarka, et. al SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, et. al What you will learn Use columnstore indexes to make storage and performance improvements Extend database design solutions using temporal tables Exchange JSON data between applications and SQL Server Migrate historical data to Microsoft Azure by using Stretch Database Design the architecture of a modern Extract, Transform, and Load (ETL) solution Implement ETL solutions using Integration Services for both on-premise and Azure data Who this book is forThis Learning Path is for database developers and solution architects looking to develop ETL solutions with SSIS, and explore the new features in SSIS 2017. Advanced analysis practitioners, business intelligence developers, and database consultants dealing with performance tuning will also find this book useful. Basic understanding of database concepts and T-SQL is required to get the best out of this Learning Path.

Build, deploy, test, and run cloud-native serverless applications using AWS Lambda and other popular AWS services Key Features Learn how to write, run, and deploy serverless applications in Amazon Web Services Make the most of AWS Lambda functions to build scalable and cost-efficient systems Build and deploy serverless applications with Amazon API Gateway and AWS Lambda functions Book DescriptionServerless computing is a way to run your code without having to provision or manage servers. Amazon Web Services provides serverless services that you can use to build and deploy cloud-native applications. Starting with the basics of AWS Lambda, this book takes you through combining Lambda with other services from AWS, such as Amazon API Gateway, Amazon DynamoDB, and Amazon Step Functions. You'll learn how to write, run, and test Lambda functions using examples in Node.js, Java, Python, and C# before you move on to developing and deploying serverless APIs efficiently using the Serverless Framework. In the concluding chapters, you'll discover tips and best practices for leveraging Serverless Framework to increase your development productivity. By the end of this book, you'll have become well-versed in building, securing, and running serverless applications using Amazon API Gateway and AWS Lambda without having to manage any servers. What you will learn Understand the core concepts of serverless computing in AWS Create your own AWS Lambda functions and build serverless APIs using Amazon API Gateway Explore best practices for developing serverless applications at scale using Serverless Framework Discover the DevOps patterns in a modern CI/CD pipeline with AWS CodePipeline Build serverless data processing jobs to extract, transform, and load data Enforce resource tagging policies with continuous compliance and AWS Config Create chatbots with natural language understanding to perform automated tasks Who this book is forThis AWS book is for cloud architects and developers who want to build and deploy serverless applications using AWS Lambda. A basic understanding of AWS is required to get the most out of this book.

Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key Features Understand the features and syntax of SQL and use them to query databases Learn how to create databases and tables and manipulate the data within them Create advanced queries and apply them on realistic databases with hands-on activities Book DescriptionMany software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully. This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe. Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world. By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL. What you will learn Create databases and insert data into them Use SQL queries to create, read, update, and delete data Maintain data integrity and consistency through normalization Customize your basic SQL queries to get the desired output Refine your database search using the WHERE and HAVING clauses Use joins to fetch data from multiple tables and create custom reports Improve web application performance by automating processes Secure a database with GRANT and REVOKE privileges Who this book is forThis Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.

The Raspberry Pi is about as minimalist as a computer gets, but it has the power to run a full Linux operating system and many great desktop and command line tools as well. Can you push it to operate at the level of a $2,000 computer? This book is here to help you find out. The primary focus of this book is getting as much as possible done with a simple Pi through non-graphic, non-mouse means. This means the keyboard and the text-mode screen. On the desktop side, you'll look at many of the most powerful GUI apps available, as these offer an easy entry to get started as you learn the command line. You'll begin by setting up and configuring a Raspberry Pi with the option to run it as a graphical desktop environment or even more economically boot straight to the command line. If you want more performance, more efficiency, and (arguably) less complexity from your Pi that can only be found through the keyboard and command line. You'll also set up and configure a Raspberry Pi to use command line tools from within either the Raspberry Pi terminal, or by logging in remotely through some other computer. Once in, you'll look at Package Managers, Tmux, Ranger, and Midnight Commander as general-purpose power tools. The book then gets into specific task-oriented tools for reading email, spreadsheet work, notes, security, web browsing and design, social media, task and video password management, coding, and much more. There are conceptual overviews of Markdown, LaTeX, and Vim for work. What You'll Learn Set up a Raspberry Pi system to get real work done using only the command line Login to a Pi remotely to use it as a remote server Integrate desktop Linux with command line mastery to optimize a Pi Work with tools for audio, writing news and weather, books, and graphics. Who This Book Is For Those with minimal technical skills or hobbyists who are interested in "retro computing" or "minimalist" approaches.

Learn development skills and improve productivity when programming in Microsoft Dynamics NAV 2018 - the popular Enterprise Resourse Planning management system used across a variety of industries for business process management Key Features Solve common business problems with the valuable features and flexibility of Dynamics NAV Understand the structure of NAV database - how documents and business entities are mapped to DB tables Design user interface and bind the presentation layer with the data storage Book DescriptionMicrosoft Dynamics NAV is an enterprise resource planning (ERP) software suite for organizations. The system offers specialized functionality for manufacturing, distribution, government, retail, and other industries. This book gets you started with its integrated development environment for solving problems by customizing business processes. This book introduces the NAV development environment - C/SIDE. It gives an overview of the internal system language and the most essential development tools. The book will enable the reader to customize and extend NAV functionality with C/AL code, design a user interface through pages, create role centers, and build advanced reports in Microsoft Visual Studio. By the end of the book, you will have learned how to extend the NAV data model, how to write and debug custom code, and how to exchange data with external applications. What you will learn Manage NAV Server configuration with Microsoft Management Console Manage NAV installation with the NAV Administration Shell Create integration events and extend functionality via the NAV event model Run XML Ports from C/AL code Design reports and write client code in RDLC expressions Who this book is forThis book is for experienced NAV users who have an understanding of basic programming concepts. Familiarity with NAV development environment or its internal development language-C/AL is not expected.

Integrate an end-to-end logistic chain using IBM Blockchain and IoT platforms Key Features Explore practical implementation of ledger technology in the IoT architecture Study security best practices for your smart devices Understand Blockchain implementation for end-to-end IoT solutions Book DescriptionBlockchain has been the hot topic of late thanks to cryptocurrencies. To make matters more interesting, the financial market is looking for ways to reduce operational costs and generate new business models, and this is where blockchain solutions come into the picture. In addition to this, with Internet of Things (IoT) trending and Arduino, Raspberry Pi, and other devices flooding the market, you can now create cheap devices even at home. Hands-On IoT Solutions with Blockchain starts with an overview of IoT concepts in the current business scenario. It then helps you develop your own device on the IBM Watson IoT platform and create your fi rst IoT solution using Watson and Intel Edison.Once you are familiar with IoT, you will learn about Blockchain technology and its use cases. You will also work with the Hyperledger framework and develop your own Blockchain network. As you progress through the chapters, you'll work with problem statements and learn how to design your solution architecture so that you can create your own integrated Blockchain and IoT solution. The next set of chapters will explain how to implement end-to-end Blockchain solutions with IoT using the IBM Cloud platform. By the end of this book, you will have mastered the convergence of IoT and Blockchain technology and exploited the best practices and drivers to develop a bulletproof integrated solution. What you will learn Understand the key roles of IoT in the current market Study the different aspects of IBM Watson IoT platform Create devices, gateways, and applications connected to the platform Explore the fundamentals of Blockchain Define good use cases for Blockchain Discover the Hyperledger Fabric and Composer frameworks Develop an IBM Watson IoT application using a Intel Edison Integrate IoT with the Blockchain platform Who this book is forHands-On IoT Solutions with Blockchain is for you if you are an Internet of Things (IoT) analyst, architect, engineer, or any stakeholder responsible for security mechanisms on an IoT infrastructure. This book is also for IT professionals who want to start developing solutions using Blockchain and IoT on the IBM Cloud platform. Basic understanding of IoT will assist you in understanding key concepts covered in the book.

Grasp advanced PowerShell Core 6.0 functionalities to automate your environment Key Features Keep up with changes introduced in PowerShell Core 6.0 Easily maintain appropriate compatibility with older versions Automate complex tasks, manipulate data, and secure your environment with PowerShell Core 6.0 Book DescriptionPowerShell scripts offer a handy way to automate various chores, however working effectively with these scripts can be a difficult task. This comprehensive guide starts with the fundamentals before moving on to advanced-level topics to help you become a PowerShell Core 6.0 expert. The first module, PowerShell Core 6.0 Fundamentals, begins with the new features of PowerShell Core 6.0, installing it on Linux, and working with parameters, objects and .NET classes from within PowerShell Core 6.0. As you make your way through the chapters, you'll see how to efficiently manage large amounts of data and interact with other services using PowerShell Core 6.0. You'll be able to make the most of PowerShell Core 6.0's powerful automation feature, where you will have different methods available to parse data and manipulate regular expressions and Windows Management Instrumentation (WMI). After having explored automation, you will enter the extending PowerShell Core 6.0 module, covering asynchronous processing and desired state configuration. In the last module, you will learn to extend PowerShell Core 6.0 using advanced scripts and filters, and also debug issues along with working on error handling techniques. By the end of this book, you will be an expert in scripting with PowerShell Core 6.0. What you will learn Optimize code through the use of functions, switches, and looping structures Work with objects and operators to test and manipulate data Parse and manipulate different data types Create scripts and functions using PowerShell Use jobs, events, and popular public modules which assist with implementing multithreading Write .NET classes with ease within the PowerShell Create and implement regular expressions in PowerShell scripts Make use of advanced techniques to define and restrict the behavior of parameters Who this book is forIf you are a system administrator who wants to become an expert in controlling and automating your Windows environment, then Mastering Windows PowerShell Scripting is for you. It is also ideal for those new to the PowerShell language.