PostgreSQL 14 Internals

Автор: literator от 4-07-2023, 17:10, Коментариев: 0

Категория: КНИГИ » ОС И БД

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

Автор: literator от 3-07-2023, 20:18, Коментариев: 0

Категория: КНИГИ » ОС И БД

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

Автор: literator от 3-07-2023, 15:11, Коментариев: 0

Категория: КНИГИ » ОС И БД

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

Автор: literator от 2-07-2023, 17:33, Коментариев: 0

Категория: КНИГИ » ОС И БД

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

Автор: literator от 1-07-2023, 18:20, Коментариев: 0

Категория: КНИГИ » ОС И БД

Enterprise Integration with Mulesoft: Learn how to leverage MuleSoft to power Enterprise IntegrationНазвание: 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)

Автор: literator от 1-07-2023, 08:44, Коментариев: 0

Категория: КНИГИ » ОС И БД

Think Like a Data Analyst (MEAP v2)Название: 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

Автор: literator от 1-07-2023, 06:26, Коментариев: 0

Категория: КНИГИ » ОС И БД

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

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

 

SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management, 2nd Edition

Автор: literator от 30-06-2023, 15:18, Коментариев: 0

Категория: КНИГИ » ОС И БД

SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management, 2nd EditionНазвание: SQL and NoSQL Databases: Modeling, Languages, Security and Architectures for Big Data Management, 2nd Edition
Автор: Michael Kaufmann, Andreas Meier
Издательство: Springer
Год: 2023
Страниц: 263
Язык: английский
Формат: pdf (true), epub
Размер: 42.1 MB

This textbook offers a comprehensive introduction to relational (SQL) and non-relational (NoSQL) databases. The authors thoroughly review the current state of database tools and techniques and examine upcoming innovations. In the first five chapters, the authors analyze in detail the management, modeling, languages, security, and architecture of relational databases, graph databases, and document databases. Moreover, an overview of other SQL- and NoSQL-based database approaches is provided. In addition to classic concepts such as the entity and relationship model and its mapping in SQL database schemas, query languages or transaction management, other aspects for NoSQL databases such as non-relational data models, document and graph query languages (MQL, Cypher), the Map/Reduce procedure, distribution options (sharding, replication) or the CAP theorem (Consistency, Availability, Partition Tolerance) are explained.
 

Data Science Using JDBC And MySQL With Object Oriented Approach and Apache Netbeans IDE

Автор: literator от 30-06-2023, 06:31, Коментариев: 0

Категория: КНИГИ » ОС И БД

Data Science Using JDBC And MySQL With Object Oriented Approach and Apache Netbeans IDEНазвание: Data Science Using JDBC And MySQL With Object Oriented Approach and Apache Netbeans IDE
Автор: Vivian Siahaan, Rismon Hasiholan Sianipar
Издательство: Balige Publishing
Год: 2023
Страниц: 734
Язык: английский
Формат: epub
Размер: 18.0 MB

JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database. This book uses the Sakila sample database which is a fictitious database designed to represent a DVD rental store. The 15 tables of the database include film, film_category, actor, customer, rental, payment and inventory among others. The Sakila sample database is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. You can download the sample database from site. In this project, you will design the form for every table and you will plot: top 10 film distribution by release year; top 10 film distribution by rating; top 10 film distribution by rental duration; top 10 film distribution by language; film distribution by categorized rental rate; film distribution by categorized length; film distribution by categorized replacement cost; top 10 film distribution by actor name; top 10 actor name distribution by average rental rate, etc.

 

Windows 11 Tips, Tricks & Shortcuts in easy steps

Автор: literator от 29-06-2023, 15:22, Коментариев: 0

Категория: КНИГИ » ОС И БД

Windows 11 Tips, Tricks & Shortcuts in easy stepsНазвание: Windows 11 Tips, Tricks & Shortcuts in easy steps
Автор: Nick Vandome
Издательство: In Easy Steps Limited
Год: 2023
Страниц: 130
Язык: английский
Формат: epub
Размер: 17.1 MB

Windows 11 Tips, Tricks & Shortcuts in easy steps provides over 1000 tips, tricks and keyboard shortcuts to help you save time and use your Windows 11 PC more efficiently. Using the full potential of Windows 11 can sometimes seem like a daunting task, even when you have mastered the basics of the operating system. However, with Windows 11 Tips, Tricks and Shortcuts in easy steps you can start to take your Windows 11 knowledge to the next level. Over 1000 useful tricks of the trade to make Windows work more efficiently for you, all revealed in this book, and updated for Windows 11. With keyboard shortcuts throughout to help you save time, this popular guide is a great investment for all Windows 11 users!