The MySQL Workshop. A practical guide to working with data and managing databases with MySQL

Thomas Pettit, Scott Cosentino

Do you want to learn how to create and maintain databases effectively? Are you looking for simple answers to basic MySQL questions as well as straightforward examples that you can use at work? If so, this workshop is the right choice for you.Designed to build your confidence through hands-on practice, this book uses a simple approach that focuses on the practical, so you can get straight down to business without having to wade through pages and pages of dull, dry theory.As you work through bite-sized exercises and activities, you'll learn how to use different MySQL tools to create a database and manage the data within it. You'll see how to transfer data between a MySQL database and other sources, and use real-world datasets to gain valuable experience of manipulating and gaining insights from data. As you progress, you'll discover how to protect your database by managing user permissions and performing logical backups and restores.If you've already tried to teach yourself SQL, but haven't been able to make the leap from understanding simple queries to working on live projects with a real database management system, The MySQL Workshop will get you on the right track.By the end of this MySQL book, you'll have the knowledge, skills, and confidence to advance your career and tackle your own ambitious projects with MySQL.

Full-Stack React, TypeScript, and Node. Build cloud-ready web applications using React 17 with Hooks and GraphQL

David Choi

React sets the standard for building high-performance client-side web apps. Node.js is a scalable application server that is used in thousands of websites, while GraphQL is becoming the standard way for large websites to provide data and services to their users. Together, these technologies, when reinforced with the capabilities of TypeScript, provide a cutting-edge stack for complete web application development.This book takes a hands-on approach to implementing modern web technologies and the associated methodologies for building full-stack apps. You’ll begin by gaining a strong understanding of TypeScript and how to use it to build high-quality web apps. The chapters that follow delve into client-side development with React using the new Hooks API and Redux. Next, you’ll get to grips with server-side development with Express, including authentication with Redis-based sessions and accessing databases with TypeORM. The book will then show you how to use Apollo GraphQL to build web services for your full-stack app. Later, you’ll learn how to build GraphQL schemas and integrate them with React using Hooks. Finally, you’ll focus on how to deploy your application onto an NGINX server using the AWS cloud.By the end of this book, you’ll be able to build and deploy complete high-performance web applications using React, Node, and GraphQL.

Learning Azure DocumentDB. Create outstanding enterprise solutions around DocumentDB using the latest technologies and programming tools with Azure

Riccardo Becker

Learning DocumentDB adopts a practical, step-by-step approach to help you learn the basics of DocumentDB and use your new-found abilities in real-life scenarios and enterprise solutions.We start with the absolute basics, such as setting up a DocumentDB environment, and guide you through managing your databases, and executing simple and complex queries. Next, we explain how to work with DocumentDB using the open REST protocol, and demonstrate how JavaScript works with DocumentDB. We’ll also show you how to authenticate and execute queries. Moving on, you’ll find out how to use DocumentDB from within Node.js to kick-start your Node.js projects. Next, you’ll discover how to increase the performance of your DocumentDB database and fine-tune it. Finally, you’ll get to grips with using DocumentDB in conjunction with other services offered from the Microsoft Azure platform.

Android Studio Arctic Fox Essentials - Kotlin Edition. Develop Android apps with Android Studio Arctic Fox in Kotlin

Neil Smyth

Android Studio is an Integrated Development Environment based on the JetBrains IntelliJ IDEA. It offers developers a unique platform to design and develop Android apps using various developer tools. Fully updated for Android Studio Arctic Fox, the goal of this book is to teach the skills necessary to develop Android-based applications using the Kotlin programming language.This book begins with an outline of the steps necessary to set up an Android development and testing environment, followed by an introduction to programming in Kotlin which includes data types, control flow, functions, lambdas, and object-oriented programming. An overview of Android Studio covers areas such as tool windows, the code editor, and the layout editor tool. An introduction to the architecture of Android is followed by an in-depth look at the design of Android applications and user interfaces using the Android Studio environment.Early chapters detail Android architecture components such as view models, lifecycle management, Room database access, the Database Inspector, app navigation, live data, and data binding. More advanced topics such as intents are also covered, as are touch screen handling, gesture recognition, and the recording and playback of audio. This edition of the book also covers printing, transitions, cloud-based file storage, and foldable device support.The concepts of material design are also discussed in detail, including the use of floating action buttons, Snackbars, tabbed interfaces, card views, navigation drawers, and collapsing toolbars. Other key features of Android Studio Arctic Fox and Android taught in this book include the Layout Editor, the ConstraintLayout and ConstraintSet classes, MotionLayout Editor, view binding, constraint chains, barriers, and direct reply to notifications. Chapters also explore more advanced features of Android Studio such as app links, dynamic delivery, Gradle build configuration, and submitting apps to the Google Play developer console.

OpenCV: Computer Vision Projects with Python. Develop computer vision applications with OpenCV

Michael Beyeler, Prateek Joshi, Joseph Howse

OpenCV is a state-of-art computer vision library that allows a great variety of image and video processing operations. OpenCV for Python enables us to run computer vision algorithms in real time.This learning path proposes to teach the following topics. First, we will learn how to get started with OpenCV and OpenCV3’s Python API, and develop a computer vision application that tracks body parts. Then, we will build amazing intermediate-level computer vision applications such as making an object disappear from an image, identifying different shapes, reconstructing a 3D map from images , and building an augmented reality application, Finally, we’ll move to more advanced projects such as hand gesture recognition, tracking visually salient objects, as well as recognizing traffic signs and emotions on faces using support vector machines and multi-layer perceptrons respectively. This Learning Path combines some of the best that Packt has to offer in one complete, curated package. It includes content from the following Packt products:• OpenCV Computer Vision with Python by Joseph Howse • OpenCV with Python By Example by Prateek Joshi• OpenCV with Python Blueprints by Michael Beyeler

WordPress MU 2.8: Beginner's Guide. Build your own blog network with unlimited users and blogs, forums, photo galleries, and more!

Lesley Harrison, Lesley A Harrison, Matt Mullenweg

WordPress MU enables you to build a complete, professional blog network. Each user gets their own blog, and can choose their favorite templates and plug-ins, and develop their own content. WordPress MU powers some of the largest blog networks in the world, including the mighty WordPress.com ñ home to thousands of bloggers.This book will take you through the setup of a WordPress MU-powered blogging network, using a real, working blog network as an example, so that you can follow the creation process step-by-step. Your blogging network will be complete with professional features such as friends lists, status feeds, groups, forums, photo galleries, and more, to build your own WordPress.com ñ a place where users can quickly come and create a blog for themselves.The book starts with a clean install of WordPress MU, and as you work through the book, you will build the blog network, and add on more and more features, all seamlessly integrated to achieve a professional, custom-built look.You will find new themes and plug-ins added to the site, as well as customization of the WordPress multi-user code. The book will also look at ways you can manage your community, and keep your site safe and secure, ensuring that it is a spam-free, enjoyable community for your users. In the later chapters, you will add a forum using the bbPress script, and add BuddyPress social networking components to your site.Imagine how good you'll feel when your first WordPress multi-user blog network launches.

Ruby on Rails Web Mashup Projects. A step-by-step tutorial to building web mashups

Chang Sau Sheong, David Heinemeier Hansson

Learning Node.js for .NET Developers. Build server side applications with Node.js

Mark Vasilkov, Harry Cummings

Node.js is an open source, cross-platform runtime environment that allows you to use JavaScript to develop server-side web applications.This short guide will help you develop applications using JavaScript and Node.js, leverage your existing programming skills from .NET or Java, and make the most of these other platforms through understanding the Node.js programming model. You will learn how to build web applications and APIs in Node, discover packages in the Node.js ecosystem, test and deploy your Node.js code, and more. Finally, you will discover how to integrate Node.js and .NET code.

Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and

Satya Shyam K Jayanty

Learning Reactive Programming with Java 8. Learn how to use RxJava and its reactive Observables to build fast, concurrent, and powerful applications through detailed examples

Nickolay Tzvetinov

Keycloak - Identity and Access Management for Modern Applications. Harness the power of Keycloak, OpenID Connect, and OAuth 2.0 to secure applications - Second Edition

Stian Thorgersen, Pedro Igor Silva

The 2nd Edition of Keycloak - Identity and Access Management for Modern Applications is an updated, comprehensive introduction to Keycloak and its updates.In this new edition, you will learn how to use the latest distribution of Keycloak. The recent versions of Keycloak are now based on Quarkus, which brings a new and improved user experience and a new admin console with a higher focus on usability. You will see how to leverage Spring Security, instead of the Keycloak Spring adapter, while using the latest distribution of Keycloak. As you progress, you will understand the new Keycloak distribution and explore best practices in using OAuth. Finally, you'll cover general best practices and other information on how to protect your applications.By the end of this new edition, you will have learned how to install and manage the latest version of Keycloak to secure new and existing applications using the newest features.

Learning Network Programming with Java. Harness the hidden power of Java to build network-enabled applications with lower network traffic and faster processes

Richard M. Reese

Network-aware applications are becoming more prevalent and play an ever-increasing role in the world today. Connecting and using an Internet-based service is a frequent requirement for many applications. Java provides numerous classes that have evolved over the years to meet evolving network needs. These range from low-level socket and IP-based approaches to those encapsulated in software services.This book explores how Java supports networks, starting with the basics and then advancing to more complex topics. An overview of each relevant network technology is presented followed by detailed examples of how to use Java to support these technologies. We start with the basics of networking and then explore how Java supports the development of client/server and peer-to-peer applications. The NIO packages are examined as well as multitasking and how network applications can address practical issues such as security.A discussion on networking concepts will put many network issues into perspective and let you focus on the appropriate technology for the problem at hand. The examples used will provide a good starting point to develop similar capabilities for many of your network needs

Azure Strategy and Implementation Guide. Up-to-date information for organizations new to Azure - Third Edition

Peter De Tender, Greg Leonardo, Jason Milgram

Microsoft Azure is a powerful cloud computing platform that offers a multitude of services and capabilities for organizations of any size moving to a cloud strategy.Azure Strategy and Implementation Guide Third Edition encapsulates the entire spectrum of measures involved in Azure deployment that includes understanding Azure fundamentals, choosing a suitable cloud architecture, building on design principles, becoming familiar with Azure DevOps, and learning best practices for optimization and management.The book begins by introducing you to the Azure cloud platform and demonstrating the substantial scope of digital transformation and innovation that can be achieved by leveraging Azure’s capabilities. The guide further acquaints you with practical insights on application modernization, Azure Infrastructure as a Service (IaaS) deployment, infrastructure management, key application architectures, best practices of Azure DevOps, and Azure automation.By the end of this book, you will be proficient in driving Azure operations right from the planning and cloud migration stage to cost management and troubleshooting.

OpenJDK Cookbook. Over 80 recipes to build and extend your very own version of Java platform using OpenJDK project

Alex Kasko, Alexey Kashchenko, Alexey Mironchenko, Stanislav Kobylyanskiy

Hands-On Full Stack Development with Spring Boot 2 and React. Build modern and scalable full stack applications using Spring Framework 5 and React with Hooks - Second Edition

Juha Hinkula

React Hooks have changed the way React components are coded. They enable you to write components in a more intuitive way without using classes, which makes your code easier to read and maintain. Building on from the previous edition, this book is updated with React Hooks and the latest changes introduced in create-react-app and Spring Boot 2.1.This book starts with a brief introduction to Spring Boot. You’ll understand how to use dependency injection and work with the data access layer of Spring using Hibernate as the ORM tool. You’ll then learn how to build your own RESTful API endpoints for web applications. As you advance, the book introduces you to other Spring components, such as Spring Security to help you secure the backend. Moving on, you’ll explore React and its app development environment and components for building your frontend. Finally, you’ll create a Docker container for your application by implementing the best practices that underpin professional full stack web development.By the end of this book, you’ll be equipped with all the knowledge you need to build modern full stack applications with Spring Boot for the backend and React for the frontend.

React Projects. Build advanced cross-platform projects with React and React Native to become a professional developer - Second Edition

Roy Derks

Developed by Facebook, React is a popular library for building impressive user interfaces. React extends its capabilities to mobile platforms using the React Native framework and integrates with popular web and mobile tools to build scalable applications.React Projects is your guide to learning React development by using modern development patterns and integrating React with powerful web tools, such as GraphQL, Expo, and React 360. You'll start building a real-world project right from the first chapter and get hands-on with developing scalable applications as you advance to building more complex projects. Throughout the book, you'll use the latest versions of React and React Native to explore features such as routing, Context, and Hooks on multiple platforms, which will help you build full-stack web and mobile applications efficiently. Finally, you'll get to grips with unit testing with Jest and end-to-end testing with Cypress to build test-driven apps.By the end of this React book, you'll have developed the skills necessary to start building scalable React apps across web and mobile platforms.

Data Engineering Best Practices. Architect robust and cost-effective data solutions in the cloud era

Richard J. Schiller, David Larochelle

Revolutionize your approach to data processing in the fast-paced business landscape with this essential guide to data engineering. Discover the power of scalable, efficient, and secure data solutions through expert guidance on data engineering principles and techniques. Written by two industry experts with over 60 years of combined experience, it offers deep insights into best practices, architecture, agile processes, and cloud-based pipelines. You’ll start by defining the challenges data engineers face and understand how this agile and future-proof comprehensive data solution architecture addresses them. As you explore the extensive toolkit, mastering the capabilities of various instruments, you’ll gain the knowledge needed for independent research. Covering everything you need, right from data engineering fundamentals, the guide uses real-world examples to illustrate potential solutions. It elevates your skills to architect scalable data systems, implement agile development processes, and design cloud-based data pipelines. The book further equips you with the knowledge to harness serverless computing and microservices to build resilient data applications.By the end, you'll be armed with the expertise to design and deliver high-performance data engineering solutions that are not only robust, efficient, and secure but also future-ready.

MS-700 Managing Microsoft Teams Exam Guide. Configure and manage Microsoft Teams workloads and achieve Microsoft 365 certification with ease - Second Edition

Peter Rising, Nate Chamberlain

Exam MS-700: Managing Microsoft Teams tests your knowledge and competence in the deployment, management, and monitoring of Microsoft Teams features within the Microsoft 365 platform.This book will teach you how to effectively plan and implement the required services using both the Teams admin centre within Microsoft 365 and Windows PowerShell. Throughout the chapters, you'll learn about all the policies relating to messaging, teams, meetings, and more; get to grips with the settings; and explore configuration options that a Teams administrator would encounter in their day-to-day responsibilities. You'll also discover best practices for rolling out and managing Teams services for users within your Microsoft 365 tenant as you explore each objective in detail.By the end of this Microsoft Teams book, you'll have covered everything you need to pass the MS-700 certification exam and have a handy, on-the-job desktop reference guide.

Instant New iPad Features in iOS 6 How-to. Learn to use Mail, iCloud, Photo Stream, iPhoto, iWorks, iTunes, iMovie, and Garageband through easy-to-follow recipes

Renee Valdez, Renee J. Valdez

The new iPad's display and processing power allows for a rich media experience that is unlike any other. Instead of solely consuming media, you can create, edit, and manage everything from Excel documents to HD home movies. The multi-touch interface makes creating and editing intuitive. iCloud syncs documents, movies, music, and images to the cloud for access from all your Apple devices.Instant New iPad Features in iOS 6 How-to will walk you through iCloud setup, project creations, and syncing. If you want to utilize all that your iPad has to offer, this is the book for you. Exploring Apple's suite of apps designed especially for the iPad, these recipes provide easy to follow steps enabling you to become a power user.You'll begin with the basics; setting up Mail, and managing your photos. Each recipe builds upon previous recipes and by the end of the book, you'll have projects in every app within Apple's media suites.If you're interested in using your iPad to the fullest, this book will cover the major applications developed by Apple and take advantage of all of its features. We begin by setting up email, using the VIP inbox, iCloud, and Photostream within the Photos application. We'll then dig a little deeper and explore iPhoto and iMovie, creating slideshows, and creating a video trailer. Lastly, we'll explore the apps within Apple's iWorks suite, learning how to create and edit documents, spreadsheets, and PowerPoint presentations. We will finish the book with a musical note, exploring iTunes and GarageBand. Instant New iPad Features in iOS 6 How-to will walk you through tasks with easy to follow recipes that will give you a great overview on the new iPad and its features. 

Joomla! Search Engine Optimization. Drive people to your site with this supercharged guide to Joomla! and Search Engine Optimization with this book and

Ric Shreves

Joomla! is an award-winning content management system (CMS), which enables you to build websites and powerful online applications. SEO, or Search Engine Optimization, is the process and techniques by which you optmize the content and style of your site in order to induce more people to view it.Joomla! Search Engine Optimization will help you develop and execute an effective search engine optimization strategy for your site. From planning to implementation, the book covers best practices in contemporary SEO.In Joomla! Search Engine Optimization you will learn how to develop a dynamic and productive SEO campaign. Covering both the basics of campaign development as well as the daily work it takes to maintain your SEO competitiveness, this book will show you how to produce a distinct and appropriate strategy for your particular site. In particular you will learn key phrase selection and competitor analysis and the correct groundwork for your dynamic SEO campaign. Joomla! Search Engine Optimization will then show you, by finding the right combination of extensions, how to supercharge your site. You will also be given a guided tour of key SEO services, like Google and Bing Webmaster, in order to implement a progressive and effective link building campaign. You will then learn key expert tips and tricks to enable you to build SEO-effective content which will take your site from invisible to unmissable with little effort.

Salesforce B2C Solution Architect's Handbook. Design scalable and cohesive business-to-consumer experiences with Salesforce Customer 360

Mike King

There’s a huge demand on the market for Salesforce professionals who can create a single view of the customer across the Salesforce Customer 360 platform and leverage data into actionable insights. With Salesforce B2C Solution Architect's Handbook, you’ll gain a deeper understanding of the integration options and products that help you deliver value for organizations. While this book will help you prepare for the B2C Solution Architect exam, its true value lies in setting you up for success afterwards.The first few chapters will help you develop a solid understanding of the capabilities of each component in the Customer 360 ecosystem, their data models, and governance.As you progress, you'll explore the role of a B2C solution architect in planning critical requirements and implementation sequences to avoid costly reworks and unnecessary delays. You’ll learn about the available options for integrating products with the Salesforce ecosystem and demonstrate best practices for data modeling across Salesforce products and beyond.Once you’ve mastered the core knowledge, you'll also learn about tools, techniques, and certification scenarios in preparation for the B2C Solution Architect exam.By the end of this book, you’ll have the skills to design scalable, secure, and future-proof solutions supporting critical business demands.

Modern DevOps Practices. Implement, secure, and manage applications on the public cloud by leveraging cutting-edge tools - Second Edition

Gaurav Agarwal

DevOps and the cloud have changed how we look at software development and operations like never before, leading to the rapid growth of various DevOps tools, techniques, and practices. This updated edition helps you pick up the right tools by providing you with everything you need to get started with your DevOps journey.The book begins by introducing you to modern cloud-native architecture, and then teaches you about the architectural concepts needed to implement the modern way of application development. The next set of chapters helps you get familiarized with Git, Docker, Kubernetes, Ansible, Terraform, Packer, and other similar tools to enable you to build a base. As you advance, you’ll explore the core elements of cloud integration—AWS ECS, GKE, and other CaaS services. The chapters also discuss GitOps, continuous integration, and continuous delivery—GitHub actions, Jenkins, and Argo CD—to help you understand the essence of modern app delivery. Later, you’ll operate your container app in production using a service mesh and apply AI in DevOps. Throughout the book, you’ll discover best practices for automating and managing your development lifecycle, infrastructure, containers, and more.By the end of this DevOps book, you'll be well-equipped to develop and operate applications using modern tools and techniques.

Test-Driven Development in Go. A practical guide to writing idiomatic and efficient Go tests through real-world examples

Adelina Simion

Experienced developers understand the importance of designing a comprehensive testing strategy to ensure efficient shipping and maintaining services in production. This book shows you how to utilize test-driven development (TDD), a widely adopted industry practice, for testing your Go apps at different levels. You’ll also explore challenges faced in testing concurrent code, and learn how to leverage generics and write fuzz tests.The book begins by teaching you how to use TDD to tackle various problems, from simple mathematical functions to web apps. You’ll then learn how to structure and run your unit tests using Go’s standard testing library, and explore two popular testing frameworks, Testify and Ginkgo. You’ll also implement test suites using table-driven testing, a popular Go technique. As you advance, you’ll write and run behavior-driven development (BDD) tests using Ginkgo and Godog. Finally, you’ll explore the tricky aspects of implementing and testing TDD in production, such as refactoring your code and testing microservices architecture with contract testing implemented with Pact. All these techniques will be demonstrated using an example REST API, as well as smaller bespoke code examples.By the end of this book, you’ll have learned how to design and implement a comprehensive testing strategy for your Go applications and microservices architecture.

IT Audit Field Manual. Strengthen your cyber defense through proactive IT auditing

Lewis Heuermann

As cyber threats evolve and regulations tighten, IT professionals struggle to maintain effective auditing practices and ensure robust cybersecurity across complex systems. Drawing from over a decade of submarine military service and extensive cybersecurity experience, Lewis offers a unique blend of technical expertise and field-tested insights in this comprehensive field manual.Serving as a roadmap for beginners as well as experienced professionals, this manual guides you from foundational concepts and audit planning to in-depth explorations of auditing various IT systems and networks, including Cisco devices, next-generation firewalls, cloud environments, endpoint security, and Linux systems. You’ll develop practical skills in assessing security configurations, conducting risk assessments, and ensuring compliance with privacy regulations. This book also covers data protection, reporting, remediation, advanced auditing techniques, and emerging trends.Complete with insightful guidance on building a successful career in IT auditing, by the end of this book, you’ll be equipped with the tools to navigate the complex landscape of cybersecurity and compliance, bridging the gap between technical expertise and practical application.