Mostrando resultados por autor "Djoni Darmawikarta" en Todas las categorías

Progressive organizations, both businesses and public services, around the world have adopted analytics. Thanks to the recent availability of SQL analytic functions they can now do their analytics right on the database. You should jump on the bandwagon now! If you want to learn SQL analytic functions, this is the book of choice. It is a practical book, teaching you how to use the SQL analytic function step-by-step using examples. When you finish the book, you’d be ready to apply your analytics skill in real-world projects.

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

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

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.

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.

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.

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

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)

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

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.

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.

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

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.

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