Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to format strings in TypeScript?
In this tutorial, we will learn to format the strings in TypeScript. The string is the sequence of characters in any programming language, and the same goes for TypeScript. In TypeScript, strings are immutable. The meaning of the immutable is that we can’t change the string character at the particular index, but we can append the character to the string. Below, we will learn different methods to format the string in TypeScript. Using the + operator to merge two or more strings Generally, the '+' operator performs the addition operation of two or more numbers. When we use the + ...
Read MoreHow to add average/grand total line in a pivot chart in Excel
Have you ever attempted to include an average line or grand total line in an Excel pivot chart? It appears difficult to show or add an average/grand total line like you would in a typical chart. Create Pivot table Let’s understand step by step with an example. Step 1 In the first, we must create a sample data for creating pivot table as shown in the below screenshot. Step 2 Now, select the data range from A1:B15. Click on the Insert tab on the toolbar ribbon and then select pivot table option to insert pivot table for the selected ...
Read MoreWhat are different types of DBMS languages?
Once data is stored or filled it requires manipulation like insertion, deletion, updating, and modification of data. For these operations a set of languages are provided by the database management system (DBMS). So, the database languages are used to read, update and store data in the database.The different types of DBMS languages are as follows −Data Definition Language (DDL) − Create, Drop, Truncate, Rename.Data Manipulation language (DML) − Select, Insert, Delete, Update.Data Control Language (DCL) − Revoke, Grant.Transaction Control Language (TCL) − Rollback, Commit.The DBMS languages are pictorially represented as follows −Data Definition Language (DDL)It is a language that allows ...
Read MoreRegEx in ReactJS
In this article, we are going to see how to handle the strings with RegEx handling in a React application.A RegEx or Regular Expression is a sequence of characters that forms a search pattern and is used to check if a string contains a specified search pattern or not. It is also used to validate strings which consist of email, passwords etc.Syntaxnew RegExp(pattern[, flags])ExampleIn this example, we will build an authentication React application that takes an email and password from the user and checks if they are validated or not.We have Regex.js which contains all the regular expressions to validate ...
Read MoreWhat are the substitution techniques in information security?
Substitution technique is a classical encryption approach where the characters present in the initial message are restored by the other characters or numbers or by symbols. If the plain text (original message) is treated as the string of bits, thus the substitution technique would restore bit pattern of plain text with the bit pattern of cipher text.There are various types of substitution ciphers which are as follows −Monoalphabetic Cipher − In monoalphabetic substitution cipher, a character in a plaintext is always restored or changed to the similar character in the ciphertext indifferent of its position in the text.For instance, if ...
Read MoreHow to get the next auto-increment id in MySQL?
MySQL has the AUTO_INCREMENT keyword to perform auto-increment. The starting value for AUTO_INCREMENT is 1, which is the default. It will get increment by 1 for each new record. To get the next auto increment id in MySQL, we can use the function last_insert_id() from MySQL or auto_increment with SELECT. Creating a table, with "d" as auto-increment. mysql> create table NextIdDemo -> ( -> id int auto_increment, -> primary key(id) -> ); Query OK, 0 rows affected (1.31 sec) Inserting records into the table. mysql> insert into NextIdDemo ...
Read MoreDifference between Electric Circuit and Magnetic Circuit
A circuit is a type of network having a closed path for the flow of either electric current or magnetic flux. A circuit mainly consists of three major parts viz. source, path or conductor and load. In simple words, the term circuit can be used to represent any fixed path through which electricity, data, single or magnetic flux can flow.Depending on the type of quantity (electric current or magnetic flux), the circuits can be of two types as −Electric circuitMagnetic circuitIn this article, we are going to see the differences between electric circuit and magnetic circuit. Also, we have added ...
Read MoreDiscuss the I/O Interface in Computer Architecture?
The I/O interface supports a method by which data is transferred between internal storage and external I/O devices. All the peripherals connected to a computer require special communication connections for interfacing them with the CPU.I/O Bus and Interface ModulesThe I/O bus is the route used for peripheral devices to interact with the computer processor. A typical connection of the I/O bus to I/O devices is shown in the figure.The I/O bus includes data lines, address lines, and control lines. In any general-purpose computer, the magnetic disk, printer, and keyboard, and display terminal are commonly employed. Each peripheral unit has an ...
Read MoreDifference Between High-Level Language and Low-Level Language
A language is basically a mode of communication, because it is used to share information, ideas, and opinions. In computer systems, programming languages are used by the software developers or programmers to creates applications or software systems. A programming language provides a way of writing computer instructions that are used to perform a specific task. Examples of computer programming languages include C, C++, Java, Python, Ruby, Scala, Perl, C#, Groovy, Dart, etc. Based on the closeness of a programming language to the system hardware (mainly processor), computer programming languages are classified into two categories namely, high-level languages and low-level languages. ...
Read MoreDifference Between Abstraction and Encapsulation
Abstraction is a process of hiding the implementation details of a system from the user, and only the functional details will be available to the user end. On the other hand, Encapsulation is a method of wrapping up the data and code acting on the data into a single unit. Read this article to find out more about abstraction and encapsulation and how they are different from each other. What is Abstraction? Abstraction is defined as a process of hiding the implementation details of a system from the user. Thus, by using abstraction, we provided only the functionality of the ...
Read More