SQL Assignment 1

we are  performing SQL operation for that used following table as :

Table Employee
Figure 1.0

 1) Display the following virtual columns.

Exam Fee 25% Discount Exam Fee After Discount 18% GST Final Exam Fees

If the Exam fee is Rs.9701 calculate the rest.

Ans : select 9701 as “Exam Fee”, (9701*(25/100)) as “25% Discount” , 9701-(9701*0.25) as “Exam Fee After Discount” , (9701-(9701*0.25))*0.18 as “18% GST”, ((9701-(9701*0.25))+((9701-(9701*0.25))*0.18)) as “Final Exam Fee” from dual;

2) Display the below sentence for the employees.  SMITH’S salary is 800 and his dream salary is 3 times i.e. = ________.

Ans: select ename||q'<‘s>’||’ salary is ‘|| sal ||’ and his dream salary is 3 times =’ || sal*3 from emp;

3) Calculate annual salary for all employees with a monthly deduction of 20%. Label the column as “Annual Salary after 20% Deduction”.

Ans: select ename as “Name”, sal, sal-(sal*0.20) as “Monthly Deduction of 20%”, sal-(sal*0.20))*12 as “Annual Salary After Deduction” from emp;

4) Display unique job in each department number.

Ans : select distinct(job), deptno from emp;

5) Calculate the below columns for all employees.

Employee Name Monthly Salary 20% Deduction Deducted Salary Annual Salary after Deduction

Ans: select ename as “Employee Name”, Sal as “Monthly Salary”,
sal-(sal*0.20) as “20% Deduction”, sal-(sal-(sal*0.20)) as “Deducted Salary”,(sal-(sal*0.20))*12 as “Annual Salary After Deduction” from emp;6) Display the below sentences for all employees. I can’t work with SMITH because he works in the department’s no. 20.

Ans : select ename || ‘ can’||q'<‘t>’ || ‘ work with SMITH ‘ || ‘because he works in department’  ||q'<‘s>’ || ‘ no ‘ ||deptno from emp where ename!=’SMITH’;

7) List all employee name and total salary, they are paid 500 rupees and balance salary. Provide proper heading to all 3 columns.

Ans : select ename as “Name”, sal as “Total Salary”, 500 as “Paid Rs 500”,  sal-500 as “Balance Salary” from emp;

What is deep learning

Deep Learning

Machine Learning and Artificial Intelligence (AI) have become the buzzword in the tech industry. There is a lot of conversation around the opportunities presented by Machine Learning. Emerging technologies like machine learning are quickly evolving but they also bring with them a sense of fear and excitement.

What is Deep Learning?
Artificial Intelligence (AI) is a technology that allows machines to perform tasks that require human intelligence. The technology encompasses machine learning, where machines can learn and acquire skills without any human assistance. Deep Learning is a subset of Machine Learning, which enables machines to learn from Artificial Neural Networks and algorithms. Just like how humans learn from different experiences, deep learning algorithms are designed to perform the same task to improve the outcomes.

The resources help in enriching the accuracy of deep learning models. Deep Learning models require a ton of data to learn from. The advent of Big Data is an important reason why deep learning capabilities are improving with each day. Apart from data creation, these algorithms benefit from the strong computing power that’s available today.

The integration of artificial intelligence and cloud platforms has also helped in boosting data creation. The proliferation of artificial intelligence (AI) as a service has helped small organisations access artificial intelligence technologies. The technology can help machines in solving complex problems using vast data sets that are diverse, unstructured and interconnected.

Practical examples of deep learning

1. Voice assistance
Several tech giants working on smart technologies are using deep learning models. Siri, Alexa, Google Assistant, and Cortana use virtual assistants to understand your speech and language. Deep Learning models are helping these virtual assistants to improve the experience of end users.

2. Autonomous cars
The way an autonomous vehicle understands the realities of the world is based on deep learning algorithms. The complex data sets and driving patterns are helping in the evolution of driverless cars.

3. Chatbots
Customer service around the world has benefitted from the arrival of chatbots and services bots. The technology powering these bots is an example of the deep learning model. Companies are feeding their customer support data to these bots to help them mimic the human-like customer support experience.

4. Facial recognition
The face tagging suggestions that you get on Facebook is the best example of facial recognition powered by deep learning models. The challenge here is in identifying that it’s the same person even when they change their facial features like hairstyle or beard.

5. Pharmaceuticals
Deep Learning can enable the medical field to diagnose diseases like tumor. The technology has gained the attention of large pharmaceutical and medical companies around the world. It can help in improving the efficiency of the treatment and service in the medical field.

Upcoming Smartphones in 2018

If you have to wait to buy a smartphone in 2018 then it’s a right time to pick the best smartphone for you after the launch of a fantastic device like Samsung Galaxy Note 9 and Xiomi mi A2, it would like to look
forward more devices like oppo F9 and Apple iPhone SE 2

Here top 5 smartphones of 2018 in india

Oppo F9
Features of Oppo F9
Processor: Octa-core
Screen Size: 6.3 inches
Storage : 64GB
Rear Camera: 16 MP + 2 MP Dual Primary Cameras
Front Camera: 25MP
Battery: 3500 mAh
Expected Launch: August 2018
Price in India: Approx. Rs 22,000

Xiaomi Mi 8 X
Features of Xiaomi Mi 8 X
Processor: octa core
Screen Size: 6 inches
Storage 64 GB
Primary Camera: 20 MP
Front Camera: 12 MP
Battery: 3100 mAh
Expected Launch: September
Price In India: Approx. Rs 24,000

Apple iPhone SE 2
Features of Apple iPhone
Processor: Octa Core
Screen Size: 4.5 inches
Storage: 32 GB
primary Camera: 12 MP
Front Camera: 1 MP
Battery: 1750 mAh
Expected Launch: November
Price in India: Approx. Rs 26000

Nokia X6
Features of Nokia X6
Processor: Octa Core
Screen Size: 5.8 inches
Storage: 32 and 64 GB
Primary Camera: Dual 12 MP
Front Camera: 8 MP
Battery: 3050 mAh
Expected Launch: September last weekend
Price in India: Approx. Rs 21,000

How to pick, the new iPhone XS, XS Max, and XR

For the consecutive second year, Apple has announced three new iPhones at once.

Image: Apple’s new iPhone XR, XS and XS Max

So, let’s examine the things that the three new iPhones have in common.


The processor: All three new iPhones share Apple’s latest A12 Bionic processor [The A12 Bionic – It has a six-core CPU (with two “performance” cores and four “efficiency” cores), a four-core GPU (which is up to 50 per cent faster than the A11’s), and an updated Neural Engine, a special part of the chip designed to handle AI tasks ]., a 7nm chip that, according to the company, represents a breakthrough in mobile computational power. Its two performance cores (which handle intensive tasks) are “up to 15 per cent faster” than the iPhone X, while the four efficiency cores (responsible for powering your everyday app usage) are “up to 50 per cent more efficient.” The GPU is up to 50 per cent faster. It’s not like modern iPhones struggle with running iOS games. Each new iPhone also contains Apple’s updated, separate eight-core Neural Engine for handling machine learning or AI tasks, which can handle 5 trillion operations per second.

The main camera: the XR might lack a telephoto/zoom lens, but it has the exact same 12-megapixel f/1.8 primary camera as the XS and XS Max. Apple says that on each of the three models, the camera uses an all-new sensor (with larger pixels) and it’s capable of Smart HDR, which produces photos with “far greater dynamic range” and less noise in low light. The new camera is also better at freezing motion shots, according to Apple. Like last year, all of the new iPhones can shoot 4K video at 60 fps and 1080p slo-mo at 240 fps.

Frontfacing TrueDepth camera: the camera system used for selfies, Face ID, Animoji, and Memoji (Moji) is the same across all three new iPhones. It’s a 7-megapixel f/2.2 sensor.

True Tone, widecolour displays: Though they use different display technology, the iPhone XS and XR each include Apple’s True Tone tech, which adjusts the display’s temperature to match the ambient lighting around you. They’re also capable of showing a wide P3 colour gamut.

A quicker Face ID system: yes, the home button is gone for good from Apple’s 2018 iPhones, but the company has sped up Face ID this year by adding a faster secure enclave and smarter face-scanning algorithms.

Faster wireless charging: Apple says all of its 2018 models support faster Qi charging than the iPhone X.

DualSIM support: the new iPhones are all capable of supporting two phone lines by including both eSIM and one physical nanoSIM card in the phone. This will make international travels easier.

Stereo audio recording: The iPhone XS, XS Max, and XR each have four microphones built in to capture stereo sound when you’re shooting video.

Better stereo speakers: Apple claims that the new iPhones all have improved stereo speakers with a wider audio presentation.

image: Apple


$1,099 (64GB) | $1,249 (256GB) | $1,449 (512GB)
The iPhone XS Max is designed for people who love their Plus-sized smartphones. You get more screen — a 6.5-inch display.

$999 (64GB) | $1,149 (256GB) | $1,349 (512GB)

$749 (64GB) | $799 (128GB) | $899 (256GB)

The difference is the camera, as the XR has just a single, optically stabilized 12-megapixel sensor.
If you pick the XR, you’re getting a lot of what’s best about the iPhone XS in a cheaper package. And it has the best battery life of any of this year’s iPhones as the final kicker.

Tech Mahindra Set up 5G Center of Excellence.

Tech Mahindra has announced that it is planning to set up a 5G (5G is a marketing term for some new mobile technologies. Definitions differ and confusion is common. The ITU IMT-2020 standard provides for speeds up to 20 gigabits per second and has only been demonstrated with millimetre waves of 15 gigahertz and higher frequency) Center of Excellence (CoE) powered by Intel technology in Redmond, Washington and Bengaluru. The CoE will help communication service providers (CSP) optimize their capital expenditure on 5G migrations and rollout and accelerate new revenue-generating services that will lead the transformation journey.

The CoEs will be set up at Tech Mahindra’s Intel-enabled VNF-Xchange Labs (Virtualized Network Functions, software implementations of network functions that can be deployed on a Network Function Virtualization Infrastructure), and will focus on developing 5G virtualized radio access network (vRAN) solutions. And it will help in diverse industry verticals like healthcare, manufacturing, banking, automotive, Energy and more, we are poised to unlock new experiences for these industry verticals with 5G and simultaneously drive growth for CSPs.

5G networks will need data-service centric platforms to not only enhance connectivity but also empower industry stakeholders to use data for better decision making. 5G will require a change in the network’s anatomy to enable CSPs to offer a wide range of digital service and SDN/NFV [SDN– Software-defined networking (SDN) and NFV — Network functions virtualization (also network function virtualization or NFV) is a network architecture concept that uses the technologies of IT virtualization)] is the foundation to accomplish this. The work in this CoE will provide for new support and acceleration of emerging technologies to be integrated into the new architectures, but more importantly, develop new social and industry relevant use cases.

Caroline Chan, vice president and general manager, 5G infrastructure division, Data Center Group, Intel, said, “We share a common vision with Tech Mahindra of enabling service providers around the world to accelerate the deployment of their 5G networks and roll out new services that are beneficial to our society. By utilizing flexible platforms based on Intel architecture and technologies, Tech Mahindra is helping reduce the time to market for CoSPs and offering a broad choice of agile solutions for the 5G future.

Tech Mahindra works with over 270 CSPs globally and is currently working with multiple services provides on their network transformational journey.


Chrome Features

The features in Chrome that communicate with Google

Google Chrome uses a combined web address and search bar at the top of the browser window. As you use the Omnibox, your default search engine can suggest addresses and search queries that may be of interest to you. These suggestions make navigation and searching faster and easier, If Google is your default search engine when you select one of the Omnibox suggestions, Chrome sends your original search query, the suggestion you selected, and the position of the suggestion back to Google. This information helps improve the quality of the suggestion feature.

Network predictions
Chrome uses a prediction service to load pages more quickly. The prediction service uses navigation history and local heuristics to predict which resources and pages are likely to be needed next TCP and TLS pre-connection, and prefetching of web pages. To turn off network predictions, uncheck “Use a prediction service to load pages more quickly” in the “Privacy” section of Chrome’s settings.

Google search local
If Google is set as your default search engine, Chrome will try to determine the most appropriate local for Google search queries conducted from the Omnibox in order to give you relevant search results based on your location.

New Tab page
The Chrome New Tab page may display suggestions for websites that you might want to visit.

Tap to Search
If you’ve enabled “Tap to Search” on Chrome Mobile you can search for terms by tapping them. When you tap a word, the word, the surrounding text, and the home country of your device’s SIM card is sent to Google to identify recommended search terms

Safe Browsing protection
Google Chrome includes an optional feature called “Safe Browsing” to help protect you against phishing, social engineering, malware, unwanted software, malicious ads, intrusive ads, and abusive websites or extensions. Safe Browsing is designed specifically to protect your privacy and is also used by other popular browsers. This feature is not available on the iOS version of Chrome.

Navigation error tips
Google Chrome can show tips to help guide you to the page you were trying to reach in cases where the web address cannot be found, a connection cannot be made, the server returns a very short (under 512 byte) error message, or you’ve navigated to a parked domain.

WhatsApp tricks you should know about it !!

Did you know you can pin your important chats on the top in WhatsApp? Or that you can read WhatsApp message without informing the sender? Like these, there are other nifty tricks/features that can change the way you use the world’s most popular instant messaging app, WhatsApp.

1) Send messages without typing
WhatsApp users can send messages without actually typing, thanks to Siri and Google Assistant. While Android smartphone users can use Google Assistant to send messages, iPhone users can send messages using Siri. These digital assistants can also read out your WhatsApp messages
for you.

2) Read WhatsApp message without informing the sender
Do you know that there is a trick in WhatsApp which will enable you to read a message without informing the sender? All you need to do is scroll down to the notification plan and enable the flight mode on the smartphone. Once done, just open the WhatsApp chat and read the message. After reading the message just make sure that you close the app from the multi-window so, that it doesn’t run in the background and sync you when online. After the complete process just removes the phone from flight mode! you have read the message without informing the sender.

3) Share your live location

After rolling our live location sharing on Messenger, Facebook rolled out the feature on WhatsApp too, but WhatsApp already added in 1 year ago. Once you share your live location with someone, they would be able to track wherever you go for the time period you select. The three-time frames that can be selected are — 15 minutes, 1 hour and 8 hours. It is very simple to share one’s live location with their friends. Just open WhatsApp, tap on the ‘Attachment’ icon on the typing spacebar and select ‘Location.’ Once you do this, you’ll get two options – ‘Share live location,’ and ‘Send your current location.’ Tap on the former option and select the time frame.

5) ‘Unsend’ messages
Did you just send a wrong message to the wrong person on WhatsApp? You needn’t panic. There is still a way to delete it. Just select the message press ‘Delete’ on the top bar which has other options like reply, mark star, copy, forward and information. Once you press ‘Delete,’ you’ll get two options – ‘Delete for me’ and ‘Delete for everyone’. Select the second one so that the recipient cannot read the message that you mistakenly sent them. However, you only get seven minutes to delete the message after you have sent it.

6) Pin your chats

There are times when you want your most important chats on the top of your conversation list. Scrolling down through scores of messages to find that chat can be tedious. Not anymore. In a recent update, WhatsApp added this function. To pin a contact to the top of the list, you have to long press on the chat from that person and then press the ‘pin icon’ that appears right next to delete, mute and archive icons on the top of the page. As of now, only three contacts can be pinned to place them on top of the conversation list.

7) Format text
There’s a good chance you’re already aware of this feature but have never used it. Somehow, changing formats of text on WhatsApp never really caught on. We’ll tell you again how to format text on WhatsApp as it is a handy feature to use. You can bold text on WhatsApp by starting it and following it with an asterisk ‘*’. Similarly, for italics, make sure the text is preceded and followed by an underscore sign ‘_’. You can also make your text appear struck off with Strikethrough. For that precede and follow it with tilde ‘~’.

8) Add conversation shortcuts

We all have a favourite friend with we are constantly yapping on WhatsApp. Rather than opening WhatsApp and going to their chat each time you want to talk to them, you can add a conversation shortcut on your home screen. Just long press on the conversation, click on three dots on top of the page and click ‘Add chat shortcut’.

Data Science and Machine Learning

Machine learning and statistics are part of data science. The word learning in machine learning means that the algorithms depend on some data, used as a training set, to fine-tune some model or algorithm parameters. This encompasses many techniques such as regression, naive Bayes or supervised clustering. But not all techniques fit in this category. For instance, unsupervised clustering – a statistical and data science technique – aims at detecting clusters and cluster structures without any a-prior knowledge or training set to help the classification algorithm. A human being is needed to label the clusters found. Some techniques are hybrid, such as semi-supervised classification. Some pattern detection or density estimation techniques fit in this category.

Data science is much more than machine learning though. Data, in data science, may or may not come from a machine or mechanical process (survey data could be manually collected, clinical trials involve a specific type of small data) and it might have nothing to do with learning as I have just discussed. But the main difference is the fact that data science covers the whole spectrum of data processing, not just the algorithmic or statistical aspects. In particular, data science also covers

  • data integration
  • distributed architecture
  • automating machine learning
  • data visualization
  • dashboards and BI
  • data engineering
  • automated, data-driven decisions

Oppo F9 Pro to be launch in India Today: Here’s everything you need to know

The Chinese Tech Giant, Oppo F9 Pro is available India on August 21.
Ahead of its launch, Oppo has posted several teasers with celebrities
revealing some of the key aspects of the F9 Pro including
VOOC flash charge, waterdrop screen, and gradient color schemes etc.

Oppo F9 Pro Key Features:

1) The striking feature of the phone is the VOOC Flash Charge.
Charging the phone for 5 minutes will last your device for 2 hours.
2) Waterdrop screen, which basically means that the display will
be edge-to-edge with a notch that is shaped as a water droplet.
3) The Oppo F9 to get the latest Gorilla Glass 6 protection,
which can survive up to 15 drops from a height of up to 1 meter.
4) The primary camera comes with a f/1.9 aperture while
the secondary camera will be used for depth sensing.

For new iPhone XS , XS Max, XR , Please visit the following link.

How to pick, the new iPhone XS, XS Max, and XR

Dragon may be ruled on Google !!

There are continuously circulating reports that Google is working on a search app and a news app that will be follow the Chinese web censorship laws.
that means Google come back in china. it’s good for Google growth but not for internet freedom. if Google search engine or apps follow china censorship laws, then Google could remove all it’s references of human right records, Tibetan independence movements, suppress opposition views, and always praising china government’s decisions and the a lots, from any and all search results. if this prediction happen means we can say that Dragon defeat tech Giant Google, and also on following China government censorship laws if any other countries make an law and implemented in their nation then that country also threat Google to follow their country law’s too.

To protect against that Project Dragonfly, Thousand’s of Google employees have signed a letter criticising the company’s plan to launch a heavily censored version of its search engine in China.

In this letter, which is an internal petition, the employees asked for more transparency and oversight of Project Dragonfly.

In the letter, the employees say Google would be validating China’s restrictions on freedom of expression and violating its own clause in the company’s code of conduct, “don’t be evil”.

Google has not officially commented on the project, but following the letter, Google CEO Sundar Pichai told employees the project is still in early stages of development and it is still unknown if the search engine would launch at all.

Human Rights Organizations and activists expressed their worry over Google’s plans when they were shared earlier this month in US media reports.

Amnesty International called it “a dark day for the internet” if Google decided to push through its plans.

However, Google completely escaped from China in 2010 after several large-scale ( censorship- laws ) attack on company by the Chinese government.
Also Google Services, including it’s search engine, Gmail and Google drive are blocked in China.