Название: MySQL Crash Course: A Hands-on Introduction to Database Development
Автор: Rick Silva
Издательство: No Starch Press
Год: 2023
Страниц: 511
Язык: английский
Формат: epub (true), mobi
Размер: 10.1 MB

With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know. MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. It’s filled withpractical examples and expert advice that will have you up and running quickly. You’ll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. You’ll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. You’ll even explore how to call MySQL from PHP, Python, and Java. The perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems.

Название: CompTIA Project+ Certification All-in-One Exam Guide (Exam PK0-005)
Автор: Joseph Phillips
Издательство: McGraw Hill
Год: 2023
Страниц:
Язык: английский
Формат: epub (true), mobi
Размер: 30.8 MB

This comprehensive study guide delivers complete coverage of every topic on the CompTIA Project+ exam. This fully updated self-study guide and professional resource shows how to successfully manage projects and prepare for the challenging CompTIA Project+ exam. CompTIA Project+ Certification All-in-One Exam Guide (Exam PK0-005) walks you through each step of the project management process, covering critical strategies for on-time and within-budget projects. You’ll get complete explanations of every objective on the CompTIA Project+ exam along with end-of-chapter summaries, quizzes, and exercises that reinforce key points. This book will help you become the superior project manager you’ve dreamed of becoming. CompTIA Project+ Certification All-in-One Exam Guide (Exam PK0-005) shows you how to get started, get funding, and get the project done. You’ll discover advanced project management techniques, the mechanics of project management, and inspiration to keep moving toward the end result of any technical project.

Название: Learning and Operating Presto: Fast Federated SQL Analytics (Second Early Release)
Автор: Angelica Lo Duca, Vivek Bharathan, George Wang
Издательство: O’Reilly Media, Inc.
Год: 2023-01-13
Язык: английский
Формат: pdf, epub
Размер: 10.2 MB

The Presto community has mushroomed since its origins at Facebook in 2012. But ramping up this distributed SQL query engine can be challenging even for the most experienced engineers. This practical book shows you how to begin Presto operations at your organization to derive insights on datasets wherever they reside. Authors Angelica Lo Duca, Vivek Bharathan, and George Wang explain what Presto is, where it came from, and how it differs from other data warehousing solutions. You'll discover why Facebook, Uber, Twitter, and cloud providers, including AWS, Google Cloud, and Alibaba, use Presto and how you can quickly deploy Presto in production.

Название: Semantic Knowledge Modelling via Open Linked Ontologies: Ontologies in E-Governance
Автор: Stamatios Theocharis, George A. Tsihrintzis
Издательство: Springer
Серия: Artificial Intelligence-Enhanced Software and Systems Engineering
Год: 2023
Страниц: 381
Язык: английский
Формат: pdf (true)
Размер: 18.2 MB

Evolving technological advances in Artificial Intelligence-empowered Software present significant potential to lead e-Government towards more collective efforts, exchange of experiences on best practices both at national and international levels and dissemination of secluded administrative knowledge. In this book, novel semantic web-based and linked open data-based approaches are developed for the modelling and management of the huge volume of administrative data and the procedures followed by public sector bodies and for the production and management of relevant administrative knowledge. Knowledge in Semantic Web is in the form of triplets RDF, to which specific languages are focused. Their main object is the recovery of results upon submission of tailored questions in the form of triplets. Such languages are RQL and SPARQL.

Название: Mathematical Methods in Data Science
Автор: Jingli Ren, Haiyan Wang
Издательство: Elsevier
Год: 2023
Страниц: 260
Язык: английский
Формат: pdf (true), epub
Размер: 23.4 MB

Mathematical Methods in Data Science introduces a new approach based on network analysis to integrate Big Data into the framework of ordinary and partial differential equations for data analysis and prediction. The mathematics is accompanied with examples and problems arising in Data Science to demonstrate advanced mathematics, in particular, data-driven differential equations used. Chapters also cover network analysis, ordinary and partial differential equations based on recent published and unpublished results. Finally, the book introduces a new approach based on network analysis to integrate Big Data into the framework of ordinary and partial differential equations for data analysis and prediction. There are a number of books on mathematical methods in Data Science. Currently, all these related books primarily focus on linear algebra, optimization and statistical methods. However, network analysis, ordinary and partial differential equation models play an increasingly important role in Data Science.

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