Название: Indexing Beyond the Basics Автор: Tobias Petry Издательство: Independently published Год: 2023 Язык: английский Формат: pdf (true), epub Размер: 20.7 MB
Learn to create indexes for your slow queries by following simple principles. Hi! I'm Tobias Petry, a full stack developer who used to suck at writing fast database queries. Whenever I had a slow query, I needed to ask more advanced developers for help and hope they had time for me. Like everyone, I always wished I could solve those problems on my own. But even after reading some tutorials I didn't get any closer to my goal. The number of queries I couldn't optimize by far exceeded the ones I could make faster. So I learned everything about databases over the next 10+ years from countless books, conferences, trainings, articles and much practice. Finally, I could fix any slow query entirely without help. But during my consulting work I found that most developers still face the same problem. The reason database indexes are still not understood by developers is the depth of the existing content. Whether it is books, articles or videos - they all have their own problems that limit the ability to understand database indexing. You are a developer who can write SQL queries but struggle with creating the correct indexes to make them fast. Neither do you have the time or interest to learn this topic in weeks - a couple evenings on the couch should be enough. You also just want to learn the practical knowledge necessary to complete your task and move on to other things. The content should avoid any technical complex database implementation details - you want the core information quickly, concisely and understandably.
Название: ADO.NET Data Access Technology With C# Автор: Theophilus Edet Издательство: CompreQuest Books Серия: Mastering Database Management Series Год: 2023 Страниц: 482 Язык: английский Формат: pdf Размер: 33.2 MB
Unlock the full potential of data access and supercharge your C# skills with our comprehensive course on ADO.NET. With 24 modules carefully crafted to guide you, this course empowers you to become a data-driven application development expert. Explore the intricacies of connecting to databases, master the art of working with data providers, and dive deep into Entity Framework. Discover the power of asynchronous data access and real-world case studies that put your skills to the test. Security is paramount in data access, and we'll show you the ropes in data access security, covering everything from authentication to encryption. But that's not all – we're taking you beyond the horizon with insights into emerging data access technologies, cloud-based data access, and the transformative world of serverless and microservices architecture. Your journey begins now. Enroll and embark on a transformational experience that will set you on the path to data mastery with C#. Don't miss out on this opportunity to take your skills to the next level.
Название: BPF: профессиональная оценка производительности Автор: Брендан Грегг Издательство: Питер Год: 2024 Страниц: 880 Язык: русский Формат: pdf Размер: 12,2 MB
Инструменты оценки производительности на основе BPF дают беспрецедентную возможность анализа систем и приложений. Вы сможете улучшить производительность, устранить проблемы в коде, повысить безопасность и сократить расходы. Книга «BPF: профессиональная оценка производительности» — ваш незаменимый гайд по применению этих инструментов. Брендан Грегг — эксперт и пионер проекта BPF — представляет более 150 готовых инструментов анализа и отладки, рекомендации по их применению, а также пошаговые инструкции по разработке ваших собственных инструментов. Вы узнаете, как анализировать процессоры, память, дисковый ввод/вывод, файловую систему, сети, языки программирования, приложения, контейнеры, гипервизоры, безопасность и ядро. Вы сможете выработать глубокое понимание того, как улучшить буквально любую Linux-систему или приложение. Иногда программисты говорят, что они «стряпают патч» («cook a patch»), а не «реализуют» (implement). Я начал увлекаться программированием еще в школе. Чтобы получить хороший код, программист должен выбрать лучшие «ингредиенты». Разные языки программирования предлагают множество разных строительных блоков — «ингредиентов», но когда дело доходит до программирования ядра Linux, то кроме самого ядра у вас ничего нет. В ядре Linux уже был похожий механизм, известный как BPF (Berkeley Packet Filter — пакетный фильтр Беркли), поддерживавший минимальный набор команд, которые можно использовать для фильтрации пакетов перед передачей их приложениям, таким как tcpdump.
Название: Getting Started with Enterprise Architecture: A Practical and Pragmatic Approach to Learning the Basics of Enterprise Architecture Автор: Eric Jager Издательство: Apress Год: 2023 Страниц: 280 Язык: английский Формат: pdf Размер: 10.2 MB
Implement a basic enterprise architecture from start to finish using a four stage wheel-based approach. Aided by real-world examples, this book shows what elements are needed for the initial implementation of a fundamental enterprise architecture. The book's pragmatic approach keeps existing architecture frameworks and methodologies in mind while providing instructions that are readable and applicable to all. The Enterprise Architecture Implementation Wheel builds on the methodology of existing architecture frameworks and allows you to apply the theory more pragmatically and closer to the reality that an architect encounters in daily practice. While the main focus of the book is the actual steps taken to design an enterprise architecture, other important topics include architecture origin, definition, domains, visualization, and roles. Getting Started with Enterprise Architecture is the ideal handbook for the architect who is asked to implement an Enterprise Architecture in an existing organization. For enterprise architects, project managers and executives.
Название: Big Data Computing: Advances in Technologies, Methodologies, and Applications Автор: Tanvir Habib Sardar, Bishwajeet Kumar Pandey Издательство: CRC Press Серия: Computational Intelligence Techniques Год: 2024 Страниц: 397 Язык: английский Формат: pdf (true) Размер: 15.0 MB
This book primarily aims to provide an in-depth understanding of recent advances in Big Data computing technologies, methodologies, and applications along with introductory details of Big Data computing models such as Apache Hadoop, MapReduce, Hive, Pig, Mahout in-memory storage systems, NoSQL databases, and Big Data streaming services such as Apache Spark, Kafka, and so forth. It also covers developments in Big Data computing applications such as Machine Learning, Deep Learning, graph processing, and many others. Big Data has become a critical issue for businesses to leverage their data assets to drive business decisions considering the exponential growth of data in today’s age. Machine Learning (ML) and Artificial Intelligence (AI) have emerged as powerful tools to extract insights and value from Big Data. Here we will explore a few of the key applications of ML and AI in Big Data. Predictive analytics is one of the most significant applications of ML in Big Data. It involves using existing data to predict future events or behaviors. Predictive analytics may be used to predict future sales, identify customers at risk of churning, or predict the likelihood of a customer purchasing a specific product . In predictive analytics, algorithms such as decision trees, random forests, and neural networks are commonly used.
Название: The Ultimate Guide to Functions in Power Query: Turn Raw Data into Actionable Insights Автор: Omid Motamedisedeh Издательство: Apress Год: 2024 Страниц: 410 Язык: английский Формат: pdf, epub Размер: 10.2 MB
This book is a complete guide to using functions in Power Query and is designed to help users of all skill levels learn and master its various functions. The Ultimate Guide to Functions in Power Query begins with an introduction to Power Query and an overview of the different types of functions available, along with detailed explanations of how to use each of them. You’ll see how to leverage power functions to process and transform large datasets from various sources and learn advanced techniques such as creating custom functions and using conditional statements. The book also covers best practices for using functions, including tips on how to optimize query performance and troubleshoot common errors. Using practical example applications, Author Omid Motamedisedeh demonstrates how to optimize your data processing workflows, saving time and boosting productivity. By the end of the book, readers will have a deep understanding of Power Query functions and be able to apply their knowledge to a wide range of data analysis tasks. For anyone who wants to learn how to use functions in Power Query to transform and analyze data. This includes data analysts, business analysts, Excel users, and data scientists. Readers should have a basic understanding of Excel and data analysis concepts, but may be new to Power Query and functions.
Название: Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization's Data, 4th Edition Автор: Michelle Malcher, Darl Kuhn Издательство: Apress Год: 2024 Страниц: 600 Язык: английский Формат: pdf, epub Размер: 20.6 MB
Master Oracle Database administration in both on-premises and cloud environments. This new edition covers the tasks you’ll need to perform to keep your databases stable, tuned, and running. The book also includes administrative tasks specific to cloud environments, including the Oracle Autonomous Database running in the Oracle Cloud Infrastructure. New in this edition is help for DBAs who are becoming involved in data management, and a look at the idea of a converged database and what that means in handling various data types and workloads. The book covers some of the machine learning features now in Oracle and shows how the same SQL that you know for database administration also helps you with data management tasks. The information in this book helps you to apply the right solution at the right time, mitigating risk and making robust choices that protect your data and avoid midnight phone calls. Data management is increasingly a DBA function, and DBAs are often called upon for help in getting data loaded into analytics environments such as a data lakehouse or a data mesh. This book addresses this fast-growing new role for database administrators and helps you build on your existing knowledge to make the transition into a new skill set that is in high demand. You’ll learn how to look at data optimization from the standpoint of data analysis and Machine Learning so that you can be seen as a key player in preparing your organization’s data for those type of activities. This book builds your skills as an Oracle Database administrator with the aim of helping you to be seen as a key player in data management as your organization pivots toward cloud computing and a greater use of Machine Learning and analytics technologies.
Название: Linux & Open Source Annual - Volume 9, 2024 Автор: Jon White (Editor) Издательство: Future Publishing Год: 2023 Страниц: 180 Язык: английский Формат: pdf Размер: 135.1 MB
Свободное программное обеспечение с открытым исходным кодом (FOSS) в последние годы стало международным феноменом. Философия FOSS, направленная на защиту свободы пользователей, отличает ее от многих коммерческих поставщиков программного обеспечения. Постоянно обновляясь и совершенствуясь, оно расширяет границы возможного в программном обеспечении, предоставляя вам свободу в других отношениях: создавать, взламывать (в смысле "взламывать"; ведите себя хорошо!), исследовать новые способы ведения дел. Мы вместили в этот ежегодник столько интересной информации, сколько смогли, включая самые горячие дистрибутивы и FOSS для широкого круга интересных и практических приложений. Эта коллекция - настоящий кладезь знаний о Linux и открытом коде, готовый к тому, чтобы вы сразу же приступили к работе. Итак, чего же вы ждете?
Название: Kafka Troubleshooting in Production: Stabilizing Kafka Clusters in the Cloud and On-premises Автор: Elad Eldor Издательство: Apress Год: 2023 Страниц: 229 Язык: английский Формат: pdf Размер: 10.1 MB
This book provides Kafka administrators, site reliability engineers, and DataOps and DevOps practitioners with a list of real production issues that can occur in Kafka clusters and how to solve them. The production issues covered are assembled into a comprehensive troubleshooting guide for those engineers who are responsible for the stability and performance of Kafka clusters in production, whether those clusters are deployed in the cloud or on-premises. This book teaches you how to detect and troubleshoot the issues, and eventually how to prevent them. Kafka stability is hard to achieve, especially in high throughput environments, and the purpose of this book is not only to make troubleshooting easier, but also to prevent production issues from occurring in the first place. The guidance in this book is drawn from the author's years of experience in helping clients and internal customers diagnose and resolve knotty production problems and stabilize their Kafka environments. The book is organized into recipe-style troubleshooting checklists that field engineers can easily follow when under pressure to fix an unstable cluster. This is the book you will want by your side when the stakes are high, and your job is on the line. For site reliability engineers tasked with maintaining stability of Kafka clusters, Kafka administrators who troubleshoot production issues around Kafka, DevOps and DataOps experts who are involved with provisioning Kafka (whether on-premises or in the cloud), developers of Kafka consumers and producers who wish to learn more about Kafka.
Название: AI-Based Data Analytics: Applications for Business Management Автор: Kiran Chaudhary, Mansaf Alam Издательство: CRC Press Год: 2024 Страниц: 261 Язык: английский Формат: pdf (true) Размер: 13.6 MB
This book covers various topics related to marketing and business analytics. It explores how organizations can increase their profits by making better decisions in a timely manner through the use of data analytics. This book is meant for students, practitioners, industry professionals, researchers, and academics working in the field of commerce and marketing, Big Data analytics, and organizational decision-making. This book is focused on Artificial Intelligence (AI), Data Analytics, Sentiment Analysis for social media, and various approaches to AI in Business Management. This is an emerging field that can increase the performance management domain to improve understanding of business and marketing dynamics that can lead to better strategic decision-making. In this book, we have also given a variety of marketing and business analytics strategies to solve market and organizational challenges. The use of AI in business and marketing analytics can help to create value by proper allocation of all available resources. By using various techniques and tools of Big Data analytics, we can improve the performance of the business. Data analytics is a vast discipline that encompasses a variety of methodologies and technologies. Predictive analytics, data mining, Machine Learning (ML), and Natural Language Processing (NLP) are included.
Разделы сайта
Авторизация
Реклама
