XPath – Nodes
In this chapter, we'll see the XPath expression in details covering common types of Nodes, XPath defines and handles. S.No.Node Type & Description1Root element node of an XML Document.2Element node.3Text…
DocumentDB SQL Tutorial
DocumentDB is Microsoft's newest NoSQL document database platform that runs on Azure. DocumentDB is designed keeping in mind the requirements of managing data for latest applications. This tutorial talks about…
Apache Presto – SQL Functions
As of now we were discussing running some simple basic queries on Presto. This chapter will discuss the important SQL functions. Math Functions Math functions operate on mathematical formulas. Following…
MySQLi – WHERE Clause
We have seen the SQL SELECT command to fetch data from a MySQL table. We can use a conditional clause called the WHERE Clause to filter out the results. Using this WHERE clause, we…
MySQLi – Select Query
The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP. Syntax Here is…
Apache Presto – Basic SQL Operations
In this chapter, we will discuss how to create and execute queries on Presto. Let us go through Presto supported basic data types. Basic Data Types The following table describes…
Apache Presto – Administration Tools
In this chapter, we will discuss the administration tools used in Presto. Let’s start with the Web Interface of Presto. Web Interface Presto provides a web interface for monitoring and…
Apache Presto – Configuration Settings
This chapter will discuss the configuration settings for Presto. Presto Verifier The Presto Verifier can be used to test Presto against another database (such as MySQL), or to test two…
Apache Presto – Installation
This chapter will explain how to install Presto on your machine. Let’s go through the basic requirements of Presto, Linux or Mac OSJava version 8 Now, let’s continue the following…
Apache Presto – Architecture
The architecture of Presto is almost similar to classic MPP (massively parallel processing) DBMS architecture. The following diagram illustrates the architecture of Presto. The above diagram consists of different components.…
- Go to the previous page
- 1
- …
- 541
- 542
- 543
- 544
- 545
- 546
- 547
- …
- 739
- Go to the next page