Название: 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.

Название: Основы работы с базами данных (2-е изд.)
Автор: Грошев А.С.
Издательство: М.: НОУ "Интуит"
Год: 2016
Страниц: 256
Формат: PDF
Размер: 23 Мб
Язык: русский

Излагаются принципы проектирования и использования баз данных, как важнейшего компонента современных информационных систем. Рассмотрены вопросы практической работы с базами данных в системах Visual FoxPro, Access и SQL Server.

Название: 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.

Название: The Ultimate Windows 11 Manual - August 2023
Автор: Papercut Limited
Издательство: Papercut Limited
Год: 2023
Страниц: 194
Язык: английский
Формат: pdf
Размер: 105.6 MB

This comprehensive user manual will guide you through Microsoft’s latest OS, offering you something new to learn on every page and providing you with the necessary knowledge to make Windows 11 work for you. In here you’ll find tutorials and tips, secrets of the OS will be unlocked, and your understanding of how everything works will help make you become an advanced user. So, let’s dive into Windows 11 and start building both your confidence and understanding of this amazing operating system.

Название: End-to-End Observability with Grafana: A comprehensive guide to observability and performance visualization with Grafana
Автор: Ajay Reddy Yeruva, Vivek Basavegowda Ramu
Издательство: BPB Publications
Год: 2023
Страниц: 710
Язык: английский
Формат: pdf, epub
Размер: 49.1 MB

Grafana, a popular open-source observability platform, provides robust tools for analyzing and visualizing data from diverse sources. If you are looking to unlock its full potential as a data visualization and monitoring platform, then this book is for you. This book offers a comprehensive insight into the capabilities of Grafana and empowers you to leverage this powerful tool to its fullest extent. It provides you with the knowledge and skills necessary to create impressive visualizations, establish dashboards, and optimize monitoring processes. The book will help you delve into various aspects of Grafana, including its interface, utilizing the Graph Panel for visualizing data, connecting it to data sources, organizing dashboards, harnessing advanced features, and exploring additional functionalities like Grafana Loki for log exploration and managing authorization and authentication. Furthermore, the book explores specific use cases such as blackbox exporter, synthetic monitoring, Kubernetes monitoring, AIOps monitoring, and maximizing Grafana plugins. It concludes by presenting best practices for working with Grafana and offering insights into setting up performance testing and engineering dashboards. By the end of the book, you will be equipped with the necessary knowledge and skills to unlock its full potential as a data visualization and monitoring platform.

Название: Pivot for office workers: Using Excel 365 and 2021
Автор: Ina Koys
Издательство: Computertrainerin.de
Серия: Short & Spicy, vol. 16
Год: 2023
Страниц: 95
Язык: английский
Формат: epub (true)
Размер: 11.4 MB

In today's offices, much time is spent finding and structuring information in given data. Pivot Tables and Charts are the tool of choice to get it done. Their result often looks impressive, making people think it takes tremendous skills setting them up. It doesn’t! They’re easy, if only you know what result you’re looking for. In this booklet you learn everything to transform a simple Excel list to a telling Pivot Table and Chart!

Название: Database Design Using Entity- Relationship Diagrams, 3rd Edition
Автор: Sikha Saha Bagui, Richard Walsh Earp
Издательство: CRC Press
Год: 2023
Страниц: 500
Язык: английский
Формат: epub (true), mobi
Размер: 13.6 MB

Essential to database design, entity-relationship (ER) diagrams are known for their usefulness in data modeling and mapping out clear database designs. They are also well-known for being difficult to master. With Database Design Using Entity-Relationship Diagrams, Third Edition, database designers, developers, and students preparing to enter the field can quickly learn the ins and outs of data modeling through ER diagramming. Building on the success of the bestselling first and second editions, this accessible text includes a new chapter on the relational model and functional dependencies. It also includes expanded chapters on Enhanced Entity-Relationship (EER) diagrams and reverse mapping. It uses cutting-edge case studies and examples to help readers master database development basics and defines ER and EER diagramming in terms of requirements (end user requests) and specifications (designer feedback to those requests), facilitating agile database development.