- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Hardik Gupta has Published 58 Articles
Hardik Gupta
111 Views
We shall view a Cassandra Collection Data Types tutorial along our Cassandra trip. In this, we will learn about Cassandra's Collection data type. These are data types in the same sense as arrays and structures in C, C++, etc. In addition, we will talk about the Cassandra Collection Data Types ... Read More
Hardik Gupta
215 Views
Edgar F. Codd, a forerunner of the relational model for databases, presented a set of thirteen rules (numbered zero to twelve) to specify what is needed from a database management system in order for it to be regarded as a relational database management system (RDBMS). They're also known as "Codd's ... Read More
Hardik Gupta
414 Views
A deductive database in SQL or any other database system is a tool that can draw conclusions about new facts based on the rules and information already present in the database. In deductive databases, datalog is the language commonly used to express facts, rules, and queries. The formula, when expressed ... Read More
Hardik Gupta
1K+ Views
The important statistics collected for a performed query, including time, temporary tables, indexes, joins, and more, are gathered in the Query Stats SQL editor results tab (see the following two figures). Requirements Enabled query, and collect performance schema statistics. The performance_schema has statement instrumentation enabled. SQL Editor: Query ... Read More
Hardik Gupta
428 Views
The controls listed below can be used to examine and export performance report data (see the following figure) − Export − Export all entries from the current performance report, including all queries and values, together with any associated data (including column headings). opens an export file dialogue. Copy Selected ... Read More
Hardik Gupta
686 Views
The MySQL system variable values are displayed using SHOW VARIABLES. There is no privilege required for this statement. Only the ability to connect to the server is necessary. Syntax SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] A LIKE clause, if present, tells SHOW ... Read More
Hardik Gupta
2K+ Views
The handling of missing or incorrect values in queries that change the data is governed by MySQL Strict Mode. This contains the CREATE TABLE, UPDATE, and INSERT statements. When attempting to process the query with MySQL Strict Mode enabled, which is the default setting, invalid or missing data may result ... Read More
Hardik Gupta
310 Views
In this article, we are going to learn about collecting Mysql statistics and Metrics. Performance Dashboard View statistics about server performance in a dashboard. Open a query tab, choose the Management tab, and then click Dashboard in the Performance section of the Navigator sidebar to display the dashboard. The informational ... Read More