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

My 4 Top Books Success, Life, Money, Mind Power

Four ultimate books I have collected after asking many seniors and experienced people. Based on their valuable suggestions I have added these books to my reading table. Simply nice collection. Even now I read these books regularly. Get these and you too can benefit.

A book that has valuable information can be read by readers on a daily basis. As said, sometimes difficult to get all the information at one time. So many professionals read daily. Just grab the below collection to your next goal.



My 4 best ultimate books that change your life
Photo credit: Srini


👍 1. Greatness Guide 2 - Robin Sharma


The Greatness Guide is a strikingly powerful and enormously practical handbook that will inspire you to get to world-class in both your personal and professional life.

Written by Robin Sharma, one of the planet's top success coaches and a man whose ideas have been embraced by celebrity CEOs, leading entrepreneurs, rock stars and royalty, as well as by many Fortune 500 companies, the Greatness Guide contains a proven formula that will help you meet your highest potential and live an extraordinary life.

Discover, the personal practices of spectacularly successful people, potent ideas to get your organization to greatness, specific strategies to turn setbacks into opportunities, revolutionary tactics for peak performance, how to attract true wealth along with real happiness, breakthrough ideas to generate excellent health and an "energy explosion", tools for work-life balance and ways to experience a lot more fun.

👍 2. Unlimited Power - Raj Bapana 


You get a book of 175 pages and a CD called "Genius CD". You learn an enormous amount of theoretical and practical knowledge from the above book as the table of contents shows below: Chapter 1. Introduction... 8 Chapter 2. The Unlimited Power of Your Subconscious Mind etc.





The Rich Dad Classics Boxed Set contains three mass-market titles from the Rich Dad Poor Dad series in one boxed set. The boxed set includes Rich Dad Poor Dad - the best-selling personal finance guide for the millions hoping to become masters of their money. The

Cash Flow Quadrant - the follow-up to Rich Dad Poor Dad reveals why some people work less and earn more, pay fewer taxes, and feel more financially secure than others. Rich Dad's Guide to Investing - the basic rules of investing, including how to reduce investment risk and how to convert earned income into passive and portfolio income.

👍 4. Winning the Game of Life by Adam Khoo 


Life is like a game. There are few who play the game of life to win and many who play 'not to lose. If you are amongst the few who play to win, this book will give you the competitive edge!

You will discover that anyone can become a winner in the game of life- to become the best in your field, to enjoy beautiful relationships, to create financial abundance, and to have everlasting happiness. All it takes is for you to learn and apply the winning principles of champions.

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