Название: Базы данных. Практическое применение СУБД SQL и NoSOL-типа для применения проектирования информационных систем
Автор: Мартишин С.А., Симонов В.Л., Храпченко М.В.
Издательство: Инфра-М, Форум
Год: 2022
Страниц: 368
Язык: русский
Формат: pdf
Размер: 69.0 MB

Учебное пособие предназначено для изучения практического применения СУБД SQL и NoSQL-типа при проектировании информационных систем. Проведены аналогии между базами данных SQL и NoSQL-типа. Полученные теоретические знания закрепляются при выполнении цикла лабораторных работ. Работа с SQL СУБД изучается на примере СУБД MariaDB, рассмотрен вопрос использования хорошо зарекомендовавших себя в работе с MySQL приложений (например, phpMyAdmin, MySQL Workbench). Работа с NoSQL СУБД изучается на примере СУБД MongoDB с использованием оболочки Robomongo. Показана возможность использования универсального менеджера баз данных DBeaver для одновременной работы с СУБД MariaDB и MongoDB. Приведены примеры информационных систем на базе обоих типов СУБД SQL и NoSQL. Предназначено для студентов, бакалавров, магистрантов, аспирантов и специалистов в области проектирования информационных систем и баз данных. Пособие также полезно для лиц, занимающихся самообразованием.

Название: SQL Server. Наладка и оптимизация для профессионалов
Автор: Дмитрий Короткевич
Издательство: Питер
Год: 2023
Страниц: 512
Язык: русский
Формат: pdf
Размер: 10.26 MB

Исчерпывающий обзор лучших практик по устранению неисправностей и оптимизации производительности Microsoft SQL Server. Специалисты по базам данных, в том числе разработчики и администраторы, научатся выявлять проблемы с производительностью, системно устранять неполадки и расставлять приоритеты при тонкой настройке, чтобы достичь максимальной эффективности. Книга посвящена внутреннему устройству SQL Server, но теперь она лаконичнее и практичнее моих предыдущих работ. Она научит вас эффективно обнаруживать и устранять типичные проблемы при работе с SQL Server, не перегружая лишней информацией. Книга также покажет, в каком направлении двигаться, если вы хотите узнать еще больше. Здесь описана методология, которую используют многие консультанты мирового уровня по SQL Server. Вы научитесь собирать и анализировать данные, выявлять узкие места и очаги неэффективности. Что еще более важно, я покажу, как рассматривать систему целостно и «видеть лес за деревьями». Содержание книги не привязано к какой-либо конкретной версии SQL Server.

Название: Excel In 7 Days: Master Excel Features & Formulas. Become A Pro From Scratch In Just 7 Days With Step-By-Step Instructions, clear illustrations, and practical examples
Автор: Paul Slatkin
Издательство: Independently published
Год: 2023
Страниц: 310
Язык: английский
Формат: epub (true)
Размер: 10.2 MB

Do you want to fast master Excel? Do you desire to understand any Excel fundamental, formula, or function in order to carry out your duties at work effectively and relieve stress and anxiety? Do you want to harness all of Excel's capabilities to solve issues faster than ever? Studies show a 15% increase in your probability of being hired if you have certified Excel skills because they have become vital in almost every office job. Administrative Assistants, Accountants, Financial Analysts, Cost Estimators, and so many others need high skills in Excel to do their jobs quickly and effectively without feeling pressured or stressed. Unfortunately, many people like you know how to use only a few basic Excel functions, and often not even very well. This leads to wasting valuable time and constantly feeling late to complete your tasks. Thanks to Paul Slatkin, who has packed all his knowledge into this straightforward and easy-to-follow guide, you will get away from that feeling of always being overwhelmed by work and frustrated.

Название: Breaking Ransomware: Explore ways to find and exploit flaws in a ransomware attack
Автор: Jitender Narula, Atul Narula
Издательство: BPB Publications
Год: 2023
Страниц: 285
Язык: английский
Формат: epub (true)
Размер: 23.1 MB

Crack a ransomware by identifying and exploiting weaknesses in its design. Ransomware is a type of malware that is used by cybercriminals. So, to break that malware and find loopholes, you will first have to understand the details of ransomware. If you are looking to understand the internals of ransomware and how you can analyze and detect it, then this book is for you. This book starts with an overview of ransomware and its building blocks. The book will then help you understand the different types of cryptographic algorithms and how these encryption and decryption algorithms fit in the current ransomware architectures. This book is for cybersecurity professionals and malware analysts who are responsible for mitigating malware and ransomware attacks. This book is also for security professionals who want to learn how to prevent, detect, and respond to ransomware attacks. Basic knowledge of C/C++, x32dbg and Reverse engineering skills is a must.

Название: Advanced techniques for collecting statistical data
Автор: Olga Moreira
Издательство: Arcler Press
Год: 2023
Страниц: 412
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

“Advanced Techniques for Collecting Statistical Data” is an edited book consisting of 17 contemporaneous articles focused on data collection methods, from qualitative research techniques to automated data collection systems. The first chapters include a practical guide to designing, sampling, and collecting qualitative research data. The second part of the book is devoted to data mining of information collected from clinical and social studies surveys, as well as from social media. The final chapters reflect on current efforts to optimize and automate data collection procedures. This book also includes new methodologies based on automatic data collection and analysis systems based on smartphone technology and Artificial Intelligence (AI), as well as their application in clinical research, sociology, stock market prediction and other fields. This book is intended to reach an academic audience ranging from undergraduate students to junior researchers.

Название: Learn PostgreSQL From Basics: A Complete Guide To Learn PostgreSQL Quickly For Absolute Beginners
Автор: Silas Burch
Издательство: Independently published
Год: 2023
Страниц: 106
Язык: английский
Формат: epub
Размер: 10.2 MB

This book will help you build efficient and fault-tolerant PostgreSQL applications. You'll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You'll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed. As you progress through the chapters, you'll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you'll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases. By the end of this PostgreSQL book, you'll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

Название: The creation and management of database systems
Автор: Adele Kuzmiakova
Издательство: Arcler Press
Год: 2023
Страниц: 262
Язык: английский
Формат: pdf (true)
Размер: 21.2 MB

This book on creation and management of database systems provides an in-depth analysis of several real-world examples of database applications. This textbook offers a clear and comprehensive overview of the fundamentals, principles, and, in particular, sophisticated instrumentation techniques used in database systems. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource.The book examines different database concepts, principles, design, implementation, and management challenges. Each chapter is carefully divided into concise, reader-friendly chunks, with itemization of the key elements to remember. It solves database system challenges in a methodical and pragmatic manner. Diagrams and pictures can also be used to summarise key topics in order to improve learning. This book does an outstanding job of providing an overview of the many different aspects of database systems. The book is intended for all the readers from multidisciplinary backgrounds. In the recent past, SQL has emerged as the dominant language for relational database management systems (RDBMSs).

Название: Data analysis and Information processing
Автор: Jovan Pehcevski
Издательство: Arcler Press
Год: 2023
Страниц: 420
Язык: английский
Формат: pdf (true)
Размер: 30.0 MB

This book covers different topics from data analysis and information processing, including data analytics methods, big data methods, data mining methods, and information processing methods. Section 1 focuses on data analytics methods, describing data analytics in mental healthcare, a case study on data analytics and machine learning accuracy, a survey from a Big Data perspective on data modeling and data analytics, Big Data analytics for business intelligence in accounting and audit, and a knowledge-based approach on Big Data analytics in immunology. Section 2 focuses on big data methods, describing an integrated real-time big data stream sentiment analysis service, the influence of big data analytics in the industry, big data usage in the marketing information systems, a review of big data for organizations, and an application research of big data technology in audit field.

Название: Building Regression Models with SAS: A Guide for Data Scientists
Автор: Robert N. Rodriguez
Издательство: SAS Institute Inc.
Год: 2023
Страниц: 464
Язык: английский
Формат: pdf (true)
Размер: 17.7 MB

Advance your skills in building predictive models with SAS! Building Regression Models with SAS: A Guide for Data Scientists teaches data scientists, statisticians, and other analysts who use SAS to train regression models for prediction with large, complex data. Each chapter focuses on a particular model and includes a high-level overview, followed by basic concepts, essential syntax, and examples using new procedures in both SAS/STAT and SAS Viya. Machine Learning has created a new divide for the practice of statistics, which relies heavily on data from well-designed studies for modeling and inference. Statistical methods now vie with algorithms that learn from large amounts of observational data. This book assumes you know the basics of regression analysis. It uses standard matrix notation for regression models but explains the concepts and methods behind the procedures without mathematical derivations. For readers who want to dive into the technical aspects of concepts and algorithms, explanations are given in appendices which use calculus and linear algebra at the level expected by master of science programs in Data Science and statistics.

Название: Chromebook Tricks and Tips - 7th Edition 2023
Издательство: Papercut
Год: 2023
Страниц: 98
Формат: PDF
Размер: 51 MB
Язык: English

Chromebook Tricks and Tips is the one stop user guide for the new Google powered laptop computer adopter or those want to learn everything you’ll need to get started with Google’s hardware. This independent manual is crammed with helpful guides and step-by-step fully illustrated tutorials, written in plain easy to follow English. Over the pages of this publication you will clearly learn everything you need to know about your Chromebook and it’s apps. With this unofficial instruction manual at your side no problem will be unsolvable, no question unanswered as you learn, explore and enhance your Google Chromebook user experience.