|
|
|
|
|
|
|
| |
|
Название: СУБД для программиста. Базы данных изнутри Автор: Тарасов С.В. Издательство: Солон-Пресс Год: 2015 Страниц: 320 ISBN: 978-2-7466-7383-0 Формат: PDF Размер: 12 Мб Язык: русский
Из классического определения «программы — это алгоритмы плюс данные» следует, что сколь веревочке не виться, пройдя через цепочку служб, запрос в итоге обрабатывается системой управления базами данных (СУБД) или ее неполнофункциональным аналогом. Активно развивающийся рынок мобильных устройств широко использует встраиваемые (embedded) СУБД, ранее применявшиеся в основном для управления оборудованием. |
Разместил: MIHAIL62 3-08-2022, 13:56 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Querying SQL Server. Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified analytics Автор: Adam Aspin Издательство: BPB Online Год: 2022 Формат: True ePUB Страниц: 622 Размер: 11 Mb Язык: English
This book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data. The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides readers through the process of building queries, using simple and then more complex table joins and progressively more advanced data filtering, to deliver advanced queries based on a variety of SQL techniques. The reader will understand how to deliver relevant and trustworthy analysis of the data through learning how to apply fundamental computations in T-SQL, relational logic, and how to group and aggregate data. There is also coverage of other SQL concepts, such as formatting queries, writing subqueries, creating derived tables, joining and filtering tables, etc. In addition to that, the book discusses how to conduct rolling analyses, examine time-series data, and manage large and complex datasets. |
Разместил: vitvikvas 3-08-2022, 13:54 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries Автор: Adam Aspin Издательство: BPB Online Год: 2022 Формат: True ePUB Страниц: 674 Размер: 10 Mb Язык: English
This book will take you on an interactive journey to understand SQL querying from the most basic to the most expert level utilising a variety of SQL techniques to extract relevant insights from your MySQL databases. The first section of this book serves as an introduction to the fundamental ideas of both SQL and MySQL. It then walks readers through constructing queries using simple and then more sophisticated table joins and gradually more advanced data filtering to produce advanced queries based on a range of SQL techniques. The reader will better understand MySQL database analysis by mastering the fundamentals of SQL computation, relational logic, and data grouping and aggregation. SQL fundamentals such as query formatting, constructing subqueries, generating derived tables, joining and filtering tables, etc., are also covered. In addition, the book explains how to do rolling analysis, study time-series data, and manage huge and complex MySQL datasets. |
Разместил: vitvikvas 3-08-2022, 13:43 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: MySQL Cookbook, 4th Edition Автор: Sveta Smirnova and Alkin Tezuysal Издательство: O’Reilly Media Год: 2022 Формат: ePUB, PDF Страниц: 1401 Размер: 10 Mb Язык: English
For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to resolve MySQL problems from scratch.
In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. |
Разместил: vitvikvas 3-08-2022, 06:26 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: SQL. Сборник рецептов, 2-е издание Автор: Роберт де Грааф, Энтони Молинаро Издательство: БХВ-Петербург Год: 2022 Формат: pdf Страниц: 594 Для сайта: Mirknig.su Размер: 39,1 Мб Язык: русский
Рассмотрены готовые рецепты для решения практических задач при работе с СУБД Oracle, DB2, SQL Server, MySQL и PostgreSQL. Описаны извлечение записей из таблиц, сортировка результатов запросов, принципы работы с несколькими таблицами, обработка запросов с метаданными. Рассказывается о способах поиска данных средствами SQL,о составлении отчетов и форматировании результирующих множеств, работе с иерархическими запросами. Рассматривается использование оконных функций, обобщенных табличных выражений (ОТВ), сбор данных в блоки, формирование гистограмм, текущих сумм и подсумм, агрегация скользящего диапазона значений. Описан обход строки и ее синтаксический разбор на символы, приведены способы упрощения вычислений внутри строки. |
Разместил: relizer 26-07-2022, 11:23 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Linux for Small Business Owners: Using Free and Open Source Software to Power your Dreams Автор: David Both, Cyndi Bulka Издательство: Apress Год: 2022 Формат: True PDF Страниц: 391 Размер: 18,6 Mb Язык: English
Learn how you can take complete control and run your small business with powerful, free open source software (FOSS). This book introduces small business owners to the power and security of Linux and other FOSS tools to manage any small business as well as the many advantages it has over expensive, proprietary software. While exploring the reasons for using Free Open Source Software, you'll investigate the assertion that, “The value of any software lies in its usefulness not in its price,” set forth by Linux Torvalds, the creator of Linux. This book examines the use of Linux and also the other Free Open Source Software you need to meet your business challenges including the usual accounting, Email, web browsing, word-processing tasks. You will be introduced to advanced tools such as those that enable you to create audio and video clips you can use to promote your business or that can even be your primary product, such as how-to instruction. |
Разместил: vitvikvas 24-07-2022, 17:34 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Statistical Hypothesis Testing with Microsoft Office Excel Автор: Robert Hirsch Издательство: Springer Год: 2022 Формат: True PDF, ePUB Страниц: 94 Размер: 10 Mb Язык: English
This book provides a comprehensive treatment of the logic behind hypothesis testing. Readers will learn to understand statistical hypothesis testing and how to interpret P-values under a variety of conditions including a single hypothesis test, a collection of hypothesis tests, and tests performed on accumulating data. The author explains how a hypothesis test can be interpreted to draw conclusions, and descriptions of the logic behind frequentist (classical) and Bayesian approaches to interpret the results of a statistical hypothesis test are provided. Both approaches have their own strengths and challenges, and a special challenge presents itself when hypothesis tests are repeatedly performed on accumulating data. Possible pitfalls and methods to interpret hypothesis tests when accumulating data are also analyzed. This book will be of interest to researchers, graduate students, and anyone who has to interpret the results of statistical analyses. |
Разместил: vitvikvas 22-07-2022, 16:50 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Security and Artificial Intelligence: A Crossdisciplinary Approach Автор: Editors: Lejla Batina, Thomas Back, Ileana Buhan, Stjepan Picek Издательство: Springer Год: 2022 Страниц: 365 Размер: 11.55 МБ Формат: PDF Язык: English
AI has become an emerging technology to assess security and privacy, with many challenges and potential solutions at the algorithm, architecture, and implementation levels. So far, research on AI and security has looked at subproblems in isolation but future solutions will require sharing of experience and best practice in these domains. |
Разместил: ak5812 21-07-2022, 18:56 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: SQL за 10 минут, 5-е издание Автор: Бен Форта Издательство: Диалектика-Вильямс Год: 2021 Формат: pdf Страниц: 335 Для сайта: Mirknig.su Размер: 63,6 Мб Язык: русский
В книге SQL за 10 минут предлагаются простые и практичные решения для тех, кто хочет быстро получить результат. Проработав все 22 урока, на каждый из которых придется затратить не более 10 минут, вы узнаете обо всем, что необходимо для практического применения SQL. Приведенные в книге примеры подходят для IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB и Apache OpenOffice Base. |
Разместил: relizer 21-07-2022, 17:42 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: Windows 365 For Dummies Автор: Rosemarie and Ken Withee Издательство: For Dummies Год: 2022 Формат: True PDF Страниц: 339 Размер: 25 Mb Язык: English
Microsoft’s newest cloud-based operating system allows you to access your PC from any device. Windows 365 For Dummies teaches you the ins and outs of this game-changing OS. You’ll learn how to make the most of Windows 365—get your work done, share documents and data, monitor storage space, and do it all with increased security. Oh, and did we mention you can do it from literally anywhere? Dummies will help you wrap your mind around cloud computing with Windows 365, so you can pick up with your files, data, and settings right where you left off, no matter where you are. |
Разместил: vitvikvas 21-07-2022, 15:32 | Комментарии: 0 | Подробнее
| | | |
|
| |
br>
|