Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
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 More
Errors and Error DetectionWhen bits are transmitted over the computer network, they are subject to get corrupted due to interference and network problems. The corrupted bits leads to spurious data being received by the receiver and are called errors.Error detection techniques are responsible for checking whether any error has occurred or not in the frame that has been transmitted via network. It does not take into account the number of error bits and the type of error.For error detection, the sender needs to send some additional bits along with the data bits. The receiver performs necessary checks based upon the ... Read More
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 More
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 More
The java.util.ArrayList.contains() method can be used to check if a Java ArrayList contains a given item or not. This method has a single parameter i.e. the item whose presence in the ArrayList is tested. Also it returns true if the item is present in the ArrayList and false if the item is not present.A program that demonstrates this is given as follows −Example Live Demoimport java.util.ArrayList; import java.util.List; public class Demo { public static void main(String[] args) { List aList = new ArrayList(); aList.add("A"); ... Read More
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 More
When dealing with several spreadsheets, renaming a workbook is a key procedure that can help you better organise your files and increase productivity. Microsoft's robust spreadsheet programme Excel provides a number of options for doing this operation. Learning how to rename workbooks will surely increase your productivity, whether you use Excel for personal or professional purposes. This step-by-step tutorial will show you how to rename an active or opened workbook in Excel using a variety of techniques. This course is appropriate for both novice and seasoned Excel users because you don't need any specialised knowledge to follow along. When ... Read More
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 More
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 More