Mostrando títulos en Ciencia de Datos

Learn the Basics in No Time, the first volume of the SQL and PL/SQL in Practice series, is for Oracle database programmers. If you have no prior or limited skill of SQL and PL/SQL, and you want to learn to use the two individually or together, then this book is perfect for you. SQL (Structured Query Language) is the standard database language. PL/SQL (Procedural Language/SQL) is the procedural language extension of SQL. PL/SQL is integrated within the Oracle database. When you install an Oracle database, PL/SQL is included in the installation. A PL/SQL program can have both SQL statements ...

Welcome to SQL for OLAP in DuckDB database: A Tutorial for Beginners! DuckDB is a relational database. It is an embedded database, there’s no server software to install. When I create a DuckDB database, a file with the name of the database is created. This file contains schema, tables, their data and other objects required by the database to function. DuckDB is designed to support analytical query workloads, such as OLAP (Online Analytical Processing) queries. OLAP queries are queries with a CUBE clause. In this book you will learn all about OLAP queries in DuckDB.

Ranking and Such for Analytics, the 3rd volume of the SQL and PL/SQL in Practice series, is for those who need to learn how to use the Oracle ranking and ranking related analytic functions. The analytic functions make it easier for us to write analytic queries.

If you are an R user who wants to move away from SQL and instead wants to manipulate data within R, then this book is perfect for you. You will learn by examples, how to use the functions of dplyr package in place of SQL statements. The R’s dplyr provides functions for manipulating data, hence the SQL statements covered in this book are DML statements (Data Manipulation Language), which include SELECT, INSERT, UPDATE, and DELETE statements.

JSON in R with tidyjson Package is about JSON (JavaScript Object Notation) in R. You will learn how to manipulate JSON using the functions provided by the tidyjson package. It is a practical book, you will learn by examples. All you need is an installation of R and its tidyjson package. Both are open source. You can use the R’s CLI or an IDE such as RStudio (also an open source) to try the examples.

This book is an accumulation of my DuckDB smaller books. The 300+ pages covers a range of topics. The primary is of course SQL (Structured Query Language), which you apply to interact with the database. Once you are familiar with SQL, the rest of the topics, eleven in total, will further enhance your DuckDB skills. The eleven topics (listed on the book inside cover page) are: Join Types, Custom Functions, Regular Expression, Data Analytic, OLAP (OnLine Analytical Processing), JSON Data (JavaScript Object Notation), Sequence Object, Designing Schema, Database Catalog, Data Ingestion, and ...

Este libro especial es una combinación del mundo real de las tecnologías de las criptomonedas y los blockchains. Comenzará con un plan bien estructurado de cómo armar un portafolio cripto ganador. Luego, continuara expandiendo sus conocimientos al ingresar al mundo de los blockchains más allá de las criptomonedas. ¡El libro incluye lo siguiente y mucho más! • Guía rápida e intensiva para entender la conexión entre las criptomonedas y los blockchains. • Cómo ensamblar y ejecutar un portafolio cripto profesional • Uso de información confidencial y de intercambio ...

In DuckDB you can create a sequence object. Then, you use the sequence object to generate integer numbers incrementally up or down.Seemingly simple, the CREATE SEQUENCE for creating a sequence object, has various clauses, which gives you the options to use a sequence properly. This book teaches you the details of the clauses.

Introducing PL/SQL to SQL Users is for SQL users who do not have PL/SQL skill. If you wish you can write some procedural logic in a SQL statement, such as controlling the process flow using IF THEN ELSE logic, you need to consider using PL/SQL. This book, which introduces PL/SQL basic features, is a perfect starting point.

The Joy of Applying Subqueries, the 4th volume of the SQL and PL/SQL in Practice series, is for those who need to learn how to use subqueries. A subquery is a SELECT statement within another SQL statement. Seemingly plain, subquery has variety of options that beginners often overlook their opportunities to solve the requirements for queries and data maintenance. Knowing where and which way to apply, you will enjoy having subquery in your SQL armory. This book, by way of examples, shows you the variety of ways you can apply subqueries.

Learn the Oracle stored programs in an easy step-by-step tutorial by examples. You will learn how to create your own user-defined procedures and functions in no time using the PL/SQL procedural programming language companion of the Oracle database.

MySQL Stored Routines

Discover the exciting world of CubeSats with "Interfacing with CubeSats" - your go-to guide for everything you need to know about these miniature spacecraft that are revolutionizing the aerospace industry. This comprehensive eBook will captivate space enthusiasts, aspiring engineers, students, and professionals alike, whether you're a seasoned satellite expert or a complete beginner. Fuel your passion for outer space with 32 engaging chapters that cover a vast range of topics related to CubeSats, from their history and applications to intricate hardware components, software design ...

**Emergency Communications Redefined Harness the Power of HAM Radio with "HAM Radio Heroes"** When disaster strikes, will you be prepared to communicate? Step into the world of amateur radio and become the lifeline your community may desperately need with "HAM Radio Heroes." This comprehensive eBook is your guide to mastering HAM radio, serving as a beacon of hope during crises, and joining a fellowship of operators who can make all the difference when traditional communications fail. Starting with the very foundation, "HAM Radio Heroes" opens a window to the history and evolution of ...

**Escape to the Edge of Tomorrow with 'Tech Survivalist' - Your Ultimate Guide to 21st Century Preparedness** In an unpredictable world, staying connected is more than a convenience—it's a lifeline. 'Tech Survivalist' is your essential handbook to mastering the digital and analog communication skills necessary to thrive in any emergency situation. Embark on a journey that melds the primal instincts of survival with cutting-edge technology. Begin with the essentials, fortifying your survivalist mindset and assessing your technological arsenal. Step into the fascinating world of HAM radios ...

Immerse yourself in the fascinating universe of data science and analytics with 'Data Revolution' – a must-have resource that bridges today and the future of this dynamic field. Part 1 – This eye-opener to the future trends in Data Science emphasizes the importance of forward-thinking in anticipating and navigating a rapidly evolving landscape. From appreciating the transformative role of Artificial Intelligence to delving into augmented analytics, you'll be primed to connect the dots between trends and their impacts. The potential of real-time analytics across industries is another ...

Dive into the revolutionary evolution of communication with "Waves of Change," the cutting-edge eBook that encapsulates the entire spectrum of digital ham radio. Immerse yourself in a world where history meets innovation, bridging the gap between Morse Code's dots and dashes and the lightning-speed digital modes of today. The journey begins with a tantalizing historical perspective, highlighting milestones and the foundations of digital signal processing, guiding readers through the past to understand the present. Embark on a voyage of discovery as you decode the complexities of PSK31 and ...

Unlock the mysteries of the airwaves and embark on a riveting journey through the captivating world of Amateur Radio in "Airwaves Unlocked," an eBook that guarantees to amplify your understanding and passion for HAM radio. Whether you're a newcomer eager to explore this fascinating hobby or a seasoned operator seeking to deepen your knowledge, this comprehensive guide navigates through the layers of radio frequencies, unraveling the complexity of HAM radio operations. Dive into the enigmatic history of HAM Radio and discover its irreplaceable role in modern communication. The very ...

Unleash the power of data! "Patterns Unveiled" provides a comprehensive exploration into the realm of data clustering, classification, and pattern recognition. The book serves as both an essential guide for those starting their journey and a valuable resource for seasoned data enthusiasts. Prepare to dive into the exhilarating world of clustering techniques in Chapter 2, as you explore a range of intriguing techniques. From understanding the importance of hierarchical clustering to examining the strengths and weaknesses of various methods, you'll uncover the secrets behind these ...

DuckDB database has a rich set of JSON functions. This is a practical book, every one of the functions is clarified and demonstrated by examples. If you want to learn how DuckDB handles JSON data, this is the book of choice.