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.

ChatGPT Prompts Book - Precision Prompts, Priming, Training & AI Writing Techniques for Mortals. Crafting Precision Prompts and Exploring AI Writing with ChatGPT

Oliver Theobald

The course embarks on an enlightening journey through the world of ChatGPT, starting from the very basics of understanding what ChatGPT is, to delving deep into the mechanics of crafting precision prompts that unlock its full potential. From the outset, you'll be introduced to the foundational elements that make ChatGPT an indispensable tool for a wide range of applications, setting the stage for a comprehensive exploration of its capabilities.As we progress, the course meticulously unfolds the layers of prompt writing techniques, priming strategies, and training methodologies that are designed to enhance your interaction with AI. You'll learn how to craft prompts for common use cases, navigate the nuances of content creation, translation tasks, and personalized tutoring, all while leveraging ChatGPT's advanced AI art capabilities.The course culminates by focusing on practical applications and exploring advanced prompt training and role prompting techniques. This final stretch is designed to solidify your understanding and empower you with the confidence to employ ChatGPT across various scenarios, from professional content writing to creative explorations.

Learning ArcGIS Geodatabases. An all-in-one start up kit to author, manage, and administer ArcGIS geodatabases

Hussein Nasser

Xamarin 4.x Cross-Platform Application Development. Click here to enter text. - Third Edition

Jonathan Peppers

Xamarin is a leading cross-platform application development tool used by top companies such as Coca-Cola, Honeywell, and Alaska Airlines to build apps. Version 4 features significant updates to the platform including the release of Xamarin.Forms 2.0 and improvements have been made to the iOS and Android designers. Xamarin was acquired by Microsoft so it is now a part of the Visual Studio family.This book will show you how to build applications for iOS, Android, and Windows. You will be walked through the process of creating an application that comes complete with a back-end web service and native features such as GPS location, camera, push notifications, and other core features. Additionally, you’ll learn how to use external libraries with Xamarin and Xamarin.Forms to create user interfaces. This book also provides instructions for Visual Studio and Windows. This edition has been updated with new screenshots and detailed steps to provide you with a holistic overview of the new features in Xamarin 4.

Professional Image Editing Made Easy with Affinity Photo. Apply Affinity Photo fundamentals to your workflows to edit, enhance, and create great images

Jeremy Hazel

In this book, you’ll explore the Affinity Photo program through practice-based learning as you make popular photo edits, learning the tools and techniques in conjunction with the workflow concept. Instead of comprehensive description of the tools, you’ll learn through practical application and understand why they work, not just how they work. This is neither a technical manual nor a workbook but a project-based hybrid approach that provides a deeper understanding of how to use each tool to achieve your goal.Starting with the fundamentals of navigating the interface, understanding layers, and making your first edit, this Affinity Photo book gradually increases the complexity of projects. You’ll go from single-layer edits, composites, and RAW development to putting together a complex composition using the tools that you've learned along the way. Additionally, you’ll learn the best practices used by expert photo editors for a flawless finish.By the end of this book, you’ll have a good body of work, be able to evaluate the edits you want to make, and achieve desired results with Affinity Photo.

CompTIA A+ Practice Test Core 1 (220-1101). Over 500 practice questions to help you pass the CompTIA A+ Core 1 exam on your first attempt

Ian Neil, Mark Birch

CompTIA A+ certification is a trusted credential that’s highly sought after by professionals looking to prove their mettle in today’s digital world. This book will provide you with exam-oriented practice material mirroring the A+ exam’s level of difficulty to prepare you for every challenge that the exam might throw at you.This book is a compilation of hundreds of carefully curated practice questions on each domain, including mobile devices, networking, hardware, virtualization and cloud computing, as well as hardware and network troubleshooting. The realistic tests are designed in a way to help you accelerate your preparation to achieve the industry-celebrated A+ certification.By the end of this practice book, you’ll be well-prepared to pass the CompTIA A+ Core 1 (220-1101) exam with confidence.

Windows Subsystem for Linux 2 (WSL 2) Tips, Tricks, and Techniques. Maximise productivity of your Windows 10 development machine with custom workflows and configurations

Stuart Leeks

Windows Subsystem for Linux (WSL) allows you to run native Linux tools alongside traditional Windows applications. Whether you’re developing applications across multiple operating systems or looking to add more tools to your Windows environment, WSL offers endless possibilities.You’ll start by understanding what WSL is and learn how to install and configure WSL along with different Linux distros. Next, you'll learn techniques that allow you to work across both Windows and Linux environments. You’ll discover how to install and customize the new Windows Terminal. We'll also show you how to work with code in WSL using Visual Studio Code (VS Code). In addition to this, you’ll explore how to work with containers with Docker and Kubernetes, and how to containerize a development environment using VS Code.While Microsoft has announced support for GPU and GUI applications in an upcoming release of WSL, at the time of writing these features are either not available or only in early preview releases. This book focuses on the stable, released features of WSL and giving you a solid understanding of the amazing techniques that you can use with WSL today.By the end of this book, you’ll be able to configure WSL and Windows Terminal to suit your preferences, and productively use Visual Studio Code for developing applications with WSL.

Mastering SQL Queries for SAP Business One. Exploit one of the most powerful features of SAP Business One with this practical guide to mastering SQL Queries. With the skills to quickly acquire business intelligence, your enterprise can gain the competitive edge

Guang Hui Du, Gordon Du

SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses. For such companies, retrieving the most relevant information from their business data can be key to standing out from the competition. SAP Business One is a rapidly growing software package and this book is timely in giving those businesses an advantage in the area of Business Intelligence. Having SQL query skills in- house is the most important and cost-effective move you can make in this growing field.This practical guide will provide you with the skills to gain more specific business information from SAP Business One by using SQL queries. It will provide you with solutions for solving complicated report related problems, covering basic tools like the Query Generator and Query Wizard. More advanced content like using queries with Crystal Reports will also be delved into.SQL query is one of the advanced tools available in SAP Business One which is easily learned and quickly utilized. By referring back to and applying the many examples in this book, you will be able to create and run correct, and therefore effective, SQL queries to help your business.The book begins by teaching a clear definition of the SQL query, and covers the data dictionary and table links. Coverage will then jump to a higher level of complex SQL queries, discussing features like FMS. Along the way more advanced SQL Query topics will be covered, such as extending the scope of basic SQL queries for more complicated cases. You will ultimately gain in depth query knowledge to bring more Business Intelligence into SAP Business One.