Posts

Showing posts with the label video trainings

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

Complete Videos of IBM Watson IoT

Image
Watson IoT is a set of capabilities that learn from, and infuse intelligence into, the physical world. The Internet of Things-generated data is growing twice as fast as social and computer-generated data, and it is extremely varied, noisy, time-sensitive and often confidential. You can learn quickly IBM watson for IoT quickly. Complexity grows as billions of devices interact in a moving world. This presents a growing challenge that will test the limits of programmable computing.  What is Cognitive IoT Cognitive IoT is not explicitly programmed. It learns from experiences with the environment and interactions with people.  It brings true machine learning to systems and processes so they can understand your goals, then integrate and analyze the relevant data to help you achieve them. References IBM Watson IoT videos 5 Challenges in internet of things Follow us on social media Facebook Twitter

Hadoop Skills Free Video Training

Are you interested in the world of Big data technologies, but find it a little cryptic and see the whole thing as a big puzzle. The hadoop free video training really useful to learn quickly. Are you looking to understand how Big Data impact large and small business and people like you and me? Do you feel many people talk about Big Data and Hadoop, and even do not know the basics like history of Hadoop, major players and vendors of Hadoop. Then this is the course just for you! This course builds a essential fundamental understanding of Big Data problems and Hadoop as a solution. This course takes you through: Understanding of Big Data problems with easy to understand examples. History and advent of Hadoop right from when Hadoop wasn’t even named Hadoop. What is Hadoop Magic which makes it so unique and powerful. Understanding the difference between Data science and data engineering, which is one of the big confusions in selecting a carrier or understanding a job role. And mos