Posts

Showing posts from December, 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

Top Cloud Security Interview Questions

Image
Also read our tech blog www.srinimf.com Cloud Computing Questions Cloud Security Cloud Computing Questions part-1 Cloud Computing Questions Part-2 Cloud Computing Questions Part-3 Cloud Computing Questions Part-4 Cloud Computing Questions Part-5 Cloud Interview Questions

Social Media Career Options

Image
Social Media career Skill Set for Social Media Jobs Understands social media universe including Facebook, Twitter, Google+, Instagram, Pinterest, YouTube, Vimeo, Yelp, Urbanspoon, TripAdvisor, Company Blogs/Wordpress and more  Able to work effectively in a multi-tasking environment  Excels at research, possesses excellent writing skills and the ability to create editorial and technical writing output quickly  Proficient with Microsoft Office products, or preferably Apple iWork products  Demonstrated creativity and documented immersion in social media  Have excellent verbal and written communication skills and an ability to work individually on a project or in a team environment  Social media popularity from Udemy The career options Management of social media Copy writing Design Public speaking The popular training (#sponsored) Popular training in social media The Hot and coldest skills as per dice The other popular Social media managers Content

SAS career these are different job roles

Image
What is SAS? Originating in 1966 at North Carolina State University, SAS is a proprietary 4th generation programming language specifically designed for data analysis. Data analysis includes data management, ETL, descriptive statistics, plots and graphics, inferential statistics, data mining, forecasting, etc.. In addition to the SAS programming language, SAS Institute, its parent company, also sells solutions built on top of the SAS language. Many people assumptions about SAS: Some people confuse SAS with the common database query language called “SQL”, thinking that both languages manage data in some way. While SAS may be used for database querying (reading/writing data to databases), this is only a tiny fraction of SAS’s capabilities. To give some scope, the entire SQL language is available in SAS as but one “procedure” (think of a procedure as a bundle of functionality). SKILL Set: What It Is: Pronounced “sass,” this software helps workers perform a variety of tasks, in

MongoDB Basics Tutorial top Resources

Mongo DB has rapidly grown to become a popular database for web applications and is a perfect fit for Node.JS applications, letting you write Javascript for the client, backend and database layer. Its schemaless nature is a better match to our constantly evolving data structures in web applications, and the integrated support for location queries is a bonus that’s hard to ignore. Throw in Replica Sets for scaling, and we’re looking at really nice platform to grow your storage needs now and in the future. Now to shamelessly plug my driver. It can be downloaded via npm, or fetched from the github repository. To install via npm, do the following: npm   install   mongodb or go fetch it from github at  https://github.com/mongodb/node-mongodb-native Once this business is taken care of, let’s move through the types available for the driver and then how to connect to your Mongo DB instance before facing the usage of some CRUD operations. Tutorial on MongoDB Mongo DB data type

MongoDB and HCL on Bigdata

Image
MongoDB and HCL Infosystems have announced a global partnership which will allow HCL Infosystems to further broaden its solution offerings in the emerging big data segment by developing services around MongoDB. Commenting on the partnership, Kamal Brar, Vice President APAC, MongoDB, said: "Big Data is more than just addressing increasing volume; organizations need solutions that can manage increasing data variety and velocity. Today, businesses need to quickly ingest, store, and access useful information from massive pools of multi-structured data.This is where MongoDB excels. HCL Infosystems will offer innovative solutions and services for organizations to gain value from their data and make smarter and faster business decisions. Partnering with HCL will further strengthen our footprint globally." Since its inception MongoDB has collaborated with organizations worldwide and now has a thriving global community. Common MongoDB use cases include single view, Internet o

Top Teradata Course details that you need to learn

Image
Teradata is most popular database among data warehousing projects. You will learn Teradata from any institute you want. My post intention is you just take a look on course contents you need to learn. Course Contents You Need to Look Before You Start Related: Top Data warehousing Interview Questions Introduction to Teradata Data warehousing concepts and SCD’s OLTP & OLAP Teradata Architecture & Physical Design Teradata Vs. Other RDBMS BYNETPEs AMPs Vprocs Clique Cluster Data Storage Data Distribution Data Access Teradata Space Management Fault Tolerance Data Protection Teradata Indexes and Performance Tuning and Optimization UPI – Unique Primary Index NUPI – Non Unique Primary Index USI – Unique Secondary Index NUSI – Non Unique Secondary Index PPI – Partition Primary Index MLPPI – Multilevel Partition Primary Index STJI – Single Table Join Index MTJI – Multi Table Join Index AJI – Aggregate Join Index Global Temporary Tables and Vola

The biggest threat to cloud security

Image
[Cloud Security] The biggest threat to cloud security among IT is the company’s employees unintentionally exposing data, according to the latest research figures from CloudEntr. The study, which took 438 survey responses from industries including financial and manufacturing, found three quarters (75%) of smaller businesses are most worried about their workforce when it comes to securing data in the cloud. Larger IT firms were more concerned about hackers using employee credentials to get their hands on data. Not surprisingly, regulated institutions were more concerned about cloud compliance than non-regulated, but 75% also said their biggest tool in becoming more secure was employee education. It’s not just employee education, but shadow IT which continues to be a problem. 29% of those polled said they had no plans to use the cloud in their organisations, but of that number, nearly half of IT pros said they knew of employees who were using it. T he vast majority (89%) of IT

Cloud Security Top Course Contents You Need to Learn

Image
Below is a list of course contents that you need in Cloud security training.  Missing any of these, you will miss many things. Cloud Security Course Contents  Cloud Architecture: Computing Evolution, cloud vocabulary, Essential Characteristics of Cloud Computing, Cloud deployment models, Cloud Service Models, Multi-Tenancy, Approaches to create a barrier between the Tenants, cloud computing vendors, Cloud Computing threats, Cloud Reference Model, The Cloud Cube Model, Security for Cloud Computing. How Security Gets Integrated Governance and Enterprise Risk Management - Information security governance processes, Governance and enterprise risk management in Cloud Computing, Governance Recommendations, Enterprise Risk Management Recommendations, Information Risk, Management Recommendations, Third Party Management Recommendations, Legal and Electronic Discovery Risk Management, Legal and Electronic Discovery Risk Management Security Recommendations. Compliance and Audit Cloud customer re

Cloud in India Rural Education

Image
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 o