Showing titles in Computers & Technology

Most real-world applications store their data in databases. Most of their databases are relational. PostgreSQL is one of the most-used relational databases. It is an open source software that you can download from https://www.postgresql.org To access data in a relational database we use SQL (Structured Query Language). If you are new to SQL, and want to use SQL in PostgreSQL, this is the book of choice. It is a practical book, teaching you SQL step-by-step using examples. If you take a glance at the table of contents, you will appreciate the comprehensive coverage of the book. When you ...

***If you hunt and peck, or if you want to type with all ten fingers, this introductory computer keyboarding course is for you. ***One of the first steps in learning how to use a home or office computer is learning how to type with all ten fingers on a computer keyboard.

The #HACKED book (2024 edition) is the perfect resource for anyone looking to learn about cybersecurity. Written by leading experts in the field, this book provides in-depth coverage of all aspects of cybersecurity. Whether you're a business owner, student, or just someone who wants to stay safe online, The #HACKED book has everything you need to know.

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.

This book shows you how to use SQL within R using the sqldf package. You will learn the many facets of SQL and their use as the argument of the sqldf function. In addition to the default SQLite database, you will also learn how to use Oracle database to execute SQL statements specifically supported by Oracle SQL.

This eBook embarks on a journey into the cutting-edge world of robotics. Researchers have brought artificial intelligence, machine learning, and advanced engineering into the forefront of technological innovation. From the inception of robotics to the latest advancements, this eBook offers a panoramic view of evolution. Discover the transformative impact of robots in various sectors, from manufacturing and healthcare to space exploration and everyday life. Explore the interactions between humans and machines, witnessing the rise of collaborative robots designed to enhance our capabilities ...

This eBook explores the fascinating field of quantum computing, which harnesses the principles of quantum mechanics to revolutionize computation. We dive into the fundamental concepts of quantum mechanics, including superposition, entanglement, and quantum gates, which form the basis of quantum computing. The eBook discusses the challenges of decoherence and error correction in quantum systems, as well as strategies for minimizing decoherence and improving the accuracy of quantum computations. We trace the history of quantum computing, highlighting key milestones and advancements, and ...

MySQL Stored Routines

PL/SQL, integrated with the Oracle database, is the procedural extension of SQL. This book is for PL/SQL beginners. When they finish reading the book and trying its examples, they would have equipped themselves with basic PL/SQL skills to start writing PL/SQL programs in a real-world development project. The second edition has three new chapters (Records & Collection, Privileges, and PL/SQL in Java), and five new topics added in existing chapters (Transaction, DDL statements, Stored Programs, Package, and Trigger)

When you, in SQLite database, create a table you have three choices in declaring the column datatype: with the datatype and STRICT option, without datatype, or with the datatype. The first choice is just like what you can do in other relational databases. You must declare the datatype of every column, and the data you insert into the columns must be of the datatype declared. This is known as static data typing. While other relational databases support only the first choice, SQLite offers the other two choices, the dynamic datatype's. The second choice allows you to create a table without ...

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.

SQLite provides JSON functions for you to store, maintain, and manipulate JSON data in the database. Functions for JSON data validation and aggregation are also available, as well, of course, for parsing and extraction. If you want to learn about JSON data and functions in SQLite, this is the book of choice. It is a practical book, every one of the functions is clarified and demonstrated by examples.

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.

This eBook offers a comprehensive exploration of blockchain technology, revealing its transformative potential and real-world applications. From its inception to its current state, the eBook dives into the fundamental concepts of blockchain, including decentralized ledgers, cryptographic techniques, and consensus mechanisms. Through explanations and practical examples, readers gain an understanding of how blockchain is reshaping industries such as finance, supply chain, healthcare, and beyond. The eBook guides readers through the key characteristics, benefits, and challenges of blockchain ...

Once in production something bad can happen to your database, even during development you don’t want to loose your works, you always need to backup your database regularly. A DuckDB database is not just data, it includes all objects, such as your table, view, and sequence. You use the export and import statement to backup and restore respectively. It is a practical book, it explains and provide examples of the various options of the export and import. If you want to learn how you can use DuckDB export and import, this is the book of choice.

The book title implies that SQL Queries for R Users is for R users who need to get the data they need from a database. Loading large raw data from a database into R workspace is often unnecessary or even prohibitive. The book teaches you how to write SQL queries to retrieve precisely only the data needed from an SQL database. But, this book also covers topics on metadata, which is equally important if not more than the SQL queries. To write an SQL query you must first know where the data is, the name of the tables and columns, their relationships, and the characteristics of the data. The ...

DuckDB is an open-source relational database. It is an embedded database. There’s no database server; all you need to create and access all database objects is a client. DuckDB is designed to support OLAP (Online Analytic Processing) workload. In OLAP data is generally loaded in bulk. DuckDB provides a COPY FROM statement, which is used to ingest (bulk load) external data. External data can be delimited text, Parquet, or JSON files. You will learn the features of the COPY FROM statement. When you finish reading this book and trying its examples, you would have equipped yourself with the ...

Time is ticking away and so I thought I’d better warn everyone. But there’s nowhere to run. We have to all take a stand by joining what I call the final SWAT Team. (Save our World Again Today) If you choose not to saddle up and fight the good fight - it’s curtains for the human race. In my new book, listeners will learn about how Time Flies about the universe in waves, how the waves are created by the smallest particles in the subatomic world—chronons—and how they are all connected to one another and to every particle that makes you and your life exist.

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.

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.