TECH - Articles

Facebook Messenger: A new feature to exchange money at no cost

A new update It is now possible to exchange money via Facebook account, through the Messenger application, and this without any fees. Of new features have seen the giant day on the social network, Facebook, it is now possible to pay another user via the messenger application "Messenger" directly attached to your Facebook account. To make a payment or simply be the beneficiary, simply click on the icon representing a dollar. Of course, beforehand it will be necessary to inform...

Read Full

Breaking iphone password in few minutes

The password of an iPhone can be broken. If the answer is in 'yes' then it will definitely be astonishing but it is possible. A foreign company has developed a software that can break the password in a few minutes. That is why Apple has advised changing its password. The American company Gresift has developed this software. This company took help from Apple employees and the American intelligence department to develop it. After that this software is ready. ​ May seem to lock...

Read Full

Snapchat: The application will get a new look!

The fetish app for teenagers will undergo a major face lift in the months to come! Snap's goal would be to attract new users to its service, at the risk of scavenging the older users of the service. Snapchat which has a renowned voice in the introduction has to go major changes. Why this redesign? The application would no longer convince enough new users to join its platform, the cause of a lack of news and, certainly, the tough competition of Instagram, shaped like ever! A black week...

Read Full

Cheap iPhone X in planning?

That the iPhone X for Apple was not a complete success, should be known so far. The smartphone maker had to correct its projected 50 million units sold in the first quarter of 2018 to 30 million and analysts have to reconsider their forecasts. The well-known expert of the company and analyst Ming-Chi Kuo corrected his forecast significantly in January of this year. Kuo works for Taiwanese financial services provider KGI Securities and has earned a reputation worldwide as the trusted source...

Read Full

Top Best Upcoming Smartphones in May 2018

Few new flagship smartphones are expected to be launched soon in May 2018. The price of these smartphones is kept low but not on the sake of quality. The specifications of the smartphones are not exactly known and are still in rumored stage.  So here is the list of three best upcoming smartphones. 1. OnePlus 6 OnePlus 6 is the new upcoming flagship smartphone by OnePlus which is expected to be launched in May 2018. The camera quality of this phone is really good....

Read Full

Whatsapp, outgoing update and revolution coming soon

Whatsapp is now essential. Just consider how many smartphones are active every day and how many of them rely on the most popular messaging apps. The alternatives are not lacking, very often they are valid, but at present, the data offer incontrovertible facts. Nobody can reach the level of diffusion of the app that since 2014 is in the orbit of Mark Zuckerberg and Facebook. Much of the merits of success also and above all reside in the work of the developers, who, even if they are at the...

Read Full

Google introduces the Chat for Android

After many attempts by Google to create an instant messaging app that resembled Whatsapp, it seems that the creators have arrived at another innovative solution. The Mountain View company has so far created numerous apps that have not been used by users. For some time, it seems that the creators of Google are thinking to completely revolutionize the concept of instant messaging, creating a platform that can resemble traditional SMS to Whatsapp. ​ Chat for Android by Google, what is...

Read Full

पावर बैंक खरीदते समय किन किन बातों का रखें ध्यान

दोस्तो, हम सभी के हाथों मे एक से बढ़कर स्मार्ट फोन है। फोन कितने भी स्मार्ट हो गये हो लेकिन कभी न कभी बैटरी डाउन होने पर हम लोगो को उनको चार्ज करने का इंतजार करना ही पड़ता है। लेकिन आजकल टेक्नालोजी के दौर मे इनको चार्ज करना बहुत ही आसान हो गया है। आप पावर बैंक के जरिये कभी  भी कहीं भी चलते-फिरते अपने फोन को चार्ज कर सकते है। आप ने अक्सर लोगो को एक हाथ मे फोन तो दूसरे हाथ मे पावर बैंक लिए देखा होगा। लगभग हर कंपनी अपने पावर बैंक से बहुत कम समय में फोन को चार्ज करने का दावा करती है। ऐसे...

Read Full

Facebook Changes News Feed

‘What are you thinking about' is the question that confronts you every time you access the news feed on Facebook. However, this may soon become history. It is because Facebook founder has given an indication about a possible disappearance of the news feed. Entrepreneurs discussed about changes in how users consume social media as part of the company performance in the fourth quarter and a comment drew special attention.  As per the founder, they believe that stories is about to break...

Read Full

France: A national app arrives against WhatsApp and Telegram

Francia decided to create an application similar to Whatsapp but its rival: the problem would be in privacy. For now, the system is being tested and is used by a few members of the Government. ​ The French 'new WhatsApp' The news arrives today, April 19, 2018, and spreads rapidly through numerous newspapers and, to a greater extent, also through the web. What is it about exactly? France has created an instant messaging application with the aim of replacing it with WhatsApp. This...

Read Full

Twitter launches new rules: Find out what things you cannot tweet

In recent months, Twitter has given something to talk about, first by the modification they made recently in the number of characters, expanding them to 280 per tweet and now they are positioned on everyone’s lips by an announcement made by Jack Dorsey, CEO of the microblogging network, in the evening hours: the rules of the game have changed. In a group of tweets, Dorsey explained that Twitter has always been concerned of the comfort of its users and that one of the main purposes of...

Read Full

New technologies in learning and development

For more than a decade, the implementation of new technologies in the field of education has been gaining momentum. The trends are changing and this useful and revolutionary tool is managing to displace the classic educational system, which always prevailed, in which the student is considered a passive figure in the learning process, to become the main protagonist of it. The classical system assumed that the student received the information from his issuer, memorized it and used it to...

Read Full

A list of the best apps from the Play Store for Android

Android is the most used operating system by users and application developers know this too. Proposed by Google, it has been successful thanks to the open source project, which allows anyone to get a fully customized version of their OS. Because of its popularity, application developers have left a considerable number of applications [VIDEO] over the years, and every day they are adding more and more. Some of them are paid and it is always difficult to choose which app to bet on. Here,...

Read Full

WhatsApp comes with hashtag function

​ Whatsapp is the most used messaging platform in the world and since the app has been made completely free, the number of users has increased substantially. The application offers different functions to its consumers and this means that many users prefer it to all the others. In particular, in recent months, several updates have arrived: some are available in beta and still have to get inside the app, while the new feature that will be introduced soon is completely new for all users. ​...

Read Full

From driverless cars to smart speakers, ieDecode demystifies new technology

The principal release of ieDecode, India's first solely online techknowledge summit composed by indianexpress.com in organization with Airtel 4G, saw a portion of the best personalities in the tech business endeavor to demystify everything from self-sufficient autos to AI-fueled savvy speakers. A great many indianexpress.com per users saw the two-hour long occasion to take in more about the new advances that are gradually turning into a piece of our lives.  ​ In her...

Read Full

Did Google Play Penguin scam you?

A harmless game of Android has become one of the most effective ways to scam you. It was called "Pingu Cleans Up", the application with which the user could easily enjoy creating a penguin avatar to make him become the character of his game. But the game turned into a scam when it turned out that behind a harmless click was hidden the most immediate way to steal money from the card linked to your account. The "game-scam" was based in fact on the ease with which a player can...

Read Full

Facebook revises its newsfeed: More friends, Less brands

The changes that Facebook is making towards its publications has become a trending news in Social networks.  Big strategic change for Facebook. In a few weeks, the content you will see on your newsfeed will no longer be the same! Mark Zuckerberg, the founder of Facebook, said in a message published on Thursday, Jan 11. He would change the news feed of the social network giving more visibility to some publications. Indeed, Facebook will put much more forward publications shared by friends...

Read Full

TRAI’s new website lets you compare mobile, landline tariffs

Telecom controller TRAI today revealed the beta adaptation of a site that will expedite one stage data about portable taxes of all administrators for all administration territories with a view to improving straightforwardness and enabling clients to look at plans.  ​ The beta variant is right now live for the circle, and clients can take after this connect to look at versatile duties. In the main stage, the Telecom Regulatory Authority of India (TRAI) has made the levy...

Read Full

WhatsApp for Android now lets users download deleted media

WhatsApp for Android has added some new features and bug fixes in its latest updates. Earlier, it fixed a timestamp issue found in the WhatsApp beta version 2.18.109. Now, the messaging app has introduced a new feature that lets users download deleted media files. Previously, when users deleted specific files sent over WhatsApp by going to the specific folder on the smartphone, they were not able to download it anymore. But now the Facebook-owned messaging app enables you to download...

Read Full

Xiaomi Mi 6X (Mi A2) Launch Confirmed for April 25, Dual Camera Setup and Blue Colour Variant Teased

Mi 6X or Mi A2, Xiaomi's most recent cell phone is relied upon to dispatch on April 25 - a reality that is currently affirmed. While there have been a few bits of gossip and theories around the up and coming handset, the main authority subtle elements have now surfaced on the web. Xiaomi has prodded a Blue shading variation of the Mi 6X flaunting the backboard of the handset. The official secret has additionally affirmed that the cell phone will brandish a double camera setup with...

Read Full

Write BFF on Facebook to check the security. Is it true?

The fake news continues to invade the networks, the rumors about if you write BFF in a comment on Facebook, to check if your account is secure against hackers or not, it is really a hoax, a lie, a fraud, according to several news portals. It's a fake news at its best (or in this case, the worst). It turns out that this is actually a Facebook feature called Text Delight, a social network tool used to activate animations related to certain words you type. On this occasion, if you write BFF,...

Read Full

5 Tips to Make your Computer Load Fast

Today, we are living in a digital world. So it is quite natural that everyone use a computer for one thing or the other. For a good working experience, your computer should also load fast and run fast. Is it not? If your computer is slow, what to do? The following five tips may help. ​ 1. If you want to increase the speed of your computer system then you have to take all the necessary steps required to reduce error messages and also get rid of all the desktop clutter with the...

Read Full

Someone is using your webcam

This is not to make you all tensed, but to make you more careful. ​We all know that how great webcams are. They allow us to easily communicate face-to-face with family and friends even if they are on the other side of the world. Remember the tough time, when we don’t have webcams, it was not possible for us to see the glimpse of our closed ones who lived far away. Science has done really great by introducing such technology in our life. But, as you all know that “ Science has never...

Read Full

The new feature in WhatsApp, sending long voice message will be easy

Favorite instant messaging app Whatsapp comes with a new feature. This feature is currently available in the Beta version of Whatsapp Android Apps. With the help of new features, you will be able to lock the voice message recording. This will facilitate recording of voice messages. Let's tell you that this feature was first introduced in WhatsApp's iPhone app. Through this, users will be able to record long voice messages without any hassle. In it, you do not have to keep a finger on...

Read Full

The real site from which you can earn real money

YouGov Acquire 50p for each review. Who are they? This is somewhat extraordinary to others, concentrating more on social issues and general intrigue points. YouGov surveys incorporate subjects, for example, legislative issues, open issues, and business items. Extraordinary on the off chance that you have huge assessments! Prizes: Cash and prize draw  Sum per overview: 50p – £3  Min. remunerate edge: £50  Our audit: YouGov is one of the all the more fascinating locales to join to...

Read Full

Online Shopping for Mobile Phones

Which is the best mobile phone in the market? It may be difficult to decide particularly when we lack in technical knowledge in deciding which type of mobile may be the cheapest and the best. As a result what do people do in such situations? They search online for getting some help and guidance in choosing an appropriate mobile that will fit their pocket as well as serve their needs.  In addition, for what other purpose does the internet help us above and beyond exploring the...

Read Full

The best paid online survey websites

Swagbucks  Exceptionally prevalent with understudies, because of a wide assortment of approaches to winning rewards. Selective information exchange reward! Who are they? Swagbucks are a dependable review site who likewise offer prizes for playing amusements and watching recordings. Prizes: Cash, vouchers and prize draw  Sum per overview: 70 focuses called SB (40p)  Min. remunerate edge: 1 SB  Our survey: We adore Swagbucks, and we hear positive audits from our perusers about them...

Read Full

Necessity of Mobile Phone in our Life

In today’s digital world it is highly impossible to come across a person who does not have a mobile phone. Even if you could see a person without a mobile phone with him or her, it will only be a chance encounter and a rare occasion to occur. Possessing a mobile phone has become a necessity and turned out to be a widespread tendency among people.  If you ask people about one particular thing that they may not be ready to carry on without the same, the most familiar answer you may...

Read Full

Big Data: The Real Kingmaker in Democracy

Neuromarketing is all about monitoring consumer behavior to strategize businesses and this isn't a foreign concept anymore. You might have been through this situation where you are browsing a headphone on Amazon and then you begin to see the ads of headphones on various websites. It was fine until the time Edward Snowden became an internet sensation. The whistleblower was a former contractor for the CIA and he left US in May 2013 leaking to the media details of internet and phone...

Read Full

जियो ने इस तरह सस्ते किये अपने प्लान, जानिए विस्तार से

Copyright Holder: SMART WORLD SMART WORLD :  जिओ के आने के बाद भारतीय टेलीकॉम इंडस्ट्री में जबरदस्त परिवर्तन देखने को मिला है। ऐसे में अन्य टेलीकॉम टेलीकॉम कंपनियां अपने ग्राहकों को लुभाने के लिए तरह-तरह की प्लान पेश कर रही हैं । ऐसे में जियो खुद को भारतीय इंडस्ट्री में नंबर वन बनाए रखने के लिए फिर से अपने प्लान में फेरबदल किए हैं। आइए विस्तार से जानते हैं। Copyright Holder: SMART WORLD 2 GB पैक :  जियो ने हाल ही में अपने प्लान मेंं फेरबदल करते हुए नया...

Read Full

अपने मोबाइल स्क्रीन को बनाये खूबसूरत

Google image स्मार्ट डेस्क आज के टेक्निकल दुनिया मे लोग सब कुुुछ स्मार्ट तरीके से कर उसे खूबसूरत बनाना चाहते है। चाहे फिर वह आप का स्मार्टफोन ही क्यों न हो | आज को हम स्मार्टफोन की ऐसे ट्रिक बताने जा रहे हैं जिसकी मदद से आपके मोबाइल की स्क्रीन बहुत खूूूबसूरत दिखने लगेगी। जैसे मंहगे फोन की स्क्रीन की लुक दिखने में सुन्दर होती है। आप को बता दे यह ट्रिक सभी एंड्रॉइड मोबाइल में काम करती है चाहे फिर आप का मोबाइल सस्ता ही क्यों न हो। इसके आप को Google Play Store से जीरो लांचर नाम का...

Read Full

New WhatsApp features you should try

Here’s the list of the top new WhatsApp features that you should try to enhance your messaging experience in the app. - WhatsApp has finally rolled out its payment feature which is connected with UPI. This makes the entire transaction process easy. One should have the UPI payment option open for utilising this feature. - We often end up sending a message that we shouldn't. Earlier we didn't have the option of undoing this mistake. But now you can delete the sent messages for everyone....

Read Full

Oppo F7, Vivo V9, Honor P20, P20 Pro, OnePlus 6: Top Android phones with a notch

The score is setting down deep roots on Android smartphones. OnePlus fellow benefactor Carl Pei simply affirmed the outline change for the OnePlus 6 and we have just observed telephones like Vivo V9, Oppo F7, Huawei P20 and P20 Pro dispatch with an indent on the front. Here's a glance at the Android telephones with an iPhone-X like score, the ones that will turn out soon and what they offer.  ​ Oppo F7: Price in India, Specifications, Features Oppo F7 was propelled in India...

Read Full

Your smartphone may leak your information

The number of smartphone users is increasing day by day in the country and in the world. The easier the smartphone makes for your everyday life, the more the risk is. Many research has also revealed the adverse health effects of the smartphone. Now after the Facebook data leak case, another information is in the news that your phone is also spying on you. Generally, people keep the phone on for 24 hours. But hardly do you know that this also threatens your privacy.  Read on to see...

Read Full

Simple Tips to Save your Laptop Battery

You should never charge different type of applications all at once. It is because this will make use of a vast percentage of the resources in your laptop system and this will have an effect on the life of your laptop battery by making it to work inefficiently. Trim down the glow of your laptop screen to the level of a cool point and thus save the life of the battery.  You can also increase the life of the battery of your laptop by reducing the brightness of your laptop screen. If...

Read Full

How to Boost the Life of Laptop Battery?

People use laptops for many reasons, ranging from its dependability to its mobility. It is very useful for people who are always on the move due to the nature of their work or business and thus a laptop makes it possible for them to connect with the online world with the help of wireless internet. The other advantage of laptop is that it does not take up much space. One of the most important reasons why a lot of people are using a laptop computer today, however, is that it provides...

Read Full

Will Facebook be closed? This is the biggest reason, Zuckerberg is also upset.

Facebook is in a bad phase trapped in the case of theft. Despite being apologetic, the company's problems are not taking the name out. Mark Zuckerberg had to apologize in this matter, but now another problem arose in front of him. Thereby, Zuckerberg is upset. It may be so much trouble that they have to close Facebook. Like other countries, including top US advertisers like America, UK, the top Indian advertisers have also shifted from Facebook. Advertising companies have also...

Read Full

Impact of Social Media

The rise of social media has been meteoric. It has literally transformed the world into a global hub where everything available merely via a few clicks. Long distance interaction with friends, family and even with people whom we have not met in person has been simplified thanks to the rise of social media. As is the case with every other thing in life, social media also has various positive and negative effects. The rise of social media captured the heart of youths in an unprecedented...

Read Full

A new way of paying through WhatsApp, sending money now is very easy

Whatsapp has stepped into the digital payments market with the UPA-based payments service launch this year. Now the company has introduced another method of transferring money to a user's account, which makes it easier. Even after putting the users up to date, after entering the UPI PIN, the payment was to complete the further process. Users can now quickly transfer the amount by scanning the QR code. Beta version of Whatsapp is available in the QR code scanning payment method. This...

Read Full

Garmin Vivofit 4 fitness tracker launches 1 year battery life in India

Looking for a Fitness Band that will track your basic activity ????? Garmin Vivofit 4 will be the perfect product for your wrist, but Moov now has a tough competition with Fitbit Alta HR and countless other brands that want to guide you in better fitness. Despite having a color screen in Vivofit 4, Garmin claims its battery - it's a regular watch battery that you replace, so you do not have to worry about re-recharge - your whole year will end. This means that you do not have...

Read Full

Solar cells just for 20 Cents

A solar cell is a device which will convert sun's light energy to electricity. This device can be used in rural areas where there are electricity problems. The solar cells could be combined and can make a panel known as solar panel. A  single junction silicon solar cell can produce a maximum open-circuit voltage of approximately 0.5 to 0.6 volts. Solar panels are the most energy conserving devices. The best example of solar panels are solar heaters. Solar panels should be kept clean if...

Read Full

iPhone SE 2 will be Made in India item

 The successor to the iPhone SE, otherwise known as the iPhone SE 2 is set to dispatch in the not so distant future. A past report had recommended that Apple may dispatch the iPhone SE 2 at WWDC 2018. While another report had uncovered that iPhone SE 2 may go official amid Apple's training occasion, demonstrating both the reports wrong. Another report now uncovers that Apple has apparently postponed the dispatch of iPhone SE 2 because of some administration arrangements and...

Read Full

5 best Android apps of the week that you should download right now

Day in and out, hundreds, if not thousands of Android apps are released into the Google Play Store, and with such a sheer amount of apps, it's quite easy to lose track of yourself. But worry not, among the hordes of apps that are released into the Play Store, there are a few gems worth noticing. So, let's get onto it, shall we? ​ The list – Library  – An app, which is same as that of GoodReads, but minus the features of the social network. In short, this app is basically...

Read Full

How Much Weight Can a Drywall Lift Carry?

The plasterboard is a characteristic component for the interior finish since it is easy to place in wooden wall frames, it is relatively cheap compared to other materials and many finishes, such as paint or wallpaper, can receive. Due to the size and weight of the leaves, at least two people are needed to treat them. If you work alone, you can try to install the sheets with a plasterboard lift, as long as it has the correct loading capacity. ​ Description Gypsum...

Read Full

Online Backup of your Data

Online backup services make certain that your data is protected from possible hackers. The drawback in using cloud backup services for your data can be the time it takes to backup or access your requisite data in case you have stored a lot of files. In addition to it, the monthly fee charged for it by the service firm concerned, though generally reasonable, can increase over a period of time.  So obviously, you have to think about the benefits and drawbacks of both the methods and...

Read Full

How to Backup your Data Safe and Secure?

If you feel your data as important, it is necessary that you have a backup system in place. Similarly you should also take some time to backup your data on a regular basis. Regrettably, all hard drives and computers are at risk of failure. If the hard drive stops working ahead of backing up your data then you may not be in a position to access it for a second time.  Quite a lot of file backup options are available for use. You can easily use external storage devices such as external...

Read Full

Apple to launch three new iPhone models in 2018: Here’s everything to know

Apple is intending to dispatch three new iPhone models in 2018. Despite the fact that a discharge date is vague now, we can expect the refreshed renditions of iPhone X to touch base in September. As indicated by a Bloomberg report, Apple could declare another supersized iPhone with 6.5-inch show and it is code-named D33. A refreshed rendition of iPhone X is likewise expected, which has been code-named D32. The third iPhone model will be a spending variation of the iPhone X and will...

Read Full

Apple set to introduce new iPad, education tools in Chicago

Macintosh Inc is getting ready to present amazing failure cost iPads and training programming one week from now in an offer to win back understudies and educators from Google and Microsoft Corp. In its first significant item occasion of the year, Apple will come back to its underlying foundations in the instruction showcase. The occasion on Tuesday at Lane Technical College Prep High School in Chicago will check the first run through Apple has held an item dispatch intended for...

Read Full

Top "NOTCH" designs of Android Phones

When APPLE launched iPhone X, everyone appreciated APPLE for its top design as it was just brilliant. There was not even a single phone in the market that can give competition to that design other than Samsung Galaxy S8. But after that, every single android company started to make their phone look like iPhone X. The first company which came with the iPhone X like "NOTCH" was Asus. Asus launched its ZenFone 5 series in the MWC 2018 and during the launch, the company compared its...

Read Full

Popular sites that offer your website testing jobs from home

TryMyUI gives you the chance to wind up an independent analyzer. The company gives distinctive web testing administrations like remote client testing, versatile client testing, wireframe and model testing, impression testing, composed review, statistic curation et cetera. What does a Tester need to do?  To be a paid analyzer you should be enrolled on the site and the enlistment procedure is obviously. You need to say your PayPal account while enlisting. To be a...

Read Full

2 Tips to Make your Life Easy on Facebook

Today, the Internet has become a most important part of our day to day lives, and we make use of the web for completely different and new services than just a few years ago was unthinkable. For example, today almost all business people use Facebook to communicate with both customers and other people who are interested in knowing what they are doing.  In such a scenario, experts who have taken a deep dip into the world's largest and most popular social network Facebook are of the...

Read Full

All In One Solution Of CSC & Digipay

There are so many problems that comes to you regarding CSC and digipay and other system and software. Here i am going to tell you the best solution to your all problems. I have started a small initiative for this problem to give you the best solution in least time. I am working as a software engineer at HP India, Bangalore. But I have knowledge and experience of troubleshooting of CSC and Digipay related problems. ​ 1. Through Website: Just go the this website...

Read Full

Want To Know Different Ideas For Making Money On The Internet?

Listverse is a rundown based substance site. Independent journalists need to present their articles in a rundown arrange. The rundown highlight of the articles makes the site extremely one of a kind. Listverse engages list-like articles from colossal themes from legislative issues to sports, everything. In this way, as an essayist, Listverse gives you the chance to compose on any theme you are knowledgeable in. ​   As I compose writes on cash making openings, one of my perusers got...

Read Full

Switching from Windows to Mac? Things you should know.

The two main operating software people nowadays use in their laptops are WINDOWS and MACINTOSH. These two software have fully occupied the market. On one side is Windows which you can get in every laptop and other is Mac which you get only in Apple laptops. In this article, we'll talk about the things you should know if you are switching from your windows system to mac laptop. So lets get started. ​ DESKTOP ​ - Desktop is one of the big differences between the two systems....

Read Full

Work at Home and earn Rs 1000 daily. No Investment !! Part Time!!

1. Selling your products online When you choose what you need to offer, make a stock by purchasing the items discount, or creating a decent number of them to stay aware of requests, and after that set the costs you need to offer them at.  To offer these things, you can enroll on the site of any prevalent online vendor, from Amazon and eBay to littler entrances like indiebazaar.com. These entryways charge a little expense for facilitating your items.  Potential income: Earnings change...

Read Full

Apple is working on its own device displays to replace Samsung screens

Apple Inc is outlining and creating its own particular gadget shows out of the blue, utilizing a mystery fabricating office close to its California home office to make little quantities of the screens for testing purposes, as per individuals acquainted with the circumstance. The innovation mammoth is making a huge interest in the improvement of cutting edge MicroLED screens, say the general population, who asked for namelessness to talk about inside arranging. MicroLED screens...

Read Full

Why you Need to be Safe Online?

Cases like credit cards being stolen and virus infection in your computer are quite common these days. You may have definitely heard or read about them either online or offline, or maybe you have even been a victim yourself. So how to keep away from these problems and save yourself from falling prey to such incidences? Well, that is what is required to be learned and followed in practice.  These days, it seems that everything depends on computers and the internet. Be it...

Read Full

Top five WhatsApp secrets which every user should know

Whatsapp has turned into a vital piece of our life. After some time, WhatApps continues changing its highlights, because of which clients don't find the opportunity to make tracks in an opposite direction from it. Thinking about the requests of WhatsApp clients, there is dependably an update. By and by WhatsApp has brought uplifting news for its clients. There are 5 included in this, which are imperative for clients to know. ​ 1. Watch YouTube recordings on...

Read Full

Why are some SMEs averse to the idea of Digitization?

The impact of the internet on businesses needs no explanation. It has opened up new horizons for businesses thus, enabling them to reach out to countless prospective online customers across the globe. However, many small businesses shy away from digitization due to various misapprehensions. Here are few myths that are preventing some small and midsize businesses from going digital: 1. Digitization is a fad that will soon fade out. 2. Digitization is a costly affair that suits...

Read Full

7 More Tips to Avoid being Cheated Online

Read my previous article to know the 7 tips to avoid being cheated online. https://www.oyewiki.com/tech/7-tips-to-avoid-being-cheated-online-13-3-2018 ​ To know more tips, read the below given points: 1. Do not log into any bank account from a public computer or from a cyber cafe. If your need to access your bank account cannot be postponed, remember to do this secretly and also fast and exit the site as soon as your work is over.  2. Share your experience. If you...

Read Full

7 Tips to Avoid being Cheated Online

If you have an unidentified person who is halfway around the globe offering a valuable gift via email or asking you to provide additional information about your bank account or password information, the possibility is that you are being targeted by a scammer.  ​ How to avoid such scammers and cheaters? Here are some simple ways to help you avoid being scammed or cheated online:  1. Sign the debit or credit card afterwards. Sign your name on the back of your debit or...

Read Full

Best Phones Under Rs 15000 To Buy In India

Dear Readers, here are few smartphones to buy under the budget of Rs 15000 without compromising the Quality and Performance based on current availability in the market. 1. Redmi Note 5 Pro (13,999) : Recently Xiaomi launched its Redmi Note series 5 with latest design and aspects in mind which is worth considering and best budget one also so check out few details. 5.99 Inches 18:9 display, 4 GB RAM, 64 GB ROM and Expandable Up to 128 GB, 12MP + 5MP Dual Rear Camera, 20MP...

Read Full

Escanner

​ Escanner app is a multiuse app. • User can use it in scanning QR code. • User can generate their own QR code with some message, number or contact details. ​ • User can share their customised QR code. • User can also pick QR code from Gallery and read the Code. • User can share secret message by writing a message and can share which is only read by this QR code app. Now how can you get advantage from this app? For example, if you want to share your personal detail to...

Read Full

Not only mobile, you will be able to order shoes from pizza. Know how.

Pizza Hut has launched a shoe through which the pizza can be ordered. After the launch of this footwear, you will not need to call either to eat pizza nor to order on the website. In this shoe, you have a button that will be ordered for you as soon as you press. About a year ago Pizza Hut launched Pie Tops sneakers. Such shoes were given such features. It was the world's first shoe, with the help of which the pizza could be ordered. Pizza Hut Company has launched the new version Pie...

Read Full

How to Search Easily on Google?

Google is amazing and startling. Every day an astronomical amount of new data is uploaded to the Internet. And Google performs the very big task daily to update all the latest information on the Internet and put it in an index so that common people like me and you can find the requisite information in seconds with the click of a button. Google has become so big in the world.  In the year 2006, the word ‘google’ was incorporated into the Oxford dictionary as a verb. Just think about...

Read Full

How to send whatsapp messages and call people not in your contact list?

Ever since its release in January 2009, the WhatsApp messenger has brought a revolution in the field of telecommunication. The instant seamless sharing of images, videos and links on a portable device, across the globe has been one of the most fantastic discoveries of recent times. The formation WhatsApp group allows information to be passed over as many as 256 people (this is the maximum number of the members a group can have). The young people use this platform for chatting, sharing...

Read Full

This feature of WhatsApp will get rid of 'Good Morning' and 'Good Evening' messages

This feature of WhatsApp will help you get rid of 'good morning' and 'good evening' messages. The company has completed preparations to get rid of spam messages to WhatsApp users. Whatsapp users are troubled by the 'good morning' and 'good evening' forwarded messages. Whatsapp is testing a feature to get rid of such messages to users. The specialty of this feature will be that the users will get the information of the forwarded message. Users will be able to find out easily that...

Read Full

How to check if a Wi-Fi network is fast or slow with android 8.1 Oreo?

The Wi-Fi settings will now display one of the four-speed labels: Very Fast, Fast, OK, or Slow.  Google has started rolling out some good and useful feature in the Android 8.1 Oreo update, that display the speed of nearby open Wi-Fi networks before connecting to it.  The private Wi-Fi networks that require passwords don’t display any speed but continue to indicate signal strength. This speed of nearby open Wi-Fi is found out by relying on the Usage & Diagnostics...

Read Full

Recovery Android apps for photos and videos to recover

Do not get disturbed when photos and videos are deleted, these apps will help you Are you worried because the photo or video of your choice is accidentally deleted from your mobile? So do not need to be panic now. It is often seen that in many cases, without delay in deleting video and photos, users accidentally delete the content of their choice and start getting panic. We are going to tell you about the apps that you will be able to recover from your delete content...

Read Full

Airtel and Huawei made India's first 5G trial

Bharti Airtel and Huawei have started the process of implementing plans to come up with 5G in India. Both companies have run the first trial of 5G. In this case, Airtel said that a small trial can also be called the start of 5G Revolution in India. 5G mobile networks are capable of delivering 100 times faster than 4G networks. Airtel and Huawei made 5G trial: 3Gbps speed gained within 3.5GHz band. Telecom Secretary Aruna Sundarajan recently said that the telecom department will...

Read Full

4 Things to Avoid in WhatsApp Groups

WhatsApp seemed to be the solution to problems for those who have a hectic life, away from the family and with very large work teams. WhatsApp groups have for the most part become true karmas for application users.  Messages that do not end, photos and more photos that pile up the files of the cell phones and the audios and videos that are unnecessary are among the most important complaints.  To stay away from embarrassment, unwanted misunderstanding and quarrels and even the...

Read Full

5 smartphones will launch Alcatel (MWC-2018), bigger revealing price and features

In Barcelona, the Capital of Spain's, the largest tech event, Mobile World Congress (MWC) is going to start. Smartphone manufacturer Alcatel has also made a big announcement after the announcements of companies such as LG, Huawei, Samsung and Motorola. TCL-owned smartphone company Alcatel, Mobile World Congress will launch its 5 smartphones in 2018. These 5 smartphones include Alcatel 5, Alcatel 3, Alcatel 3V, Alcatel 3X, and Alcatel 1X. Alcatel is one of the first companies to launch...

Read Full

Another good news, Google Assistant will start speaking this year in Hindi

Another good news, Google Assistant will start speaking this year in Hindi here is another great news for those who use the internet. It was informed by the company that the Google Assistant app will be available in more than 30 new languages including Hindi by the end of this year. This information was given by a senior executive officer from Google. It's an official app from Google that turns the smartphone into a virtual assistant on the smartphone's homepage or by pressing the...

Read Full

You can download 3 movies in a second from May-2018

In India when 4G came after 3G, people were not happy about it. But why not, people got faster internet speed than before. But now this year, there is a big change in the world of communication in India. After this change, you will be able to download three movies of one-one GB in a second. Apart from this, you can get rid of cable, dish and internet wires too. All this will change in reality from the launch of GSAT-11. This satellite will launch France's Space Agency Ariane. ​...

Read Full

Mi Max 3 launch date specifications features with-5500mAh battery

Xiaomi Mi Max 3:  Two new smartphones of Xiaomi were sold in India for the first time on February 22nd. Now the company is preparing to bring its own smartphone into India. Its name is Mi Max 3. Some information about this smartphone has surfaced. Now XDA developers have leaked the features of Xiaomi mid-range fable Mi Max 3. The first 4,850mAh battery was given in the Mi Max smartphone. There was a big battery of 5,300mAh capacity in Mi Max 2. At the same time, the Mi Max 3 can have...

Read Full

Xiaomi MI LED TV4 to go on sale in India for the first time today

Chinese company Xiaomi launched its first television Mi TV4 in the Indian market last week. The company claims that it is the world's slimmest TV. The company's subsidiary is its thickness 4.9 mm, it is also thinner than the iPhone7. Its thickness is less than 1 rupee coin. Only after the launch, this TV was getting a tremendous response in the Indian market. Now this TV will be available for sale on February 22 i.e. Thursday at 2 pm. With this TV, the company also launched Note 5...

Read Full

3 Tips that Bring more Visitors

The front page of your website needs to convince visitors that it is worth viewing the entire site. In other words, the front page must prevent the visitors leaving the site. For this to take place, you need to have relevant content and create a pleasant environment for visitors.  ​ 1. Titles: Tests conducted on titles shows that if the titles are done well, it ensures that the content is fully read at least by 36% of visitors. When using a specific title, 500 people...

Read Full

Are you into Social Bubbles?

In all probability, you are reading this article from your desk top computer, laptop, iPad or your cell phone, right? Somehow, this link has come to you, either through some good website or through popular social networks like the Twitter or Facebook or someone known to me or you might have shared the link for good. The point is, this little screen you are reading is attractive, is not it?  But you have to be aware. Unknowingly, you may have gotten into one of the social bubbles....

Read Full

Looking to buy smartphone in budget range with good camera and features

Looking to buy a smartphone with fast speed and that too in the budget range, then this might be of your work. So I am going to tell you about the smartphones that are being given 3 GB RAM and 13 megapixel camera. All these smartphones are available in the market for less than Rs 7,000. Have a look at all these smartphones. Xiaomi Redmi 5A:  The phone, Redmi 5A with 32 GB storage costs Rs 6,999. The phone's rear camera is 13 megapixels, while the front camera is 5...

Read Full

Jio offer - Rs 2200 cashback, double data on Redmi Note 5 and Redmi Note 5 Pro

Chinese mobile maker Xiaomi has launched Redmi Note 5 and Redmi Note 5 Pro in the Indian market a few days before expanding its Redmi Note Series in India. Both phones have been launched by the company in two-two variants. The sale of these two smartphones will start online soon. Only a few days after launching the smartphones of Xiaomi, JIO has announced that it will give a cashback of Rs 2200 on these smartphones. ​ Double 5 on Note 5 and Note 5 Pro The company...

Read Full

Samsung Carnival 2018, Best offers on Galaxy S7 and more handsets

Samsung, the South Korean technology giant is offering a discount of more than Rs 6,000 for its Galaxy S7 and Galaxy S7 Edge, and many more offers on its handsets, on its official website, from 17 to 20 February. Consumers can also avail 10 percent cash back on ICICI credit card EMI. ​ We have already seen online retailers like Amazon and Flipkart organizing offers like the latest Amazon Great Indian Sale and Flipkart Republic Day Sale, where smartphones with attractive discounts...

Read Full

Another good news for Jio phones, the announcement made by Mukesh Ambani's son himself

If you have ordered a Jio Phone or you already have a live phone then this news will make you happy. Now after the new facility given by Jio, the user will be able to use the user's social media app Facebook on their phone. Jio  phone  Reliance  Retail is a smart feature phone. Reliance Jio says that its customers will be able to download Facebook app from Jio App store from Wednesday. The new version of the Facebook app is specifically designed for Jio Kai operating system (KaiOS)....

Read Full

Xiaomi Redmi Note 5, Redmi Note 5 Pro with selfie light launched in India

Chinese mobile maker Shyomi has expanded its Redmi Note Series in India. The company launched Redmi Note 5 and Redmi Note 5 Pro on Wednesday in the Indian market. Both phones have been launched by the company in two-two variants. Redmi Note 5 is an upgrade version of Redmi Note 4, launched last year. Both smartphones will be sold in India via Flipkart. Also, both phones will be available in MI dot com and MI home retail stores. In the launch of the two phones, the company also launched...

Read Full

Apple Days Sale: iPhone X to iPhone SE gets huge discounts

The craze for new users from old to new iPhone has not yet been reduced in Indian users. Whether the iPhone 5S or the iPhone 6S are many years old, these models are selling well in the market. You understand the reason behind this. From February 12 to February 15, the Apple Days Sale has been selling in e-commerce website Flipkart. Not only this, the sale of old iPhone models, but it is also getting discounts on the most expensive and new iPhone like the iPhone X. Let's know which...

Read Full

Unilever threatens to pull ads from Facebook and Google

​ Unilever possesses more than 400 brands, with a turnover in 2016 of more than 50 billion euros, and thirteen brands with offers of more than one billion euros: Ax/Lynx, Dove, Omo, Becel/Flora, Heartbrand frozen yogurts, Hellmann's, Knorr, Lipton, Lux, Magnum, Rama, Rexona/Degree, Sunsilk and Surf. It is a double recorded organization comprising of Unilever plc, situated in London, and Unilever N.V., situated in Rotterdam. The two organizations work as a solitary...

Read Full

10 Benefits of Blockchain Technology

People think that blockchain is meant for crypto currency only. But there are other uses as well for this technology than just a digital payment option. ​ Here are ten uses for blockchain technology: 1. Decentralized Internet: Programmers are currently working with decentralized internet platforms to distribute all possible features on the internet. Here everyone can join and build the features of users where no big company owns the information. 2....

Read Full

What is Blockchain Technology?

​Block Chain Technology : Blockchain is a technology that has been programmed to record Financial Transaction. This is a digital system, in which an Internet technology has the underlying strength, which can store blocks of identical information on its network. Lock-chain has the ability to distribute digital information, meaning that it acts like a distributed network. Not all records in the database are stored in a computer, but distributed in 1000 computers or millions...

Read Full

Xiaomi Mi 6x pics leaked case

It was reported in the media in the past that Chinese mobile maker (Xiaomi) is preparing upgrade variants of MI 5X. Now the updates of MI 5X's upgraded variants Mi 6X are reported to be leaked. In the first look at its pictures, it seems that the new phone of Xiaomi will have a dual camera like the iPhone X. Leaked Photos of Chinese microblogging websites are shared on Vibo and on phones. Mi 5X was launched by the company in some markets as Mi A1. It was also launched in the...

Read Full

Airtel introduced online reverification of Aadhar

Finally India's leading telecom operator Bharti Airtel is the first company ever to introduce Online Aadhar re-verification with mobile number for non resident indians (NRI), physically challenged peoples and senior citizens after a long wait. They need not to go to their retailers to re-verify the same. This is a good news for non resident indians too. As before that there was no any procedure to re verify the same. Earlier before you could re-verify your mobile number with Aadhar by...

Read Full

Xiaomi Mi A1 vs Honor 7X Camera Review

2017 will be marked as an excellent year for dual camera smartphones. Once an affair for flagship devices, dual cameras made their way to the mid-range, budget, and entry-level devices in 2017. While the cameras in entry-level smartphones have a lot to be desired, budget and mid-range devices have gotten incredibly better. To be frank, dual cameras will be a common affair for smartphones releasing in 2018.  ​ At the end of 2017, there were two dual camera smartphones released from...

Read Full

Should You Buy the Samsung Galaxy Note 8 or Wait for the Galaxy S9 S9+

We all know that Samsung releases two flagships every year, of which one is released in the first quarter under S-series, and the other is released in the last quarter with Note branding. Likewise, in 2017, the South Korean tech giant released the Galaxy S8 line-up and also the Galaxy Note 8. Despite its not-so-appealing UI, Note 8 won the hearts of many and eventually became the best phone of 2017 due to its complete package of cutting-edge features.  ​ It's been three months...

Read Full

Be Safe from Phishing Attacks

Do you think phishing is an old-fashioned attack? If so, you have to think again. In spite of smarter spam filtering, the working group on anti-phishing reports an increase in unique phishing attacks every year. What is worse? The security experts predict that it will only continue to go up in the coming years. Phishing continues to be the method for stealing sensitive information like security codes, passwords and credit card numbers.  ​ It is also a method used as malicious software...

Read Full

Galaxy A8+ is Samsung's Answer to OnePlus 5T and Honor View 10

Samsung, the number one smartphone vendor in India, has kick-started this year by launching the Galaxy A8+. The South Korean tech giant launched the smartphone in India on Wednesday at an event held in New Delhi. It seems like Samsung has released this device to take on the likes of OnePlus 5T and the Honor View 10. ​ ​ The Galaxy A8+ looks like a watered-down version of the Galaxy S8, and it has all the bells and whistles you would expect from a premium phone. For those who would...

Read Full

Samsung Galaxy X: The World's First Bendable Display Smartphone to Debut in 2019

Now that bezel-less screens have become a trend, the next most anticipated technology is the foldable/bendable display. We all know that Samsung has been working on a foldable phone from a very long time - 2011 to be precise - and after a ton of leaks and rumours, it seems like the concept is finally going to turn out into a fully commercial device. ​ As we look back into the past, Samsung showed off a prototype of a bendable display way back in 2011. Since then, the company has...

Read Full

OnePlus 6: What We Can Expect from the Next Flagship Killer of OnePlus?

OnePlus , a brand which probably doesn't need any introduction in India, perhaps in many other countries as well, has launched their latest flagship, the OnePlus 5T, only a couple of months ago. And, as the annual refresh cycle of OnePlus happens twice every year, we can assert that the next iterative update is in the pipeline and would go by the OnePlus 6 moniker. As of now, there haven't been any leaks and rumours about the phone, but here is the list of specifications we can expect...

Read Full

Your Business can Benefit from Twitter

Are you in search of a great marketing tool? If so, Twitter is a great social media platform with a lot of fun. The number of people who register on Twitter only grows each passing year. More and more people use it to be in contact with their friends. Many also use it as a business tool. Here are some helpful ideas on how you can use Twitter to help your business.  When we live in a world that is moving very fast things never remain the same for a long time. They are constantly...

Read Full

How to Succeed in Social Media Marketing?

You may be new to social media or trying to fill some gaps in your knowledge about social media. It is good that you try. Right now, everybody has heard how important and valuable social media platforms are. Your feeling may either be in anxiety or eagerness. However, the fact is that the social media platform is a very intricate place than it may appear on the surface.  Exploring the social media without any idea of what it may be like can only be amazing and frightening. To build...

Read Full

Tecno Camon I Launch in India, this phone with fullvay display has 13 megapixel camera

The Chinese company 'Techno' has launched its new smartphone Tecno Camon I in the Indian market. The company has given it as 'camera phone' and has made the full view display a part of it. The price of this smartphone will be Rs 8,999 in the Indian market and its offline sales will start from the first week of February. ​ ​ Keeping the trend of 18:9 aspect ratios, the phone has been equipped with a full view display. For users to browse videos, play games and do multiple tasks...

Read Full

Launch of the Olympic games limited edition variant of Samsung Galaxy Note-8

Samsung Galaxy Note 8's new Olympic Games Limited Edition has been launched. The company presented Samsung Galaxy Note 8 PyeongChang 2018 Olympic Games Limited Edition in Seoul, the capital of South Korea. South Korean company Galaxy Note Edition will give more than 4,000 unit athletes and Pyongchang winter games staff before the game starts in February.  It is worth noting that all specifications in the new variants are of the original Galaxy Note 8. Although there is a bright...

Read Full

Top Free Learning Apps That You Will Be Thankful To

We all want to learn something and in the era of technology, this has become easy. Learning helps us to grow. Here, there are some Google applications that will become your favourite. ​ 1. DuoLingo - This app is in itself a revolution. Many come on this platform to learn various languages. This application has made language learning a very easy task. It also checks your progress and there is a fluency bar on which you'll know how fluent you have become in your chosen language....

Read Full

Good Web Design for Business

The design of a website is very important. It can create a lot of difference in how users on internet will visit a particular website. As a matter of fact, the design will show the credibility of a business. In terms of this type of web design, the most important issues are adding up importance to the experience of users. It makes them feel satisfied for visiting the particular website.  A particular design that has a well-built center of attention on users provides its users with...

Read Full

Use Search Engines to Boost Traffic

If you wish to increase traffic to your blog or website, you need to understand how online users are searching for different types of information on search engines. They first look for content that looks interesting and out of the ordinary. Only after they have found the information they are looking for, they begin to read. With inbound marketing, you can help potential customers to look forward to your website.  In place of pushing ads on probable customers, you can attract...

Read Full

Samsung The Frame – The next generation television

What do you look for, when you are choosing the right TV for your home, office or any other use? There are a lot of things one needs to consider. But it’s highly unlikely that people get any ahead than the brand name, size, and resolution. The more advanced people might even look for the smart connectivity or HDR Compatibility. But Samsung, one of the biggest tech giants, known to lead the innovation in many fields have made it possible. People are going crazy over the latest “THE”...

Read Full

Artificial Intelligence, a threat to humans

What is artificial intelligence? The branch of computer science that emphasizes & intensifies on creating intelligent machines that work and react like humans is known as artificial intelligence. It can perform tasks normally requiring human intelligence, such as visual perception, speech recognition, decision making and translation between languages. It is the intelligence displayed by machines, in contrast with the natural intelligence displayed by humans and other animals....

Read Full

How to update or correct you aadhar details

How to correct Aadhar Details​ In your Aadhar  card if there is any mistake and spelling errors like mistake in your name or fathers name or spelling errors in your address might lead you many problems as now a days Aadhar is being so important for us. Seeding aadhar became mandatory for almost all government related schemes and services which requires your Demographic details. If there is any mismatch in your details with the information provided by you and...

Read Full

7 Tips for using Hashtags in Social Networks

Many of you know the importance of creating a good Hashtag representing your social media campaign on Twitter. But what many do not know is how to use them or what not to do with them. Here are seven tips for your campaigns that do not end up being a irritation for your followers and customers.  1. Do not carry a paragraph of only hashtags It is important that you define one or two that represents the spirit of your campaign. If your content has too many tags,...

Read Full

Tips to Generate Traffic with Free Methods

A lot of things are required to start an online business. To get straight to the point, you need a capital to earn money. Of course, with the versatility the internet offers, there are a lot of ways you could find to help optimize the potential of your website or business in generating traffic. Although there are ways to jump start your traffic flows, many websites do not have the resources that others have to generate more traffic to their site.  Well, you do not have to spend...

Read Full

Basic Necessity to Work from Home

Imagine that you finally took the bold step, resigned your present job, decided to follow the passion of your life, and started working from home, of course, due to lack of a new office space. You are welcome to the club. Have you been there for a few years now and guess what, it turned out that working from home is not as simple as you thought it would be.  Working from home certainly has a lot of benefits. At the same time, these benefits do not come in a sweet, care free, or any...

Read Full

Pinterest, the interesting Social Network

Pinterest is the social network of most recent things. Its ability is to share pictures and videos termed ‘pins’. People like those pins through individual or virtual boards. The educational potential of Pinterest is based on the effective union of some of the typical functionalities of social networks with a very attractive visual design. Here is a small guide to get started in the use of this great social network and some ideas to use it in other places.  To start, you must...

Read Full

How search engines can help get more visitors?

SEO is a term widely used but remains unclear to a lot of people. This article will help you know what natural SEO is. SEO is the mechanism that allows search engines to sort out the results to the research query. So if you are looking for ‘travel’ on a search engine, it will evaluate all websites that might interest you. It will rank those results in order to offer you the results that you consider most relevant to you. SEO is free and you need not have to pay the search engines...

Read Full

Importance of Firewall for your Computer

We are living today in a digital world surrounded by different types of electronic gadgets. In today’s environment, it is difficult to imagine the absence of computer technology in our everyday lives. With all the different types of portable devices at our disposal, a full-featured computer is sometimes very important, not just in the office, but also at home. And when you have a computer, for uninterrupted function of the computer and its protection, it is important to have a firewall....

Read Full

Earn Upto $1000 Per Month On Android By Chatting

Zwerl App is the platfrom on android to earn money by chatting to strangers. you will become an expert in your profession and help peoples according to their need and questions, there are many sections like  Tutoring ÷ physics, Chemistry, history ,political, Biology, mathematics, English, philosophy, geography, economics, music, religious studies, education guidance, psychology. Business ÷ accounting, finance, human resources, marketing,sales, startups, interview tips. Coding ÷...

Read Full

3 Tools to Schedule your Tweets

Social media platforms are not short of users at all times especially on Twitter. There are also a number of business accounts on Twitter that keep informed these users from time to time. At the same time, it is not possible for you to be active on Twitter all the time. But there is a way to overcome it. For this, you can schedule your tweets using a few twitter tools available for the purpose.  On Facebook, there is an option available to schedule a post. But there is no...

Read Full

Do Social Networks make our Life Easy?

Most people we know are enrolled in a social network. Among the scores of social networks that exist today, Twitter and Facebook are the best known. But do you know exactly, what are social networks? Today, as never before, we have the possibility to communicate with others at any time and at any place overcoming the limitations of place and time. There has been a rapid growth of technology and expansion of Internet.  It has made it easier for people from different parts of...

Read Full

5 Benefits of improving your Position on Search Engines

Every day thousands of people in the world start their blog. But they do not take full advantage of their blogs. They work and work without seeing the expected results. Web positioning is something that will help you get the most out of what you post. Every time you post something, you expect it to be read by as many people as possible. Being well positioned in Google will allow you to achieve it and thus have more online presence. If the content you publish is of good quality...

Read Full

4 Tips to Optimize your Content

Search giant Google makes use of more than two hundred positioning factors to find out if a page is the one that should return first to its users based on visitor queries formulated. Do you actually know which elements of internal SEO optimization are most important? Given here are the four fundamental SEO optimizations recommended. ​ 1.    Rewrite and make your URLs new Start by setting up the URL rewriting to have words in your URLs and not only numbers or page IDs....

Read Full

Make Money with YouTube Subscribers

The internet has been a great market for jobs for a lot of people who already know the ways to make money through that interesting medium. In any case, everything happens where the public is present in large numbers, and today we all already know that we are connected twenty-four hours a day. So, in this post, I will list out ways to make money through the interesting YouTube channel.  When you opt for online work, there are no problems with shouting and irritating bosses,...

Read Full

2 Steps to make Money on YouTube

In my earlier article on the subject, we saw making money with YouTube subscriber base.  https://www.oyewiki.com/tech/make-money-with-youtube-subscribers-1-1-2018 Now, let us know about the other two ways to make money on YouTube that is, ‘Disclosure’ and ‘Content’. On YouTube, the more visibility or views you get, the more ads you will attract towards your channel, and it is with those ads that you earn good money. These ads work as commercials, and you get paid for the advertisement....

Read Full

How to get more Direct Visitors?

Direct traffic is visitors who already know your website. They can tell the address (URL) from the outside, have it written or saved as a bookmark in their browser. This type of visitor comes naturally when you get more visitors from other sources and is, in a way, a measure of the value of your brand name. Naturally, you may want to work on increasing this kind of traffic.   You can market your URL in different ways outside the internet, such as ‘flyers’. How do you get more...

Read Full

2 Tips To Use Social Media For Your Benefit

With so many freelancers, web designers, developers as well as bloggers, finding networking can often be a tough fight to death (with blows of falling prices or payments delayed to months on end), especially for those who have just started. In addition to the simple interaction with friends (or should we say ‘simple fooling around’), a growing number of professionals are using social media as a tool for the distribution of their services. The Social Media Marketing can be...

Read Full

4 Simple Tips to Use Twitter

Although Twitter is simple, when you open a Twitter account for the first time, there are many things you need to understand before you start to Tweet. Once you know the basics of its use, this tool is an excellent way to make you known both personally and from work. But first if you follow these tips, they will help you understand the small functions of Twitter. ​ 1. Use the search bar on Twitter: To find people or any word related to your niche, you can use the search bar. You...

Read Full

Recharging the Batteries of your Mobile

There are many wrong but popular beliefs among people and they do mistakes when loading their electronic devices especially mobile phone. The gifts of a technological nature such as mobiles, tablets and a few other electronic devices, most commonly known as wearable, to measure our physical activity always plays leading role during festivities. All these electronic devices are provided with rechargeable batteries, an everyday element on which many myths surround.  Stated...

Read Full

An INSIGHT into MI A1

​ We all know that Xiaomi makes the largest profit in India and has it's largest market in India only. And Indians also love the products manufactured by Xiaomi. The best phone Xiaomi launched this year was Reddi Note 4 with a very decent price . But people were expecting something new and different from Xiaomi other than that of it's  MIUI and camera quality. And Xiaomi does not disappointed it's users and launched a phone with collaboration of Google naming Mi A1 . In this A1...

Read Full

8 Ways to get People follow you

If you have a blog then write in detail about different popular topics, that is, write your content clearly with a target audience. Be sure headlines contain good keywords for the article. If you have an online store, you need to write detailed product descriptions and run a blog on your site where you write about products, the business and anything else that may be of interest to your customer base.  For example, there may be tips of different kinds or analysis of...

Read Full

Why your Business should have a Blog?

Approximately, all sellers are following a number of online marketing techniques and platforms. They use it more in order to extend their point across the huge number of people who have access to the internet. Also, they do it to be in touch with their clients. As it is, the most important of this communication takes place on websites. A business can explain the world what it actually is on websites.  Blogs are close to websites. Perhaps, blogging is one of the vital techniques. It...

Read Full

Work from Home Job Opportunities

On the internet a lot of work from home jobs is available today. It is digital world. Some of the jobs you can find online are data entry jobs, survey jobs, creative design and customer service. These jobs enable you to work from home effortlessly and get a good income from these. They do not require any amount to start. That’s the best part of all these work at home jobs.  It implies that you need not have to pay any money to begin doing them. A computer with...

Read Full

Dalai Lama launches Iphone app

His holiness ‘The Dalai Lama’, has launched an IOS app to keep his followers updated on his events, schedule and other updates.   ​ The app is currently available only for IOS, Ipod users. Turning 82, he has a twitter account too, which has stunning 16 million followers. Dalai Lama praises modern technology, while also warning the bad effects if we don’t use it the right way. "Without technology humanity has no future, but we have to be careful that we don’t become...

Read Full

बदल गया मैसेज का भी पैटर्न - यह नए खास फीचर्स करेंगें स्मार्ट मैसेज करने में आपकी बेहद मदद

स्मार्ट फ़ोन अब संचार का प्रमुख साधन बन चुके हैं। और मैसेज के लिए एक से बढ़कर ऐप प्लेस्टोरे पर मौजूद हैं।और स्मार्टफोन कंपनियां भी बेहतर से बेहतर नयी चीज़ों को इन ऐप्स में जोड़ रही हैं। अपने उपयोगकर्ता आधार पर लगे रहने के लिए गूगल अपने गूगल पिक्सेल फोन पर लगातार नए अनुभव जोड़ रहा है ताकि यह सुनिश्चित हो सके कि वह समय के साथ बेहतर हो रहे हैं। गूगल सहायक के एक उन्नत संस्करण के लिए, यहां हाल के हफ्तों के कुछ आकर्षण दिए गए हैं जिससे आप अपने पिक्सेल फोन को स्मार्ट मैसेज के साथ-साथ अन्य विकल्पों...

Read Full

4000 रु से भी कम में 4G मोबाइल - जीवी टच-एंड-टाइप स्मार्टफोन, टाइपिंग में ला देगा नए बदलाव

स्मार्ट फोन अब हर किसी की जरूरत बन चुका है और हर कोई बेहतर से बेहतर फ़ोन चाहता हैं। स्मार्ट फ़ोन कम्पनियाँ भी एक से बढ़कर एक टेक्नोलॉजी के साथ नए फ़ोन मार्केट में ला रही हैं। वैसे भी भारतीय मोबाइल बाजार अपनी वृहत जनसंख्याँ आकार के कारण विश्व में टेक्नोलॉजी और स्मार्ट फ़ोन के लिए बहुत बड़ा बाजार हैं। और हर कोई इसका पूरा फायदा उठाना चाहता हैं।  भारतीय मोबाइल उपयोगकर्ताओं के बड़े सेक्शन को पूरा करने के लिए जीवी मोबाइल ने "क्रांति टीएनटी 3" स्पर्श नाम से 4 जी स्मार्टफोन को 3,99 9 रुपये...

Read Full

दुनिया की सबसे महेंगे मोबाइल कोनसे है।अभी देखे।

क्या आप जानते हैं कि 2017 की दुनिया में शीर्ष 3 सबसे महंगे मोबाइल फ़ोनों में से कौन सी चीजें हैं? 3. Kings Button iPhone 3G ​ किंग्स बटन दुनिया में शीर्ष 10 सबसे महंगे फोनों में आईफोन 3 जी की तीसरी स्थिति है। स्मार्टफोन स्क्रीन 3.5 "इंच और स्क्रीन सुरक्षा कॉर्निंग गोरिल्ला ग्लास ऑलेओफोबिक कोटिंग और स्मार्टफ़ोन संकल्प 320 × 480 पिक्सल प्रदर्शित करता है। अमरीका के यूनाईटेड स्ट्रीट यूएस $ यूएस $ में स्मार्टफोन की शुरुआत मूल्य अगर आप किंग्स 3 जी की कीमत यूरो में गिनाते...

Read Full

फ्री टॉकटाइम और फ्री मोबाइल इंटरनेट डेटा देने वाली ऐप

फ्री टॉकटाइम और फ्री मोबाइल इंटरनेट डेटा देने वाली काम की ऐप जिन्हें आपको डाउनलोड करना चाहिए फ्री टॉकटाइम और फ्री मोबाइल इंटरनेट डेटा देने वाली ऐप जिन्हें डाउनलोड करके आप अपने पैसे बचा सकते हैं। तो जानिए ऐसी कौन कौन सी ऐप हैं। ​ 1. अर्न टॉकटाइम अर्न टॉकटाइम आपको अपने मोबाइल टॉकटाइम वॉलेट में दैनिक रूप से पैसे कमाने का अवसर देता है, जब आप मोबाइल एप्लिकेशन इंस्टॉल करते हैं या अर्न टॉकटाइम मोबाइल एप्लिकेशन के माध्यम से खरीददारी करते हैं। आपके कमाएं टॉकटाइम वॉलेट में...

Read Full

Two Important Sources to Get Visitors

Once you have established your own website or blog, one important thing to consider is recurring traffic for your website or blog. Some type of traffic can be very temporary and not recurring and that is of no use. If you have a visitor profile that is mostly from non renewable sources, a little word spell, but gives you an idea, you must constantly renew your traffic, which can be very laborious.  Particularly blog posts, for example, become old very quickly, that is, after a week...

Read Full

२६ MP कैमरा ६००० mAh बैटरी और १६ GB रोम, सिर्फ ५९९९ रुपये!

मेरे प्यारे देश वासियों आपने बिल्कुल सही पढ़ा है, एक स्मार्टफ़ोन में इतने सारे फीचर्स वह भी इतने कम दाम में। आजकल बहुत सारी कंपनियां अपने उपभोक्ताओ को रिझाने के लिए सबसे ज्यादा फीचर्स वाले मोबाइल फोन बहुत ही कम दाम में बाजार में उतार रही हैं। और कंपनिया एक दुसरे से कॉम्पीटिशन कर रही है|  इसी बिच चाइना की स्मार्टफोन कंपनी ग्रेटेल ने चाइना में सबसे बड़ी कंपनियों से सस्ता स्मार्टफोन GT6000 लॉन्च किया है। इस स्मार्टफ़ोन कंपनी ने इस फोन की कीमत दूसरे फ़ोन्स से जो कि...

Read Full

5 Ways to Protect your Online Data

We live in a digital world today. Internet and mobile has penetrated our life as never before. The work we do online is innumerable. The situation is such that we cannot live even a single day without the electronic gadgets that we have embraced. Naturally, the information we give out or share with others is also enormous. At a time when almost all of our information is easy to get on the Internet, through the different types of accounts we have in the digital world, it is becoming more...

Read Full

6 More Tips for Safe Mobile Use

Tips for Safe Mobile Use: 1. Think about apps you download You should not have more apps on your mobile. When you download an app, you'll get information about what resources the app wants to access. If you download a game, you must consider if you want this app to have access to contact list information, your call history and location. 2. Turn off wireless network when you are not using  It will save power and avoid the mobile connecting to wireless networks you...

Read Full

4 Tips for Safe Mobile Use

Basically, the mobile phone is safer than a computer. It is therefore important that you do not open it or meddle with it unnecessarily. Following are 4 tips for a safer mobile use. ​ 1. Lock your mobile:   The easiest way one can access your mobile is when someone gets physical access to it. If you have not locked it with key lock, just doing it will be in your own interest. Some mobiles also have the option of pattern recognition. You may want to clean the screen. Otherwise...

Read Full

Genuine talks: Freedom 251, a Rs 250 phone finally delivers

Freedom 251 delivers, Google ties up with Indian Railways, Bitcoin jobs Welcome to genuine reviews and we have brought a new technology current events for today. Please subscribe our blog. Before moving forward I would like you to press the bell icon. If you haven't click the bell icon please click it and please give a like on our Facebook page!! If you like our facebook page and press the bell icon you will get our latest notification. Click Here!!...

Read Full

Are you Browsing your Mobile Safely?

Many people are not aware how badly secured some popular websites are. Therefore, you must have a keen eye to see if you are on a safe connection. If you are not, the information you enter like passwords and card details can be stolen up by someone with a little computer skills and weird intentions. Today, the very lowest level of safe browsing is on the mobile phone.  Stuffed letters and numbers: These days, you can see a small, usually green padlock in the address bar of...

Read Full

Why your Website should be in HTTPS?

As a businessman, it is understandable to devote the bulk of your resources and time in managing the business. But you do not have to neglect your supporting tools like your website. It is a thing too often neglected and yet, allows you to acquire new prospects. In the business-customer relationship, simple concepts such as security and trust are very essential.  On the web, your ability to provide users with the assurance of a secure navigation (when placing an order or sharing...

Read Full

Top 4G smartphones Under Rs 10,000

Hello friends In this post, we are going to tell you the best 4G smartphone within Rs 10,000 pricing with their specifications. Because of the 4G connectivity in India, everyone is upgrading their smartphone into 4G handsets. Right now you are looking for a good and cheaper 4G handset, so we are telling you the smartphones coming within the best Rs 10000 price in this post. The handsets we are going to tell has the best performance under this range. The connectivity of these 4G handsets...

Read Full

सबसे अच्छे 10,000 कीमत के अंदर के टॉप 4जी स्मार्टफोन

नमस्कार दोस्तों इस पोस्ट में हम आपको 10,000 कीमत के अंदर की सबसे अच्छे 4जी स्मार्टफोन उनके स्पेसिफिकेशन के साथ बताने वाले हैं। भारत में 4G कनेक्टिविटी आने की वजह से हर कोई अपना स्मार्टफोन 4जी हैंडसेट में अपग्रेड कर रहा है। अभी आप कोई अच्छा और सस्ता 4जी हैंडसेट ढूंढ रहे हैं तो हम आपको इस पोस्ट में सबसे अच्छे 10,000 कीमत के अंदर आने वाले स्मार्टफोन बता रहे हैं। हम जो हैंडसेट आपको बता रहे हैं वह काफी शानदार है। यह हैंडसेट स्मार्टफोन का परफॉर्मेंस भी काफी बेहतरीन है। इन 4जी हैंडसेट की...

Read Full

Are Mobile apps Helpful for your Mental Problems?

In a recent study, researchers have looked at digital applications as psychological help. It appears that they are effective against mild to moderate depression. Depression is the most widespread mental disorder. Globally health services are struggling to meet the demand for treatment. At the same time, majority of the population in many countries has smart phones. A lot of applications have come out to reduce stress, treat anxiety, control mood, etc.  This seemed to be a new and...

Read Full

Social Networks and their Influence on our lives

Social networks are present in our day to day life. But, in spite of everything, how far can they influence our life and the society we live in? Can you be aware of your strength? Are they just simple applications that allow you to share photos and ideas, make conversation, search for classmates and friends, promote meetings and encourage relationships? They allow a new way for society to play a part.  With interesting applications that facilitate and support relationships, with...

Read Full

Top 5 Smartphone myths Busted

It's quite evident that the world of technology is getting bigger and bigger with every single day passing by. A smartphone is often considered as a pinnacle of what technology has ever achieved and also regarded as a computer in our pocket. Although we know numerous things a smartphone could do, there are quite a bunch of them that we are mistaken about. These are five of the smartphone myths that everyone believes are true but not. ​ ​1.Higher the MegaPixel (MP) of a Camera, Better...

Read Full

This Tech news will amaze you

Tech plays a vital day in our day to day life. We can't imagine our life without it. Just imagine a day without our smartphone and think about it. So, today we are going to see some of the latest news related to technology.​ ​ Latest NEWS: 1. Qualcomm Snapdragon source image: Google image The first news is from Qualcomm Snapdragon Qualcomm processor. The latest news is that you can get to see a new design of 10 nm with 4 Cortex-A 75 core and remaining cortex will A-53...

Read Full

How to make Money by Uploading Videos to Facebook?

Many of you might have often heard people telling ‘make money by uploading videos on Facebook’. Is there really a way to make money by uploading videos to Facebook? As you know, at present, to view a variety of videos, the website that comes to our mind is YouTube only and nothing else. Hence there is no wonder that people are very fond of YouTube.  As expected, people are accessing the universally popular YouTube only for their entertainment and pleasure and gaining knowledge. At the...

Read Full

Electrifying Tyres for Electric Vehicles

Electric Vehicle is the “New Green Revolution” of our generation and we all know tyres are one of the biggest waste hazards around. Tyres developed for electric vehicles would be next responsible thing for tyre manufacturer. You might probably look for what make these tyres so special. ​ What make EV tyres so special? Ultra Low Rolling Resistance: Rolling resistance of tyres for electric vehicles is generally 20-30% lower than that of a conventional tyre....

Read Full

4 Free Sources for Getting Visitors

When you do it correctly, you can build a website with a respectable number of visitors per day in three to six month’s time. With respect, I mean, in this case, hundreds of visitors. I perhaps have the courage to say that this number of visitors can be reached without any special ability for online marketing. But, of course, it is relative and depends on the viewer's goals, place and experience. The internet is very big and the largest websites have millions of visitors per day.  ​...

Read Full

Get Free Visitors to your Website

Whether you are a blogger, an e-commerce entrepreneur or a company, this information about how to get free visitors to your website applies. Getting more visitors will likely take you closer to your goal. I am going to approach this subject from a general viewpoint. That is, I will discuss various possible sources of traffic on the side and state how to do it.  I have written this article for the benefit of bloggers, e-merchants and other businesses that have little traffic and few...

Read Full

Know about the Crypto Currency

When printing the national currency in each country, the gold reserve, the right to which belongs exclusively to the state concerned, is taken into account. Unlike the national currency, the crypto-currency does not have any owner. Crypto-currency has no guarantee from state obligations, no oil connection, no gold reserves, and no security. Each of the crypto-currency is in essence a long string of numbers with a mathematical code.  These long strings of number with a mathematical code...

Read Full

Business card size large capacity power bank just for you

Remember the times whilst phones had dial pads and every smartphone emblem had their own special charging connector? Those were the days, a single rate could be enough for per week's real worth (or maybe even greater) in comparison to modern-day breed of smartphones with energy hungry hardware, you'll be lucky to get through a complete day. The simple technique to this problem is both to shop for a cellphone with an awesome battery lifestyles or simply learn how to conserve your battery....

Read Full

One Plus 5T - A Flagship Rated Smartphone

Like other companies, (for eg, Xiaomi) One Plus entered our smartphone market through online shopping market and after it launched it's first smartphone in India, it just rocked the mid range smartphone market. It has launched One Plus, One Plus 3, One Plus 3T, and One Plus 5. Recently one more name is added to it that is One Plus 5T. It was launched on 16 November 2017 and it's launch was streamed live on YouTube. After the launch of One Plus 5 , it performed really well with it's...

Read Full

4 Tips to Succeed in Online Marketing

​ Here are four tips to succeed in online marketing: 1. Social Media: Twitter, Facebook, and blogs are some of the most commonly used social media when it comes to marketing. Social media is an essential sales channel. But they can also be used to build trust and good relationships between the customers and the business. By creating social relationships and ties with the customers, trust will be built up, which means that customers come over and over again. In addition, social...

Read Full

CryptoCurrency

Hello,  Today I am going to talk about the cryptocurrency & how does it affect our daily life. I am writing it today because today something happened to me after that I thought I should share this information with all of you. At first let us talk about cryptocurrencies. These are some kind of virtual currency which didn't get legal permits in so many countries as a currency. Well, keeping bitcoins is not illegal but it is an unofficial currency in so many countries so like in India...

Read Full

Top 10 SSL certificates

Introduction Secure socket layer (SSL) works as the digital certificate that behaves like the base for the internet security. SSL is the digital certificate used to make the encryption connection between the user and server or user and browser. The main key point of using SSL is the protection of the sensitive information such as bank details, credit, and debit card details etc. When users initiate the process that needs credit and debit card information, the process is called...

Read Full

iMediaShare App, its features and how to download App on Android, iOS & PC

If you have a smartphone, then you can enjoy playback and the stored things like home videos, photos, movie and lots more. You can enjoy all these things by using an  iMediaShare app . Smart TV support all the latest technologies such as Miracast, DLNA and much more. iMediaShare enables you to view the stored content in Smart TV through both iOS & Android phones. This amazing app is free to download. It works with Blu-ray players, media boxes, audio systems and lots more....

Read Full

How to use and downloading process of WPS App and its features?

WPS app is used to check the security level of the network with the help of WPS protocol. WPS stands for Wi-Fi protection setup. The protocol allows the user to connect with the network using 8 digit pin number. The pin number used in the process is a predefined number in the router. Introduction WPS is a wireless network standard which enables user to connect to the router using any wireless device quickly and effortlessly. It only works for the device those are...

Read Full

Go Pro Fusion design and features

Go Pro fusion has the square design which is totally different from the Go Pro Hero 5. It is about 3.5 inches tall and wide. Though its size is different as compared to the Go Pro Hero 5 but they do have some likenesses. It also had the same rubbery texture and has same gippy patterns all over the edge of the cameras. ​ It has 180-degree camera to the front and other to the back. It has quick play button which can use to capture the photos quickly and do the recording and video. It...

Read Full

Everything you need to know about the Go Pro Hero 6

Go Pro hero 6 plays a significant role for the Go Pro. After the invention of this product, the company has gained new height. The company share jumped to the peak value just because of this wonderful innovation. Go pro now looking forward to have the great success of the Go Pro hero 6. ​ Release date People are waiting for this product. As per the information, the release of this product will take place in the month of September. This event will announce the availability...

Read Full

Content Marketing for IT Consultancies

It is important to have good content on the website. Content marketing can be vital for your organization. Content marketing is known for creating and sharing useful content with thе people. Type of the content thoroughly depend upon the operation done by the organization. Content should always be customer centered. You need to define the content after analyzing the targeted audience. Content is used to define the information which fulfills the predefined marketing goals....

Read Full

How to increase the Facebook fans for business page?

If you want to achieve success on the Facebook platform you must need a community. If you do not have community support, no one will connect with your brand. When no one is connected with the brand, it would be difficult to build a strong brand image. You always need a community that has the number of people who support and share your content.  Moreover, it is not just about the quantity, it is also important to maintain quality. You need to choose the...

Read Full

Importance of Quora Upvotes for thread and answers

​ Quora is the emerging community in the marketplace having 7 million monthly viewers. You can put your question on the Quora and get answers for the same. This is the best source to get the viral traffic for your business. To increase the distribution of the content, Quora use Upvotes method. The Upvotes signifies that the given content have high-quality content. Some people like to earn Quora Upvotes because this is the best feedback one's post can have. Importance of Upvotes...

Read Full

Facebook - How safe is it for your kid?

Imagine your 10-year-old daughter refuses to talk to you, have locked herself in the room and is showing early signs of depression from past few months. Despite your multiple efforts to know the reason behind her agony, she refuses to utter a word regarding this matter. During a psychological treatment, she reveals that one of her class mate has been bulling her from quite a while now saying that he has a picture of her’s naked and that he will post it in every social media platform. ​...

Read Full

8 Benefits of Email Encryption

​ Whether you are a businessman and a student you might be using E-mail as the primary communication tool. Nowadays all the necessary communication is taking place with the E-mails. The reason behind this is E-mail mobility, economic factor, and reliability. When you work for the organization there might be various chances that you need to get the important document through the E-mail. So it is significant that the confidential information stays safe. A wrong click can lead to a...

Read Full

Echo Dot

Echo Dot is the latest addition to the echo products line support by the Amazon. This is the cylinder-shaped device with the voice control computing used to make the connection to Alexa voice services to provide the response to the different activity such as response to the question, weather report, music, news and more. Echo dot also provides the support to control the small electronic gadgets at your home. The gadgets can be lights, switches, and thermostats. Echo dot...

Read Full

Nokia 2: All that glitters is not gold

HMD Global just announced its latest budget offering named as Nokia 2. The much rumoured smartphone was launched at a global launch event in Gurgaon. Nokia 2 is the cheapest device till now by HMD Global and acts as a entry level smartphone. The device packs in some great features while it lags at some major areas.  ​Design ​Nokia 2 boasts of a great design and build quality. The device looks premium and fits well in the hand. The device has a sculpted polycarbonate aluminium body....

Read Full

Upcoming WhatsApp feature !

WhtasApp  is a familiar name among the many Indians Who joined the group of smartphone users this year with the Jio 4G revolution.It is not quite astonishing that besides Facebook they chose what's app, for staying connected with the society as a whole. WhtasApp  too has several lucrative feature that one can not simply resist. Be it the status update feature, be it the video and audio calling feature, be it group chat feature. The developers team are constantly tryinng to update...

Read Full

Offline Methods to Get Visitors

A large number of people who set up their business online are completely ignoring the very inexpensive marketing methods at our disposal in the actual offline world. This is a reality. It's now time for you to get the offline people at once to your website. Marketing and advertising offline, utilizing the available strategies and resources is a good method to get new customers to your website. This time tested techniques have already been used in the past to attract the attention...

Read Full

The Sub 15k King: The Smartphones Battle

​The Battle of the budget smartphones is on fire at the moment. The smartphone companies are coming up with great budget smartphones to beat each other. The rivalry is increasing and it all depends upon the customer as to how to choose the best of smartphone so to ensure his value of money. Below I have enlisted the best budget smartphones that contain all the latest features and will ensure your value of money. They also ensure that you don't get fooled by the fake advertisements of...

Read Full

To get the best out of your computer

The present generation computers are very powerful, fast and comes with huge storage space. But there are still many of us having computers, which once used to be super but now has become average as compared to present day computers. Still if we maintain it properly, we can get a decent performance out of it. So following are some very useful tips, that can make a computer deliver a decent performance. ☆ Keep your drive segment, in which you have installed the Operating...

Read Full

Are dual rear cameras on chinese phones fake?

Hello everyone, one interesting talk these days is the dual rear cameraman's setup that takes DSLR quality images from smart phones. No doubt this feature has so much craze since it offers many features like lossless zoom, better quality, vibrant colours, true black and white and of course the much interesting bokeh effect (some of these features depend on type of secondary lens on phone whether telephoto or monochrome). But now a days we see a lot of small Chinese companies offering...

Read Full

Man Ki Baat - Why not deliver it on BharatNet?

Under Hon'Ble PM's flagship program BharatNet, optical fibre has been laid in thousands of villages bridging the proverbial digital divide to a great extent. Equipments have been installed in Gram Panchayat Bhawans which can be used to access internet at broadband speeds. The country is thus on the way of achieving one major milestone on the path of all round development. Here an important question arises-How good is the quality of the Optical Fibre Network being created?  And we all...

Read Full

Paint conducts electricity!!!

Hey are you wondering how can paints conduct electricity? when the paint we know are just used for paintings and preventing rust in iron bars. Read on to know more about how this revolutionary product is changing ways projects and being done.How wires in home space are being reduce and how much amount of raw resource such as plastic ,copper ,rubber can be reduced. How much amount of processing cost can be saved and the Eco-friendliness of the product ease of use. ​ Matt Johnson is the...

Read Full

Digital Solutioning Skills for Enterprises & Professionals

The demand for ‘Digital’ seems to be on rise. Quite a few IT vendors are going helter-skelter in order to catch up with the demand. Nearly every enterprise that perceives itself to be in the race, knows that the ‘game’ requires different skills, but is not sure about the capacity of the talent within the company. Many have shed work-force or are in the process and this may be giving especially the more expensive employees, a bit of anxiety. Many such employees could be seen ruing about...

Read Full

What is Locky Ransomware attack and how to protect our computer from attacks?

The global ransomware attack will not end . After WannaCry and Petya  attack , cyber criminals are now spreading an email-based Locky ransomware. The Indian Computer Emergency Response Team ( CERT-In ) has given  an alert on its website about the new Locky ransomware.  It mainly spreads through emails. Locky ransomware attackers demand payments in crypto currency Bitcoin like WannaCry  attack .  Till now, no complaint is registered in India regarding this attack...

Read Full

Blook : A Boon for Bloggers and Blog-site Owners

Today Bloggers are trying to find out fresh new opportunities to earn from their Blogs. There are number of web-sites available that pay bloggers in different ways. Some sites pay per blog, while some pay per 1000 blog views. While there are some sites that flash advertisements vis-a-vis your blog and pay you on the basis of number of times this ads are clicked. Blook is a fresh new earning opportunity in  the internet  world. Blook is an example of new opportunities that arise...

Read Full

How to make web browsing on your iPhone a whole lot faster

In the past, people used internet by means of their computer or laptop. But, the time has changed now and people have started to use mobile phones in order to search for things online. The development mobile technology and also the coming of the smartphone have made the life of people very easy. Today, they don’t want to go to virtual shops in order to purchase the things that they wanted. They can do shopping from the comfort of their smartphone and secured internet connection....

Read Full

Why Performance Testing is Important?

Performance testing is a type of testing which is conducted or handled with a very clear notion to check the  performance of  an application under heavy load. Few parameters that are all of really paramount importance when it comes to performance testing is whether the system that we are trying to test is reliable enough to be used, whether it can hold that much load and whether it will work same way when bombarded with humongous data of production. So performance t  esting is...

Read Full

Secret Gmail features you didn’t know exist

What might be one of the most challenging things for the next generation? To find a Gmail address of choice! With over 1 billion Gmail ids already taken, growing at a rate of new 100+ million users every year, it would be a gargantuan task to find a name of choice for Gmail id. Looks like, few more years and it might be hard to find a person without Gmail Address on this planet. I am sure, you have a Gmail address (may be more than one). Let’s try and find out how we could get the most out...

Read Full

Amazing Facts About Apple Company

Apple Company is one of the world’s most powerful companies. In the initial period, the company suffered an economic downturn, after that it gained such popularity that the world is seeing.  Every man has the wish to have an Apple phone sometime in life. Today we will read “Apple Facts” in this post, which no one has ever told you till date. 1. Do you know that Apple Company was founded in 1976 on the April fool (Fools Day). 2. Apple’s first logo was Newton’s picture. Not...

Read Full

Facts about Samsung

Speaking of new and attractive smartphones, Samsung’s name is remembered first. With the help of its entire Galaxy Range, Samsung has become the world’s largest smartphone maker company. Regardless of fact that Samsung has revolutionized its mobile in the field of communication, the mobile handset was not its first product. The company of South Korea started in 1938 with just a staff of 40 people. Slowly, Samsung has finally decided to fly from domestic products to becoming the biggest...

Read Full

How AI can influence the future of Indian students?

An important field of Artificial Intelligence (AI) is Machine Learning. Machine learning can be considered as the most powerful branch of AI and basically enables a machine to learn from data and then mimic the things humans can do. ​ Machine learning was in its infancy stages in the industry during the early '90s. At the time, it focused on relatively simple tasks such as assessing risk of bad debts, sorting mail by reading zip codes, etc. However, the last decade has seen...

Read Full

Top Smartphone hacks to make your life easier

With virtually a phone in each and every hand on this planet, the hand mobile device has invariably become an important part of our routine. With the revolution in the devices capabilities and apps available to download, a mobile phone is used by different people in more ways than we could even imagine. For example, a real estate dealer in India uses iPhone because of the high-veracity compass it comes loaded with. In India where the direction and layout of property is very important as...

Read Full

How spinning mills spin yarn?

​ Source for textiles ​Generally, raw material used for textile goods include natural fibers like Raw cotton, Flax, Jute etc. Alternatively, synthetic fibers like Polyester can be used. Wear comfort varies based on the raw material used. A cotton inner wear gives more comfort than wearing a synthetic inner wear. To cite another example, woolen sweaters gives more warmth and comfort during winter than cotton. Likewise, based on the end use, raw material for manufacturing...

Read Full

How to signup anywhere without you Real Email id

​ Friends, Today I'm going to tell you that how to save yourself from fraud. Many times a person is asked to sign up on a website or an app, and you will afraid about that if the website leaks my information then what will I do or if the web or app is fake then by information will be sold. So, do not compromise with you privacy just use a trick to save your private informations from spammers and also you can use the web material or app material. So, The trick is -: Use Fake Emails...

Read Full

Google redesigns mobile search app with personalised news feed

Google on Wednesday announced its newly designed news feed settings for the search app for all the mobile phones.This personalised news feed displays links about hobbies, travel, sports and other topics and it looks like the new feed of Facebook and going to give stiff competition to the social media giant. ​ Google is the world's largest search engine and its parent company is Alphabet Inc. It said that the changes begin to roll out in the US in the coming days. The new name...

Read Full

Top 10 Best Android games of 2017

​ There are a lot of best Android games available in the Google Play Store. But it is difficult to choose the right one.So I have compiled the list of best android games apps which will give you the real gaming experience. Pokemon GO Pokemon Go is the real adventure game and one of the best android games in 2017. It is the hottest and hyped game of the year.Venusaur, Charizard, Blastoise, Pikachu, and many other Pokémon have been discovered.  ​  You...

Read Full

How to recover the lost files with EaseUS Data Recovery Wizard

​ EaseUS Free Data Recovery Wizard 11.0 Version – Quick Intro EaseUS Data Recovery Wizard Free is the one of the best free data recovery software. It can also recover the missed files from the virus attack or system crash. The user interface is good in the new version so that the recovery process is easy and fast. Best Features Of EaseUS Data Recovery Wizard Free 11.0 There are some exciting features of Free EaseUS Data Recovery Wizard 11.0...

Read Full

Can Power BI become leader in the Self Service BI Tools

​ ​ Though Microsoft (MS) products for BI and Analytics have been pioneers in Gartner's quadrant, but the below points are based on one of the MS Product Offering: Power BI. It showcases the potential of how Power BI can rule the Self-service BI Tool space.   Price is low MS have thrown almost all of their analytical IP into this Power BI covering all the features from MS Office product Suite. At $10 USD per month per user , we are getting a piece of technology that...

Read Full

An App That Lets You Carry Your Aadhaar On Mobile

UIDAI Launches m-Aadhaar, an App That Lets You Carry your Aadhaar On Mobile. m-Aadhaar is official mobile application developed by Unique Identification Authority of India (UIDAI) to provide an interface to Aadhaar Number Holders to carry their demographic information viz. Name, Date of Birth, Gender & Address along with photograph as linked with their Aadhaar Number in smart phones. ​ The app is currently available for Android users only. Some of the services will only...

Read Full

Run android apps on laptop using bluestack android emulator

​ All of us have been using Android applications on our smart phones regularly but at some point of time have felt certain disconnect regarding their use on our laptops and PCs. Inquisitiveness is human nature which leads them to try and search for newer possibilities and open up the doors to new innovations. For instance if I have some very useful Android app on my phone, why should not I be able to use that app on my desktop or laptop also? One such innovation, that is...

Read Full

Top 10 best digital wallet apps for safe and secure payments

​ The digital wallet is an electronic device which helps the individuals to carry out the electronic transaction. You can use the wallet for shopping at stores.An individual’s bank account is linked with the Wallet. This is the way the digital wallets work.It passed the account information to the merchant’s terminal through Near Field communication technology.Carrying money is not safe in this world.So the digital wallets help you to keep your financial transactions safely without...

Read Full

How to Use Facebook Profile Guard to Protect Your Profile Photos

​ The Facebook introduced a new tool in India which is called Facebook Profile Picture Guard tool to secure the profile picture that is being misused. It helps you to protect the picture from stalkers. The people who are not friends of us can never tag or take the screenshot of your profile picture through by implementing this profile picture guard tool. It is rolled out only for the Android mobile devices. The social giant Facebook quoted that the feature was rolled out...

Read Full

How Are Mobile Payment Solutions Taking A Firm Grip In The Market?

​ Two decades back, when the payment with plastic cards has started, the people were amazed. Later, the cashless transaction with cards accelerated at the furious pace and make a tide over the cash transactions. Slowly, the plastic cards like - a debit card, prepaid card or credit cards also become the hassle for the people with the surge in mobile payments as they have to carry the cards with them every time. Now, people are welcoming the cashless payment landscape. According to...

Read Full

Life cycle hooks in Angular js 2

​ Angular2 is the trending UI framework that enable you to create rich interface using typescript. Angular2 application are the collection of components. Like every framework it has to go through a life cycle, here in angular we called it life cycle hook . Its important to have a idea where to use these life cycle hooks. So in this blog I tried to provide an idea where to use them. List of life cycle hooks are given below ngOnChanges ngOnInit ngDoCheck ngAfterContentInit...

Read Full

What Will Internet Be Like in 100 Years?

Facebook is planning to provide everyone with internet coverage using renewable energy, for both empowering lives and being eco-friendly at the same time! The plan is to deploy giant solar powered drones, which will beam the internet to the ground, the areas which are still disconnected from the rest of the world, due to being extremely remote. Recently Facebook completed its test flight. The drone named Aquila was airborne for approximately 2 hours (1 hour 45 mins to be exact)...

Read Full

Best Free Online Photo Editor to make your photos looks awesome

According to InfoTrends, more than 1.2 trillion digital photos will be taken in 2017. If you’re like me, you constantly have your smartphone’s camera app open, ready to take pictures of your family, vacations and pets. There are dozens of affordable clip-on lenses, numerous editing and sharing apps, and countless ways to display your smartphone pictures. Check out these 8 free online photo editors to make your digital photos top-notch. VSCO ​ The VSCO web app is a hugely...

Read Full

3 Freebies To Get Free Software

However, there are lots of websites on the Internet that provides you free software, but today I want to get three such websites from where you can download the free software (Freeware, Shareware) easily. ​ http://www.filehippo.com This website is one of the most popular websites where most of the softwares can be downloaded. In this single website, you will find all the major Freeware whether it is anti virus or any media player. The best thing about this website is that here...

Read Full

Xiaomi Redmi 4 Review

After 3 years of spreading it’s roots in Indian market Xiaomi’s popularity among the user has increased tremendously. It has established it’s new bench mark by launching almost every kind of budget smart phones. The company is creating a new landmark as far as the price and specifications of the smart phones is considered. After the sought on success of Redmi 4A ,Xiaomi has recently launched the successor of Redmi 3S REDMI 4. Redmi 4 comes along with fingerprint sensor and in...

Read Full

Have Fun with YouTube

​ Hi guys!! Today I am going to tell you some of the amazing facts about YouTube that I am sure you are not familiar with. Some of the keywords which when written in youtube search box wiil produce amazing outcomes .It might sound something weird but yeah it’s true. So, let’s see what are those amazing keywords. MAKE YOUTUBE TO GO ON A SWING Type “Use the force Luke” in YouTube search box and see it having a merry-go-round. MAKE YOUTUBE COLORFUL Just type “dog...

Read Full

Using keys in React Js

​ I recently started working on a mobile website that uses  React  for its view part. One thing I found to be critical was the usage of  key . Consider the below render function render() {     const dataArray = [       { id: 1, value: 'First' },       { id: 2, value: 'Second' },       { id: 3, value: 'Three' }     ]     return (       <ul>         {           dataArray.map(data => <li>{data.value}</li>)         }       </ul>     )   } When...

Read Full

FREE PASS : Download and Earn Rs 10 Instantly

(Image Source) FreePass App – Get Rs 10 Free Recharge instantly on downloading.  We are Back with another offer where you will get free mobile recharge of Rs 10 instantly on downloading Free Pass App. So, Hurry up and download Free Pass App to avail Rs 10 Free Recharge. You  have to achieve the target of use of data, the amount of MB data recommended by the app (you can use only 10 MB/day). As soon as your target is completed, you will instantly get Rs...

Read Full

Building an Audio Player in Electron

​ ( Image Source ) I was stumbled upon by the buzz around NodeJS and cool projects and libraries being discussed by the developers around the globe. So, as a newbie developer I was curious to learn and try out the JavaScript based server side platform. I don’t have a web app in mind however I wanted to build a desktop program. The idea of audio player came to my mind, yes I know there are at least hundreds of audio player out there which does the job far better than mine, however...

Read Full

Google Betting Big on AI Future

GOOGLE said it was moving from a “ mobile-first to an AI-first world ” as it unveiled a host of new products at its I/O conference. The company announced several new features for its Google Home speaker at I/O, including voice calling, and the ability to use Google Actions – the equivalent of Amazon’s Skills – on Android devices. The focus on AI development echoed the tone of Microsoft’s recent developer conference, but it’s Amazon the company has fixed in its sights, according...

Read Full

Impact of Automation on IT Sector

Impact of Automation on IT Sector After the industrial revolution in early 1700’s automation has taken a huge upsurge. It has helped us increase the productivity, safety and profitability. Automation in past 20 years has eliminated jobs but on the other hand has created new ones. The jobs which requires more physical work have been replaced by the jobs which requires more technical aspect of work. This has improved the working environment and the standard of living of people. So...

Read Full

Top 10 Essential Digital Security Tips For Entrepreneurs

Source   ​Gigantic sort of digital security breaks that smashed some topenterprises tossed the subject of digital security to the prevalent exchange. Thoughonly extensive organizations discover their way to the features, independent companies are not freefrom a few digital security dangers. The unpleasant actuality remains that the impactof digital assault on a private company can regularly be destroying. Studies byNational Digital Security Organization together demonstrate...

Read Full

The Most popular High end games for Android - 2017 list

Gaming on the Android has been increasing over the years as the graphics and the quality of the games are increasing with the newer version of Android  So if you're tired playing minecraft and think that 8-bit gaming doesn't make the most of your glorious phone display, here is the list of some the best high profile in the playstore to suite youe high end devices    1   GODFIRE THE  RISE OF PROMETHEUS ​Size — 2.19gb Godfire is one of the most interesting games as it contain action...

Read Full

Five Easy Steps to Earn Rs 650 by Investing Rs 300 using PhonePe App

Now a days wallet & UPI services are becoming more popular, the service providers are investing more capital to gain new customers. One among them is PhonePe app and i t has launched a very attractive refer & earn program for generating new leads. (Image Source) Recently, I have used these simple method of five steps to earn Rs 650 by investing Rs 300 using PhonePe App via two mobiles in few minutes. Step 1 :   Click Here to download &...

Read Full

Bitcoin technology

​ Bitcoin is a form of digital currency , created and held electronically . No one controls it . Bitcoins aren’t printed , like dollars or euros – they’re produced by people, and increasingly businesses, running computers all around the world, using software that solves mathematical problems. It’s the first example of a growing category of money known as the cryptocurrency . Bitcoin is a digital asset and a payment system. It is commonly called a...

Read Full

Survival of the fittest?

Science is an amazing, wonderful undertaking:  it teaches us about life, the world, and the Universe. But it has not revealed to us why the universe came into existence, nor what preceded its birth in the Big Bang. Equally, biological evolution has not brought us the slightest understanding of how the first living organisms emerged from inanimate matter on this planet, and how the advanced eukaryotic cells—the highly structured building blocks of advanced life forms—ever emerged...

Read Full

Osx - Install wget on Mac OX using brew

​ Mac OS does not come automatically with wget. Often we require to download various files to install various softwares and utilities. So for downloading wget is an useful utility. Below are the steps to install wget on Mac OS. brew install wget This should work. Try to download a simple file to test wget http://www.tcpdump.org/release/libpcap-1.7.4.tar.gz Let us know if you find any...

Read Full

How to use for entity framework code first with mysql using visual studio 2015

Hello everyone, this article is targeted to .net developer who wants to use Mysql as a back end and entity framework  as ORM with code-first approach. Minimum Requirement VS2015 MySqlConnector with Visual Studio If you don't have MySql Connector in your system download from this link and install https://dev.mysql.com/downloads/windows/visualstudio/ I have created a console application for this demo.After adding a console application  add these packages by using Nuget....

Read Full

Determine Operating System type using Java

Hi, In this post we will try to determine Operating system type using Java One of the system properties,   os.name   can help us in achieving that. Below code can detect Windows, Mac, Unix, Solaris. Determine Operating System using Java: package Selenium; public class DetermineOS {     public static String OS = System.getProperty("os.name").toLowerCase();     public static void main(String[] args){         System.out.println(OS);...

Read Full

Building Blocks of Angular2

In Angular2 we have 8 building blocks that help us to create an angular application. In this article I have mention 6 of them so that we get an idea what are they and where they can be used this is the architecture overview. This is just a brief introduction. Each building blocks will be explained in near future in separate articles. Modules:  In our angular application we must have at least one module class conventionally it is Appmodule and also called as a root module ....

Read Full

How to setup angular2 in visual studio ide

As a .net developer we always want that we can develop our application in Visual Studio IDE . So in this article our main focus is to add Angular2 with typescript project in VS IDE. To do that we must have these thing installed in our machine Node.js ( greater than version 4.6.*) and (npm greater than version 3.*.*). Visual Studio 2015 Update 3 Install Typescript 2 for VS2015 from link  download typescript from here Note : We need to configure External web tool as mention...

Read Full

301 Page redirect, misunderstanding I had.

As the title suggest, I misunderstood 301 page redirect in one of my web applications which led to, that's right, a Bug! Let's first try to understand why we need a page redirect and how should we use it. I will try my best to explain this using some scenarios below. Scenario 1 Suppose you have a website whose url is https://sellon.india.com . This website has all the things for SEO (Search Engine Optimization). Now your team has developed a new and better web application which...

Read Full

How to solve IE/Edge CORS error ?

As a web developer, it is highly likely that you have encountered below while trying to fetch data from other domain. XMLHTTPrequest cannot load <api_name>. No 'Acess-Control-Allow-Origin' header is present on the requested resource. Origin <your_website> is therefore not allowed to access But, ever encountered a scenario where it is working fine on every other browser on the planet but not on Internet Explorer or Edge . This can be a little frustrating. Below is...

Read Full

Web Server vs Application Server Difference Explained

Web servers are used to server static content over the http request. while application servers are used to serve dynamic content over variety of requests. Web servers also act as protecting container to the application server, restricting direct access to the application server by the client. In this the port on which web server is running is accessible from outside, whereas access to port on which application server is closed and client can only contact web server thus...

Read Full

MYSQL difference between count(*) and count(column_name)

Earlier we have published about Mysql Count Function  which is used to return the total number of rows present in any database table. Count function is mainly used where we want to fetch the total number of records in any of the given table. Problem Statement So the question arises is that what is the difference between count(*) and count(column_name)? count(*) count(*) returns the total number of rows in any table irrespective of the values inside the columns. count(column_name)...

Read Full

MYSQL Dump - How to take mysql dump or export mysql data

Some times we get a requirement to take mysql dump from remote server to share within our teams or ofter we use to get mysql backup at some regular interval to keep a backup copy of your MYSQL databases. There can be lot more scenarios where we require to take mysql backup. We take this with the help of MYSQLDUMP command. The syntax of mysqldump command is  MYSQLDUMP -u user -p password database_name > file_name.sql  user - User name of the user that...

Read Full

Find the name of the hostel which has second highest capacity from hostel_list table

Problem Overview Suppose we have a table hostel_list   - List of hostels +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN | 2 | 1090 | |  2 | KAILASH BHAVAN | 2 | 990 | |  3 | RUDRAKSH BHAVAN | 2 | 990 | |  4 | KAVERI BHAVAN | 1 | 690 | |  5 | BHAGIRATHI BHAVAN | 4 | 2140 | |  6...

Read Full

Calculate nth Highest salary of an employee

In this article I am emphasizing the ways to get the nth record from a table . Here I have took a old example of employee salary.  Now first we need a table  EmployeeSalary  CREATE TABLE [dbo].[EmployeeSalary](     [EmployeeID] [int] IDENTITY(1,1) NOT NULL,     [EmployeeName] [nvarchar](50) NOT NULL,     [Salary] [money] NOT NULL,  CONSTRAINT [PK_EmployeeSalary] PRIMARY KEY CLUSTERED (     [EmployeeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Read Full

Incorrect table definition there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Error I was getting this error in adding a table in MYSQL Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause My new MYSQL table looks something like this. create table table_name (col1 int(5) auto_increment primary key, col2 varchar(300), col3 varchar(500), col4 int(3), col5 tinyint(2), col6 timestamp default current_timestamp , col7 timestamp default current_timestamp...

Read Full

How to use ninject dependency injection in mvc

Overview While working on MVC application in asp.net sometime we need to inject dependency also know as DI(Dependency Injection). DI is itself a separate topic to study which I left for some other day. Refer here for more info on  DI Dependency Injection According to the wikipedia In  software engineering ,  dependency injection   is a  software design pattern   that implements  inversion of control   for resolving dependencies....

Read Full

Find Amit's hostel name using hostel_list and student_list MYSQL database tables

Problem Overview Suppose we have two tables a) hostel_list - List of hostels +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN | 2 | 1090 | |  2 | KAILASH BHAVAN | 2 | 990 | |  3 | RUDRAKSH BHAVAN | 2 | 990 | |  4 | KAVERI BHAVAN | 1 | 690 | |  5 | BHAGIRATHI BHAVAN | 4 | 2140 | |  6...

Read Full

Knuth–Morris–Pratt Algorithm for Pattern Matching Implementation in Javascript

Algorithm Knuth–Morris–Pratt Algorithm also known as KMP Algorithm is a well known algorithm for pattern matching. As per wikipedia ,  In  computer science , KMP  searches for occurrences of a "word"   W   within a main "text string"   S   by employing the observation that when a mismatch occurs, the word itself embodies sufficient information to determine where the next match could begin, thus bypassing re-examination of previously matched characters....

Read Full

ASP.NET Web API — Part 1

Hello All, For   Asp.net   Web API, I am going to write a series of technical articles. Few of them will cover conceptual point, few will cover demos and in few of them, I will try to dig deep into it by covering important technical point like routing, hosting, security stuff. So in this series of articles, Lets start with light node, what is   ASP.NET   Web API and why we should go for it. What ??? So   ASP.NET   Web API is a framework that help in building...

Read Full

What can be the maximum number of rows in a MYSQL Database Table?

Interview Question Series:   This question was asked in one of the top startups interview from one of my friend. Question here is What can be a maximum number of rows that a MYSQL Database table can contain? Suppose you have a MYSQL Database  and a database table in it called users . So this table contains a list of users. Each row in this table contains unique user. So The question is what can be the maximum number of users that can be inserted in user's table. If...

Read Full

Enlisting servers connected to mysql machine

Few days back our DBA updated the DNS entry of one of the slave to point it to newly created machine, with better configuration and disk space. Now we were required to switch all mysql connections (built by our app servers) from old machine to new one. show processlist gave me huge list of connections which made the enlisting of unique servers a tedious task. Hence I spent some time and wrote this query: select count(1), user, substring(host, 1, length(host) -...

Read Full

Binary Search Tree Search a Node Implementation in Javascript

Overview Searching in binary tree is easy as nodes in binary search tree are in sorted order. With each node traversal in binary search tree we skip about half of the tree left to traverse. We have covered insertion in the last post  Binary Search Tree Insert node Implementation in Javascript Now let us see how to search in a binary search tree Algo //Check if the root node's value is equal to the value we are searching for //    If not than move to the left child if node's value...

Read Full

Binary Search Tree Insert node Implementation in Javascript

Overview Binary search trees commonly knows as BST are a special type of trees which are sorted in nature. In binary search tree every node is larger than its left child and smaller than its right child. This feature makes it easy to search, insert and delete a node from binary search tree.  Algo //Check if root node is empty or not //    If yes then assign new node to root //    If not than iterate. Iterate method will check the node value to add from left and right child of...

Read Full

Linked List Node Swapping Implementation in Javascript

Overview You are given a linked list. Write a program for swapping two nodes by value. If you don't know how to create linked list than you can go through previous article  Linked List Insertion Implementation in javascript Example Suppose you are given a linked list 1 -> 3 -> 9 -> 14 -> 17 You need to swap the node having value 3 and 14, So now modified linked list will be 1 -> 14 -> 9 -> 3 -> 17 Implementation //Method to swap two nodes of a...

Read Full

Linked List Size or Count in Javascript

Overview Find size or count of the linked list. You have given a linked list and you need to find out the size of that linked list. There are probably two ways to find out the count of the linked list. 1) By Recursion Method - In this we will recursively call the node and increment the counter. 2) By Iteration Method - In this we will iterate over the linked list and will find out the count. If you don't know how to create linked list than you can go through previous article...

Read Full

Linked List Delete Node By Key in Javascript

Overview To delete a node by key we need to traverse the whole linked until we find a node which has value equal to key and than we can delete that node.  If you don't know how to create linked list than you can go through previous article Linked List Insertion Implementation in javascript Example Suppose You have given a linked list 4 -> 5 -> 7 -> 10 -> 14 1. Now delete the node with key 7. So we will traverse linked list from node by node. and will keep...

Read Full

Linked List Delete Node By Postion in Javascript

Overview To delete a node by position we need to traverse the whole linked list until we reach a position on which we need delete a node. If you don't know how to create linked list than you can go through previous article Linked List Insertion Implementation in javascript Example Suppose You have given a linked list 4 -> 5 -> 7 -> 10 -> 14 1) Now delete the node at position 1 (head is at position 0). So we will traverse linked list from node by node. and...

Read Full

Linked List Introduction

Linked List is a basic data structure. Unlike arrays which have fixed length Linked list have variable length. Thus Linked List have advantage over arrays where we don't know the number of elements to be inserted before hand. Linked list consists of nodes, details of node are as follows. Basic Structure of Linked List node contains Value - The value of the element. Next - Pointer to the next element of the node.  Value Pointer      |           |     V          V...

Read Full

MYSQL NOW Function

MYSQL NOW Overview MYSQL NOW Function is used to return system's current data and time. NOW Function will basically return the date and time of that system on which you are running on your query. If running on your system then Now will return your system's data and time and if you are running this function on any remote server than Now Function will return remote server's data and time. MYSQL NOW Syntax Syntax for MYSQL Now Function is SELECT NOW() FROM table_name;...

Read Full

MYSQL SQRT Function

MYSQL SQRT Overview MYSQL SQRT Function is used to calculate square root of the input values. We can use MYSQL SQRT function while fetching data from database and can return SQRT of any of the column values. MYSQL SQRT Function comes handy when we need to calculate or use square root while processing or making any mysql Query. MYSQL SQRT Function can only be used on positive numbers and not on negative numbers. if you will give negative numbers to MYSQL SQRT Function it...

Read Full

MYSQL LEN Function

MYSQL LEN Overview MYSQL LEN Function is used to return length of the input column text value. LEN function does not include spaces that occurs in the start and end of the string. It means that LEN function will first perform trim function to remove spaces and then MYSQL LEN Function will calculate the length of the string. MYSQL LEN Syntax SELECT LEN(column_name) FROM table_name WHERE [condition]. MYSQL LEN Example Let us have a look at an example of MYSQL LEN function...

Read Full

MYSQL MID Function

MYSQL MID Overview MYSQL MID function is used to return a sub string characters from any text field column on the basis of start point and length of the sub string to return. MID function takes three input column_name => Name of the field from which sub string will be returned. start => Starting point of substring to return. length => Length of characters from start point to return. MYSQL MID Syntax Syntax for MYSQL MID function is...

Read Full

MYSQL LCASE Function

Overview MYSQL LCASE() function is used to return the column value in lower case while fetching data from database. LCASE function will return only input column in lower case not all columns in that table.  Suppose you have to show values from some column in lowercase to user despite of type of case of values store in any particular column, so in that case you have two options either you will fetch data from db and than will convert it to lowercase in your business logic or...

Read Full

MYSQL UCASE Function

MYSQL UCASE() function is used to return the column value in upper case while fetching data from database. UCASE function will return only input column in upper case not all columns in that table. Syntax for UCASE function is SELECT UCASE(column_name) FROM table_name; Let us look more into it with the help of an example Consider table student_list containing details for student. +-----+------------------+--------+-----------+ | sid | name | year |...

Read Full

MYSQL SUM Function

MYSQL Sum Overview MYSQL SUM() function returns the aggregated summation of all the values for input column name. There are lot of real scenario application uses for MYSQL SUM function like calculate total population of a state by finding sum of its city wise population. Other use can be to find out the total salary given by company by finding out the sum of all the employee's salary. Other use case of MYSQL Sum function can be suppose in one table you have list of...

Read Full

MYSQL MAX Function

MYSQL MAX Function is used to find the maximum values for any input column_name. MAX aggregate Function is used to find the maximum value present in any column name like highest salary. Syntax for MAX Function is SELECT MAX(column_name) FROM table_name; Let us look on a example for this, Consider table hostel_list which is containing list of hostel details. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

MYSQL LAST Function

MYSQL LAST Function returns the last match, value, row or redord for a given condition. Last function is more useful when we have to get what is the last entry in the table for any given condition or situation. Syntax fot MYSQL LAST Function is SELECT LAST(column_name) FROM table_name WHERE [condition]; Let us understand better with an example. Consider student_list table with details for all the students.  +-----+------------------+--------+-----------+ | sid | name...

Read Full

MYSQL FIRST Function

MYSQL FIRST Function returns the first match, value, row or redord for a given condition. First function is more useful when we have to get what is the first entry in the table for any given condition or situation. Syntax fot MYSQL FIRST Function is SELECT FIRST(column_name) FROM table_name WHERE [condition]; Let us understand better with an example. Consider student_list table with details for all the students. +-----+------------------+--------+-----------+ | sid...

Read Full

MYSQL COUNT Function

MYSQL COUNT function is used to return the total number of rows present in any database table. Count function is mainly used where we want to fetch the total number of records in any of the given table. Syntax for MYSQL Count() Function is SELECT COUNT(column_name) FROM table_name WHERE [condition]; Let us take a deeper look at count function with the help of an example Consider table student_list which contains the list of students...

Read Full

MYSQL AVG Function

MYSQL AVG function is used to find out the average value of the column value that is provided as input to AVG function. It will return the aggregated average of all the values. AVG function is quite useful when we are doing some sort of analysis and needs to find the average value such as average salary, or avergae family strength in some city. Syntax for MYSQL AVG function is  SELECT AVG(column_name) FROM table_name; Let us have close look at it with the help...

Read Full

MYSQL Functions

Often we are required to perform lot of aggregations on columns containing string and numeric data. For this purpose MYSQL provides lot of in-built functions.  These MYSQL functions are defined to provide single value for all the aggregations by running functions or operations on the column provided to them as input. MYSQL Provides lot of functions that are listed below MYSQL AVG() Function - MYSQL AVG function will calculate the average value of all the input column values....

Read Full

MYSQL Null Function

Various REDBMS provide MYSQL NULL Functions in different forms. NVL(), IFNULL(), COALESCE() All provide same functionality to treat NULL values as 0.  MYSQL provides ISNULL() function to check whether the given column value passed in this is NULL or not. it gives outcome as 1 if value is NULL and 0 if it is something other than NULL. Syntax for ISNULL() function is SELECT column1_name, ISNULL(column2_name) FROM table_name; IFNULL() and COALESCE() function are used to...

Read Full

MYSQL Auto Increment

MYSQL Auto Increment is used to declare any field as auto increment. Which means that whenever a new record is inserted into the table this value will gets generated by incrementing its value in previous row. Often it is used as a primary key as it generated unique value for each record.  Often when we create a new table. We use to keep an Id field thats purpose is to uniquely define each record. So we can keep this record is auto increment primary key as this will get auto...

Read Full

MYSQL Sub Queries

MYSQL sub queries are referred as a subquery within a query. Subquery is used to fetch values and pass in another query as input. In MYSQL we can write subquery to fetch data and provide that data as input to the other query. Then other query can use that data as a conditions which is provided by subquery. In MYSQL we can use subquery within queries like INSERT, UPDATE, DELETE and SELECT. A Subquery can also be used wit all the MYSQL Operators. Often a Subquery is used to...

Read Full

MYSQL Clone Table

Overview MYSQL Clone Tables can be referred as exact replica of an existing table. And to perform certain operations which you can not apply on original table as it is currenlty used by lot of enitities. For this purpose you can create a clone table of the exisitng table. There are various ways to create clone table. One way of creating a clone table is to use CREATE TABLE AS SELECT command Syntax Syntax for creating a clone table by this way is CREATE TABLE table_name...

Read Full

MYSQL Temporary Table

MYSQL Temporary tables is the functionality provided by various RDBMS. This is used to create temporary tables which provide same funtionalities as of regular tables such as SELECT, UPDATE, INSERT, DELETE options but for the current logged in session only. Temporary tables acts very useful when we need to operate some operation on temporary data for temporary cases. As we know temporary tables only exist for the current logged in session in database so you will not find you...

Read Full

MYSQL Default Constraint

Overview MYSQL Default Constraint is used to set default value for any column in a database table. Column gets populated with the default value if no value is specified while insertion. Syntax Syntax for setting default constraint while creating a table is CREATE TABLE table_name (column1 data_type DEFAULT default_value, column2 data_type); Syntax for setting default value in already created table is ALTER TABLE table_name MODIFY column_name DEFAULT default_value;...

Read Full

MYSQL Wildcards

Overview Special characters are used as wild cards in MYSQL. MYSQL Wildcards are used to fetch data from table with the LIKE clause. We can use LIKE clause with wildcards to match substring or string with some pattern in database table. MYSQL Wildcards are % ==> It matches one or more characters. _ ==> It matches one character. [list_of_characters] ==> In this it applies sets, ranges of string characters. [! or ^list_of_characters] ==> In this this is...

Read Full

MYSQL Expressions

Overview MYSQL Expressions are used to evaluate to a value. MYSQL Expressions can be combination of one or more values, operators and MYSQL functions that evaluate to a value.  Expressions are used to query database for a specific data set. We can assume MYSQL Expressions as formulas that are used in MYSQL Queries to fetch and process data. Syntax Basic syntax for MYSQL Expressions is SELECT * FROM hostel_name where [expressions]; Different kind of MYSQL Expressions are as...

Read Full

MYSQL Indexes

Overview Indexes helps in faster retrieval of data from database table. Database application uses indexes to retrieve data fast. Indexes are separate tables which are used to lookup on database tables to fetch data faster. Indexes are like index that you have in books. If you want to directly go to any chapter or topic than you search for that topic or chapter in index and directly go to that page. This is how index works. We create lookup tables having pointers to our data in...

Read Full

MYSQL Unique Key

Overview Unique Key is used to define uniqueness in data in any column of a table. Primary Key and Unique key both are used to maintain uniqueness in a table.  Despite of lot of same functionalities in primary and unique keys. There are lot of differences as well. Unique key can have null values where as primary key does not. There can be lot of unique keys in a table but only one primary key. A primary key by default has unique constraint in it. Syntax Create Table with...

Read Full

MYSQL Foreign Key

Overview MYSQL Foreign Key constraint is always defined as primary key constraint in another table. Foreign key column can only have those values which are mentioned in another table's primary key column. Foreign key acts as a reference key to the primary key in another table. Foreign key can be a single column or a combination of columns. Syntax Syntax for defining Foreign key is CREATE table table_name (column1 data_type, column2 data type, column1...

Read Full

MYSQL Primary Key

Overview MYSQL Primary Key is a property of column which uniquely defines each row or we can say record in a database table. In a table we can define one or more column as primary key. In simple words we can say that Primary key is a column or a group of column which uniquely defines row in a table. So for no two columns can have same data for a primary key. Primary key column cannot contain null value. Composite Key When two or more than two column combines to form primary...

Read Full

MYSQL Truncate Table

Overview MYSQL Truncate table is used to delete all data inside the database table at once. Unlike delete it deletes all data at once without going to each line one by one leaving the empty table behind. MYSQL Truncate table also makes only one entry in transaction log file. You can say that truncate statement is like delete statement without a where clause to delete all data at once. Syntax Syntax for MYSQL Truncate table statement is TRUNCATE TABLE table_name;...

Read Full

MYSQL Alter Table

Overview SQL Alter table is used to update the database table structure of an existing table. Alter table command can add, delete or modify any of the column in an exisitng table. Lot of time we get a requirement to either add a new column, delete an existing column or change the name, place, data type or data a column can hold, In all such requirement we can use SQL Alter statement. Syntax for SQL Alter statement for add, drop and modify a column is mentioned below in...

Read Full

MYSQL Insert Into Select

Overview MYSQL INSERT INTO SELECT query is used to select data from one table and to copy that selected data into another existing table. Either we can copy all the data or we can also select a subset of data from the table which satisfies the given condition. Largely it is used to take backup or to copy the existing rows, records from one table to another existing table. we can also say that MYSQL INSERT INTO SELECT is used to create new table by copying data from existing table....

Read Full

MYSQL Select Into

Overview MYSQL SELECT INTO query is used to select data from one table and to copy that selected data into new table. Either we can copy all the data or we can also select a subset of data from the existing table which satisfies the given condition. Largely it is used to take backup or to copy the existing rows, records from one table to another new table. we can also say that MYSQL SELECT INTO is used to create new table by copying data from existing table. Syntax Syntax for...

Read Full

MYSQL Using Views

Overview A view is a virtual table stored in database. View can contains all the rows and columns of one or more table combined using a MYSQL Statement. It will act just like a real table, the only difference is that a view is a virtual table not a real table. We can add Where conditions, MYSQL functions and can also use join statements to create a view and than show that view as if data is coming from one single table.  Views are useful in collating the data from different...

Read Full

MYSQL Having Clause

Overview MYSQL Having Clause works with Group BY Clause. Having clause applies the condition on the groups returned by the group by clause. Final rows contains only those groups which passes the having condition. In other words Having Clause will only returns those aggregate values which will meet the Having condition in the select query. Syntax Syntax for Having Clause is SELECT column_names FROM table_name WHERE conditions GROUP BY column_name HAVING [condition]....

Read Full

MYSQL Limit Clause

Overview MYSQL Limit Clause is used to return a subset of the total rows in a table. Limit takes two numbers total results to return and offset (optional). Suppose if you say limit 20,10 than it will return 20 records after first 10 records. MYSQL Limit clause is heavily used in designing pagination features. Syntax Syntax for MYSQL Limit Clause is SELECT column_name FROM table_name LIMIT NUMBER,OFFSET; Example Let us have a look at this with some examples...

Read Full

MYSQL Aliases

Overview MYSQL Aliases are used to temporarily assign a different name to a table and columns headings while they are making a SELECT query. Often when we use Joins on table we use aliases at that time. Aliases are also used to make tables and column names more readable while we are fetching data through comples queries. Syntax Syntax for Aliases for columns and tables are given below SELECT column_name AS temp_column_name FROM table_name; SELECT column_name...

Read Full

MYSQL Null & Not Null Operator

Overview Null values represent a blank values in a database table. Suppose you insert data for four column in table having six column. So at that time the rest of the two columns will have either the null value or the default value if there is any default value set for those column in table. At times when we are working on MYSQL Queries we get the requirement to fetch rows by checking whether the column has Null values or doesnt have null values. So for such requirements...

Read Full

MYSQL Union Clause

Overview MYSQL Union Operator is used to combine select query result for two or more than two tables. As MYSQL Union Opertor combines result set for two or more than two select fetch statements than all the select statement must have same set of columns, same set of columns in expression, same data types with same or different data length. Union operator is used to select only distinct or unique values in default case. If we want to fetch all the possible Union of...

Read Full

Evaluate Postfix Expressions Using Stack In Javascript

Postfix expressions are easy to evaluate in comparison to infix expressions.  What is Infix notation? The expression of the form of   a op b , where operator is in between of bot the operands. What is Postfix notation? The expression of the form of   a b op ,  where both the operands are followed by operator. We have told Infix To Postfix Conversion Using Stack in Javascript  in previous article. Postfix expressions don't have brackets and thus they are easy to evaluate. Here...

Read Full

Minimum number of bracket reversals needed to make an expression balanced

Overview You will be provided a string containing opening and closing brackets, You need to identify that how many reversals is required to balance the brackets. For Ex " {} " this is balanced but this is not "{{{}", You need to make this balanced by doing reversal " }{{{{} " This is not balanced you need 3 reversals to make this a balanced bracket string. " }{}{{{} " This is not a balanced string and you cannot make it as balanced as it...

Read Full

How to Add Comparison Feature in Replace in C-Sharp

Overview In C# we have Replace method that contains 2 overload methods Replace(string,string) Replace(char,char) What if you need to compare the 1 st  parameter (string to be replaced) by using StringComparison.OrdinalIgnoreCase. Example I have a string and I want to change but what when we have “ cusTomiZed” is come in different case like “ customized” var testString="This is my cusTomiZed message"; Console.WriteLine("Old String is...

Read Full

Infix To Postfix Conversion Using Stack in Javascript

Here we go with the javascript program to convert infix to postfix notation. What is Infix notation? The expression of the form of a op b , where operator is in between of bot the operands. What is Postfix notation? The expression of the form of a b op ,  where both the operands are followed by operator. Here we will see the implementation to convert infix notation to postfix notation. As it is also easier for compliers also to read from left to right or from right to left....

Read Full

Command Query Separation (CQS) in C#

CQS is the principle of development where we need to separate c ommand from query. Its a basic rule that a developer must follow. Segregation of command with query is very important.  But question is what are these term ? Command: Which change the state of a system. In event driven programming the function that effect the system's state is command.  The method whose return type are void are supposed to be command type. Example:  A button click event in web form is...

Read Full

Write a method to generate binary numbers from 1 to n

Given a number n, Print all the binary number from 1 to n. Few Examples can be :- 1) n=3 Binary Numbers will be 1 10 11 2) n=7 Binary Numbers will be 1 10 11 100 101 110 111 In a simple way we can also create a decimal to binary method and call that inside a loop from 1 to n. But In this we will be solving this with the help of the Queue Data Structure. To see Queue's Basic Implementation in Javascript read here . Algo...

Read Full

Queue Basic Implementation in Javascript

Basic Methods :- Queue consists of methods like  Enqueue - Method to add an item to queue Dequeue - Method to remove an item from the queue IsEmpty - Method to check whether Queue is empty or not? Rear - Method to fetch the rear pointer of the queue. Front - Method to fetch the front pointer of the queue.  Size - Method to return the size of the queue. For full source code you can follow the link  https://github.com/oyewiki/DataStructures/blob/master/Queue/Queue.js...

Read Full

Stack Basic Implementation in Javascript

Global Variables :- Top - Holds the count of the top element in stack. Stack - Array which holds all the element inside stack. Basic functions :- IsEmpty - Returns true if stack is empty, false if not. Push - Pushes an element to the top of the stack. Pop - Remove and return an element from the top of the stack. Peek - Returns the top element from the stack. Print - Print all the stack elements and some basic property details about stack. Size - Returns the...

Read Full

Linux and Unix More Command

Overview Linux More Command is used to display text from any file one screen at a time. Unlike editors More command doesn't requires to load the whole file a once. This comes handy when we are reading a large file. More command provides a filter for pagination by showing one screenfull text at a time. More command is not as powerful as Less command but it is alsp quite simple and easy to use. Syntax more [-dlfpcsu] [-num] [+/pattern] [+linenum] [file ...] Options...

Read Full

Linux and Unix Free Command

Overview Linux Free command comes handy when we need to find out the free and consumed space in our system. Linux free command displays the total amount of free and used amount of physical as well as swap memory, It also tell us about shared memory, cached memory and memory in buffer. The shared memory column represent either the Shemm value or Mem Shared value. Syntax free [options] Options -b, --bytes Display the amount of memory in bytes....

Read Full

Linux and Unix Uptime Command

Overview Linux Uptime Command is used to tell from how long the system has been running. As per linux manual uptime gives a one line display of the following information. The current time, how long the system has been running, how many users are currently logged on, and the system load averages for the past 1, 5, and 15 minutes. This is the same information contained in the header line displayed by w. System load averages is the average number of processes that...

Read Full

Linux and Unix Reboot Command

Overview Commands like reboot, halt or poweroff are used to reboot or stop the system. These programs are used to reboot, halt or stop the system by system administrator. As per linux manual when these commands are called with --force or when in runlevel 0 or 6, this tool invokes the reboot(2) system call itself (with REBOOTCOMMAND argument passed) and directly reboots the system. Otherwise this simply invokes the shutdown(8) tool with the appropriate arguments without...

Read Full

Linux and Unix Shutdown Command

Command Overview Linux Shutdown command is used to bring the system down. According to linux manual which states as shutdown arranges for the system to be brought down in a safe way. All logged-in users are notified that the system is going down and, within the last five minutes of TIME, new logins are prevented. TIME may have different formats, the most common is simply the word 'now' which will bring the system down immediately. Other valid formats are +m, where m is...

Read Full

Linux and Unix Head Command

Linux Head Command Overview Linux Head Command prints the lines from the top of the file. By default it prints the first 10 lines of a file. If more than one file is given in the input than it shows the top lines from the files precedes by the file name as header. Linux Head Command Syntax head [--options] [file_name(s)] Linux Head Command Options -c, --bytes=[-]K print the first K bytes of each file; with the leading '-', print all but the last K bytes of each file...

Read Full

Linux and Unix LS Command

Linux LS Command Overview Linux LS Command is used give the list of the content in a directory. It list out the files and directory inside any directory and by default it prints them by sorting them alphabettically. It is one of the most common, basic and most used command in a linux. It is pretty much useful if we know all options provided by ls command. Linux LS Command Syntax ls [options]... [File]... Linux LS Command Options -a, --all do not ignore...

Read Full

Linux and Unix SCP Command

Overview scp -- secure copy (remote file copy program) As the name suggests Linux SCP Command is used to securely transfer files from source machine to destination machine. Often we get requirements to transfer some file from remote server to our local machine or say we need to transfer some file from our local machine to our colleague's machine and here file can be a movie as well :D. In such cases we uses we use Linux SCP Command.  Syntax Syntax for Linux SCP Command is...

Read Full

Linux and Unix CP Command

Linux CP Command Overview Linux "cp" command is used to copy file(s) or directory(s) from one directory to another. So Linux "cp" command comes handy when you are restructuring your directory. Linux CP Command Syntax cp [--options] Source Destination-Directory Linux CP Command Examples Consider file sample_file.txt and directory sample_dir and destination directory as /var/www/dest_dir Linux CP Command Example Case 1: Let us copy file...

Read Full

Linux and Unix Chmod Command

Overview Before describing CHMOD Command let us understand a little about the files, how they are structured in linux and who all can access it and what type of access users have on these files. For this we require to use Linux LS command . LS -l Suppose it prints drwxr-xr-x 18 ankur staff 612 Jun 22 09:21 abcDir In this we can break it into several parts. So let us have a look on them drwxr-xr-x It denotes the type directory or file and also denotes what type...

Read Full

Linux and Unix Chown Command

Overview Linux CHOWN command is used to change the owner or/and group of any file or directory. Linux Chown command has the capability to define ownership of any file or directory. Some interesting usage of Linux CHOWN command is  If only owner is provided with CHOWN command than only owner of the file is changes without changing the group of the file. To change both owner as well as group of the file, we need to provide owner and group separated by colon. If only colon group name...

Read Full

Linux and Unix Chgrp Command

Overview Linux CHGRP Command is used to change the group ownership of a file. By using Linux CHGRP command we can change the group recursively for all the files and directories inside. we have also covered CHOWN , CHMOD in previous steps. Syntax chgrp [OPTION]... GROUP FILE... chgrp [OPTION]... --reference=RFILE FILE... Options -c, --changes like verbose but report only when a change is made -f, --silent, --quiet suppress...

Read Full

Linux and Unix Cat Command

Linux Cat Command Overview Linux Cat Command is used to concatenate two or more files. It reads the text from all the files or standard intput and prints on the standard output. There are lot of practical uses of cat command. It can be used to create a new file, concatenate tow or more files, merge two files into one. Linux Cat Command Syntax c at [OPTION]... [FILE]... Linux Cat Command Options -A, --show-all equivalent to -vET -b, --number-nonblank...

Read Full

Linux and Unix Tail Command

Linux Tail Command Overview Linux Tail Command is used to fetch last or we can say latest lines from a file. By default it will return last 10 lines from input file and will show them on standard output. If we will provide more than one file than it will print last 10 lines of each file seperated by header with the respective file name. Linux Tail command is also used to monitor server logs. As when we paas "-f" as a parameter with tail than tail doesnt stop at the end...

Read Full

Linux and Unix RM Command

Overview Linux RM command is used to remove files and directories from the files system. By default it does not removes directories on its own. For deleting directories use --recursive (-r or -R) with Linux RM command. Syntax rm [OPTION]... FILE... Options -f, --force ignore nonexistent files and arguments, never prompt -i prompt before every removal -I prompt once before removing more than three files, or when removing recursively....

Read Full

Linux and Unix MV Command

Linux MV Command Overview Linux " mv " command is used either to rename a file or a directory or move/relocate a file or directory to new location in the file system. So we can use linux mv command to either move a file from source to destination, old to new location or we can rename a file from old to new name. Linux MV Command Syntax mv [--options] Source Destination Linux MV Command Example Consider we have a file with name hostel_list.txt and in a...

Read Full

MYSQL Cartesian Join

Overview MYSQL Cartesian Join returns the cartesian product of two or more joined tables. Thus It joins every row of each table with other tables. Some time Cartesian Join is also referred as Cross Join.  It tends to Join all the rows of each table with every possible row of other tables on the basis of specified conditions. There are other type of Joins as well which are explained in MYSQL Joins . Syntax Syntax for Cartesian Join or Cross Join is Select * from table...

Read Full

MYSQL Self Join

Overview MYSQL Self Join is a join which is used to combine table with itself on the basis of a condition. In MYSQL Self join table will be combined with itself as another table. Syntax Syntax for MYSQL Self join is SELECT tab1.column, tab2.column FROM table tab1, table tab2 WHERE tab1.column1_value = tab2.column2_value;...

Read Full

MYSQL Full Join

Mysql Full Join Overview SQL Full Join will return combination of rows from both the tables on the basis of common field by filling NULL values on non matching rows. Full Join will basically give you a combination of both the tables. Mysql Full Join Syntax Syntax for Full Join is: SELECT left_table.column, right_table.column FROM left_table FULL JOIN right_table ON left_table.field = right_table.field; Mysql Full Join Example Let us have a look with the...

Read Full

MYSQL Right Join

Mysql Right Join Overview Right Join as the name suggests it returns all the result from the right table i.e. table 2 and all the rows that matches the ON clause from left table i.e. table 1. So Right Join will return all the rows from right table and it will return either matching rows from left table or null for non matching rows. Even if it will not find any matching rows in left table at all in that case also it will return all the rows from right table. Mysql Right...

Read Full

MYSQL Left Join

Mysql Left Join Overview Left Join as the name suggests it returns all the result from the left table i.e. table 1 and all the rows that matches the ON clause from right table i.e. table 2. So Left Join will return all the rows from left table and it will return either matching rows from right table or null for non matching rows. Even if it will not find any matching rows in right table at all in that case also it will return all the rows from left table. Mysql Left Join...

Read Full

MYSQL Inner Join

Mysql Inner Join Overview Among all the available MYSQL Joins Inner Join is the most common type of join. Inner Join is used to combine data from two or more tables. Inner Join combines all the data from all the tables having common data and are also fufilling the condition. Inner Join are also known as Equi Join . Let us have a look at an example having two tables Mysql Inner Join Syntax Syntax for SQL Inner Join is SELECT left_table.column, right_table.column...

Read Full

MYSQL Joins

Overview MYSQL joins are used to combine data from two or more database tables on the basis of some common value in the tables. We apply joins by passing where conditions so we can use all the operators applicable with where clause like < , > , <=, >=, !=, <>, between, like, Not, = and lot more. Here we will be explaining 5 types of joins in next few articles MYSQL Inner Join MYSQL Left Join MYSQL Right Join MYSQL Full Join MYSQL Self Join...

Read Full

MYSQL Between Clause

Overview Between Clause is used to check where conditions between two values for a column. You can actually fetch, update, delete data by applying a condition between two values. Syntax Syntax for Between Clause is SELECT * FROM table_name WHERE column_name BETWEEN (Val1, Val2); Example Suppose we want to fetch list of hostels which have max_capacity between 1000 to 3000 students. SELECT * FROM hostel_list where max_capacity BETWEEN 1000 and 3000;...

Read Full

MYSQL In Clause

Overview In clause helps us to apply a range of values or multiple values in a where condition to match with. It is more commonly used when we want to match a column value to any from a group of values. Syntax Syntax for In Clause is SELECT * FROM table_name WHERE column_name in (Val1, Val2, .... ValN); Example Let us consider hostel_list table, which contains the list of hostels with their occupancy and capacity limits....

Read Full

MYSQL Like Clause

Overview Like clause is used with Where clause to apply condition. As the name suggests Like clause is used to fetch all the records where a column matches/contains a word. Syntax Syntax for Like clause is SELECT * FROM table_name where column_name LIKE 'random_value'; Example Suppose we need to find all the hostel name which ends with 'SH' like KAILASH BHAVAN is one of them. So the query for this will be SELECT * FROM hostel_list WHERE name LIKE '%SH %'; In...

Read Full

MYSQL Group By

Overview Group By operator is used for grouping our data on the basis of column values. It is very useful when we want our data to be represented in groups. Syntax Syntax for Group By Operator is SELECT * FROM table_name GROUP BY column_name; Example Suppose we want fetch list of hostels but ir should be in order where all the hostels with same occupancy_type should be toghether. For this we can write MYSQL query like this SELECT * FROM hostel_list GROUP...

Read Full

MYSQL Order By

Overview Order By Operator is used when we want to arrange you results in a particular order. Order by is used against any of the table column in either ascending or descending order. Syntax Syntax is for Order By is SELECT * FROM table_name WHERE ORDER BY column_name [order]. You can pass order value as asc and desc. Asc is used for ascending order and Desc is used for descending order. Example For ex. Consider hostel list table which contains list of hostel...

Read Full

MYSQL Distinct

Overview Distinct Statement is used to find out the distinct values in any of the columns. Syntax Syntax for Distinct Statement is SELECT DISTINCT column_name FROM table_name; Example Let us get a clear picture with the help of an example Consider table hostel_list containing the list of hostels +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN |...

Read Full

MYSQL And & Or Operator

Overview While using where condition in mysql query we can use AND and OR operands. Syntax Syntax for using AND and OR operator are SELECT * FROM table_name where [conditions]; Example Let us dig deeper with the help of an example Consider table hostel_list containing list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN | 2 |...

Read Full

MYSQL Operators

MYSQL Provide various operators to specify the conditions with Where clause. You can use multiple mysql operators in where clause to connect one or more conditons in your mysql statement. Below is the list of operators that MYSQL provides Arithmetic Operator Comparison Operator Logical Operator Negate Operator...

Read Full

MYSQL Delete Table

Mysql Delete Table Overview Whenever you need to delete anything from your table, you can use Delete command Mysql Delete Table Syntax Syntax for delete command is DELETE FROM table_name where [conditions]; Mysql Delete Table Example Let us look more into this with the help of an example. Let us consider table hostel_list which contains the list of hostel. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

MYSQL Update Table

Overview When you are required to update any data in the exisitng table you can use mysql update command Syntax Syntax for update data in any table is UPDATE table_name SET col1_name = col1_new_value, col2_name = col2_new_value where [conditions]; Example Let us look into this with the help of an example and consider table hostel_list which contains list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

MYSQL Where Condition

Overview Where condition is used to fetch data from the table on the basis of some conditions on some of the data columns. Syntax Syntax for using where clause is SELECT * FROM table_name WHERE (conditions); Example Let us have a deeper look on this with the help of an example Let us consider our hostel_list table which contains the list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

MYSQL Select Table

Overview To fetch data from database table we use select command. Syntax Syntax for select command is SELECT (Col1, Col2) FROM table_name; Example Let us dig in some of the data that we inserted in insert step in our hostel_list. I have added four hostel details in our list. To select all data in our hostel list table, the mysql query will be SELECT * FROM hostel_list; +----+-------------------+-----------+----------+ | id | name | occupancy...

Read Full

MYSQL Insert Into

Overview Now in previous few steps you were learning how to create , desc and delete table. Now let us see how to insert data into our tables. Insert into command is used to insert data into our tables. Syntax Syntax for insert command is INSERT INTO table_name (Col1, Col2.... ColN) values (Val1, Val2... ValN); Here in this command the number of columns passed should be equal to number of values passed. and Val1 will always corresponds to Col1. That means...

Read Full

MYSQL Drop Table

Overview To remove/delete a sql table from database we use DROP command. Syntax Syntax for dropping a table is  DROP TABLE table_name; Example For ex. If we want to drop abc table create in last step . Than the sql query will be DROP TABLE abc;...

Read Full

MYSQL Create Table Like

Overview Sometimes you can get a requirement where you need to create a new table like an already exiting with different table name. There you can use " create table like " command. Syntax Syntax for create table like command is CREATE TABLE table_name like already_exiting_table_name; CREATE TABLE table_name AS SELECT [COL1, COL2] FROM already_exiting_table_name [WHERE]; Example For ex: If you want to create abc table like hotel_list table...

Read Full

MYSQL Desc Table

Overview To see description, structure, column names and data types of any existing table you can use command Desc table. Syntax Syntax for this is DESC table_name; Example Let us see the table hostel_list that we just created in last step DESC hostel_list; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra...

Read Full

MYSQL Create Table

Overview Table is where database store structured data. For creating a simple or you can say basic database table you need a unique table name in that database and need to define columns and their data types. CREATE TABLE command is used for this purpose. Syntax Syntax for creating a simple database table is CREATE TABLE table_name (column_one data_type, column_two data_type, column_three data_type, primary key(column_name)); Example Now let us create...

Read Full

MYSQL Use Database

Mysql Use Database Overview After logging in to database. Before accessing any data or doing any operation, we are required to select a database. which we do using USE command. Mysql Use Database Syntax Syntax for selecting database is. USE db_name; Mysql Use Database Example As we have created hostel database in previous step than to start using that database we need to select that database. Mysql Use Database Example Case 1: To select hostel database the command...

Read Full

MYSQL Show Database

Overview Previously we have covered Mysql Create Database and Mysql Drop Database . Now let us have a look on Mysql Show command. To see the list of available databases we can use the Show databases command. Syntax Syntax for getting list of databases is SHOW databases; it will give the list of available...

Read Full

MYSQL Drop Database

Mysql Drop Database Overview Drop database command is used to drop an existing database. Admin user rights are required for drop command. MYSQL Drop Database Syntax Syntax for SQL drop database command is DROP DATABASE db_name; Mysql Drop Database Example Say if you want to create hostel database that you created in previous step. DROP DATABASE hostel;...

Read Full

Mysql Create Database

Mysql Create Database Overview Create database command is used to create a new database. Admin user rights are required for creating database. Mysql Create Database Syntax The syntax for SQL create database command is CREATE DATABASE db_name; Mysql Create Database Example Say if you want to create a database with name hostel. CREATE DATABASE hostel;...

Read Full

MYSQL Syntax

MYSQL syntax or query follows a particular rules and regulation which are denoted as MYSQL Syntax. Every MYSQL query starts with standard operators and ends with the semicolon. Some of The Most Important MYSQL Commands CREATE DATABASE - creates a new database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DROP TABLE - deletes a table INSERT INTO - inserts new data into a database SELECT...

Read Full

MYSQL Data Types

MYSQL data types defines what type of data a column can contains. While creating a column you need to define the data type that you would be saving in that column. Through these data types SQL understands what type of data is in column and how to show that data while retrieving that data. Below is the list of various data types and their descriptions. bit  ==> Numeric value, can hold from 0 to 1. tinyint ==> Numeric value, can hold from 0 to 255. smallint...

Read Full

MYSQL RDBMS Concept

RDBMS stands for Relational Database Management System. RDBMS data are stored in database tables, record and fields in structured manner. Each RDBMS table consists of table rows and each row consists of data in the form of fields. RDBMS is collection of data stored in table consisting of rows and columns. RDBMS also provides several operators to define, manipulate the data stored into the tables and indexes. Most RDBMS use SQL as a database query language. Edgar Codd is the one...

Read Full

MYSQL Overview

SQL stands for Structured Query Language. SQL is a language for Computer to manage, process and retrive large amount of data stored in relational database. By using SQL you can execute queries against database, insert new data, update data, can delete and modify data. SQL queries are classified as Data Definition Language (DDL) The standard for group of commands which are used to define structures in a database are called Data Definition Language (DDL). DDL statements such...

Read Full

Linux and Unix Uniq Command

Linux Uniq Command Overview Linux Uniq Command return the uniq content from the input text or from the input file data. It filters out all the duplicate data and thus returning unique data. You can provide input data by using it with some other command such as sort -u | uniq or you can provide input data in a text file to uniq command. Similarly either you can provide its output to some other command as standard output or you can save the output in a file. To summarise It...

Read Full

Linux and Unix Sort Command

Linux SORT Command Overview Linux and Unix sort command is used to sort the data. Either any other command like grep or less can provide input data to sort command or sort can be used to sort data present in a text file. We can provide output of other command to sort command as input. We can also provide data inside text file as a input to sort command Linux SORT Command Syntax Syntax for sort command is SORT [--options] [--input_data] Linux Sort Command Example...

Read Full

SQL DATEDIFF Function

SQL DATEDIFF OVERVIEW SQL DATEDIFF Function is used to calculate difference between two dates. SQL DATEDIFF Function is very useful in cases where you are required to apply any condition by checking differences between two dates. One can use SQL DATEDIFF function with all the SQL SELECT, UPDATE, DELETE, INSERT Statements and all the operators. SQL DATEDIFF SYNTAX SQL Syntax for DATEDIFF Function is SELECT *, DATEDIFF(date_column1, date_column2) FROM table_name;...

Read Full

Linked List Insertion Implementation in Javascript

We told about linked list basic structure in post  Linked List Introduction . In Linked List insertion can be done by adding a node. The value will be the one that we need to insert and next pointer depends on the position on which we are inserting that node.  We can insert a new node in three different ways in linked list. They are as follows Let us first initialise the linked list  "use strict"; var Node = require("./LListNode"); var LinkedList = function(){ ...

Read Full

SQL NOW Function

SQL NOW Overview SQL NOW Function is used to return system's current data and time. NOW Function will basically returnt the date and time of that system on which you are running on your query. If running on your system then Now will return your system's data and time and if you are running this function on any remote server than Now Function will return remote server's data and time. SQL NOW Syntax Syntax for SQL Now Function is SELECT NOW() FROM table_name; SQL...

Read Full

SQL SQRT Function

SQL SQRT Overview SQL SQRT Function is used to calculate square root of the input values. We can use SQL SQRT function while fetching data from database and can return SQRT of any of the column values. SQL SQRT Function comes handy when we need to calculate or use square root while processing or making any sql Query. SQL SQRT Function can only be used on positive numbers and not on negative numbers. if you will give negative numbers to SQL SQRT Function it will return null....

Read Full

SQL LEN Function

SQL LEN Overview SQL LEN Function is used to return length of the input column text value. LEN function does not include spaces that occurs in the start and end of the string. It means that LEN function will first perform trim function to remove spaces and then SQL LEN Function will calculate the length of the string. SQL LEN Syntax SELECT LEN(column_name) FROM table_name WHERE [condition]. SQL LEN Example Let us have a look at an example of SQL LEN function...

Read Full

SQL MID Function

SQL MID Overview SQL MID function is used to return a sub string characters from any text field column on the basis of start point and length of the sub string to return. MID function takes three input column_name => Name of the field from which sub string will be returned. start => Starting point of substring to return. length => Length of characters from start point to return. SQL MID Syntax Syntax for SQL MID function is SELECT...

Read Full

SQL LCASE Function

Overview SQL LCASE() function is used to return the column value in lower case while fetching data from database. LCASE function will return only input column in lower case not all columns in that table. SQL LCASE Syntax Syntax for LCASE function is SELECT LCASE(column_name) FROM table_name; SQL LCASE Example Let us look more into it with the help of an example Consider table student_list containing details for student....

Read Full

SQL UCASE Function

SQL UCASE() function is used to return the column value in upper case while fetching data from database. UCASE function will return only input column in upper case not all columns in that table. Syntax for UCASE function is SELECT UCASE(column_name) FROM table_name; Let us look more into it with the help of an example Consider table student_list containing details for student. +-----+------------------+--------+-----------+ | sid | name | year | hostel_id...

Read Full

SQL SUM Function

Overview SQL SUM() function returns the aggregated summation of all the values for input column name. There are lot of real scenario application uses for SUM function like calculate total population of a state by finding sum of its city wise population. Other use can be to find out the total salary given by company by finding out the sum of all the employee's salary. Other use case can be suppose in one table you have list of purchased goods than you can use sql sum function...

Read Full

SQL MAX Function

SQL MAX Function is used to find the maximum values for any input column_name. MAX aggregate Function is used to find the maximum value present in any column name like highest salary. Syntax for MAX Function is SELECT MAX(column_name) FROM table_name; Let us look on a example for this, Consider table hostel_list which is containing list of hostel details. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

SQL LAST Function

SQL LAST Function returns the last match, value, row or redord for a given condition. Last function is more useful when we have to get what is the last entry in the table for any given condition or situation. Syntax fot SQL LAST Function is SELECT LAST(column_name) FROM table_name WHERE [condition]; Let us understand better with an example. Consider student_list table with details for all the students.  +-----+------------------+--------+-----------+ | sid | name...

Read Full

SQL FIRST Function

SQL FIRST Function returns the first match, value, row or redord for a given condition. First function is more useful when we have to get what is the first entry in the table for any given condition or situation. Syntax fot SQL FIRST Function is SELECT FIRST(column_name) FROM table_name WHERE [condition]; Let us understand better with an example. Consider student_list table with details for all the students. +-----+------------------+--------+-----------+ | sid | name...

Read Full

SQL COUNT Function

SQL COUNT function is used to return the total number of rows present in any database table. Count function is mainly used where we want to fetch the total number of records in any of the given table. Syntax for SQL Count() Function is SELECT COUNT(column_name) FROM table_name WHERE [condition]; Let us take a deeper look at count function with the help of an example Consider table student_list which contains the list of students...

Read Full

SQL AVG Function

SQL AVG function is used to find out the average value of the column value that is provided as input to AVG function. It will return the aggregated average of all the values. AVG function is quite useful when we are doing some sort of analysis and needs to find the average value such as average salary, or avergae family strength in some city. Syntax for SQL AVG function is  SELECT AVG(column_name) FROM table_name; Let us have close look at it with the help of example....

Read Full

SQL Functions

Often we are required to perform lot of aggregations on columns containing string and numeric data. For this purpose SQL provides lot of in-built functions.  These SQL functions are defined to provide single value for all the aggregations by running functions or operations on the column provided to them as input. SQL Provides lot of functions that are listed below SQL AVG() Function - SQL AVG function will calculate the average value of all the input column values. SQL...

Read Full

SQL Null Function

Various REDBMS provide SQL NULL Functions in different forms. NVL(), IFNULL(), COALESCE() All provide same functionality to treat NULL values as 0.  MYSQL provides ISNULL() function to check whether the given column value passed in this is NULL or not. it gives outcome as 1 if value is NULL and 0 if it is something other than NULL. Syntax for ISNULL() function is SELECT column1_name, ISNULL(column2_name) FROM table_name; IFNULL() and COALESCE() function are used to...

Read Full

SQL Auto Increment

SQL Auto Increment is used to declare any field as auto increment. Which means that whenever a new record is inserted into the table this value will gets generated by incrementing its value in previous row. Often it is used as a primary key as it generated unique value for each record.  Often when we create a new table. We use to keep an Id field thats purpose is to uniquely define each record. So we can keep this record is auto increment primary key as this will get auto...

Read Full

SQL Sub Queries

SQL sub queries are referred as a subquery within a query. Subquery is used to fetch values and pass in another query as input. In SQL we can write subquery to fetch data and provide that data as input to the other query. Then other query can use that data as a conditions which is provided by subquery. In SQL we can use subquery within queries like INSERT, UPDATE, DELETE and SELECT. A Subquery can also be used wit all the SQL Operators. Often a Subquery is used to provide data to...

Read Full

SQL Clone Table

SQL Clone Tables can be referred as exact replica of an existing table. And to perform certain operations which you can not apply on original table as it is currenlty used by lot of enitities. For this purpose you can create a clone table of the exisitng table. There are various ways to create clone table. One way of creating a clone table is to use CREATE TABLE AS SELECT command Syntax for creating a clone table by this way is CREATE TABLE table_name AS SELECT [COL1,...

Read Full

SQL Temporary Table

SQL Temporary tables is the functionality provided by various RDBMS. This is used to create temporary tables which provide same funtionalities as of regular tables such as SELECT, UPDATE, INSERT, DELETE options but for the current logged in session only. Temporary tables acts very useful when we need to operate some operation on temporary data for temporary cases. As we know temporary tables only exist for the current logged in session in database so you will not find you...

Read Full

SQL Default Constraint

SQL Default Constraint is used to set default value for any column in a database table. Column gets populated with the default value if no value is specified while insertion. Syntax for setting default constraint while creating a table is CREATE TABLE table_name (column1 data_type DEFAULT default_value, column2 data_type); Syntax for setting default value in already created table is ALTER TABLE table_name MODIFY column_name DEFAULT default_value; Syntax for...

Read Full

SQL Check Constraint

SQL CHECK Constraint is used to set the range of values that can be set in a column. You can apply CHECK Constraint on any column to set the range of value that can be set in that column while insertiong and updation. Syntax for setting SQL CHECK Constraint is CREATE TABLE table_name (column1_name data_type, column2_name data_type, CHECK (column_name condition)); Syntax for setting CHECK Constraint in already created table is ALTER TABLE table_name ADD...

Read Full

SQL Wildcards

Overview Special characters are used as wild cards in SQL. SQL Wildcards are used to fetch data from table with the LIKE clause. We can use LIKE clause with wildcards to match substring or string with some pattern in database table. SQL Wildcards are % ==> It matches one or more characters. _ ==> It matches one character. [list_of_characters] ==> In this it applies sets, ranges of string characters. [! or ^list_of_characters] ==> In this this is used...

Read Full

SQL Expressions

SQL Expressions are used to evaluate to a value. SQL Expressions can be combination of one or more values, operators and SQL functions that evaluate to a value.  Expressions are used to query database for a specific data set. We can assume SQL Expressions as formulas that are used in SQL Queries to fetch and process data. Syntax Basic syntax for SQL Expressions is SELECT * FROM hostel_name where [expressions]; Different kind of SQL Expressions are as follows SQL Date...

Read Full

SQL Indexes

Overview Indexes helps in faster retrieval of data from database table. Database application uses indexes to retrieve data fast. Indexes are separate tables which are used to lookup on database tables to fetch data faster. Indexes are like index that you have in books. If you want to directly go to any chapter or topic than you search for that topic or chapter in index and directly go to that page. This is how index works. We create lookup tables having pointers to our data in...

Read Full

SQL Unique Key

Overview Unique Key is used to define uniqueness in data in any column of a table. Primary Key and Unique key both are used to maintain uniqueness in a table.  Despite of lot of same functionalities in primary and unique keys. There are lot of differences as well. Unique key can have null values where as primary key does not. There can be lot of unique keys in a table but only one primary key. A primary key by default has unique constraint in it. Syntax Create Table with...

Read Full

SQL Foreign Key

Overview SQL Foreign Key constraint is always defined as primary key constraint in another table. Foreign key column can only have those values which are mentioned in another table's primary key column. Foreign key acts as a reference key to the primary key in another table. Foreign key can be a single column or a combination of columns. Syntax Syntax for defining Foreign key is CREATE table table_name (column1 data_type, column2 data type, column1...

Read Full

SQL Primary Key

Overview SQL Primary Key is a property of column which uniquely defines each row or we can say record in a database table. In a table we can define one or more column as primary key. In simple words we can say that Primary key is a column or a group of column which uniquely defines row in a table. So for no two columns can have same data for a primary key. Primary key column cannot contain null value. Composite Key When two or more than two column combines to form primary key...

Read Full

SQL Truncate Table

Overview SQL Truncate table is used to delete all data inside the database table at once. Unlike delete it deletes all data at once without going to each line one by one leaving the empty table behind. SQL Truncate table also makes only one entry in transaction log file. You can say that truncate statement is like delete statement without a where clause to delete all data at once. Syntax Syntax for SQL Truncate table statement is TRUNCATE TABLE table_name; Examples...

Read Full

SQL Alter Table

Overview SQL Alter table is used to update the database table structure of an existing table. Alter table command can add, delete or modify any of the column in an exisitng table. Lot of time we get a requirement to either add a new column, delete an existing column or change the name, place, data type or data a column can hold, In all such requirement we can use SQL Alter statement. Syntax for SQL Alter statement for add, drop and modify a column is mentioned below in...

Read Full

SQL Insert Into Select

Overview SQL INSERT INTO SELECT query is used to select data from one table and to copy that selected data into another existing table. Either we can copy all the data or we can also select a subset of data from the table which satisfies the given condition. Largely it is used to take backup or to copy the existing rows, records from one table to another existing table. we can also say that SQL INSERT INTO SELECT is used to create new table by copying data from existing table....

Read Full

SQL Select Into

Overview SQL SELECT INTO query is used to select data from one table and to copy that selected data into new table. Either we can copy all the data or we can also select a subset of data from the existing table which satisfies the given condition. Largely it is used to take backup or to copy the existing rows, records from one table to another new table. we can also say that SQL SELECT INTO is used to create new table by copying data from existing table. Syntax Syntax for...

Read Full

SQL Using Views

Overview A view is a virtual table stored in database. View can contains all the rows and columns of one or more table combined using a SQL Statement. It will act just like a real table, the only difference is that a view is a virtual table not a real table. We can add Where conditions, SQL functions and can also use join statements to create a view and than show that view as if data is coming from one single table.  Views are useful in collating the data from different tables and...

Read Full

SQL Having Clause

Overview SQL Having Clause works with Group BY Clause. Having clause applies the condition on the groups returned by the group by clause. Final rows contains only those groups which passes the having condition. In other words Having Clause will only returns those aggregate values which will meet the Having condition in the select query. Syntax Syntax for Having Clause is SELECT column_names FROM table_name WHERE conditions GROUP BY column_name HAVING [condition]....

Read Full

SQL Top Clause

Overview SQL Top Clause is used to return a subset of the total rows in a table. TOP takes a number or a percent as input and will return those data from the table. TOP Clause is not supported by all RDBMS. But Most of the RDBMS provide same funtionality eiher by using TOP CLause or some other clause. Syntax Syntax for TOP Clause is SELECT TOP NUMBER column_name FROM table_name; SELECT TOP PERCENT column_name FROM table_name; MYSQL Provides this functionality...

Read Full

SQL Aliases

Overview SQL Aliases are used to temporarily assign a different name to a table and columns headings while they are making a SELECT query. Often when we use Joins on table we use aliases at that time. Aliases are also used to make tables and column names more readable while we are fetching data through comples queries. Syntax Syntax for Aliases for columns and tables are given below SELECT column_name AS temp_column_name FROM table_name; SELECT column_name...

Read Full

SQL Null & Not Null Operator

Overview Null values represent a blank values in a database table. Suppose you insert data for four column in table having six column. So at that time the rest of the two columns will have either the null value or the default value if there is any default value set for those column in table. At times when we are working on SQL Queries we get the requirement to fetch rows by checking whether the column has Null values or doesnt have null values. So for such requirements we...

Read Full

SQL Union Clause

Overview SQL Union Operator is used to combine select query result for two or more than two tables. As SQL Union Opertor combines result set for two or more than two select fetch statements than all the select statement must have same set of columns, same set of columns in expression, same data types with same or different data length. Union operator is used to select only distinct or unique values in default case. If we want to fetch all the possible Union of select...

Read Full

SQL Cartesian Join

Overview SQL Cartesian Join returns the cartesian product of two or more joined tables. Thus It joins every row of each table with other tables. Some time Cartesian Join is also referred as Cross Join.  It tends to Join all the rows of each table with every possible row of other tables on the basis of specified conditions. There are other type of Joins as well which are explained in SQL Joins . Syntax Syntax for Cartesian Join or Cross Join is Select * from table...

Read Full

SQL Self Join

Overview SQL Self Join is a join which is used to combine table with itself on the basis of a condition. In SQL Self join table will be combined with itself as another table. Syntax Syntax for SQL Self join is SELECT tab1.column, tab2.column FROM table tab1, table tab2 WHERE tab1.column1_value = tab2.column2_value;...

Read Full

SQL Full Join

Overview SQL Full Join will return combination of rows from both the tables on the basis of common field by filling NULL values on non matching rows. Full Join will basically give you a combination of both the tables. Syntax Syntax for Full Join is: SELECT left_table.column, right_table.column FROM left_table FULL JOIN right_table ON left_table.field = right_table.field; Examples Let us have a look with the help of following table i) hostel_list containing list...

Read Full

SQL Right Join

Overview Right Join as the name suggests it returns all the result from the right table i.e. table 2 and all the rows that matches the ON clause from left table i.e. table 1. So Right Join will return all the rows from right table and it will return either matching rows from left table or null for non matching rows. Even if it will not find any matching rows in left table at all in that case also it will return all the rows from right table. Syntax Syntax for SQL Right Join is...

Read Full

SQL Left Join

Overview Left Join as the name suggests it returns all the result from the left table i.e. table 1 and all the rows that matches the ON clause from right table i.e. table 2. So Left Join will return all the rows from left table and it will return either matching rows from right table or null for non matching rows. Even if it will not find any matching rows in right table at all in that case also it will return all the rows from left table. Syntax Syntax for SQL Left Join is...

Read Full

SQL Inner Join

Overview Among all the avaialable SQL Joins Inner Join is the most common type of join. Inner Join is used to combine data from two or more tables. Inner Join combines all the data from all the tables having common data and are also fufilling the condition. Inner Join are also known as EquiJoin . Let us have a look at an example having two tables Syntax Syntax for SQL Inner Join is SELECT left_table.column, right_table.column FROM left_table INNER JOIN right_table...

Read Full

SQL Joins

Overview SQL joins are used to combine data from two or more database tables on the basis of some common value in the tables. We apply joins by passing where conditions so we can use all the operators applicable with where clause like < , > , <=, >=, !=, <>, between, like, Not, = and lot more. Here we will be explaining 5 types of joins in next few articles SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Cartesian...

Read Full

SQL Between Clause

Overview Between Clause is used to check where conditions between two values for a column. You can actually fetch, update, delete data by applying a condition between two values. Syntax Syntax for Between Clause is SELECT * FROM table_name WHERE column_name BETWEEN (Val1, Val2); Example Suppose we want to fetch list of hostels which have max_capacity between 1000 to 3000 students. SELECT * FROM hostel_list where max_capacity BETWEEN 1000 and 3000;...

Read Full

SQL In Clause

Overview In clause helps us to apply a range of values or multiple values in a where condition to match with. It is more commonly used when we want to match a column value to any from a group of values. Syntax Syntax for In Clause is SELECT * FROM table_name WHERE column_name in (Val1, Val2, .... ValN); Example Let us consider hostel_list table, which contains the list of hostels with their occupancy and capacity limits....

Read Full

SQL Like Clause

Overview Like clause is used with Where clause to apply condition. As the name suggests Like clause is used to fetch all the records where a column matches/contains a word. Syntax Syntax for Like clause is SELECT * FROM table_name where column_name LIKE 'random_value'; Example Suppose we need to find all the hostel name which ends with 'SH' like KAILASH BHAVAN is one of them. So the query for this will be SELECT * FROM hostel_list WHERE name LIKE '%SH %'; In...

Read Full

SQL Group By

Overview Group By operator is used for grouping our data on the basis of column values. It is very useful when we want our data to be represented in groups. Syntax Syntax for Group By Operator is SELECT * FROM table_name GROUP BY column_name; Example Suppose we want fetch list of hostels but ir should be in order where all the hostels with same occupancy_type should be toghether. For this we can write SQL query like this SELECT * FROM hostel_list GROUP BY...

Read Full

SQL Order BY

Overview Order By Operator is used when we want to arrange you results in a particular order. Order by is used against any of the table column in either ascending or descending order. Syntax Syntax is for Order By is SELECT * FROM table_name WHERE ORDER BY column_name [order]. You can pass order value as asc and desc. Asc is used for ascending order and Desc is used for descending order. Example For ex. Consider hostel list table which contains list of hostel...

Read Full

SQL Distinct

Overview Distinct Statement is used to find out the distinct values in any of the columns. Syntax Syntax for Distinct Statement is SELECT DISTINCT column_name FROM table_name; Example Let us get a clear picture with the help of an example Consider table hostel_list containing the list of hostels +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN |...

Read Full

SQL AND & OR Operator

Overview While using where condition in sql query we can use AND and OR operands. Syntax Syntax for using AND and OR operator are SELECT * FROM table_name where [conditions]; Example Let us dig deeper with the help of an example Consider table hostel_list containing list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN | 2 |...

Read Full

SQL Operators

SQL Provide various operators to specify the conditions with Where clause. You can use multiple sql operators in where clause to connect one or more conditons in your sql statement. Below is the list of operators that SQL provides Arithmetic Operator Comparison Operator Logical Operator Negate Operator...

Read Full

SQL Delete Table

Overview Whenever you need to delete anything from your table, you can use Delete command Syntax Syntax for delete command is DELETE FROM table_name where [conditions]; Example Let us look more into this with the help of an example. Let us consider table hostel_list which contains the list of hostel. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity | +----+-------------------+-----------+----------+ |  1 | ASHOK BHAVAN...

Read Full

SQL Update Table

Overview When you are required to update any data in the exisitng table you can use sql update command Syntax Syntax for update data in any table is UPDATE table_name SET col1_name = col1_new_value, col2_name = col2_new_value where [conditions]; Example Let us look into this with the help of an example and consider table hostel_list which contains list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

SQL Where Condition

Overview Where condition is used to fetch data from the table on the basis of some conditions on some of the data columns. Syntax Syntax for using where clause is SELECT * FROM table_name WHERE (conditions); Example Let us have a deeper look on this with the help of an example Let us consider our hostel_list table which contains the list of hostels. +----+-------------------+-----------+----------+ | id | name | occupancy | capacity...

Read Full

SQL Select Table

Overview To fetch data from database table we use select command. Syntax Syntax for select command is SELECT (Col1, Col2) FROM table_name; Example Let us dig in some of the data that we inserted in insert step in our hostel_list. I have added four hostel details in our list. To select all data in our hostel list table, the sql query will be SELECT * FROM hostel_list; +----+-------------------+-----------+----------+ | id | name | occupancy...

Read Full

SQL Insert Into

Overview Now in previous few steps you were learning how to create , desc and delete table. Now let us see how to insert data into our tables. Insert into command is used to insert data into our tables. Syntax Syntax for insert command is INSERT INTO table_name (Col1, Col2.... ColN) values (Val1, Val2... ValN); Here in this command the number of columns passed should be equal to number of values passed. and Val1 will always corresponds to Col1. That means...

Read Full

SQL Drop Table

Overview To remove/delete a sql table from database we use DROP command. Syntax Syntax for dropping a table is  DROP TABLE table_name; Example For ex. If we want to drop abc table create in last step . Than the sql query will be DROP TABLE abc;...

Read Full

SQL Create Table Like

Overview Sometimes you can get a requirement where you need to create a new table like an already exiting with different table name. There you can use " create table like " command. Syntax Syntax for create table like command is CREATE TABLE table_name like already_exiting_table_name; CREATE TABLE table_name AS SELECT [COL1, COL2] FROM already_exiting_table_name [WHERE]; Example For ex: If you want to create abc table like hotel_list table...

Read Full

SQL Desc Table

Overview To see description, structure, column names and data types of any existing table you can use command Desc table. Syntax Syntax for this is DESC table_name; Example Let us see the table hostel_list that we just created in last step DESC hostel_list; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra...

Read Full

SQL Create Table

Overview Table is where database store structured data. For creating a simple or you can say basic database table you need a unique table name in that database and need to define columns and their data types. CREATE TABLE command is used for this purpose. Syntax Syntax for creating a simple database table is CREATE TABLE table_name (column_one data_type, column_two data_type, column_three data_type, primary key(column_name)); Example Now let us create...

Read Full

SQL Use Database

Overview After logging in to database. Before accessing any data or doing any operation, we are required to select a database. which we do using USE command. Syntax Syntax for selecting database is. USE db_name; Example As we have created hostel database in previous step than to start using that database we need to select that database. To select hostel database the command will be. USE hostel. For any reason if hostel database doesn't exist. we will get an...

Read Full

SQL Show Database

Overview To see the list of available databases we can use the Show databases command. Syntax Syntax for getting list of databases is SHOW databases; it will give the list of available...

Read Full

SQL Drop Database

Overview Drop database command is used to drop an existing database. Admin user rights are required for drop command. Syntax Syntax for SQL drop database command is DROP DATABASE db_name; Example Say if you want to drop hostel database that you created in previous step. DROP DATABASE hostel;...

Read Full

SQL Create Database

Overview Create database command is used to create a new database. Admin user rights are required for creating database. Syntax The syntax for SQL create database command is CREATE DATABASE db_name; Example Say if you want to create a database with name hostel. CREATE DATABASE hostel;...

Read Full

SQL Data Type

SQL data types defines what type of data a column can contains. While creating a column you need to define the data type that you would be saving in that column. Through these data types SQL understands what type of data is in column and how to show that data while retrieving that data. Below is the list of various data types and their descriptions. bit  ==> Numeric value, can hold from 0 to 1. tinyint ==> Numeric value, can hold from 0 to 255. smallint ==>...

Read Full

SQL Syntax

SQL syntax or query follows a particular rules and regulation which are denoted as SQL Syntax. Every SQL starts with standard operators and ends with the semicolon. Some of The Most Important SQL Commands CREATE DATABASE - creates a new database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DROP TABLE - deletes a table INSERT INTO - inserts new data into a database SELECT - retrieves data...

Read Full

SQL RDBMS Concept

RDBMS stands for Relational Database Management System. RDBMS data are stored in database tables, record and fields in structured manner. Each RDBMS table consists of table rows and each row consists of data in the form of fields. RDBMS is collection of data stored in table consisting of rows and columns. RDBMS also provides several operators to define, manipulate the data stored into the tables and indexes. Most RDBMS use SQL as a database query language. Edgar Codd is the one...

Read Full

SQL Overview

SQL stands for Structured Query Language. SQL is a language for Computer to manage, process and retrive large amount of data stored in relational database. By using SQL you can execute queries against database, insert new data, update data, can delete and modify data. SQL queries are classified as Data Definition Language (DDL) The standard for group of commands which are used to define structures in a database are called Data Definition Language (DDL). DDL statements such...

Read Full