Posts

Showing posts from October, 2014

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

Talent Analytics on employees to measure real worth

Image
Human resource managers are currently embracing talent analytics like never before. Companies are evaluating and analysing raw data to derive valuable insights which are helping them to hire the right talent, retain them as well as help them learn and grow internally. Data to do analytics Talent analytics companies take into account all the data, rather than limited samples, so a full-fledged picture emerges.  It looks for patterns in the data and discovers critical connections that might otherwise go unnoticed. Such data can be related to employees' pre-employment assessments to background checks to social media profiles. How data will gather They also gather data on the characteristics of their most successful employees. When big data is tapped this way, HR managers no longer need to depend on intuitions of interviewers and hiring managers or rely on obsolete hiring tools of yesteryears.  Organisations are also leveraging big data to hire and promote t

Internet-of-Things jobs Booming in Technology area

Image
The Internet of Things helps enable proactive data access from any connected device.The Internet of Things represents an evolution in which objects are capable of interacting with other objects. Hospitals can monitor and regulate pacemakers long distance, factories can automatically address production line issues and hotels can adjust temperature and lighting according to a guest's preferences, to name just a few examples.  Stocksnaps.io Furthermore, as the number of devices connected to the Internet continues to grow exponentially, your organization's ability to send, receive, gather, analyze and respond to events from any connected device increases as well. IBM solutions can help put the Internet of Things to work for you by giving you the ability to:  connect millions of objects and millions of events. unlock information in systems of record.  support new systems of interaction with people, mobile devices, sensors, machines and applications.  optimize business r

New Wave in Data Analytics in 2014

Image
 SrnimfJobs N ow that we’re in the swing of a new year, we’ve taken stock of the data analytics trends that are brewing and developed a list of the Top 5 trends we believe are going to dominate the industry this year. Even if some of them don’t realize their full potential in 2014, it promises to be an important year in which consumer trends and technology innovation will further shape a future in which companies make data-driven decisions. 1. Data Visualization Goes Mainstream In the mid-90s, e-mail introduced the Internet to consumers, made it more accessible, and catalyzed user adoption. Similarly, data visualization will make data analytics more accessible in 2014. Visual analytics allows business users to ask interactive questions of their prepared data sets and get immediate visual responses, which makes the whole process engaging. This trend will democratize access to data and foster a strong data analysis culture where business users will look for data and perform

12 Top Teradata Blogs

Image
Teradata is popular among data warehouse projects. I have collected good blogs for developers. Here you will get complete list. The following are 12 top Teradata blogs. Teradata with learn quest Teradata Tutorials Teradata first blog Teradata developer blog Teradata developers recommendations Teradata tuning Teradata fog blog Teradata Bigdata Blog Teradata blog big solutions Teradata Applications Blog Teradata Utilities Teradata Technology Blog Conclusion Not only reading getting knowledge from these blogs, if you feel these are good you can share to your friends.