|
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 12-01-2023, 04:39 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 12-01-2023, 04:09 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 11-01-2023, 19:47 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 11-01-2023, 18:46 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 11-01-2023, 17:48 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 10-01-2023, 22:06 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 9-01-2023, 21:05 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 8-01-2023, 18:29 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 6-01-2023, 17:10 | Комментарии: 0 | Подробнее
| | | |
|
| |
|
|
|
|
|
|
| |
|
Название: 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. |
Разместил: Ingvar16 6-01-2023, 07:10 | Комментарии: 0 | Подробнее
| | | |
|
| |
br>
|