Название: Inside Enterprise Architect: Querying EA's Database
Автор: Thomas Kilian
Издательство: Leanpub
Год: 2023-04-29
Страниц: 128
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

If you ever wondered what happens behind the scenes in Enterprise Architect you should have a look into this book. It's the prefect map for the twisty little passages, all alike in EA. The current issue has been updated to match the new GUI found in V12. This book shows details of what is at the low level of EA: its database. The information gathered in this book is a summary of what has been found out by quite a number of EA users including me. If you need to dive into details which the official API does not provide, this book is what you might have been looking for. This book starts with a short introduction on how to query EA’s database. This is followed by a concise list of all available tables and details for the most important ones. The details contain cross references into more details as well as screen shots of the GUI where the appropriate elements appear. Vice versa the screen shots point to the according table columns. The final sections conclude with a practical approach to using SQL in Enterprise Architect.

Название: Everyday Data Visualization (MEAP v5)
Автор: Desiree Abbott
Издательство: Manning Publications
Год: 2023
Страниц: 295
Язык: английский
Формат: pdf, epub
Размер: 31.7 MB

Radically improve the quality of the data visualizations you do every day by mastering core principles of color, typography, chart types, data storytelling, and more! Everyday Data Visualization gives you skills you’ll use to enhance the most common data visualizations, including charts and tables, data dashboards, and infographics. You’ll learn how to use color, typography, positioning, and choice of charts to catch and keep a viewer’s attention. Discover the finesse and design rigor that goes into building delightful dashboards, and best practices for live visualizations that flex and grow as underlying data changes. Design fundamentals are broken down into their component parts so they’re easy to understand—even if you’re the analytical type! Best of all, everything you learn is tool-agnostic, with universal principles you can apply to any data stack. For readers experienced with data analysis tools.

Название: 35 Database Examples: A Database Reference Book For Anyone
Автор: Mark Hayford
Издательство: PublishDrive
Год: 2022
Язык: английский
Формат: pdf, epub, mobi
Размер: 10.2 MB

This book is a collection of simple database designs meant to serve as a quick reference for someone looking for an idea or example. You may find this helpful in situations like: - Needing a reference to easily communicate between a database / developer professional and someone with other expertise. Such as a product manager or client looking to build something; - As a frontend developer the following can provide a basic understanding of the data layer. Often a frontend developer would be somewhat familiar with an API or controller level; - Having simple examples of data organization when implementing low code or no code tools. Good data organization can be exceptionally useful in going from a low code prototype to a full product; - When working with analytic tools such as Tableau

Название: Microsoft Office 365: A Skills Approach, 2021 Edition
Автор: Cheri Manning, Catherine Manning
Издательство: McGraw Hill
Год: 2023
Страниц: 1008
Язык: английский
Формат: epub (true)
Размер: 145.1 MB

How well do you know Microsoft Office? Many students can follow specific step-by-step directions to re-create a document, spreadsheet, presentation, or database, but do they truly understand the skills it takes to create these on their own? Just as simply following a recipe does not make you a professional chef, re-creating a project step by step does not make you an Office expert. The purpose of this book is to teach you the skills to master Microsoft Office 365 in a straightforward and easy-to-follow manner. But Microsoft® Office 365: A Skills Approach goes beyond the how and equips you with a deeper understanding of the what and the why. Too many times books have little value beyond the classroom. The Skills Approach series has been designed to be not only a complete textbook but also a reference tool for you to use as you move beyond academics and into the workplace.

Название: SPSS Statistics: A Practical Guide, 5th Edition
Автор: Kellie Bennett, Brody Heritage, Peter Allen
Издательство: Cengage Learning
Год: 2023
Страниц: 355
Язык: английский
Формат: pdf (true)
Размер: 41.6 MB

SPSS Statistics: A Practical Guide gives students step-by-step guidance through the process of using SPSS software to analyse, interpret and report on data. IBM SPSS Statistics is a flexible set of data analytic tools used throughout many disciplines. With SPSS Statistics: A Practical Guide we aim to introduce readers to a range of commonly used statistical procedures that can be performed with SPSS Statistics, and are typically included in the curricula of undergraduate applied statistics and research methodology units. Our approach is unashamedly practical, and highly visual. We take a hands-on approach to our subject matter, and work through each procedure in an illustrated, step-by-step fashion. Beyond the necessary focus on “doing”, we emphasise interpretation and reporting throughout this text, which contains hundreds of tables of tightly annotated SPSS Statistics output, and dozens of examples of how specific research findings can be communicated clearly and concisely.

Название: 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.