Showing results by author "Djoni DARMAWIKARTA" in All Categories

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.

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.

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.

PostgreSQL is an open relational database. In PostgreSQL you can have a query with CUBE clause. A cube is an aggregated row. A query with a CUBE clause returns (generates) a complete set of cubes; complete in the sense that the cubes generated cover all the possible combinations of all columns specified (listed) under the WITH clause. In this book you will learn the WITH clause and usages of cubes, known as OLAP queries.

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 embedded relational database. There is no server to install and administer. All you need is a client. One of the clients supported is R. When you have the duckdb package, which is the DuckDB client for R, you can create a new database. The package provides a rich set of DBI (Database Interface) methods for interacting and maintaining data in the database. This book shows you how to use the DBI methods from the duckdb package.

Bad data, data that you do not expect, can accidently get created and stored in your operational database. Bad data can also be in transit being transformed or already get loaded to a data warehouse or any other data storage. To improve the quality of your data, you will firstly have to identify the bad data. This book teaches how, using the R validate package, you can identify bad data. Using R validate package we define data quality indicators. Bad data are those that violate the indicators. You will, in this book, learn the various types of indicator, how to inspect data using the ...

In addition to general-purpose data types, which includes numeric, text, date, interval, blob, and bitstring, DuckDB also supports composite data types: list, struct, and map. You will learn these composite data types, as well the functions specifically for them. Discussion on the data types is accompanied by one or more examples. When you finish reading this book and trying the examples, you would have equipped yourself with the skills to apply the composite data types in a real-world development projects.

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.

SQL (Structured Query Language) is the standard programming language for interacting with relational database such as MySQL. If you want to learn SQL in MySQL the practical way, this is the book of choice. You will learn SQL step-by-step. The best way to gain the skill quickly is by learning from the examples. When you understand and try them, by the end of the book you will have equipped yourself with the SQL skill you need to start participating in real-world MySQL projects.

Welcome to SQL in Microsoft SQL Server: A Tutorial for Beginners. This book is for you if you want to learn SQL in Microsoft SQL Server database the easy way. SQL in MS SQL Server is part of its Transact-SQL. The other part of Transact-SQL is a programming extension of SQL, it gives you the ability to do programming around SQL. This book is only about the SQL part. When you finish reading and trying the examples, you’d have mastered the basics of SQL: Creating tables, maintaining data stored in tables and querying (reading) the data. You’d learn all the topics step-by-step in a tutorial...

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.

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 ...

Progressive organizations, both businesses and public services, around the world have adopted data analytic. You should jump on the bandwagon now! If you want to learn data analytic using the window functions in MySQL database, this is the book of choice.