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 by Pradeep Kumar
Page 10 of 104
Difference between PHP and C
PHP and C are two distinct programming languages that serve different purposes. PHP is a server−side scripting language primarily used for web development, while C is a low−level procedural programming language used for system programming. Understanding their differences helps developers choose the right tool for their projects. What is PHP? PHP (Hypertext Preprocessor) is a general−purpose programming language developed by Rasmus Lerdorf in 1994. It is primarily utilized for web development and runs on web servers to generate dynamic content. PHP code is processed by a PHP interpreter installed on web servers as a module, daemon, ...
Read MoreDifference between Hadoop and MongoDB
Hadoop is a Java-based distributed computing framework designed to store and analyze large volumes of data across multiple computer clusters. It processes enormous amounts of structured and unstructured data through its core components: HDFS (Hadoop Distributed File System) for storage and MapReduce for parallel data processing. MongoDB is an open-source NoSQL document database that stores data in BSON format rather than traditional tables, rows, and columns. It's designed to solve performance, availability, and scalability issues of SQL-based databases by offering a flexible, document-oriented approach to data storage. What is Hadoop? Apache Hadoop is a distributed computing platform ...
Read MoreDifference between NoSQL and RDBMS
RDBMS stores data in structured tables with fixed schemas using SQL. NoSQL is a non-relational approach with flexible schemas, designed for large-scale distributed data. Companies like Amazon, Facebook, and Google pioneered NoSQL to handle massive data volumes that traditional RDBMS struggled with. RDBMS ID Name Age Fixed Schema | Vertical Scaling vs NoSQL ...
Read MoreHow to add country/area code to a phone number list in Excel?
In this tutorial, you will learn how to format phone numbers with country code using three simple methods. Method 1: Using Format for Phone Number with Country Code You need to take the following actions to be able to add a country code to the Formatted Number column. Step 1 Select the phone number from the range of cells C1:C7. Step 2 Press ctrl+1. When Format cells dialog box opens, choose Custom and type +1 (000) 000-0000, then click OK. Result Finally, the outcome with country codes in the Formatted Number cells are shown in ...
Read MoreHow to Convert Time to Decimal Hours /Minutes/ Seconds in Excel?
A decimal hour is a time that is represented as a number. In Excel, you may have needed to convert the given time to decimal values at times. If we try to do this task manually, then it can be a time-consuming process. We can use the faster approach mentioned in this article. We can solve this task using the formulas supported in Excel. Read this tutorial to learn how you can convert time to decimal time in Excel. Converting Time to Decimal Hours in Excel Here we will use the formula to get any one of the values, then ...
Read MoreHow to Convert Numbers to Words in Indian Rupees in Excel?
When we need to convert numbers to words in Indian rupees in Excel, it can be a time‑consuming process if we do it manually as we need to type the large numbers. We can complete this time-consuming process much more quickly by using the VBA application. Even though the VBA code will be lengthy, we can use this process if there are many values to convert. Read this tutorial to learn how to convert numbers to words in Indian rupees in Excel. Converting Numbers to Words in Indian Rupees in Excel Here we will create a new VBA module, then ...
Read MoreHow to Add Quotes around Numbers or Text in Excel
Have you ever wondered how you can add quotes to the text or words in Excel? Adding quotes is similar to adding symbols as prefix and suffix to the words. It can be done using the "format" function in Excel. In this tutorial, we have provided a detailed step-by-step explanation of how you can add quotes around numbers or text in Excel. Adding Quotes around Text using "Format Cells" Option You can use the "Format Cells" option in Excel to add quotes around numbers or text. It is simple process. Step 1: Let us suppose we have an Excel sheet ...
Read MoreHow to calculate standard error of the mean in Excel?
This same standard error would be a crucial statistic that serves as a parameter. But are you able to determine it throughout the process of sampling and distribution. A standard error of measurement, often known as the SEM, is indeed a statistical measurement which also provides an approximation of the difference between both the sample mean of the data and the actual population mean. You are aware that the Standard Error is equal to the Standard Deviation divided by the Square Root of the Total Number of Samples; hence, we can convert this into an Excel formula by writing Standard ...
Read MoreHow to Count Unique Values in a Filtered Column in Excel?
Powerful spreadsheet software like Excel provides a variety of features to alter and analyse data. Finding the number of distinct values in a filtered column is a typical task that can be helpful when working with huge datasets. Excel data filtering enables you to focus on particular subsets of your data by only displaying rows that match specified criteria. The ordinary COUNT function, however, merely counts the visible cells, including any duplicates, when a column is filtered. We need to use a different strategy in order to precisely count the unique values in a filtered column. In this article, we'll ...
Read MoreHow to Replace All After/Before Specific Character or Space in Excel?
Excel is a robust spreadsheet programme that provides a wide range of functions to successfully modify and organise data. One frequent task is to change the text in cells based on specific parameters. In order to show you how to carry out these substitutions successfully, we will lead you through step-by-step instructions and examples throughout this lesson. We will also go through how to use these functions with dynamic formulas to handle texts of various lengths. You will have the knowledge and abilities necessary to confidently edit text in Excel at the end of this session, boosting your data processing ...
Read More