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
Explain about nested queries in DBMS
A nested query is a query that has another query embedded within it. The embedded query is called a subquery.A subquery typically appears within the WHERE clause of a query. It can sometimes appear in the FROM clause or HAVING clause.ExampleLet’s learn about nested queries with the help of an example.Find the names of employee who have regno=103The query is as follows −select E.ename from employee E where E.eid IN (select S.eid from salary S where S.regno=103);Student tableThe student table is created as follows −create table student(id number(10), name varchar2(20), classID number(10), marks varchar2(20)); Insert into student values(1, 'pinky', 3, ...
Read MoreWhat is tier-3 architecture in DBMS?
The overall design of the Database Management System (DBMS) depends on its architecture. A large amount of data on web servers, Personal Computers (PC) and other elements are linked with networks with the help of basic client or server architecture.PCs and workstations are part of Client architecture that are connected over the network. The architecture of DBMS depends on how the users are linked to the database.There are three kinds of DBMS Architecture, which are as follows −Tier-1 Architecture.Tier-2 Architecture.Tier-3 Architecture.Tier-3 ArchitectureThe 3-tier architecture contains one more layer between the client and the server.In this architecture, there is no direct ...
Read MoreDifference between MIS and DSS
MIS and DSS are the two common terms that are often heard in the field of business management. But, they are quite different from each other. MIS (Management Information Systems) and DSS (Decision Support Systems) are both types of information systems that are used to support decision making in organizations. Read this tutorial to learn more about MIS and DSS and how they are different from each other. What is MIS? MIS, Management Information System, is a computer-based program to assist users to make decisions based on information present in the system. MIS is a type of link that helps ...
Read MoreDifferences between Computer Architecture and Computer Organization
Computer Architecture is a functional description of the design implementation and requirements of different components of a computer, while Computer Organization provides information about the linking of different operational attributes of the computer system. Read this tutorial to learn more about "computer architecture" and "computer organization" and how they are different from each other. What is Computer Architecture? Computer Architecture is a blueprint for design and implementation of a computer system. It refers to the overall design of a computer system, including the hardware and software components that make up the system and how they interact with each other. Computer ...
Read MoreHow to Rename Group or Row Labels in Excel PivotTable?
Excel's pivot tables are strong tools that make it simple to analyse and summarise huge datasets. They give you the ability to easily manipulate and meaningfully present your data. Managing the labels that organise and categorise your data is a crucial part of using PivotTables. You will learn how to rename group or row labels in an Excel pivot table in this article. Sometimes, the Excel default labels may not be sufficiently descriptive or may need to be customised to meet your unique reporting requirements. You may make a PivotTable that better explains your data analysis and is more user-friendly ...
Read MoreHow to Rename All Images Names in a Folder According to a List of Cells in Excel?
Have you ever had to take on the challenging duty of renaming a sizable number of image files in accordance with particular data kept in an Excel spreadsheet? Each file must be manually renamed, which can be laborious and error-prone. Luckily, using the power of programming and automation, there is a more effective approach to complete this chore. This tutorial will show you how to rename every photograph in a folder based on a list of cells in an Excel file by taking you step-by-step through the procedure. Rename All Images Names in a Folder According to a List ...
Read MoreHow to Rename a Table in Excel?
The ability to construct tables is a key component of Excel, a potent tool for data organisation and analysis. With tables, you can sort, filter, and analyse data more effectively while managing and working with it more easily. We will walk you through the straightforward procedure of renaming a table in Excel in this step-by-step tutorial. Whether you're a novice or a seasoned Excel user, learning how to rename tables will improve your productivity and data management abilities. By the end of this course, you will be competent to rename tables in Excel, giving them titles that are more significant ...
Read MoreHow to Rename a Data Series in an Excel Chart?
Excel charts are effective tools for clearly and succinctly visualising and presenting data. However, the default data series names may not always be illustrative or clear when you make a chart utilising the information from your Excel spreadsheet. Renaming data series in an Excel chart is crucial for giving your audience context and clarity, as well as for making your charts look more polished and understandable. We will walk you through the process of renaming data series in an Excel chart in this step-by-step tutorial. This article will assist you in mastering the abilities necessary to modify your chart labels ...
Read MoreHow to Remove Year From Date in Excel?
Excel is an effective tool for managing and analysing data, but working with dates may occasionally be challenging, particularly when you need to extract particular details like the year, month, or day. This step-by-step tutorial will show you how to remove the year from a date in Excel using a variety of techniques. This course will provide you the skills to handle dates effectively, whether you wish to clean up your data for better visualisation or conduct calculations without the year component. Whether you're a novice or a seasoned Excel user, this course is made to be simple to follow ...
Read MoreHow to Remove Whitespace After Text in Excel?
Powerful spreadsheet programmes like Excel are frequently used for data analysis, reporting, and a variety of other functions. However, it's typical to run into problems with additional whitespace or leading/trailing spaces in cells while working with data, which might interfere with computations or the manipulation of data. This step-by-step tutorial will show you how to eliminate whitespace after text in Excel using various techniques. Understanding how to effectively clean up your data can help you save time and assure the correctness of your analysis, regardless of whether you have a tiny dataset or a massive spreadsheet. Let's get started and ...
Read More