Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Being in a society, you have the responsibility of following some etiquette. These, when followed, makes you a better person as viewed by the society and also help you develop some self-discipline as well.When you are in a group or being associated with a group, you will carry some responsibilities such asBeing polite and using words such as Please, Sorry and Thank you will please the people around you and makes a good impression.Behaving gently and speaking in a normal voice but not loudly.Using your own things and sticking to your boundaries.Asking for permission, if you have to use other's ... Read More
BPO stands for Business Process Outsourcing. This is a great career option for freshers, whether they are technical or nontechnical students. Here a company or a country delegates or employs people to get non-core work done by experts from other companies or other countries. BPO outsourcing can be two types.Back office outsourcing: Herein the jobs are offsite and entail dealing mainly with customer care, data processing, accounting, finance or other technical work. This is a non-voice based BPO category.Front office outsourcing: Here the job is front office service oriented. The nature of the job is to provide customer related services ... Read More
You can get the sum for every distinct value in another column with the help of aggregate function SUM() with GROUP BY command. To understand the above concept, let us create a table. The query to create a table is as follows:mysql> create table SumOfEveryDistinct -> ( -> Id int not null, -> Amount int -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command. The query is as follows:mysql> insert into SumOfEveryDistinct values(10, 100); Query OK, 1 row affected (0.19 ... Read More
To create a cumulative sum column in MySQL, you need to create a variable and set to value to 0. Cumulative sum increments the next value step by step with current value.Firstly, you need to create a variable with the help of SET. The syntax is as follows −set @anyVariableName:= 0;The syntax to create a cumulative sum column in MySQL is as follows −select yourColumnName1, yourColumnName2, ........N, (@anyVariableName := @anyVariableName + yourColumnName2) as anyVariableName from yourTableName order by yourColumnName1;To understand the above concept, let us create a table. The following is the query to create a table −mysql> create table ... Read More
You can add column values without using aggregate function like sum(). For that, the syntax is as follows −SELECT *, (yourColumnName1+yourColumnName2+yourColumnName3, ....N) as anyVariableName from yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table AddingColumnDemo -> ( -> StudentId int, -> StudentName varchar(20), -> MathMarks int, -> PhysicsMarks int, -> ChemistryMarks int -> ); Query OK, 0 rows affected (0.82 sec)Insert records in the table using insert command. The query is as follows −mysql> insert into AddingColumnDemo values(1, 'John', 35, ... Read More
In order to do insert a row and get the content, you need to use stored procedure, First, you need to create a table. After that you need to create a stored procedure that will insert a row and get the content to the end user.To do the above task, let us first create a table. The query to create a table is as follows:mysql> create table InsertRecord_SelectTable -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> PRIMARY KEY(Id) -> ); Query ... Read More
The Indian Education System that exists today in India is influenced mainly by the British System of Education. The Education System is considered to be one of the most advanced in the world. There are some strengths and weaknesses in both the systems that exist today.There are many differences between the Indian and the American Education systems.3 years v/s 4 years graduation − The system that is followed in India is 10+2+3 years for streams like commerce, science, social sciences, humanities, management, and media.(Engineering degree is an exception which is a 4-year long course).However, in the US, the system followed ... Read More
You can declare a variable using @anyVariablename which is a session variable. To create a session variable, you need to use SET command.The syntax is as followsSET @anyVariableName:=anyValue;You can declare a local variable using DECLARE command. The syntax is as followsDECLARE yourVariableName datatypeYou can set the default value at the time of creating a variable. The syntax is as followsDECLARE yourVariableName datatype default ‘yourValue’Here is the demo of session variable. To understand it, let us create a table.The query to create a table is as followsmysql> create table SessionVariableDemo -> ( -> EmployeeId varchar(10), -> EmployeeName varchar(30), ... Read More
To detect current device with iOS/Swift we can use UserInterfaceIdiom. It is an enum in swift, which tells which device is being used.The interface idiom provides multiple values in it’s enum which are.case unspecified @available(iOS 3.2, *) case phone // iPhone and iPod touch style UI @available(iOS 3.2, *) case pad // iPad style UI @available(iOS 9.0, *) case tv // Apple TV style UI @available(iOS 9.0, *) case carPlay // CarPlay style UIIn swift interfaceIdiom can be used in the following way:print(UIDevice.current.userInterfaceIdiom) if UIDevice.current.userInterfaceIdiom == .phone { print("running on iPhone") }When we run the above code ... Read More
The internet is the most craziest place we have ever witnessed because there are content creators who put all their sweat and blood to create the best content but hardly get the desired response from the audience out there. On the other hand, some content despite being substandard, make people go gaga about it within minutes and hours. This made me ponder upon the key factor involved in it. What makes any content whether good, better or best go viral.TastemakersThey are influential people who introduce content they want to make viral to common people and get the content in limelight. ... Read More