Название: 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
Название: 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.
Название: 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.
Название: 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, и предоставляет простые пошаговые руководства, которые помогут вам начать свою работу.
Название: 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 Автор: 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.
Бесплатная электронная библиотека. Скачать книги бесплатно!
Наша электронная библиотека Bookskeeper (для РФ работает через VPN) - это интернет-витрина, где любой посетитель может публиковать электронные варианты книг, журналов, газет, комиксов, в общем, любой литературы со ссылками для медленного, но бесплатного скачивания с файлообменников.
В нашем книжном хранилище Вы всегда найдете литературу на любой вкус человека любого возраста - от детских комиксов и расскрасок до серьезной научной литературы.
|