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
Create a Slider Component in MATLAB
MATLAB is a high-level programming language that allows us to create GUI applications without need of proper programming knowledge. In a MATLAB application, we can create various kinds of GUI (Graphical User Interface) components such as buttons, slider, text and number fields, hyperlinks, and many more. This tutorial is meant for explaining the process of creating a slider component in a MATLAB application. A slider component in MATLAB application is a GUI component that allows users to chose a specific value from a range just by dragging a slider/wiper control along the range track. In MATLAB, we can create a slider ...
Read MoreHow to rebuild Docker container on file changes?
Docker is a widely used containerization solution that allows programmers to easily package and distribute software in a lightweight and portable manner. The capability of rebuilding a container once modifications are made to its files is one of Docker's key features. This can be very helpful for a number of things, like making sure that code changes are appropriately reflected in a development environment or that code updates are always reflected in a containerized application. In this article, we will go into Docker's crucial feature and examine how it may be used to rebuild a container when files are changed. ...
Read MoreCosine Similarity Calculation Between Two Matrices in MATLAB
In this tutorial, we will learn how to calculate cosine similarity between two matrices using MATLAB. So, let’s start with the basic definition of cosine similarity. What is Cosine Similarity? Cosine similarity is a standard of measurement in matrix algebra used to determine the measure of similarity between two non-zero matrices in an inner product space like Euclidean space. Cosine similarity measures the cosine of the angle between the two matrices and produces a value between -1 and 1. Here, the value 1 indicates that the two matrices are perfectly similar, and the value -1 indicates that the two matrices ...
Read MoreHow to Paste Skipping Hidden/Filtered Cells and Rows in Excel?
You can frequently find yourself having to copy and paste data without taking into account hidden or filtered cells while working with huge datasets or complicated spreadsheets. If you're not familiar with the right methods, this can be rather difficult. Excel, fortunately, offers various ways to complete this operation successfully. Regardless of your level of Excel proficiency, this guide will arm you with the skills and information you need to handle this typical case successfully. You'll have a firm grasp on how to selectively paste data in Excel while ignoring hidden or filtered columns and rows by the end of ...
Read MoreHow to select first 10 elements from a MySQL database?
To select first 10 elements from a database using SQL ORDER BY clause with LIMIT 10.The syntax is as followsSELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table Clients - > ( - > Client_Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, - > ClientName varchar(20) - > ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using INSERT command.The query is as followsmysql> insert into Clients(ClientName) values('Larry'); Query OK, 1 row affected (0.09 ...
Read MoreHow to Plus Text to Cell Value in Excel?
Excel is a robust spreadsheet programme that provides a wealth of functions to aid in the efficient organisation and analysis of your data. The ability to mix text with cell values is one important feature that can be helpful for creating custom labels, adding prefixes or suffixes to existing data, or simply for formatting information. By the end of this session, you will know how to merge text and cell values in many situations effortlessly using basic formulas, Excel functions, and even more sophisticated methods. Let's get started and learn the methods that will enable you to enrich and manage ...
Read MoreHow to Play Video File from Excel Worksheet?
Ever ponder whether you might easily incorporate video playback into your Excel spreadsheets? The good news is that it is in fact feasible, and in this lesson, we'll examine the detailed steps involved in carrying it out. Excel's ability to play videos can be beneficial for a number of tasks, including the creation of interactive presentations, training materials, or simply adding a visual component to your spreadsheet. You may embed a video file into your Excel worksheet and enable playback right within the spreadsheet by following the instructions in this article. This tutorial will provide you the skills and resources ...
Read MoreHow to Play a Sound if a Condition is Met in Excel?
Your Excel workbooks can benefit from the interactive and dynamic addition of sound effects, which can notify you when certain circumstances or occurrences arise. Excel has robust options to complete this work, whether you want to make a sound notification for meeting deadlines, track changes, or simply add a little interactivity. This tutorial will show you how to use Excel to play a sound if certain conditions are met. Before we get started, it's crucial to understand that this course presupposes a basic understanding of Excel and its features. You should have Excel installed on your computer in order to ...
Read MoreHow to Pick the Lower or Higher Value of Two Cells in Excel?
There are several situations in Microsoft Excel when it may be necessary to compare two values and extract either the lower or higher value depending on particular conditions or requirements. Excel's robust functions and formulae let you easily do these comparisons whether you're working with numerical data, dates, or any other kind of information. This article will give you step-by-step instructions and examples to help you master the skill of determining the lower or greater value from a pair of cells, regardless of your level of expertise with Excel. You will have a firm grasp on how to perform these ...
Read MorePartial Dependency in DBMS
What is Partial Dependency?Partial Dependency occurs when a non-prime attribute is functionally dependent on part of a candidate key.The 2nd Normal Form (2NF) eliminates the Partial Dependency.Let us see an example −ExampleStudentIDProjectNoStudentNameProjectNameS01199KatieGeo LocationS02120OllieCluster ExplorationIn the above table, we have partial dependency; let us see how −The prime key attributes are StudentID and ProjectNo, andStudentID = Unique ID of the studentStudentName = Name of the studentProjectNo = Unique ID of the projectProjectName = Name of the projectAs stated, the non-prime attributes i.e. StudentName and ProjectName should be functionally dependent on part of a candidate key, to be Partial Dependent.The StudentName can be determined by StudentID, which makes the relation ...
Read More