Litgu.ru - Литературный Гуру

Название: SQL Survival Guide: Database basics for beginners: Learn SQL from Scratch and Save Time and Effort
Автор: Sergio Garrido Barrientos
Издательство: Independently published
Серия: Database books: design and SQL for beginners and dummies
Год: 2024
Страниц: 153
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

Envision yourself seamlessly executing queries, analyzing data, and making informed decisions. "SQL Survival Guide" is more than a book—it’s a workshop in print form. Each exercise and example is a stepping stone to proficiency, designed to build your knowledge incrementally. Sergio Garrido, a Project Manager in IT at a leading public sector engineering company, has meticulously crafted over 100 exercises and examples to ensure a comprehensive understanding of SQL. His approach is not just to teach but to empower you with a skill set that will stand the test of time. Have you ever felt that querying a database was like searching for a needle in a haystack? Surely you have heard everyone say that SQL is no longer used or that its use is becoming less widespread... Do not belive that! The reality is very different. The SQL language continues to be one of the most used in the world of application development. Today we find ourselves surrounded by information and the ability to exploit and analyze all this amount of data is becoming a highly required skill in companies. This is an eminently practical book, I have avoided long and cumbersome explanations or parameters that are not usually used. You will see how in each chapter there are examples and exercises that will help you understand each of the orders or commands that SQL has. The goal is that in a very short time you can become proficient with SQL. Depending on the database manufacturer we will have some differences when using the SQL language. In this book we try to use a standard that adapts to most cases. The world of databases is fascinating and offers many benefits to both developers and anyone involved in creating applications.

Название: Statistical Process Control and Data Analytics, Eighth Edition
Автор: John Oakland, Robert Oakland
Издательство: Routledge
Год: 2025
Страниц: 387
Язык: английский
Формат: pdf (true)
Размер: 30.2 MB

Now entitled Statistical Process Control and Data Analytics, this revised and updated eighth edition retains its focus on processes that require understanding, have variation, must be properly controlled, have a capability and need improvement – as reflected in the five sections of the book. In this book the authors provide not only an instructional guide for the tools but communicate the management practices which have become so vital to success in organizations throughout the world. The book is supported by the authors' extensive consulting work with thousands of organizations worldwide. A new chapter on data governance and data analytics reflects the increasing importance of Big Data in today’s business environment. Fully updated to include real-life case studies, new research based on client work from an array of industries and integration with the latest computer methods and software, the book also retains its valued textbook quality through clear learning objectives and online end-of-chapter discussion questions. It can still serve as a textbook for both student and practicing engineers, scientists, technologists, managers and anyone wishing to understand or implement modern statistical process control techniques and data analytics. ‘Big Data’ (very large complex data sets, sometimes explained by the use of five Vs: volume, variety, veracity, value and velocity), Machine Learning (ML), robotics, Artificial Intelligence (AI), the Internet of Things (IoT) and cloud computing will continue to greatly impact industry and business/organization models. The amount of data is constantly growing, but learning from more data depends massively on the data being collected and used correctly if we are not going to see increases in variation in processes through lack of understanding of aggregated or filtered data with selected algorithms.

Название: Excel: The Complete Beginner's Excel Guide and Video Tutorial to the Fundamentals, Advancing Efficiency and Productivity with Practical Examples, Formulas and Functions
Автор: Alan Hopper
Издательство: Independently published
Год: 2024
Страниц: 240
Язык: английский
Формат: epub
Размер: 24.0 MB

Are You Ready to Learn Excel and Become Proficient? Unlock the full potential of Microsoft Excel in just five days with our comprehensive guide. Whether you're an absolute beginner or an experienced user looking to refine your skills, this book provides a structured, easy-to-follow path to Excel mastery. Includes 100 Short Video Tutorials + 13 Books. "Excel" by former Microsoft Programmer, Alan Hopper, is your ultimate guide to conquering Microsoft Excel in less than one week. This step-by-step manual covers everything from basic functionalities to advanced techniques, making it perfect for users at any skill level. Dive into transformative content brimming with key functions, formulas, shortcuts, and beyond. With 13 detailed books and 100 short instructional videos, you'll have all the resources you need to become an Excel expert in just five days. Each chapter is accompanied by a series of short, easy-to-digest instructional videos. These videos provide visual demonstrations of key concepts, ensuring you can follow along and practice as you learn. From basic data entry to advanced VBA scripting, these videos are designed to enhance your understanding and make learning Excel both engaging and effective.

Название: Linux Visual Guide: Step-By-Step Manual for Complete Beginners to Mastering Linux Basics, Vim Editor, Command Management, Remote Server Operation, and More
Автор: Ben Bloomfield, David Ocean, Atlas Skylark
Издательство: D-Libro
Год: 2024
Страниц: 424
Язык: английский
Формат: epub
Размер: 22.6 MB

If you're looking for a roadmap to mastering the Linux operating system, this comprehensive guide is the perfect choice. Linux is a robust platform for everything from everyday computing to advanced network security and server management. This guide is designed for absolute beginners and gradually takes you through the intricacies of the Linux command line, offering a thorough understanding of the operating system's architecture and scripting potential. From initial setup on physical or cloud platforms to advanced kernel management, this book covers essential concepts such as file systems, security protocols, and network configurations. This Linux guide is uniquely valuable for its practical, easy-to-understand content presented in comprehensive, step-by-step instructions. It stands out by offering hands-on exercises that apply real- world applications, ensuring even beginners can follow complex topics. The guide covers all aspects of Linux, from basic commands to advanced configurations, making it a thorough resource for mastering the operating system. Each distribution includes the Linux kernel (the foundation of the operating system), GNU shell utilities (the terminal interface and commands), and a package management system.

Название: SQL for Data Analysis: A Middle-Level Guide to Integrating SQL with Data Science Tools
Автор: Louis Johanson
Издательство: Independently published
Год: 2024
Страниц: 196
Язык: английский
Формат: epub
Размер: 10.1 MB

"SQL for Data Analysis: A Middle-Level Guide to Integrating SQL with Data Science Tools" is the perfect bridge for professionals who have grasped the basics of SQL and are ready to elevate their data analysis skills to new heights. This comprehensive guide is tailored for those poised at the intersection of SQL proficiency and the vast landscape of Data Science, seeking to deepen their expertise and integrate SQL seamlessly with cutting-edge Data Science tools. Venture beyond the fundamentals with advanced SQL techniques and methodologies that unlock the power of data. This book delves into sophisticated SQL queries, optimization strategies, and best practices for performance improvement, ensuring you can handle complex data analysis tasks with ease. Explore the dynamic interplay between SQL and popular Data Science languages like Python and R, learning how to wield these tools in unison to enhance your data analysis projects. "SQL for Data Analysis" not only strengthens your SQL capabilities but also guides you through the integration of SQL with leading Data Science platforms and libraries. Discover how to leverage SQL within environments such as Jupyter Notebooks, Apache Spark, and Machine Learning frameworks, enabling a holistic approach to data analysis that spans across tools and technologies. Whether you're a data analyst looking to upgrade your skills, a data scientist seeking to fortify your SQL knowledge, or a professional in a data-driven field, "SQL for Data Analysis: A Middle-Level Guide to Integrating SQL with Data Science Tools" is your comprehensive guide to harnessing the synergy between SQL and Data Science. Embark on this journey to become a more versatile and impactful data professional, ready to tackle the challenges and opportunities of the data-rich world head-on.

Название: Справочник сисадмина. Все, что нужно, под рукой
Автор: Левицкий Н.Д., Матвеев М.Д.
Издательство: Наука и техника
Год: 2024
Страниц: 609
Язык: русский
Формат: pdf
Размер: 41.0 MB

Данная книга пригодится всем, кто занимается созданием и эксплуатацией информационных систем под управлением Windows Server и операционной системы Linux. Структура справочника позволит быстро находить нужную информацию, получать примеры использования тех или иных элементов Windows Server и Linux. ПЕРВЫЙ блок книги относится к администрированию Windows Server - вы узнаете об управлении сервером; мониторинге процессов, сервисов и событий; автоматизации административных задач; основах безопасности; управлении учетными записями пользователя и группы; как управлять сетью TCP/IP и использовать сервисы DNS и DHCP. Также подробно рассмотрим Active Directory - разворачивание, основы администрирования, доменные службы Active Directory. ВТОРОЙ блок книги относится к администрированию в операционной системе Linux - вы узнаете об использовании командной строки и локальной сети; управлении процессами и хранилищем данных; маршрутизации и настройке брандмауэра; файловой системе и командном интерпретаторе Bash. Начать наш справочник хотелось бы с обзора Microsoft Windows Server 2022 — этой мощной, универсальной и полнофункциональной серверной операционной системы от Microsoft. В Microsoft уделяют много внимания обратной совместимости, поэтому работа с преды­дущими версиями (Windows Server 2012 и Windows Server 2016) во многом схожа, в том числе в управлении, настройке средств безопас­ности, сети и средств хранения данных. Поэтому большую часть ин­формации о Windows Server 2022 можно применить и к более старым выпускам этой ОС, что будет полезно для администраторов разного возрастного уровня. Командная строка — неотъемлемая и важнейшая часть Linux. Посредством командной строки осуществляется выполнение команд Linux. Эффективно сможет работать с Linux только тот, кто освоил принципы работы в командной строке.

Название: Computational Approaches in Bioengineering. Volume 2: Computational Approaches in Biomaterials and Biomedical Engineering Applications
Автор: Edited By Pranav Deepak Pathak, Roshani RautORCID Icon, Sebastian Jaramillo-Isaza, Pradnya BorkarORCID Icon, Rutvij H. Jhaveri
Издательство: CRC Press
Год выхода: 2024
Страниц: 323
Формат: True PDF
Размер: 14 MB
Язык: английский

Computational Approaches in Bioengineering, Volume 2—Computational Approaches in Biomaterials and Biomedical Engineering Applications is a comprehensive and up-to-date resource that provides a broad overview of the use of computational methods in the fields of biomaterials and biomedical engineering. Written by a team of experts in the field of biomaterials and biomedical engineering, it provides a wealth of information on the use of computational methods in these fields. Furthermore, it explores emerging trends and discusses future directions and associated limitations in the field. Through thorough exploration and explanation, it showcases the latest research and advancements, offering valuable insights into how computational methods are utilized to design and optimize biomaterials, simulate biological processes, and develop innovative medical devices.

Название: Data Virtualization in the Cloud Era: Data Lakes and Data Federation At Scale
Автор: Daniel Abadi, Andrew Mott
Издательство: O’Reilly Media, Inc.
Год: 2024-07-03
Страниц: 184
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.1 MB

For decades data virtualization has been little more than a dream. How nice it would be if we could ignore all the details regarding where data is located and how it is stored, and simply access all data within an organization from a single unified interface! Unfortunately, this dream was held back by fundamental limitations of hardware and complexity of the necessary software, so data virtualization remained a niche technology. However, in the last decade, advances in networking hardware and Machine Learning technology has started to transform data virtualization from dream to reality. One system may have an SQL interface, another GraphQL, and a third system may support only text search. The client who wishes to pose a question to these differing systems needs to learn the language that the system supports as its interface. The goal of data virtualization (DV) is to eliminate or alleviate these other barriers. A DV System creates a central interface in which data can be accessed no matter where it is located, no matter how it is stored, and no matter how it is organized. The most complex part of a DV System is the data virtualization engine (DV Engine), which receives requests from clients (generated using the client interface) and performs whatever processing is required for these requests. This typically involves communication with the specific underlying data sources that contain data relevant to those requests. The DV Engine thus needs to know how to communicate with a variety of different types of systems that may store data that is being virtualized by the system. In general, the goal of data virtualization is to allow clients to express requests over datasets without having to worry about the details of how the underlying data source systems store the source data.

Название: Express Guide Fedora Linux Workstation 40
Автор: Shiv Kumar Goyal
Издательство: Independently published
Год: 2024
Страниц: 148
Язык: английский
Формат: epub
Размер: 10.1 MB

Unlock the full potential of Fedora Linux Workstation 40 with this comprehensive and easy-to-follow guide. Whether you're new to Linux or a seasoned user, this book equips you with everything you need to know to get started and become proficient quickly. This book is meant to serve as your all-in-one resource for Fedora, regardless of your level of knowledge with the OS or desire to learn more. Fedora is renowned for its creativity, dedication to open source ideals, and community-driven development. It is a state-of-the-art Linux distribution that provides a stable basis for server and desktop environments. System administrators, developers, and enthusiasts all love Fedora because it embraces the most recent developments in software and technology with every release. Fedora ships with the GNOME desktop environment by default, although additional desktop environments such as KDE, LXDE, XFCE, LXQT, Mate, Cinnamon, SOAS, and others are also available. If you like a specific type of desktop environment, you can choose the appropriate spin. In this book, we will install and explore Fedora's default GNOME version. Whether you're a developer, IT professional, or enthusiast, this guide is your essential companion to mastering Fedora Linux Workstation 40. Anyone interested in learning about Fedora Linux is the target audience for this book. It serves both novices venturing into the realm of Linux and experienced users searching for in-depth analysis and useful information. This book will be your go-to resource whether you are configuring your own desktop or exploring the extensive ecosystem of open source software.

Название: Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud (Final Release)
Автор: Arunjith Aravindan, Jeyaram Ayyalusamy
Издательство: O’Reilly Media, Inc.
Год: 2024
Страниц: 606
Язык: английский
Формат: True EPUB (Retail Copy)
Размер: 16.5 MB

Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, high availability, scaling techniques, and performance tuning. Using practical techniques, tips, and real-world examples, authors Arunjith Aravindan and Jeyaram Ayyalusamy show you how to deploy and manage MySQL, Amazon RDS, Amazon Aurora, and Azure MySQL. By the end of the book, you'll have the knowledge and skills necessary to administer, manage, and optimize MySQL databases effectively. The motivation behind crafting Hands-On MySQL Administration stems from recognizing a growing need within the diverse community of individuals involved in database management. MySQL, the second most popular database management system globally and widely adopted by major corporations like Google, Facebook, and LinkedIn, has become an indispensable skill for IT professionals. The book can be used as a reference for daily tasks as well as for learning and mastering new concepts. DBAs can use the book to optimize the performance of their databases, identify and solve common issues, and learn new techniques for managing MySQL databases. Developers can also use the book to create efficient and scalable applications by learning how to design database schema and optimize queries. IT professionals can use the book to enhance their skills and keep up with the latest trends and best practices in database administration.