Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Cloud in India Rural Education

Many a times we do things beyond a formal classroom without realizing that we are learning in the process. For example, an individual surfs and accesses material on the Internet in the form of audio, video, wiki and then goes ahead to even create and store information. Understanding the immense power of peer-to-peer learning, Classle, a Chennai-based startup has developed a cloud based education system for rural India. Classle gets lakhs of people together and enables them to connect to each other in thousands of communities available on open social network of Classle. People can connect with these communities to collaborate and share exchange resources in their chosen areas of interest. There are many features to collaborate in addition to make learning fun oriented. The cloud-based system enables students to access learning material free of cost, through their basic, low-cost mobile devices. The impact - more than 55 academic institutions have partnered with Classle-- almost all of them are engineering colleges predominantly in rural areas. Some of them are GLA University, Mathura; Madanapalle Institute of Technology and Madanapalleand Excel College of Engineering, Thiruchengodu.

Read more at: http://www.informationweek.in/informationweek/case-study/287388/indian-startup-cloud-transform-education-rural-india?utm_source=referrence_article

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers