Название: Mastering SQL Joins: A Quick Handbook On Mastering SQL Joins With Practical Exercises
Автор: Dane Wade
Издательство: DataCeps
Год: 2023
Язык: английский
Формат: pdf, epub
Размер: 11.5 MB

Are you overwhelmed by SQL Joins?? Do you struggle to understand the concept of different SQL Joins? If Yes, then keep reading... Understanding the concept of SQL Joins is indeed a challenging task for many people. Combining data from multiple datasets and creating advanced queries leads to frustration and confusion. All you need is a resource that simplifies SQL joins and provides ample opportunities for practice. "Mastering SQL Joins: A Quick Handbook On Mastering SQL Joins With Practical Exercises" is your ultimate solution. This short handbook has everything you want to know about SQL as well as the hands-on challenges that'll equip you with skills to succeed. This book is not another dense theory-packed boring textbook filled with only technical jargon and fluff, which you need a computer science degree to understand. This is not just a textbook; this is an interactive practical handbook!

Название: Statistics and Data Science for Teachers
Автор: Anna Bargagliotti, Christine Franklin
Издательство: American Statistical Association
Год: 2021
Страниц: 248
Язык: английский
Формат: pdf
Размер: 34.9 MB

A main goal of Statistics and Data Science for Teachers is to provide teacher educators with a resource to guide entire courses and professional development, or portions of courses and professional development when preparing teachers of all school level grade levels to teach the foundations of statistics and data science in their classrooms. In supporting the spirit of Pre-K–12 Guidelines for Assessment and Instruction in Statistics Education II (GAISE II): A Framework for Statistics and Data Science Education, this book presents statistical ideas through investigations and engagement with the statistical problem-solving process of formulating statistical investigative questions, collecting/considering data, analyzing data, and interpreting results. The book is organized into three sections: 1) “Statistics as a Problem-Solving Process”; 2) “Toward Data Science”; 3) “Probability Unpacked”. Within each of these sections, standard topics of descriptive statistics, associations and relationships, distributions, probability, and sampling distributions are all developed.

Название: Halo dаta: Understanding and Leveraging the Value of your Data
Автор: Caroline Carruthers, Peter Jackson
Издательство: Facet Publishing
Год: 2023
Страниц: 180
Язык: английский
Формат: pdf, epub (true), mobi
Размер: 10.1 MB

The past two decades have seen an explosion both in the volume of data we use, and our understanding of its management. However, while techniques and technology for manipulating data have advanced rapidly in this time, the concepts around the value of our data have not. This lack of progress has made it increasingly difficult for organisations to understand the value in their data, the value of their data and how exploit that value. Halo Data proposes a paradigm shift in methodology for organisations to properly appreciate and leverage the value of their data. Written by an author team with many years' experience in data strategy, management and technology, the book will first review the current state of our understanding of data. This opening will demonstrate the limitations of this status quo, including a discussion on metadata and its limitations, data monetisation and data-driven business models. Following this, the book will present a new concept and framework for understanding and quantifying value in an organisation's data and a practical methodology for using this in practice. Ideal for data leaders and executives who are looking to leverage the data at their fingertips.

Название: Stream Processing: Hands-on with Apache Flink
Автор: Giannis Polyzos
Издательство: Leanpub
Год: 2023-08-10
Страниц: 234
Язык: английский
Формат: pdf (true), epub
Размер: 28.8 MB

Get onboard this journey into the land of streams. This is a complete hands-on book about Apache Flink, that follows real-life use cases and will help you learn how to create scalable end-to-end stream processing pipelines. This is a complete hands-on book about Apache Flink. The book follows real-life use cases and you will learn how to create end-to-end stream processing pipelines. We will be using Redpanda and Apache Kafka - along with other technologies - so an understanding of Apache Kafka and Redpanda concepts like topics/partitions and producers/consumers is nice to have. Apache Flink is the defacto solution when it comes to low-latency stream processing, but its unified API allows also for historic data processing with no code changes. Moreover, Flink is proven in production at an extremely large scale and it also has a rich ecosystem with a bright future ahead. The book is designed to teach you the theory and the practicals as fast as possible. The reader should be able to get from zero to production-ready applications fast with enough practice on the concepts introduced in the book, along with having enough knowledge to debug and troubleshoot when things go wrong.

Название: Реляционные базы данных в примерах. Практическое пособие для программистов и тестировщиков
Автор: Куликов Святослав
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 1.0.24)
Страниц: 425
Язык: русский
Формат: pdf, djvu
Размер: 16.1 MB

Эта книга посвящена практическому взгляду на реляционную теорию и проектирование реляционных баз данных. Здесь не рассматриваются такие фундаментальные основы, как реляционная алгебра и реляционное счисление, но с множеством примеров и пояснений показаны основные понятия и подходы, необходимые для проектирования баз данных. Все схемы баз данных в этой книге приведены в нотации UML 2.1, созданы с использованием Sparx Enterprise Architect и (если речь идёт об уровнях проектирования, для которых это актуально) ориентированы на MySQL 8.0, Microsoft SQL Server 2019, Oracle 18c. Скорее всего, приведённые решения будут успешно работать на более новых версиях этих СУБД, но не на более старых.

Название: Работа с MySQL, MS SQL Server и Oracle в примерах. 2-е издание. Практическое пособие для программистов и тестировщиков
Автор: Куликов Святослав
Издательство: EPAM Systems
Год: 26.07.2023 (Версия 2.0.28)
Страниц: 592
Язык: русский
Формат: pdf
Размер: 10.4 MB

Основное внимание в книге уделено практике использования SQL для решения типовых задач. В ней не рассматривается теория реляционных баз данных (предполагается, что вы с ней знакомы или сможете найти недостающую информацию), но представлено более 500 SQL-запросов: от базового выбора до использования представлений, триггеров, хранимых процедур и функций. Все примеры представлены в виде постановки и решения задач с использованием MySQL, MS SQL Server и Oracle, даны описания и анализ типичных ошибок. Все решения работают на MySQL Community Server 8.x, Microsoft SQL Server Express 2019 и Oracle 18c Express Edition и могут работать с более новыми версиями этих СУБД, но не будут работать со старыми версиями.

Название: Kafka Connect: Build and Run Data Pipelines (12th Early Release)
Автор: Mickael Maison, Kate Stanley
Издательство: O’Reilly Media, Inc.
Год: 2023-08-23
Страниц: 512
Язык: английский
Формат: pdf, mobi, epub (true)
Размер: 10.9 MB

Used by more than 80% of Fortune 100 companies, Apache Kafka has become the de facto event streaming platform. Kafka Connect is a key component of Kafka that lets you flow data between your existing systems and Kafka to process data in real time. With this practical guide, authors Mickael Maison and Kate Stanley show data engineers, site reliability engineers, and application developers how to build data pipelines between Kafka clusters and a variety of data sources and sinks. Connect allows you to quickly adopt Kafka by tapping into existing data and enabling many advanced use cases. No matter where you are in your event streaming journey, Kafka Connect is the ideal tool for building a modern data pipeline.

Название: Embedded and Real-Time Operating Systems, Second Edition
Автор: K. C. Wang
Издательство: Springer
Год: 2023
Страниц: 861
Язык: английский
Формат: pdf (true)
Размер: 43.2 MB

This book covers the basic concepts and principles of operating systems, showing how to apply them to the design and implementation of complete operating systems for embedded and real-time systems. It includes all the foundational and background information on ARM architecture, ARM instructions and programming, toolchain for developing programs, virtual machines for software implementation and testing, program execution image, function call conventions, run-time stack usage and link C programs with assembly code. Embedded and Real-Time Operating Systems describes the design and implementation of a complete OS for embedded systems in incremental steps, explaining the design principles and implementation techniques. For Symmetric Multiprocessing (SMP) embedded systems, the author examines the ARM MPcore processors, which include the SCU and GIC for interrupts routing and interprocessor communication and synchronization by Software Generated Interrupts (SGIs). This Second Edition covers ARM64 architecture and programming. These include exception levels, vector tables and exceptions handling, GICv3 programming and interrupt processing.

Название: Designing and Implementing Cloud-native Applications Using Microsoft Azure Cosmos DB: Study Companion for the DP-420 Exam
Автор: Steve Flowers
Издательство: Apress
Год: 2023
Страниц: 204
Язык: английский
Формат: pdf
Размер: 10.1 MB

This book will help prepare you for the Microsoft DP-420 exam. Whether you are new to Azure Cosmos DB or have experience working with the platform, Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB is organized to address the specific skills measured in the DP-420 exam. The topics covered include NoSQL models, code, and real-world scenarios aimed at helping you to understand and solve the case studies included in the exam. Beyond the exam, this book will assist you in your journey to adopt Microsoft Azure Cosmos DB for your own projects. You’ll learn what makes Azure Cosmos DB such a robust NoSQL service, as well as how NoSQL approaches help enable modern applications. You’ll also get practical guidance for your own implementations. The topics covered in this book are essential to knowing how to leverage the Cosmos DB service and provide best practices that will guide you to success both on the exam and in your career.

Название: Self-Service Analytics with Power BI: Learn how to build an end-to-end analytics solution in Power BI
Автор: Annu Roy, Rishiraj Deb, Gaurav Aroraa
Издательство: BPB Publications
Год: 2024
Страниц: 488
Язык: английский
Формат: pdf, epub
Размер: 44.6 MB

Transform raw data into actionable insights by collecting, cleaning, analyzing, and visualizing data. Data-driven culture is becoming increasingly important in modern enterprises, and self-service BI tools are making it easier for professionals to gain insights from data. This book serves as a practical and invaluable guide for all data-driven users, empowering them to gain insights rapidly and effortlessly, thereby enabling organizations to unlock the true potential of their data. This book is a practical guide that teaches readers how to use self-service BI tools to organize, clean, and analyze data. It offers step-by-step instructions on connecting to and refining data from various sources, including data lakes, data warehouses, cloud applications, and spreadsheets, including platforms such as Snowflake or Amazon Redshift. The book also provides expert guidance on smart data preparation and data discovery techniques, equipping you with a comprehensive understanding of all the capabilities and features of Power BI. Through practical examples, you will learn how to run, design, and test a wide array of analytics, along with insightful visualizations, heatmaps, and reports.