Posts

Showing posts from October, 2016

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

How to Write Python 'Hello World' Program Quickly and Run it

Image
The first Python program looks like the below.  I have explained the steps you need to write your first program in Python. My first program: odbchelper.py You can write your program as nameccheck.py module. if authorsFirstName == 'Irv':       teachingPython = True       print 'Pay attention to his wisdom' How to Run Your Python Program python namecheck.py Sample python program if authorsFirstName == 'Irv':      teachingPython = True    print 'Pay attention to his wisdom' The above if condition checks for first name.  In python '==', means equal to. It makes true to teachingPython .  You can start your python program quickly. Really useful for learning and to use it in projects.

5 Top Code Format Tools

I have given in this post the list of code formatting tools. These are useful to write better code. 5 Top Code Format Tools SQL Formatter - This tool helps you format your SQL Queries instantly. Java Code format Tool - This tool is one of the best tool to format your JAVA code instantly. Python Code Format Tool - This tool is famous Python online code format tool. CSS Code format Tool - The best tool to format your CSS code so nicely JavaScript Code Format Tool - This is one of the best tool to format your JavaScript code

How to use Python Interactive Shell in an easy way

It's like this: Python leads a double life. It's an interpreter for scripts that you can run from the command line or run like applications, by double-clicking the scripts. What is Interactive Shell? But it's also an interactive shell that can evaluate arbitrary statements and expressions. This is extremely useful for debugging, quick hacking, and testing. I even know some people who use the Python interactive shell in lieu of a calculator!  Launch the Python interactive shell in whatever way works on your platform, and let's dive in with the steps shown here: First Steps in the Interactive Shell >>> 1 + 1 ❶ 2 >>> print 'hello world' ❷ hello world >>> x = 1 ❸ >>> y = 2 >>> x + y 3 ❶ The Python interactive shell can evaluate arbitrary Python expressions, including any basic arithmetic  expression. ❷ The interactive shell can execute arbitrary Python statements, including the print s

Python Command Line Options List

The complete list of command line options -b Issue warnings for calling str() with a bytes or bytearray object and no encoding argument, and comparing a bytes or bytearray with a str. Option -bb issues errors instead. -B Do not write .pyc or .pyo byte-code files on imports. -d Turn on parser debugging output (for developers of the Python core). -E Ignore Python environment variables described ahead (such as PYTHONPATH). -h Print help message and exit. -i Enter interactive mode after executing a script. Hint: useful for postmortem debugging; see also pdb.pm(), described in Python’s library manuals. -O Optimize generated byte code (create and use .pyo byte-code files). Currently yields a minor performance improvement. -OO Operates like -O, the previous option, but also removes docstrings from byte code. -q Do not print version and copyright message on interactive startup (as of Python 3.2). -s Do not add the user site directory to the sys.path module search path. -S Do not imply “impor

5 Top Features People Need Today in Modern Devices

Image
S mart devices in the current world play a key role. It is because these have better features to help people. In this post, I shared the top features people expect in smart devices. Now the world is mature enough to design devices and connect them with some intelligence and should give some benefit to users. Intelligence in the Modern Devices. Devices installed with Software, you can call Intelligent things. Modern devices nowadays have intelligence.  People look at Smart things is the problem-solving approach . At the same time, smart things should generate revenue. List of Smart Devices. There are many smart devices already in the market. For example, smartphones, smart appliances, Shoes, watches, and more.  The real requirement is increasing user experience in those devices. Design companies are advising their departments to implement high user experience in their devices.  For example smart cameras, advice on personal and financial matters. Features People Need in Mo

Top Skills You Need to Develop a modern App

Image
The development of mobile applications provides many job opportunities. In today’s mobile world intelligent apps play a crucial role. Modern Intelligent apps. To understand correctly intelligent apps now ruling the world. They started 60 years ago, and they are now in a mature stage.  Due to the increasing usage of mobile phones, the importance of Artificial Intelligence apps came into the limelight again. Intelligent apps usage is quite a lot. The key applications are Voice to text , Text to Voice, and Image recognition. Application of Intelligent Apps. Planning Vision Voice recognition Natural Language Processing Self-driving cars Help to physical Disabled people Role of Robotics. Agriculture needs many robots. They can work even in the rainy season. The construction field needs many robots to work on roof-tops.  Deep-ocean where Robots requires for exploration of oil and pearls.  Top Examples of Intelligent Apps. PowerVocab  UnlockyourBrain  TED  Casual

7 Amazing Ideas to Make Resume for First Job

Image
Resume writing is a skill. Out of a thousand applications, only a few would shortlist for the next process. Here are my ideas to provide in your resume before you send it out. Resume format How to make resume format Give Mobile number and E-mail on the top of your resume. Use MS-word to format it. Organize information using bullets wherever the need. Check Spell and Grammar. Two pages are ideal for any type of job. 7 Amazing ideas Detailed resume ideas Provide genuine-experience. Transferable skills such as Public-speaking, Customer-communication - good to mention. Provide previous experience in reverse order - last-in-first. Keep educational qualification after the experience. No need to mention weaknesses. Add awards you received during your employment. Not required salary details.

Top Tips You Need to Create Mobile Apps

Image
Before you start creating mobile applications, you need to understand two things. There are two mobile application types. Namely Native and Web applications. Mobile applications are two types.Those are Native and Web applications.   Photo Credit: Srini Native applications Each mobile operating system you need to create one version. Native applications are platform dependent. The disadvantage is you need to create multiple versions. Develop apps only on that platform These apps not portable Web applications The web applications are platform independent. They work for all mobile operating systems. These applications are browsable using any popular browsers. These apps are browsable from any popular web browsers 4 Top Mobile Platforms iOS  Android  Windows Phone 7  Blackberry OS  4 Top Tablet Platforms iOS  Android  Blackberry OS  Windows 8 Related Learn Android app quickly and your own time