Название: Grokking Relational Database Design (MEAP v4)
Автор: Qiang Hao, Michail Tsikerdekis
Издательство: Manning Publications
Год: 2024
Страниц: 145
Язык: английский
Формат: epub
Размер: 24.7 MB

A friendly illustrated guide to designing and implementing your first database. Data is the backbone of computer science, and databases are the main way that data is stored, exchanged, manipulated, and managed. Whether you’re a software developer, a data scientist, or an enthusiastic business user looking to up your data analysis skills, it pays to learn how to create and query relational databases like MySQL, SQL Server, PostgreSQL, and Oracle. Grokking Relational Database Design will get you started! Grokking Relational Database Design teaches the art of database design through real-world projects, insightful illustrations, and action-oriented learning. Unlike many beginning database books that focus on the technical details of SQL and formal database theory, this book teaches you how to think about relational database design from the ground up, so you’ll create databases that are a joy to use for a long time. Everything in this book is reinforced by hands-on exercises and examples. You’ll quickly design, implement, and optimize a database for an e-commerce application like the ones you use every day. You’ll also explore how generative AI tools such as ChatGPT radically simplify the mundane tasks of database design. Suitable for self-taught programmers, engineers, data scientists, and business data users. No previous experience with relational databases required.

Название: Raspberry Pi OS System Administration: Ancillary Topics
Автор: Robert M. Koretsky
Издательство: CRC Press
Серия: Raspberry Pi OS System Administration with systemd
Год: 2025
Страниц: 293
Язык: английский
Формат: pdf (true)
Размер: 22.2 MB

The fourth volume in a new series exploring the basics of Raspberry Pi Operating System administration, this installment builds on the insights provided in Volumes 1, 2, and 3 to provide a compendium of easy-to-use and essential Raspberry Pi OS administration for the novice user, with specific focus on ancillary topics that can be used with the Raspberry Pi OS based upon upstream Debian Bookworm release, and the Raspberry Pi 5. The overriding idea behind system administration of a modern, 21st-century Linux system such as the Raspberry Pi OS is the use of systemd to ensure that the Linux kernel works efficiently and effectively to provide these three foundation stones of computer operation and management: computer system concurrency, virtualization, and secure persistence. This book is aimed at students and practitioners looking to maximize their use of the Raspberry Pi OS. With plenty of practical examples, projects, and exercises, this volume can also be adopted in a more formal learning environment to supplement and extend the basic knowledge of a Linux operating system.

Название: Learn SQL in a Month of Lunches (MEAP v13)
Автор: Jeff Iannucci
Издательство: Manning Publications
Год: 2024
Страниц: 312
Язык: английский
Формат: epub
Размер: 47.7 MB

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! This book is designed for all SQL beginners, including those who are not necessarily software developers. It emphasizes practical ways to use SQL, rather than theoretical, helping you quickly assimilate the basics needed to begin implementing what you’ve learned. If you know how to use Windows or MacOS and have experience using spreadsheet applications, then you absolutely are ready to start learning how to use SQL to read and manipulate data, create database objects, and more. Each chapter of this book is short enough to complete within an hour, whether that be during lunchtime or some other part of your day. Month of Lunches books are also designed to help you be immediately effective, so by the second chapter you will already have written your first SQL statement and examined its core components. Subsequent chapters will focus on teaching skills that you can apply to real-life scenarios and will include plenty of exercises to help you reinforce what you have learned.

Название: Future Communication Systems Using Artificial Intelligence, Internet of Things and Data Science
Автор: Inam Ullah, Inam Ullah Khan, Mariya Ouaissa
Издательство: CRC Press
Год: 2024
Страниц: 253
Язык: английский
Формат: pdf (true)
Размер: 16.0 MB

Future Communication Systems Using Artificial Intelligence, Internet of Things and Data Science mainly focuses on the techniques of Artificial Intelligence (AI), Internet of Things (IoT) and Data Science for future communications systems. The goal of AI, IoT and data science for future communications systems is to create a venue for industry and academics to collaborate on the development of network and system solutions based on Data Science, AI and IoT. Recent breakthroughs in IoT, mobile and fixed communications and computation have paved the way for a data‑centric society of the future. New applications are increasingly reliant on machine‑to‑machine connections, resulting in unusual workloads and the need for more efficient and dependable infrastructures. Such a wide range of traffic workloads and applications will necessitate dynamic and highly adaptive network environments capable of self‑optimization for the task at hand while ensuring high dependability and ultra‑low latency. Networking devices, sensors, agents, meters and smart vehicles/systems generate massive amounts of data, necessitating new levels of security, performance and dependability. Such complications necessitate the development of new tools and approaches for providing successful services, management and operation. Data Science is basically utilized to extract meaningful information generated by Artificial Intelligence of Things (AIoT) devices. This will open new opportunities for researchers, engineers and scientists. The merger of AI, IoT and Data Science will enhance communication systems. This book provides detailed information about future communication systems. Also, it explains the relationship between AI, IoT and Data Science.

Название: Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot
Автор: Thomas Fragale
Издательство: Wiley
Год: 2024
Страниц: 304
Язык: английский
Формат: pdf (true)
Размер: 11.3 MB

Get more out of your data with step-by-step tutorials for the Excel features you need to know. Excel is still the most popular tool for organizing and analyzing data, and today's professionals are expected to have a high degree of fluency with it. Complex Excel tools like Pivot Tables, PowerQuery, and PowerPivot can help you manage and report on data the way you need to. Getting Great Results with Excel Pivot Tables, PowerQuery and PowerPivot offers a fresh look at how these tools can help you. Author and Microsoft Certified Trainer Thomas Fragale breaks down the topics into easy-to-use steps and screenshots, so you'll be able to put your advanced Excel skills into practice right away. Using Pivot Tables, PowerQuery, and PowerPivot, you can import, sort, transform, summarize, and present your data, all without having to be a programmer. This book takes the technical jargon out of using these features, so you can do your job more efficiently, bring value to your teams, and advance your career. The plain-English instructions inside will help anyone learn to get quick, meaningful results from your data, without having a degree in computing. Microsoft Excel has great tools to help you manage your data and to report on that data the way you want to see it. Using pivot tables, Power Query, and PowerPivot, you can pull in data from many sources. You can also clean up and prepare your data, summarize your data in many ways, analyze your data by adding formulas, create visually appealing and interactive dashboards, and get real results from your data.

Название: Debian 12.5 Bookworm: The Comprehensive Guide: From Installation to Advanced Security and Productivity
Автор: Morgan Partridge
Издательство: Independently published
Год: 2024
Страниц: 552
Язык: английский
Формат: pdf
Размер: 31.8 MB

Debian 12.5 Bookworm: The Comprehensive Guide" is the ultimate resource for anyone looking to dive into the latest version of Debian, whether you're setting up a powerful workstation, a gaming rig, or simply exploring Linux. This guide takes you through every step of the Debian 12.5 experience, from initial considerations like system requirements and choosing the right installation media, to detailed installation instructions for both beginners and experienced users. Starting with a clear explanation of what Debian 12.5 is, this book ensures you're well-prepared even before you begin the installation process. Learn how to select the best media for installation, set up your environment for success, and navigate the complexities of partitioning and network configuration with ease. Whether you're burning a Debian ISO to a DVD or setting up a Ventoy USB for installation, our guide has you covered with practical advice and step-by-step instructions. Once Debian is up and running, this book doesn't stop. Delve into post-installation tasks like adding users to the sudoers file, managing Debian repositories, and setting up your desktop environment for productivity. With a focus on security, you'll also discover how to secure your system with firewalls, antivirus software, and more, ensuring you're protected against threats.

Название: Android for Beginners - 18th Edition 2024
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2024
Страниц: 74
Формат: PDF
Размер: 41,3 MB
Язык: английский

Android for Beginners is the first and only choice if you are new adopter and want to learn everything you'll need to get started with your new device. This independent manual is crammed with helpful guides and step-by-step fully illustrated tutorials, written in plain easy to follow English. Over the pages of this new user guide you will clearly learn all you need to know about out of the box set up, getting to grips with the more advanced features and discover a huge array of amazing apps. With this unofficial instruction manual at your side no problem will be unsolvable, no question unanswered as you learn, explore and enhance your user experience.

Название: Master Linux Mint 21.3: The Ultimate Guide from Installation to Security: A Comprehensive Manual to Navigating Linux Mint 21.3: From Setup to Advanced Security
Автор: Morgan Partridge
Издательство: Independently published
Год: 2024
Страниц: 533
Язык: английский
Формат: pdf
Размер: 31.5 MB

Master Linux Mint 21.3: The Ultimate Guide from Installation to Security" is an essential manual for anyone eager to dive into Linux Mint 21.3. It offers a detailed walkthrough from setting up your machine, selecting the perfect system requirements, to creating bootable USB drives and installing the OS. With step-by-step guides on BIOS configurations, first login, and empowering user privileges, it ensures a smooth experience. The book covers software updates, system maintenance, security enhancements, and introduces a wide array of software options—from office suites to gaming. It wraps up with advice on privacy, virtualization, and programming languages, making it a comprehensive resource for mastering Linux Mint.

Название: The Linux Command Line: Your Path to Faster Computing: Unleash Linux's Potential for Beginners and Experienced Users
Автор: R. Parvin
Издательство: Independently published
Год: 2024
Страниц: 303
Язык: английский
Формат: pdf
Размер: 52.2 MB

Discover the power and efficiency of the Linux command line! Are you ready to unlock the full potential of your Linux operating system? "The Linux Command Line: Your Path to Faster Computing" is your definitive guide to mastering this powerful interface, transforming the way you interact with your computer. Whether you're a beginner seeking to conquer the basics or an experienced user looking to level up your skills, this book offers a comprehensive and engaging journey through the world of Linux commands. Begin your command-line adventure with a smooth onboarding experience, covering terminal basics and essential commands. Master file system exploration with clear explanations of directory structures and navigation techniques. Learn to create, delete, move, rename, and link files and directories with ease. Explore essential text editors like gedit and Nano, and delve into file viewing and manipulation commands like less, cat, tac, head, and tail. Discover the categories of Linux commands, how to find executable files, and how to navigate help pages for in-depth support. Learn how to execute commands sequentially, harness wildcards for pattern matching, and create your own custom commands with aliases. Dive into performance optimization, advanced command-line tools, system monitoring, and network management. With clear explanations, practical examples, and step-by-step guidance, this book is designed to make the Linux command line accessible and enjoyable for users of all levels.

Название: The Complete Windows 11 User Manual - 10th Edition 2024
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2024
Страниц: 148
Язык: английский
Формат: pdf
Размер: 57.5 MB

Все, что нужно для освоения Windows 11! С момента своего выхода в октябре 2021 года Windows 11 быстро стала основной операционной системой для начинающих, средних и опытных пользователей компьютеров. Она призвана расширить границы, охватить повседневные цифровые технологии и помочь нам стать ближе друг к другу, чем когда-либо прежде. Она получила новый свежий вид и новый мощный код под капотом. Все, что вам нужно, чтобы двигаться в будущее. Это руководство проведет вас через новейшую ОС Microsoft, предлагая на каждой странице что-то новое и давая необходимые знания, чтобы заставить Windows 11 работать на вас. Здесь вы найдете учебники и советы, откроете секреты ОС, а ваше понимание того, как все работает, поможет вам стать продвинутым пользователем. Итак, давайте погрузимся в Windows и начнем укреплять вашу уверенность и понимание этой замечательной операционной системы.