Название: Learn SQL Quickly: A Beginner’s Guide to Learning SQL, Even If You’re New to Databases
Автор: Code Quickly
Издательство: Code Quickly
Год: 2020
Страниц: 235
Язык: английский
Формат: pdf, azw3, epub
Размер: 17.4 MB

The information era is upon us, and the ability to organize and make sense of data has become an invaluable skill. Have you been hearing about data, databases, or SQL, and wondering what they are all about? Or perhaps you have just gotten a new job and need to learn SQL fast. If so, this book is for you. You no longer have to feel lost and overwhelmed by all of the fragmented tutorials online, nor do you have to waste your time and money learning SQL from lengthy books and expensive online courses.

Название: SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases
Автор: Antonio Badia
Издательство: Springer
Год: 2020
Формат: PDF
Страниц: 296
Размер: 10 Mb
Язык: English

This textbook explains SQL within the context of data science and introduces the different parts of SQL as they are needed for the tasks usually carried out during data analysis. Using the framework of the data life cycle, it focuses on the steps that are very often given the short shift in traditional textbooks, like data loading, cleaning and pre-processing.

Название: Excel Dynamic Arrays Straight to the Point, 2nd Edition
Автор: Bill Jelen
Издательство: Holy Macro! Books
Год: 2020
Формат: PDF, EPUB
Страниц: 90
Размер: 14,3 Mb
Язык: English

New for Office 365 customers, one single formula sitting in one single cell can return many results. Those extra results will spill into adjacent cells. This is a major change to the calculation engine in Excel. This book covers the new functions added for Dynamic Arrays: SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY. It shows how Dynamic Arrays make the new XLOOKUP even more powerful. Dynamic arrays make every Excel calculation function more powerful. Pass a SEQUENCE to another function and Excel will Lift the function to return many results. Learn how to use the new # and @ operators in your formulas. After fifteen months of preview, the Dynamic Arrays are reaching general availability. Learn how the FastExcel SpeedTools add-in offers much-needed improvements, such as TOTALS, SLICES, VSTACK and UNPIVOT. Join in lobbying the Excel team to incorporate these improvements.

Название: VMware' Certified Professional Data Center Virtualization on vSphere 6.7 Study Guide: Exam 2V0-21.19
Автор: Jon Hall, Joshua Andrews
Издательство: Wiley
Год: 2021
Формат: True PDF
Страниц: 637
Размер: 53.2 Mb
Язык: English

Master vSphere 6 virtualization with hands-on practice and bonus preview exams
VCP6-DCV: VMware Certified Professional-Data Center Virtualization on vSphere 6 Study Guide is your ultimate guide to preparing for exam 2VO-621. This Study Guide provides 100% coverage of all exam objectives and offers a unique set of study tools including assessment tests, objective map, real-world scenarios, hands-on exercises, and much more so you can be confident come exam day. You will also receive access to the superior Sybex interactive online learning environment that provides additional study tools including electronic flashcards and bonus practice exams.

Название: Секреты Linux
Автор: Леонов В.
Издательство: Эксмо
ISBN: 978-5-699-40128-4
Серия: Компьютер на 100%
Год: 2010
Формат: PDF
Страниц: 335
Размер: 20.9 MB
Язык: Русский

Операционные системы Linux обладают понятным и удобным интерфейсом, отличным быстродействием, высоким уровнем безопасности и надежности.
В данной книге вы познакомитесь с тремя разными дистрибутивами Linux: Ubuntu, Mandriva и Fedora. Далее вы сможете выбрать наиболее понравившийся и подходящий для ваших нужд.
Вы научитесь устанавливать операционную систему на компьютер, настраивать ее интерфейс, сетевые соединения, а также познакомитесь с некоторыми программами (кстати, тоже бесплатными), входящими в состав этих дистрибутивов.

Название: Applications of Data Mining in Engineering, Management and Medicine
Автор: Neha Kaul
Издательство: Arcler Press
Год: 2019
Формат: PDF
Страниц: 300
Размер: 46,83 МБ
Язык: English

Applications of Data Mining in Engineering, Management and Medicine has been broadly divided into four sections. According to some industry specialists, ‘Data is the new gold’ and has numerous applications in each and every field of industry, be it the engineering, medicine or management. The need of data mining in engineering, management and medicine is due to the fact that, these industries generate data in large quantities and data mining has made the job very efficient and quick.

Название: Windows 7. Справочник администратора
Автор: Станек Уильям Р.
Издательство: Русская Редакция, БХВ-Петербург
ISBN: 978-5-7502-0399-4, 978-5-9775-0587-1
Год: 2010
Формат: PDF
Страниц: 715
Размер: 14.9 MB
Язык: Русский

Эта книга - подробный справочник по администрированию новейшей клиентской операционной системы от Microsoft Windows 7. В ней содержатся сведения об архитектуре системы, описание ее установки и развертывания, а также работы в средах Windows PE и Windows RE. Детально рассказывается об управлении Windows 7, об использовании групповой политики, об автоматической и ручной настройке системы, о настройке рабочего стола и панели задач. Приводятся сведения о настройке и контроле учетных записей пользователей и групп, об организации входа в систему и о работе в компьютерных сетях. Отдельные главы посвящены вопросам установки оборудования и программного обеспечения, управлению дисками и другими накопителями, а также использованию новых технологий — TPM и шифрованию BitLocker. Особое внимание уделено вопросам производительности системы, безопасности данных, а также их архивации и восстановлению. Кроме того, специально рассматривается использование Window 7 на мобильных компьютерах.

Название: Oracle 19c Database Administration: Oracle Simplified
Автор: Tanveer A.
Издательство: Amazon.com Services LLC
Год: 2020
Страниц: 428
Язык: английский
Формат: pdf, epub
Размер: 14.9 MB

Oracle Database 19c is the final, and therefore 'long term support' releaseof the Oracle Database 12c family of products (which includes Oracle Database 18c). Oracle Database 19c builds upon the innovations of previous releases such as Multitenant, In-Memory, JSON support, Sharding and many other features that enable Oracle’s Autonomous Database Cloud Services. This latest release of the world’s most popular database also introduces new functionality, providing customers with a multi-model enterprise-class database for all their typical use cases.

Название: Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud
Автор: de Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic
Издательство: Apress
Год: 2021
Формат: EPUB, PDF
Страниц: 351
Размер: 11,5 Mb
Язык: English

Here is the expert-level, insider guidance you need on using Azure SQL Database as your back-end data store. This book highlights best practices in everything ranging from full-stack projects to mobile applications to critical, back-end APIs. The book provides instruction on accessing your data from any language and platform. And you learn how to push processing-intensive work into the database engine to be near the data and avoid undue networking traffic. Azure SQL is explained from a developer's point of view, helping you master its feature set and create applications that perform well and delight users.

Название: Design with MongoDB: Best models for applications
Автор: Alessandro Fiori, Silvia Chiusano
Издательство: Independently published
Год: 2020
Страниц: 107
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

The world of NoSQL databases is constantly evolving. Many applications are adopting these new technologies to provide developers with increasingly powerful tools. One of their prominent hallmarks is the freedom from having to define a database model ahead - a feature known as being "schemaless". MongoDB, the market leader in NoSQL document databases, has made this feature its strong point. An unprecedented level of flexibility makes MongoDb an incredibly powerful tool, but may likewise compromise performance, if not properly tamed. The design of database models, therefore, becomes fundamental to achieving the best performance. In this book we will analyze some use cases and identify optimal modeling patterns, by taking into account the constraints of the application context.