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
Creating materialised view using table definition in cassandra
A materialised is defined as a database object that contains the results of a particular query. It could be called as a subset of a table. Any changes in the base table would be reflected in the materialised view. Syntax CREATE MATERIALISED VIEW view_name AS SELECT * FROM table_name WHERE column_name IS NOT NULL PRIMARY KEY (provide_primary_key) Here, view_name is the name of the materialised view, table_name is the base table, column_name are the columns provide_primary_key are the primary keys for the base table. Example 1 In this example, we are gonna have a ...
Read MoreCreate, Alter & Drop schema
Create a schema Schema is basically the logical representation of the database. there is a default schema named dbo. Objects gets created inside a schema when ‘create schema’ statement is used. To provide access to other user after the schema is created, we need to impersoinate permissions. Syntax:The syntax to create a schema is − Create schema schema_name Here, we have created a schema named schema_name. Example 1: Granting permissions In this example, we are going to create a schema and grant permissions to have access to that. Algorithm Step 1 − Create a schema. Step 2 − ...
Read MoreCreate login in SQL Server
A login is a security check process to authenticate the user and make their data secure. In case of SQL, we need to login to connect to the server. Creating login for the server gives a security advantage. Also, security implications are to be understood and kept in mind while creating a login. A user will be granted the access of the database after user login is provided. Here, we are going to use various methods. Method 1: login with Password We are going to use simply the userid and password to login to the server. Syntax Create login ...
Read MoreDifference Between EBCDIC and ASCII
EBCDIC (Extended Binary Coded Decimal Interchange Code) and ASCII (American Standard Code for Information Interchange) are two-character encoding methods used in digital communication to represent characters. ASCII is a character encoding method that uses a 7-bit code to represent 128 characters, which include letters, numbers, and special characters. EBCDIC has 256 characters and is used to represent a wide variety of characters, such as letters, numbers, special characters, and control characters. Read this article to find out more about EBCDIC and ASCII and how they are different from each other. What is EBCDIC? IBM created EBCDIC (Extended Binary Coded ...
Read MoreDifference Between Inline and V Engines
An inline engine is a type of engine in which the cylinders are arranged in a straight line along the crankcase. It is also known as a straight engine or straight-four engine. A V engine, often known as a Vee engine, is a form of engine in which the cylinders are placed in two banks at an angle to each other in the shape of a "V". Read this article to find out more about Inline and V Engines and how they are different from each other. What are Inline Engines? An inline engine is a type of internal ...
Read MoreDifference Between Edge Lit and Backlit
Edge-lit and backlit lighting technologies are used in modern displays such as televisions, monitors, and advertising panels. The primary difference between the two is how light is spread across the screen. Edge-lit technology refers to a display with LEDs located around the panel's edges. Backlit technology refers to displays with LEDs located behind the screen. Read this article to find out more about Edge Lit and Backlit and how they are different from each other. What is Edge Lit? Edge-lit technology is a type of display lighting technology in which the LEDs are placed along the panel's edges. These LEDs emit light ...
Read MoreDifference Between vCenter and vSphere
VMware's vSphere and vCenter are both virtualization technology providers. While vSphere is the name of VMware's virtualization platform, vCenter is a management application used to manage vSphere environments. vCenter is a centralized management tool for vSphere environments. vSphere is an enterprise-class virtualization platform that offers services such as virtual machine management, resource allocation, and load balancing. Read this article to find out more about vCenter and vSphere and how they are different from each other. What is vCenter? vCenter is a centralised management tool for managing virtual infrastructure, including virtual machines, virtual networks, and storage resources. It allows administrators to manage multiple ...
Read MoreDifference Between Ableton Live and Suite
Ableton Live and Ableton Suite are two popular digital audio workstations (DAWs) created by Ableton, a software company based in Berlin. Both versions of the software are designed for music production and live performance, but they differ in certain areas. Ableton Live is the software's entry-level version, designed for live music creation and performance. Ableton Suite is a more advanced version of the software that includes all of the functionality of Ableton Live as well as a wide range of extra instruments and effects. Read this article to find out more about Ableton Live and Ableton Suite and how they are ...
Read MoreDifference Between Valet and Valet Plus
Valet and Valet Plus are parking services provided by various companies or establishments. The primary difference between Valet and Valet Plus is the level of service and convenience provided. Valet parking is a service in which a customer hands over their vehicle for parking to a valet attendant, whereas valet plus is a premium version of valet parking that includes additional services such as car detailing and maintenance. Read this article to find out more about Valet and Valet Plus and how they are different from each other. What is Valet? A valet parking service is a type of ...
Read MoreDifference Between Thermistor and RTD
Thermistors and RTDs (Resistance Temperature Detectors) are two types of temperature sensors that work on the principle that electrical resistance changes as temperature increases. They differ, however, in terms of construction, materials, and temperature ranges. Read this article to find out more about Thermistors and RTDs and how they are different from each other. What is Thermistor? A thermistor is a type of temperature sensor that works on the principle of electrical resistance changing with temperature. It is made from a semiconductor material, usually ceramic or polymer, and has a negative temperature coefficient (NTC), which means its resistance reduces ...
Read More