Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In this article, we will learn how to find the difference of the sum of list elements that are missing from Matrix and vice versa. Methods Used The following are the various methods to accomplish this task − Using for loop & from_iterable() function Using sum() & from_iterable() functions Using the Counter() function Example Assume we have taken an input matrix and a target list. We will now find the difference of the sum of list elements that are missing from Matrix and vice versa. Input inputMatrix = [[6, 3, 2], [5, 4, 1], [10, 8, 1], [15, ... Read More
In this article, we will learn Case insensitive string replacement in python. Methods Used The following are the various methods to accomplish this task − Using re.IGNORECASE, re.escape(), re.sub() Using re.sub(), lambda, re.escape() functions Using split(), lower() & replace() functions Using split(), list() and join() functions Method 1: Using re.IGNORECASE, re.escape(), re.sub() re.compile() function A regular expression pattern can be combined with pattern objects, which can then be used for pattern matching. This function also allows searching for a pattern again without rewriting it. Syntax re.compile(pattern, repl, string) re.sub() function The string with replaced ... Read More
According to Barak Obama, the Affordable Care Act (aka Obamacare) borrows heavily from similar state-level legislation (aka Romneycare) implemented in Massachusetts in 2006 and passed by then-governor Mitt Romney. The ACA exchanges' less-than- smooth launch, combined with recent revelations that many people who buy health insurance on the individual market are receiving cancellation notices, has some Americans wondering if the new law will work. President Barack Obama cites the success of Massachusetts' health-care reform as proof that, despite a rocky start, the law will work to provide nearly universal coverage to all Americans. What is Obamacare? At the national and ... Read More
Introduction Migrating from a SQL to a NoSQL database is a significant undertaking that requires careful planning and strategizing. It's important to understand the differences between these two types of databases and to identify the specific use cases for which you will be using the NoSQL database. There are several different tools and techniques available for migrating data from a SQL to a NoSQL database, and it's important to carefully evaluate the pros and cons of each option to determine the best fit for your needs. Migrating from a SQL to a NoSQL database can be a significant undertaking and ... Read More
Introduction In SQL Server, permissions are used to control access to database objects, such as tables and views. Each user in a database has a set of permissions that determine what they are able to do within the database, such as SELECT, INSERT, UPDATE, DELETE, and EXECUTE. To view the permissions that a user has been granted in a database, you can use the sys.database_permissions view. This view provides information about the permissions that have been granted or denied on database-level securables for a specific database. The sys.objects view contains information about all the objects in a database, and the ... Read More
Introduction A referential integrity constraint ensures that a foreign key value in one table matches a primary key value in another table. This helps to maintain the consistency and accuracy of the data in a database by preventing the insertion of incorrect or invalid data. However, if there is an update anomaly, the referential integrity constraint can be violated, which can lead to inconsistencies in the data. An update anomaly occurs when an update to a primary key value in a table causes multiple foreign key values in other tables to become incorrect. To demonstrate an update anomaly in referential ... Read More
Introduction A SQL query is a request for data from a database. In the context of demonstrating a deletion anomaly in a table with referential integrity, a SQL query would be used to delete a record from the parent table and observe the impact on the related records in the child table. To demonstrate a deletion anomaly, we can create two tables with a foreign key constraint, insert some sample data, and then use a `DELETE` statement to delete a record from the parent table. We can then use a `SELECT` statement to retrieve the data from the child table ... Read More
Introduction To demonstrate an addition anomaly in a referential integrity in a table, we can create a simple database with two tables: a parent table and a child table. The parent table should have a primary key column, and the child table should have a foreign key column that references the primary key column in the parent table. We can then insert some rows into both tables and run a SELECT statement on the child table that filters the results based on a column from the parent table. If we delete a row from the parent table, the result of ... Read More
Bash history is a powerful tool that can help you keep track of all the commands you've executed in your terminal. It can be especially useful when you're working with multiple terminal windows, as it allows you to easily switch between them and pick up where you left off. In this article, we'll show you how to preserve bash history in multiple terminal windows on Linux, and explain why it's so important. Why Preserve Bash History? Preserving bash history is important because it allows users to easily recall commands they have previously executed in the terminal. This can save time ... Read More
One of the most powerful features of the Linux operating system is the ability to find and manipulate files quickly and easily from the command line. This can be especially useful when working with large numbers of files or when you need to automate certain tasks. In this article, we will take a look at two of the most commonly used command-line tools for finding and compressing files on Linux: the find command and the tar command. Finding Files with the find Command The find command is a powerful tool that allows you to search for files on your Linux ... Read More