Название: Excel Essentials: A Step-by-Step Guide with Pictures for Absolute Beginners to Master the Basics and Start Using Excel with Confidence
Автор: Nigel Tillery
Издательство: Independently published
Год: 2023
Страниц: 117
Язык: английский
Формат: pdf, epub
Размер: 10.2 MB

Are you new to Excel and looking for an easy-to-follow, step-by-step guide? Look no further! In today's fast-paced digital world, knowing how to use Excel, even at a basic level,is crucial for successin various professional fields. Don't let your lack of Excel knowledge hold you back any longer! With "Excel Essentials: A Step-by-Step Guide with Pictures for Absolute Beginners," you'll master the basics of Excel and gain the confidence to use it effectively. Powerful spreadsheet software like Microsoft Excel has become a necessity for professionals in a variety of fields. Learning Excel may make it easier for you to organize and analyze data, create budgets, keep track of sales, and quickly complete complicated computations. Employers place a high value on Excel skills, which may lead to new work prospects and professional progress. When you finish reading this book, you'll fully grasp Excel's fundamentals and be prepared to use it productively.

Название: PostgreSQL 15 Cookbook: 100+ expert solutions across scalability, performance optimization, essential commands
Автор: Peter G.
Издательство: GitforGits
Год: 2023
Страниц: 364
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.2 MB

If you're a PostgreSQL database administrator looking for a comprehensive guide to managing your databases, look no further than the PostgreSQL 15 Cookbook. With 100 ready solutions to common database management challenges, this book provides a complete guide to administering and troubleshooting your databases using latest PostgreSQL 15.Starting with cloud provisioning and migration, the book covers all aspects of database administration, including replication, transaction logs, partitioning, sharding, auditing, realtime monitoring, backup, recovery, and error debugging. Each solution is presented in a clear, easy-to-follow format, using a real database called 'adventureworks' to provide an on-job practicing experience.Throughout the book, you'll learn how to use tools like pglogical, pgloader, WAL, repmgr, Patroni, HAProxy, PgBouncer, pgBackRest, pgAudit and Prometheus, gaining valuable experience and expertise in managing your databases.

Название: Working with Grep, Sed, and Awk. Pocket Primer
Автор: Oswald Campesato
Издательство: Mercury Learning and Information
Год: 2023
Страниц: 385
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.2 MB

The goal of this book is to introduce readers to three powerful command line utilities that can be combined to create simple yet powerful shell scripts for performing a multitude of tasks. The code samples and scripts use the bash shell, and typically involve very small text files so that you can focus on understanding the features of grep, sed, and awk. In the simplest terms, grep (global regular expression print) will search input files in data for certain words or word patterns and print the lines that match it. sed is useful for changing or modifying data. Awk is a programming language also used for searching a data file for certain patterns, but can also perform certain tasks on the pattern matches it finds. Aimed at a reader relatively new to working in a bash environment, the book is comprehensive enough to be a good reference and teach a few new tricks to those who already have some experience with these command line utilities.

Название: PostgreSQL 14 Internals
Автор: Egor Rogov
Издательство: Postgres Professional
Год: 2023
Страниц: 629
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

This book is for those who will not settle for a black-box approach when working with a database. If you are eager to learn, prefer not to take expert advice for granted, and would like to figure out everything yourself, follow along. I assume that the reader has already tried using PostgreSQL and has at least some general understanding of how it works. Entry-level users may find the text a bit difficult. For example, I will not tell anything about how to install the server, enter psql commands, or set configuration parameters. I hope that the book will also be useful for those who are familiar with another database system, but switch over to PostgreSQL and would like to understand how they differ. A book like this would have saved me a lot of time several years ago. And that’s exactly why I finally wrote it. In the introductory chapter, I briefly touch upon the main database concepts that will serve as the foundation for all the further narration. I do not expect you to get much new information from this chapter but still include it to complete the big picture. Besides, this overview can be found useful by those who are migrating from other database systems.

Название: Controlling Privacy and the Use of Data Assets - Volume 2: What is the New World Currency – Data or Trust?
Автор: Ulf Mattsson
Издательство: CRC Press
Год: 2024
Страниц: 318
Язык: английский
Формат: pdf (true)
Размер: 12.96 MB

The book will review how new and old privacy-preserving techniques can provide practical protection for data in transit, use, and rest. We will position techniques like Data Integrity, and Ledger. This book will use practical lessons in Data Integrity, and Trust, and data's business utility. This book is based on a good understanding and experience of new and old technologies, emerging trends, and a broad experience from many projects in this domain. This book will provide unique context about the WHY (requirements and drivers), WHAT (what to do), and HOW (how to implement), and review current state and major forces representing challenges or driving change, what you should be trying to achieve, how do you do it, including discussions of different options. We will also discuss WHERE (in systems) and WHEN (roadmap). Unlike other general or academic texts, this book is being written to offer practical general advice, outline actionable strategies, and include templates for immediate use. The book contains diagrams needed to describe the topics and Use Cases.

Название: Database Systems: Design, Implementation, & Management, 14th Edition
Автор: Carlos Coronel, Steven Morris
Издательство: Cengage Learning
Год: 2023
Страниц: 818
Язык: английский
Формат: pdf (true)
Размер: 49.1 MB

Database skills are among the most in-demand IT skills. With its practical, accessible approach, Coronel/Morris' market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, & MANAGEMENT, 14th edition, equips you with a solid foundation in database design and implementation for today's market. The authors blend foundational theory, the latest real-world practices and the skills employers want. Straightforward writing and vivid illustrations make even complex concepts easy to understand. You'll learn the key to successful database implementation as you study how to properly design databases that fit within the larger strategic data environment. Expanded coverage includes big data analytics, NoSQL and data visualization technologies. In addition, the MindTap digital platform gives you real-world, hands-on practice to help you prepare for a successful career in database design and management.

Название: Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Автор: Elizabeth Noble
Издательство: Apress
Год: 2023
Страниц: 555
Язык: английский
Формат: pdf (true), epub
Размер: 34.7 MB

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics, integration with S3-compatible object storage, and SQL Ledger tables based on blockchain. You’ll learn to improve your T-SQL design in ways that provide faster performance, stronger security, and easier comprehension. The book identifies common anti-patterns in writing T-SQL and instructs you on how to change your code so you can be more confident in writing T-SQL code that is reliable and performs well.

Название: Enterprise Integration with Mulesoft: Learn how to leverage MuleSoft to power Enterprise Integration
Автор: Gaurav Aroraa, Radhika Atmakuri, Tanuja Mohgaonkar
Издательство: BPB Publications
Год: 2023
Страниц: 228
Язык: английский
Формат: Retail PDF
Размер: 27.3 MB

Harness the strength of the MuleSoft Anypoint Platform for seamless integration. Integrating enterprise applications is a complex task that requires a comprehensive understanding of the latest technologies and programming languages. MuleSoft is a powerful and versatile integration platform that has revolutionized the way enterprises connect their applications, data, and systems. If you want to achieve seamless integration across various technologies, applications, and platforms, then this book is for you. From understanding the industry trends to exploring the history and idea behind MuleSoft's technology, the book will establish a solid foundation in the initial chapters. It will then cover a wide range of topics, including the basics of RESTful services, DataWeave, Anypoint Platform, Designer and Mule RPA. Furthermore, the book will cover the essential functionalities of MuleSoft and help you acquire the skills to leverage them effectively in developing integration solutions for enterprise applications that are efficient, dependable, and effortless to manage. The book will also delve into industry best practices for designing and integrating APIs, providing you with valuable insights on creating robust and scalable API solutions. Additionally, the book will explore the powerful capabilities of DataWeave, an essential tool for data transformation within the MuleSoft ecosystem.

Название: Think Like a Data Analyst (MEAP v2)
Автор: Mona Khalil
Издательство: Manning Publications
Год: 2023
Страниц: 158
Язык: английский
Формат: pdf, epub
Размер: 12.8 MB

Learn the technical and soft skills you need to succeed in your career as a data analyst. Think Like a Data Analyst is full of sage advice on how to be an effective data analyst in a real production environment. Inside, you’ll find methods that maximize the impact of your work, from choosing the right analysis approach to effectively communicating with stakeholders. You’ll soon understand the nuances and challenges of real data science projects, with the kind of insights that only come from years of experience. Without doubt, technical skills in Python, R, SQL, along with knowledge of statistics and data science are vital to your success as an analyst. However, they’re only part of the picture. This one-of-a-kind guide reveals the soft skills, best practices, and tools that help you maximize your effectiveness and deliver accurate data-driven decisions in your organization.

Название: Android for Beginners - 15th Edition, 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Язык: английский
Формат: pdf
Размер: 39.7 MB

В книге "Android для новичков" на четком английском языке и на практических примерах описывается, как установить и запустить свои исходные приложения для Android. Она развеивает запутанность терминологии и загадок, окружающих приложения для Android, и предоставляет простые пошаговые руководства, которые помогут вам начать свою работу.