Showing results by author "Djoni Darmawikarta" in All Categories
-
-
Introducing the Flexible Data Type in SQLite Database
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 34 mins
- Unabridged
-
Overall
-
Performance
-
Story
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 ...
-
Introducing the Flexible Data Type in SQLite Database
- Narrated by: Virtual Voice
- Length: 34 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $7.00 or 1 credit
Sale price: $7.00 or 1 credit
Included in Plus membership -
-
-
MySQL Window Functions for Data Analytic
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 49 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
MySQL Window Functions for Data Analytic
- Narrated by: Virtual Voice
- Length: 49 mins
- Release date: 05-03-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $8.00 or 1 credit
Sale price: $8.00 or 1 credit
Included in Plus membership -
-
-
Learning SQL in PostgreSQL for Beginners
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 1 hr and 40 mins
- Unabridged
-
Overall
-
Performance
-
Story
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 ...
-
-
Overall Performance
- By Kindle Customer on 05-04-24
-
Learning SQL in PostgreSQL for Beginners
- Narrated by: Virtual Voice
- Length: 1 hr and 40 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $7.00 or 1 credit
Sale price: $7.00 or 1 credit
Included in Plus membership -
-
-
MySQL Stored Routines: Creating Your Own Procedures and Functions
- A Beginner's Tutorial
- Narrated by: Virtual Voice
- Length: 1 hr and 3 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
Introducing PL/SQL to SQL Users
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 26 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
Introducing PL/SQL to SQL Users
- Narrated by: Virtual Voice
- Length: 26 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
Oracle PL/SQL Programming Fundamentals 2nd Edition
- A Practical Tutorial by Examples
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 2 hrs and 57 mins
- Unabridged
-
Overall
-
Performance
-
Story
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)
-
Oracle PL/SQL Programming Fundamentals 2nd Edition
- A Practical Tutorial by Examples
- Narrated by: Virtual Voice
- Length: 2 hrs and 57 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
Learning SQL Queries for R Users
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 1 hr and 56 mins
- Unabridged
-
Overall
-
Performance
-
Story
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 ...
-
Learning SQL Queries for R Users
- Narrated by: Virtual Voice
- Length: 1 hr and 56 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
DuckDB: Backing-up and Restoring Your Database
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 15 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
DuckDB: Backing-up and Restoring Your Database
- Narrated by: Virtual Voice
- Length: 15 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
DuckDB Data Ingestion Importing Delimited Text, JSON, and Parquet files
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 15 mins
- Unabridged
-
Overall
-
Performance
-
Story
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 ...
-
DuckDB Data Ingestion Importing Delimited Text, JSON, and Parquet files
- Narrated by: Virtual Voice
- Length: 15 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
DuckDB: Creating and Using SEQUENCE
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 21 mins
- Unabridged
-
Overall
-
Performance
-
Story
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: Creating and Using SEQUENCE
- Narrated by: Virtual Voice
- Length: 21 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
The Joy of Applying Subqueries
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 32 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
The Joy of Applying Subqueries
- Narrated by: Virtual Voice
- Length: 32 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
Oracle Stored Programs for Beginners
- Creating Your Own Procedures and Functions in PL/SQL
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 57 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
Oracle Stored Programs for Beginners
- Creating Your Own Procedures and Functions in PL/SQL
- Narrated by: Virtual Voice
- Length: 57 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
DuckDB: Dealing with JSON Data
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 39 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
DuckDB: Dealing with JSON Data
- Narrated by: Virtual Voice
- Length: 39 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $7.00 or 1 credit
Sale price: $7.00 or 1 credit
Included in Plus membership -
-
-
Composite Type in PostgreSQL Database
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 22 mins
- Unabridged
-
Overall
-
Performance
-
Story
A composite type is a collection of columns. In postgreSQL database you create a composite type using a CREATE TYPE statement. Once created, you can use a composite type the same way as a primitive datatype, for example, as the datatype of a column. In this practical book you will learn how to create, use, and maintain composite type, by examples.
-
Composite Type in PostgreSQL Database
- Narrated by: Virtual Voice
- Length: 22 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
PostgreSQL: Cubes for OLAP A Tutorial for Beginners
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 19 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
PostgreSQL: Cubes for OLAP A Tutorial for Beginners
- Narrated by: Virtual Voice
- Length: 19 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
R Data Preparation and Manipulation Using the sqldf Package
- Executing SQL Statements from Within R Program
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 48 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
R Data Preparation and Manipulation Using the sqldf Package
- Executing SQL Statements from Within R Program
- Narrated by: Virtual Voice
- Length: 48 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
R for Beginners: A Practical Introduction
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 1 hr and 17 mins
- Unabridged
-
Overall
-
Performance
-
Story
If you are new to R and want to learn it the practical, step-by-step, the tutorial way, this book is perfect for you. It will teach you how to interact with R. You will learn among others: statements and programming control structures, function and how to write your own, custom functions, and data structures (vector, data frames, and others) The book has over 50 examples. When you try them you would have been trained, ready to use R for real-life works.
-
R for Beginners: A Practical Introduction
- Narrated by: Virtual Voice
- Length: 1 hr and 17 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
DuckDB: Using the Database in R with Database Interface (DBI)
- By: Djoni Darmawikarta
- Narrated by: Virtual Voice
- Length: 39 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
DuckDB: Using the Database in R with Database Interface (DBI)
- Narrated by: Virtual Voice
- Length: 39 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $4.00 or 1 credit
Sale price: $4.00 or 1 credit
Included in Plus membership -
-
-
JSON Functions in SQLite Database
- By: Djoni DARMAWIKARTA
- Narrated by: Virtual Voice
- Length: 42 mins
- Unabridged
-
Overall
-
Performance
-
Story
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.
-
JSON Functions in SQLite Database
- Narrated by: Virtual Voice
- Length: 42 mins
- Release date: 04-17-24
- Language: English
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.Add to Cart failed.
Please try again laterAdd to Wish List failed.
Please try again laterRemove from wishlist failed.
Please try again laterAdding to library failed
Please try againFollow podcast failed
Please try againUnfollow podcast failed
Please try againRegular price: $7.00 or 1 credit
Sale price: $7.00 or 1 credit
Included in Plus membership -