Litgu.ru - Литературный Гуру

Название: Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation (2nd Early Release)
Автор: Stephen B. Morris
Издательство: O’Reilly Media, Inc.
Год: 2023-01-10
Страниц: 325
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to use PL/SQL to develop resilient database solutions. A solid knowledge of relational databases such as, those from Oracle, IBM, Microsoft and others remains a good addition to the IT skillset. The same is true for the open source relational databases, such as, MySQL. Pretty much every developer job I’ve done has required at least some knowledge of SQL. Some jobs have also required knowledge of stored procedure languages, such as, PL/SQL. As you’ll see in the book, there is often a great deal of confusion about the role of SQL and PL/SQL in the context of high level languages, such as, Java, C#, jаvascript, and so on.

Название: Ultimate Linux Projects - 2nd Edition, 2023
Автор: Drew Sleep (Editor)
Издательство: Future Publishing
Год: 2023
Страниц: 132
Язык: английский
Формат: pdf (true)
Размер: 16.2 MB

Linux is the gateway to exciting open-source software, stimulating coding projects and, of course, impressive Raspberry Pi machinations. In Ultimate Linux Projects, we throw those doors wide open and explore the opportunities that Linus Torvalds’ creation can offer us. Inside, the minds behind Linux Format magazine provide their expertise to bring you specialist tutorials, guides and advice to help you get some extra joy from your machine. From coding masterclasses that will tell you how to tap into weather satellites and more, to plug-in-and-play Raspberry Pi guides, and open-source alternatives to popular services like Google Photos and Plex – we’re sure that if you’re a Linux fan, you’ll find something to obsess over here. So, pop that kettle on, boot up your machine and get ready to explore the possibilities that Linux has to offer.

Название: Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database, Third Edition
Автор: Thomas LaRock, Enrico van de Laar
Издательство: Apress
Год: 2023
Страниц: 410
Язык: английский
Формат: pdf, epub
Размер: 38.7 MB

Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You'll learn to identify precisely why your queries are running slowly. And you'll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more.

Название: Acing the System Design Interview (MEAP v5)
Автор: Zhiyong Tan
Издательство: Manning Publications
Год: 2022
Страниц: 331
Язык: английский
Формат: pdf, epub
Размер: 10.1 MB

The system design interview can be the hardest part of the software engineering hiring process. This practical book gives you the insights, skills, and practice you need to ace the toughest system design interview questions and land the job and salary you want. Acing the System Design Interview teaches you how to effectively demonstrate your system design expertise in an interview environment. This in-depth guide's serious technical overviews cover everything there is to know about system design—from the frameworks for functional partitioning, to different API paradigms. This book is divided into two main parts. Part 1 is presented like a typical textbook, with chapters that cover the various topics discussed in a system design interview. Part 2 consists of discussions of sample interview questions that reference the concepts covered in part 1, and discusses antipatterns and common misconceptions and mistakes.

Название: Analyzing US Census dаta: Methods, Maps, and Models in R
Автор: Kyle Walker
Издательство: CRC Press
Серия: The R Series
Год: 2023
Страниц: 378
Язык: английский
Формат: pdf (true)
Размер: 147.7 MB

Census data are widely used by practitioners to understand demographic change, allocate resources, address inequalities, and make sound business decisions. Until recently, projects using US Census data have required proficiency with multiple web interfaces and software platforms to prepare, map, and present data products. This book introduces readers to tools in the R programming language for accessing and analyzing Census data, helping analysts manage these types of projects in a single computing environment. R is one of the most popular programming languages and software environments for statistical computing and is the focus of this book with respect to software applications. This section introduces some basics of working with R and covers some terminology that will help readers work through the sections of this book. The tidyverse ecosystem developed by RStudio is one of the most popular frameworks for data analysis in R and attempts to respond to problems introduced by package fragmentation. The tidyverse consists of a series of R packages designed to address common data analysis tasks (data wrangling, data reshaping, and data visualization, among many others) using a consistent syntax.

Название: MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide with 900 Practice Test Questions: Exam MD-100 and Exam MD-101, 2nd Edition
Автор: William Panek
Издательство: Sybex
Год: 2023
Страниц: 971
Язык: английский
Формат: pdf (true)
Размер: 30.1 MB

Complete, UPDATED study guide for MCA Modern Desktop Administrator certification exams, MD-100 and MD-101. Covers new Windows 11, services, technologies, and more! MCA Microsoft 365 Certified Associate Modern Desktop Administrator Complete Study Guide, Second Edition, is your all-in-one guide to preparing for the exams that will earn you the MCA Modern Desktop Administrator certification! In this book, well-known Windows guru and five-time Microsoft MVP, William Panek, guides you through the latest versions of the Windows Client exam (MD-100) and the Managing Modern Desktops exam (MD-101). This one-stop resource covers 100% of the objectives for both exams, providing real world scenarios, hands-on exercises, and challenging review questions. You’ll also dive deeper into some of the more complex topics and technologies, including deploying, maintaining, and upgrading Windows; managing devices and data; configuring storage and connectivity; managing apps and data; and more.

Название: SQLite Internals : How The World's Most Used Database Works
Автор: Abdur-Rahmaan Janhangeer
Издательство: Leanpub
Год: 2023-01-02
Язык: английский
Формат: pdf (true), mobi, epub
Размер: 10.2 MB

SQLite is famous for it's ubiquity. This book is a deep dive into the mechanisms that drive it! To all SQLite lovers. This book discusses SQLite internals in depth. SQLite is a file-based database which is extremely reliable and stable. It is the world’s most used database. It’s used on military devices, on planes (the A350 for instance) and in space. The codebase and mechanisms it uses is extremely complex. The seemingly simple nature of it and adoption makes a good case for deep diving into in a fascinating piece of software. It also implemented many features years ahead of popular databases like partial indexes. It’s pronounced S-Q-L-ite, like mineral. SQLite is notorious for implenting a bunch of functionalities from scratch. It’s a daring, amazing, bold and crazy spirit which requires confidence and professionalism.

Название: SAS Essentials: Mastering SAS for Data Analytics, 3rd Edition
Автор: Alan C. Elliott, Wayne A. Woodward
Издательство: Wiley
Год: 2023
Страниц: 576
Язык: английский
Формат: pdf (true)
Размер: 15.8 MB

Valuable step-by-step introduction to using SAS statistical software as a foundational approach to data analysis and interpretation. Presenting a straightforward introduction from the ground up, SAS® Essentials illustrates SAS using hands-on learning techniques and numerous real-world examples; keeping different experience levels in mind, the highly qualified author team has developed the book over 25 years of teaching introductory SAS courses. This book introduces data manipulation, statistical techniques, and the SAS programming language, including SAS macros, reporting results in tables, and factor analysis, as well as sections on character functions, variable manipulation, and merging, appending, and updating files. It features self-contained chapters to enhance the learning process and includes programming approaches for the latest version of the SAS platform.

Название: Data Mesh in Action (Final Release)
Автор: Jacek Majchrzak, Sven Balnojan, Marian Siwiak
Издательство: Manning Publications
Год: 2023
Страниц: 330
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

Revolutionize the way your organization approaches data with a data mesh! This new decentralized architecture outpaces monolithic lakes and warehouses and can work for a company of any size. Data Mesh in Action teaches you pragmatic ways to decentralize your data and organize it into an effective data mesh. You’ll start by building a minimum viable data product, which you’ll expand into a self-service data platform, chapter-by-chapter. You’ll love the book’s unique “sliders” that adjust the mesh to meet your specific needs. You’ll also learn processes and leadership techniques that will change the way you and your colleagues think about data. For data professionals. Requires no specific programming stack or data platform.

Название: Excel: Power Query for Advanced
Автор: Saskia Giessen
Издательство: bookboon.com
Год: 2022
Страниц: 101
Язык: английский
Формат: epub
Размер: 10.1 MB

This manual was written to accompany our seminar on Microsoft Power Query. Its target audience is users who need to import external data into Excel or transform data into Excel before further processing. The exercises in the book are easy to understand and can be adapted with little effort to your own needs. Power Query has very comprehensive feature set which is also easy to use. The software can do a great deal of work for you without requiring any programming skills. The output of Power Query is a list that you can then use for further analysis in Excel or in the data model of PowerPivot. Power Query is integrated in Excel and is specialized in importing, transforming and cleansing all kinds of data. It offers you many other useful commands for data transformation. The chapter Many useful tools in Power Query teaches you how to detect and remove duplicates. You will find more than 400 functions in Power Query. Some of them are discussed in this manual. You will also learn about the better and faster alternative to the VLOOKUP() function.