Krishna Origin of the concept of “Internet of Things” MIT Auto-ID Center The phrase “Internet of Things” was coined some 20 years ago by the founders of the original MIT Auto-ID Center, with special mention to Kevin Ashton in 1999 2 and David L. Brock in 2001 3 . The term “Auto-ID” refers to any broad … Read more
The Creation of Java Java was conceived by James Gosling, Patrick Naughton, Chris Warth, Ed Frank, and Mike Sheridan at Sun Microsystems, Inc. in 1991. It took 18 months to develop the first working version. This language was initially called “Oak,” but was renamed “Java” in 1995. Between the initial implementation of Oak in the … Read more
INFORMATION SECURITY “ To catch a thief, to prevent from theft, think like a thief”. The idea is that if as a security professional you don ̳t know what threats you are facing from crackers/hackers, you will never be able to build an efficient security system. In fact many a times in movies you would … Read more
INTRODUCTION TO INFORMATION SECURITY Two hundred years ago, you probably would have made a living in agriculture. One hundred years ago, you most likely would have worked in a factory. Today, we live in the Information Age and almost everyone has a job somehow connected to information stored in digital form on a network. During … Read more
Introduction PHP started out as a small open source project that evolved as more and more people found out how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in 1994. PHP is a recursive acronym for “PHP: Hypertext Preprocessor”. PHP is a server side scripting language that is embedded in … Read more
How to Install MySQL 8.0 on CentOS 7 MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user access to each created database. Step 1: Adding the MySQL Yum Repository 1. We will use the … Read more
MySQL JOINS MySQL JOINS are used with SELECT statement. It is used to retrieve data from multiple tables. It is performed whenever you need to fetch records from two or more tables. There are three types of MySQL joins: MySQL INNER JOIN (“or sometimes called simple join”) MySQL LEFT OUTER JOIN (“or sometimes called LEFT … Read more
MySQL AND Condition The MySQL AND condition is used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query. Syntax: WHERE condition1 AND condition2 … AND condition_n; Parameter explanation: condition1, condition2, … condition_n: Specifies all conditions that must be fulfilled for the records to be selected. MySQL AND Example The following … Read more
MySQL HAVING Clause MySQL HAVING Clause is used with GROUP BY clause. It always returns the rows where condition is TRUE. Syntax: SELECT expression1, expression2, … expression_n, aggregate_function (expression) FROM tables [WHERE conditions] GROUP BY expression1, expression2, … expression_n HAVING condition; Parameters aggregate_function: It specifies any one of the aggregate function such as SUM, COUNT, MIN, MAX, or AVG. expression1, expression2, … expression_n: It specifies the expressions that … Read more
MySQL GROUP BY Clause The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement. You can also use some aggregate functions like COUNT, SUM, MIN, MAX, AVG etc. on the grouped column. Syntax: SELECT expression1, expression2, … expression_n, aggregate_function (expression) … Read more