Название: Mastering SEQUENCE: Excel's most amazing function with more than 200 examples
Автор: Meni Porat
Издательство: BPB Publications
Год: 2023
Страниц: 248
Язык: английский
Формат: pdf (true)
Размер: 74.3 MB

The definitive guide to data sequencing and manipulation in Excel. The SEQUENCE function in Excel 365 allows you to generate sequences of numbers or values based on specific criteria. By utilizing this function, you can effectively manage a wide range of numerical and data manipulation tasks. If you're looking to leverage its dynamic capabilities to enhance your productivity, this book is an ideal resource for you. This book provides the most comprehensive coverage of the SEQUENCE function, which is widely considered the most versatile function in Excel 365. It serves as a detailed introduction to the new Dynamic Array Functions, offering examples for a better understanding of this new revolutionary concept. Additionally, the book delves into the extensive applications of SEQUENCE in various areas, including text functions, number manipulation, arrays, date and time operations, financial calculations, math, and complex formulae involving SEQUENCE, with a special focus on the LAMBDA. With over 200 examples, this book allows you to actively engage and explore the multifaceted dynamism of the SEQUENCE function.

Название: Windows 10 Tricks and Tips - 15th Edition, 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Язык: английский
Формат: pdf
Размер: 37.4 MB

"Трюки и советы по Windows 10" - это первый и единственный выбор для пользователей, которые только начинают работать с Windows 10 и хотят узнать все, что им нужно знать для работы с новой операционной системой. Это отдельное руководство содержит множество полезных советов и пошаговых иллюстрированных инструкций, написанных на понятном английском языке. В этом совершенно новом руководстве пользователя вы узнаете все, что вам нужно знать, начиная с работы из коробки и заканчивая освоением более сложных функций и обширной справкой. С помощью этого неофициального руководства вы сможете решить любую проблему и получить ответы на любой вопрос.

Название: Data Analysis : A Gentle Introduction for Future Data Scientists
Автор: Graham Upton, Dan Brawn
Издательство: Oxford University Press
Год: 2023
Страниц: 161
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

Data analysis has been a hot topic for a number of years, and many future data scientists have backgrounds that are relatively light in mathematics. This slim volume provides a very approachable guide to the techniques of the subject, designed with such people in mind. Formulae are kept to a minimum, but the book's scope is broad, introducing the basic ideas of probability and statistics and more advanced techniques such as generalised linear models, classification using logistic regression, and support-vector machines. An essential feature of the book is that it does not tie to any particular software. The methods introduced in this book could also be implemented using any other statistical software and applying any major statistical package. Academically, the book amounts to a first course, practical for those at the undergraduate level, either as part of a mathematics/statistics degree or as a data-oriented option for a non-mathematics degree. As a data scientist you will be using the computer to perform the data analysis. Any programming language should be able to carry out the analyses that we describe. We used R (because it is free); our code is available as an accompaniment to the book.

Название: PostgreSQL for Jobseekers: Introduction to PostgreSQL administration for modern DBAs
Автор: Sonia Valeja, David Gonzalez
Издательство: BPB Publications
Год: 2023
Страниц: 318
Язык: английский
Формат: pdf (true)
Размер: 28.5 MB

A practical guide that will help you learn and leverage PostgreSQL's core features. PostgreSQL is a powerful open-source relational database management system (RDBMS) that is widely used in the industry. If you are seeking to acquire knowledge about PostgreSQL, this book is for you. This comprehensive book provides you with a solid foundation in working with PostgreSQL, a popular open-source database management system. It covers a broad spectrum of topics, allowing you to successfully install and configure PostgreSQL across various platforms and methods. By delving into the internal components that constitute a PostgreSQL service and their interplay, you will gain a deep understanding of how these elements collaborate to deliver a robust and dependable solution. From comprehending the process model and shared memory to mastering query execution and optimization, you will acquire comprehensive knowledge of PostgreSQL's internal workings. Furthermore, the book explores essential tasks performed by a database administrator (DBA), including backup and restore operations, security measures, performance tuning, and troubleshooting techniques. Lastly, it explores widely used extensions and compatible tools that can enhance the functionality of PostgreSQL.

Название: MongoDB for Jobseekers: Reach new heights in your career with MongoDB
Автор: Justin Jenkins
Издательство: BPB Publications
Год: 2023
Страниц: 432
Язык: английский
Формат: pdf (true)
Размер: 38.5 MB

Unlock a world of job opportunities and accelerate your career growth by mastering MongoDB. MongoDB for Jobseekers serves as the ultimate companion, providing assistance and support throughout your entire MongoDB learning journey. Whether you are an experienced professional exploring new career paths or an aspiring jobseeker looking to enhance your opportunities, this comprehensive guide is specifically designed to cater to your needs. From the basics to advanced concepts, MongoDB for Jobseekers offers a well-structured approach to understanding the intricacies of this powerful NoSQL database. The book then delves into subjects like schema modeling, querying, indexing, and scalability, and discovers the reasons behind MongoDB's widespread popularity. Through clear and practical examples, the book will swiftly help you grasp the fundamental concepts and techniques required to work with MongoDB in real-life scenarios. This extensive guide will not only help establish a strong foundation in MongoDB but also unlock numerous job opportunities.

Название: SQL Server 2022 Administration Inside Out
Автор: Randolph West, William Assaf , Elizabeth Noble
Издательство: Microsoft Press/Pearson Education
Год: 2023
Страниц: 1953
Язык: английский
Формат: pdf
Размер: 27.1 MB

Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery.

Название: SQL and NoSQL Interview Questions: Your essential guide to acing SQL and NoSQL job interviews
Автор: Vishwanathan Narayanan
Издательство: BPB Publications
Год: 2023
Страниц: 180
Язык: английский
Формат: pdf (true)
Размер: 10.8 MB

A comprehensive guide to SQL and NoSQL interview questions for software professionals. In every software-based job interview, database systems will undoubtedly be a topic of discussion. It has become customary to ask at least a few database-related questions. As NoSQL technologies continue to gain popularity, asking about their functionality and practical applications during interviews is becoming more commonplace. This book focuses on these two areas, aiming to familiarize you with the types of questions you may encounter in interviews and providing guidance on preparing and strategizing accordingly. This book thoroughly explores the NoSQL family, covering everything from the fundamentals to advanced topics such as architecture, optimization, and practical use cases. It also includes a selection of frequently asked questions from a query perspective. Moreover, this book is designed to assist you in last-minute revisions. This book also tackles a common interview challenge of effectively communicating complex concepts in a clear and concise manner, even if you have a strong understanding of the subject matter.

Название: Fundamentals of Data Observability: Implement Trustworthy End-to-End Data Solutions (Final)
Автор: Andy Petrella
Издательство: O’Reilly Media, Inc.
Год: 2023
Страниц: 264
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

Quickly detect, troubleshoot, and prevent a wide range of data issues through data observability, a set of best practices that enables data teams to gain greater visibility of data and its usage. If you're a data engineer, data architect, or Machine Learning engineer who depends on the quality of your data, this book shows you how to focus on the practical aspects of introducing data observability in your everyday work. Author Andy Petrella helps you build the right habits to identify and solve data issues, such as data drifts and poor quality, so you can stop their propagation in data applications, pipelines, and analytics. You'll learn ways to introduce data observability, including setting up a framework for generating and collecting all the information you need. Fundamentals of Data Observability is not just for data engineers or data scientists, but for anyone who interacts with data systems in their daily work life. Whether you’re a chief data officer (CDO), a chief technology officer (CTO), a manager, a leader, a developer, a data analyst, or a business manager, understanding data observability concepts and principles will empower you to make better decisions, build more robust systems, and gain greater insight from your data resources.

Название: Oracle Global Data Services for Mission-critical Systems: Maximizing Performance and Reliability in Complex Enterprise Environments
Автор: Y.V. Ravi Kumar, Mariami Kupatadze, Sambaiah Sammeta
Издательство: Apress
Год: 2023
Страниц: 455
Язык: английский
Формат: pdf
Размер: 10.2 MB

New to Oracle Global Data Services? You’ve come to the right place. This book will show you how to leverage the power of Oracle GDS to ensure runtime load balancing, region affinity, replication lag tolerance-based workload routing, and inter-database service failover. In particular, you will see how to maximize the utilization of replication investments with Oracle GDS. The book starts by guiding you through the installation and configuration of GDS and provides details for each component in the GDS framework. Next, you’ll learn how to configure various components of Oracle GDS in standalone environments. Hands-on exercises that explore the advantages of GDS with different test cases utilizing Active Data Guard (ADG), Oracle GoldenGate (OGG), and Oracle Real Application Clusters (RAC) will help you put your learning in context. The book concludes with a demonstration of how to add Oracle GDS to OEM for monitoring and troubleshooting. You’ll also see how to monitor Oracle GDS in a centralized location using Oracle Enterprise Manager Cloud Control. For Oracle database administrators, Oracle database architects, Oracle technical managers, Oracle application business analysts, and Oracle data engineers.

Название: Essential Techniques for Excel 2023: Foundational Essentials for All Workers!
Автор: Yun Matsuura
Издательство: Independently published
Год: 2023
Язык: английский
Формат: pdf
Размер: 10.1 MB

Even when you're at the office, you don't have many opportunities to observe how my colleagues works. I was astonished when I saw my coworkers struggling with Excel tasks at work. Despite Excel being an excellent spreadsheet software, they would manually select ranges and write down the displayed numbers in paper to calculate totals, and they would search and manually copy and paste data instead of using functions to transfer the necessary data. This book aims to cover the essential Excel operation techniques that professionals of all levels, from new employees to executives, should learn, rather than focusing on advanced techniques. Improving in soccer doesn't require fancy techniques like the Marseille Turn. It's about mastering basic dribbling that sticks to your foot and precise inside-kick passes that roll the ball accurately to a nearby teammate. And it's about being able to do it naturally, without even thinking about it.