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.

Go beyond the jigsaw approach of just using blocks of code you don't understand and become a programmer who really understands how your code works. Starting with the fundamentals on C programming, this book walks you through where the C language fits with microcontrollers. Next, you'll see how to use the industrial IDE, create and simulate a project, and download your program to an actual PIC microcontroller. You'll then advance into the main process of a C program and explore in depth the most common commands applied to a PIC microcontroller and see how to use the range of control registers inside the PIC. With C Programming for the PIC Microcontroller as your guide, you'll become a better programmer who can truly say they have written and understand the code they use. What You'll Learn Use the freely available MPLAX software Build a project and write a program using inputs from switches Create a variable delay with the oscillator source Measure real-world signals using pressure, temperature, and speed inputs Incorporate LCD screens into your projects Apply what you've learned into a simple embedded program Who This Book Is For Hobbyists who want to move into the challenging world of embedded programming or students on an engineering course.

Develop native applications for multiple mobile and desktop platforms including but not limited to iOS, Android, and UWP with the Xamarin framework and Xamarin.Forms Key Features Understand .NET Core and its cross-platform development philosophy Build Android, iOS, and Windows mobile applications with C#, .NET Core, and Azure Cloud Services Bring Artificial Intelligence capabilities into your mobile applications with Azure AI Book Description.NET Core is the general umbrella term used for Microsoft's cross-platform toolset. Xamarin used for developing mobile applications, is one of the app model implementations for .NET Core infrastructure. In this book, you will learn how to design, architect, and develop highly attractive, maintainable, efficient, and robust mobile applications for multiple platforms, including iOS, Android, and UWP, with the toolset provided by Microsoft using Xamarin, .NET Core, and Azure Cloud Services. This book will take you through various phases of application development with Xamarin, from environment setup, design, and architecture to publishing, using real-world scenarios. Throughout the book, you will learn how to develop mobile apps using Xamarin, Xamarin.Forms and .NET Standard; implement a webbased backend composed of microservices with .NET Core using various Azure services including but not limited to Azure App Services, Azure Active Directory, Notification Hub, Logic Apps, and Azure Functions, Cognitive Services; create data stores using popular database technologies such as Cosmos DB, SQL and Realm. Towards the end, the book will help developers to set up an efficient and maintainable development pipeline to manage the application life cycle using Visual Studio App Center and Visual Studio Services. What you will learn Implement native applications for multiple mobile and desktop platforms Understand and use various Azure Services with .NET Core Make use of architectural patterns designed for mobile and web applications Understand the basic Cosmos DB concepts Understand how different app models can be used to create an app service Explore the Xamarin and Xamarin.Forms UI suite with .NET Core for building mobile applications Who this book is forThis book is for mobile developers who wish to develop cross-platform mobile applications. Programming experience with C# is required. Some knowledge and understanding of core elements and cross-platform application development with .NET is required.

Use Qt 5 to design and build functional, appealing, and user-friendly graphical user interfaces (GUIs) for your applications. Key Features Learn to use Qt 5 to design and customize the look and feel of your application Improve the visual quality of an application by using graphics rendering and animation Understand the balance of presentation and web content that will make an application appealing yet functional Book DescriptionWith the growing need to develop GUIs for multiple targets and multiple screens, improving the visual quality of your application becomes important so that it stands out from your competitors. With its cross-platform ability and the latest UI paradigms, Qt makes it possible to build intuitive, interactive, and user-friendly user interfaces for your applications. Qt5 C++ GUI Programming Cookbook, Second Edition teaches you how to develop functional and appealing user interfaces using the latest version of QT5 and C++. This book will help you learn a variety of topics such as GUI customization and animation, graphics rendering, implementing Google Maps, and more. You will also be taken through advanced concepts like asynchronous programming, event handling using signals and slots, network programming, various aspects of optimizing your application. By the end of the book, you will be confident to design and customize GUI applications that meet your clients' expectations and have an understanding of best practice solutions for common problems. What you will learn Animate GUI elements using Qt5's built-in animation system Draw shapes and 2D images using Qt5's powerful rendering system Implement an industry-standard OpenGL library in your project Build a mobile app that supports touch events and exports it onto devices Parse and extract data from an XML file and present it on your GUI Interact with web content by calling JavaScript functions from C++ Access MySQL and SQLite databases to retrieve data and display it on your GUI Who this book is forThis intermediate-level book is designed for those who want to develop software using Qt 5. If you want to improve the visual quality and content presentation of your software application, this book is for you. Prior experience of C++ programming is required.

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.

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.

Use Ansible to configure your systems, deploy software, and orchestrate advanced IT tasks Key Features Get familiar with the fundamentals of Ansible 2.7 Understand how to use Ansible Tower to scale your IT automation Gain insights into how to develop and test Ansible playbooks Book DescriptionAnsible is an open source automation platform that assists organizations with tasks such as application deployment, orchestration, and task automation. With the release of Ansible 2.7, even complex tasks can be handled much more easily than before. Learning Ansible 2.7 will help you take your first steps toward understanding the fundamentals and practical aspects of Ansible by introducing you to topics such as playbooks, modules, and the installation of Linux, Berkeley Software Distribution (BSD), and Windows support. In addition to this, you will focus on various testing strategies, deployment, and orchestration to build on your knowledge. The book will then help you get accustomed to features including cleaner architecture, task blocks, and playbook parsing, which can help you to streamline automation processes. Next, you will learn how to integrate Ansible with cloud platforms such as Amazon Web Services (AWS) before gaining insights into the enterprise versions of Ansible, Ansible Tower and Ansible Galaxy. This will help you to use Ansible to interact with different operating systems and improve your working efficiency. By the end of this book, you will be equipped with the Ansible skills you need to automate complex tasks for your organization. What you will learn Create a web server using Ansible Write a custom module and test it Deploy playbooks in the production environment Troubleshoot networks using Ansible Use Ansible Galaxy and Ansible Tower during deployment Deploy an application with Ansible on AWS, Azure and DigitalOcean Who this book is forThis beginner-level book is for system administrators who want to automate their organization's infrastructure using Ansible 2.7. No prior knowledge of Ansible is required

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.