Название: Grokking Relational Database Design (MEAP v4)
Автор: Qiаng Нао, Мiсhаil Тsikеrdеkis
Издательство: Manning Publications
Год: 2024
Страниц: 145
Язык: английский
Формат: epub
Размер: 24.7 MB

A friendly illustrated guide to designing and implementing your first database. Data is the backbone of computer science, and databases are the main way that data is stored, exchanged, manipulated, and managed. Whether you’re a software developer, a data scientist, or an enthusiastic business user looking to up your data analysis skills, it pays to learn how to create and query relational databases like MySQL, SQL Server, PostgreSQL, and Oracle. Grokking Relational Database Design will get you started! Grokking Relational Database Design teaches the art of database design through real-world projects, insightful illustrations, and action-oriented learning. Unlike many beginning database books that focus on the technical details of SQL and formal database theory, this book teaches you how to think about relational database design from the ground up, so you’ll create databases that are a joy to use for a long time. Everything in this book is reinforced by hands-on exercises and examples. You’ll quickly design, implement, and optimize a database for an e-commerce application like the ones you use every day. You’ll also explore how generative AI tools such as ChatGPT radically simplify the mundane tasks of database design. Suitable for self-taught programmers, engineers, data scientists, and business data users. No previous experience with relational databases required.

Название: Learn SQL in a Month of Lunches (MEAP v13)
Автор: Jеff Iаnnuссi
Издательство: Manning Publications
Год: 2024
Страниц: 312
Язык: английский
Формат: epub
Размер: 47.7 MB

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your own business data in just 24 short lessons–no programming experience required! This book is designed for all SQL beginners, including those who are not necessarily software developers. It emphasizes practical ways to use SQL, rather than theoretical, helping you quickly assimilate the basics needed to begin implementing what you’ve learned. If you know how to use Windows or MacOS and have experience using spreadsheet applications, then you absolutely are ready to start learning how to use SQL to read and manipulate data, create database objects, and more. Each chapter of this book is short enough to complete within an hour, whether that be during lunchtime or some other part of your day. Month of Lunches books are also designed to help you be immediately effective, so by the second chapter you will already have written your first SQL statement and examined its core components. Subsequent chapters will focus on teaching skills that you can apply to real-life scenarios and will include plenty of exercises to help you reinforce what you have learned.

Название: SQL All-in-One For Dummies, 4th Edition
Автор: Аllеn G. Тауlоr
Издательство: For Dummies
Год: 2024
Страниц: 800
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

The most thorough SQL reference, now updated for SQL:2023. SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there's no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. This book isn’t just about SQL; it’s also about how SQL fits into the process of creating and maintaining databases and database applications. In this book, I cover how SQL fits into the larger world of application development and how it handles data coming in from other computers, which may be on the other side of the world or even in interplanetary space. This Dummies All-in-One guide is for all SQL users—from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.

Название: MySQL Crash Course, 2nd Edition (Final)
Автор: Веn Fоrtа
Издательство: Addison-Wesley Professional/Pearson Education
Год: 2024
Страниц: 304
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. This book will teach you all you need to know to be immediately productive with the latest version of MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. MySQL is a DBMS; that is, it is database software. MySQL has been around for a long time, and it is now installed and in use at millions of installations worldwide. Why do so many organizations and developers use MySQL? Here are some of the reasons: MySQL is open source, and it is usually free to use and even modify the software; MySQL is fast—make that very fast; MySQL is used by some of the most important and prestigious organizations and sites, all of which entrust it with their critical data. MySQL is easy to install and get up and running. In fact, historically the only real criticism of MySQL has been that it has not always supported the functionality and features offered by other DBMSs. But as new features have been added to each new version, that has changed, and it continues to do so.

Название: Data Analytics and Machine Learning: Navigating the Big Data Landscape
Автор: Рushра Singh, Аshа Rаni Мishrа, Рауаl Gаrg
Издательство: Springer
Серия: Studies in Big Data
Год: 2024
Страниц: 357
Язык: английский
Формат: pdf (true)
Размер: 10.7 MB

This book presents an in-depth analysis of successful data-driven initiatives, highlighting how organizations have leveraged data to drive decision-making processes, optimize operations, and achieve remarkable outcomes. Through case studies, readers gain valuable insights and learn practical strategies for implementing data analytics, Big Data, and Machine Learning solutions in their own organizations. The book discusses the transformative power of data analytics and Big Data in various industries and sectors and how Machine Learning applications have revolutionized exploration by enabling advanced data analysis techniques for mapping, geospatial analysis, and environmental monitoring, enhancing our understanding of the world and its dynamic processes. This book explores how Big Data explosion, the power of analytics and Machine Learning revolution can bring new prospects and opportunities in the dynamic and data-rich landscape. It highlights the future research directions in data analytics, Big Data, and Machine Learning that explores the emerging trends, challenges, and opportunities in these fields by covering interdisciplinary approaches such as handling and analyzing real-time and streaming data. The study is done using a popular statistical tool named R programming.

Название: C# ADO.NET: Building Secure and Scalable Data Access
Автор: Тhеорhilus Еdеt
Издательство: CompreQuest Books
Серия: Mastering Database Management Series
Год: 2024
Страниц: 275
Язык: английский
Формат: pdf
Размер: 32.5 MB

Discover the key to unlocking powerful data access solutions: Unlock the power of data access in your C# applications with "C# ADO.NET: Building Secure and Scalable Data Access." This comprehensive guide equips you with the knowledge and tools necessary to create robust, secure, and scalable data access solutions using ADO.NET. ADO.NET is a data access technology from the Microsoft.NET Framework that provides communication between relational and non-relational systems through a common set of components. Dive into the world of ADO.NET for secure data access: Are you looking to enhance your understanding of data access in C# applications? Dive into the world of ADO.NET and discover how to leverage its capabilities to build secure and scalable data access solutions. Whether you're a beginner or an experienced developer, this book provides valuable insights and practical examples to help you master the art of data access in C#. Get your copy of "C# ADO.NET: Building Secure and Scalable Data Access" today and take your C# development skills to the next level. Whether you're a seasoned professional or just starting with C#, this book has something for everyone. Don't miss out on this opportunity to become a master of data access in C# applications.

Название: Database and Application Security: A Practitioner's Guide (Final)
Автор: R. Sаrmа Dаnturthi
Издательство: Addison-Wesley Professional/Pearson Education
Год: 2024
Страниц: 448
Язык: английский
Формат: epub (true)
Размер: 37.2 MB

An all-encompassing guide to securing your database andapplications against costly cyberattacks! Cybersecurity is both a very challenging and very fun field to work in. The ultimate law to excel in this field remains to be this—keep your eyes open, learn continuously, adapt, and grow with the field. Whether you are an application developer, DB coder, DB administrator, or system administrator, this book will help you achieve a strong security posture in your organization. But remember that cybersecurity is a security posture that can only be achieved by working with everyone around you. The first line of defense in security is YOU. This book is for IT professionals who want to learn how to secure their DB or their applications with a multi-pronged stature. System administrators can use this book in securing their hosts, creating firewall rules, and hardening the IIS side of hosting an application. The book might be helpful in learning security of software and DBs and may help with Sec+ and CISSP certifications. The book should be used at every stage of the software or DB development process to create a strong cybersecurity posture. It also helps in learning the fundamentals for an aspiring student in IT and cybersecurity. The book touches on both Oracle and SQL Server software.

Название: Data Visualization for People of All Ages
Автор: Nаnсу Оrgаn
Издательство: CRC Press
Год: 2024
Страниц: 333
Язык: английский
Формат: pdf (true)
Размер: 25.0 MB

Data visualization is the art and science of making information visible. On paper and in our imaginations, it’s a language of shapes and colors that holds our best ideas and most important questions. As we find ourselves swimming in data of all kinds, visualization can help us to understand, express, and explore the richness of the world around us. No matter your age or background, this book opens the door to new ways of thinking and sharing through the power of data visualization. Data Visualization for People of All Ages is a field guide to visual literacy, born from the author’s personal experience working with world-class scholars, engineers, and scientists. By walking through the different ways of showing data—including color, angle, position, and length—you’ll learn how charts and graphs truly work so that no visualization is ever a mystery or out of reach. It doesn’t stop at what fits on a page, either. You’ll journey into cutting-edge topics like data sonification and data physicalization, using sound and touch to share data across the different senses. Packed with practical examples and exercises to help you connect the dots, this book will teach you how to create and understand data visualizations on your own—all without writing a single line of code or getting tangled up in software. Written with accessibility in mind, this book invites everyone to the table to share the joy of one of today’s most necessary skills.

Название: DBA Essentials for 21c: Installing Oracle Database 21c on OCI Compute
Автор: D Guрtа
Издательство: BPB Publications
Год: 2024
Страниц: 288
Язык: английский
Формат: epub (true)
Размер: 28.2 MB

Oracle Database 21c is the engine driving some of the most critical systems on the planet. "DBA Essentials for 21c," equips you with the essential knowledge and skills to confidently manage and optimize your Oracle Database in the cloud. This book breaks down Oracle Database Setup Wizard, Configuration Assistant, and steps for creating and configuring databases. In the first section, you will learn the basics of 21c, understand its Infrastructure, use its advantages, and learn its role in the modern data landscape. As you progress, you will gain knowledge of tools like Setup Wizard and Configuration Assistant to build powerful database structures and optimize performance. Then advanced topics are covered, where you will discover how to secure your data, troubleshoot common issues, and automate tasks for efficiency with practical tips and best practices. After reading this book, you will be highly competent in Oracle Database 21c installation on OCI Compute. You will grasp the fundamental concepts and sophisticated features to deploy databases in a cloud environment.

Название: Data Warehouse and Data Mining: Concepts, techniques and real life applications
Автор: Jugnеsh Кumаr
Издательство:
Год: 2024
Страниц: 214
Язык: английский
Формат: epub (true)
Размер: 10.1 MB

Data warehouse and data mining are essential technologies in the field of data analysis and business intelligence. Data warehouse provides a centralized repository of structured data and facilitates data storage and retrieval. Data mining, on the other hand, utilizes various algorithms and techniques to extract valuable patterns, trends, and insights from large datasets. The book explains the ins and outs of data warehousing by discussing its principles, benefits, and components, differentiating it from traditional databases. The readers will explore warehouse architecture, learn to navigate OLTP and OLAP systems, grasping the crux of the difference between ROLAP and MOLAP. The book is designed to help you discover data mining secrets with techniques like classification and clustering. You will be able to advance your skills by handling multimedia, time series, and text, staying ahead in the evolving data mining landscape. Data Warehousing introduces the foundational concepts behind the creation and management of centralized repositories, offering a blueprint for designing efficient data storage systems.