Skip to main content

Posts

Featured post

Python For Loop increment Tricky Example

In this post, I have explained tricky for loop example in Python. The usage of FOR LOOP is to create loops. How many times the loop will execute you may supply in the input.

My Project is to get each character from the input String. I use for loop to achieve this.
Tricky FOR LOOP Examples Explained different for loop examples.
1. Python For Loop Syntax using Variable or Array >> for valuein variable
Python For Loop Example >> myName = 'srinimf'

>> for valuein myName
...        print(value)

The result is as follows:
s
r
i
n
i
m
f
2. Python For Loop With '1' to '10' or 'n'for(i=1;i<=10;i++)<loopbody> The above for loop useful to create definite loop. The maximum loops are '10'. You can write your logic for each value in Python.

This is one of the tricky and most popular example.
3. How does a Python For Loop works a Flowchart

The 'letter' contains ValuestateName is an Array or VariableAfter For Loop you can use BODY s…
Recent posts

Top template technical resume for professionals

Sample resumes for Software engineers explained the length of the Resume for different experience levels. Also covered how one can show projects in the Resume.

The Resume is a tool to showcase your skills and talent. Powerful sentences in your resume make bright chances to pick it by an interviewer.

You can classify resumes for Software engineers as four categories. In my experience, I found these four types. I listed down four types as below.
Different Types of Resumes0-1 Year Resume1- 5 Years Resume5-10 Years Resume10-20 Years Resume Your English with simple and powerful sentences adds power in a way to convince your recruiter or interviewer. Ideal Resume with Two Pages is more than enough for all levels of experienceHow many pages you do have to keep in Technical Resume Nowhere you can find how long the resume should be. But, I want to say there is a thumb rule. Two Page Resume ideal fit for all cases No matter, If you just came from a college or an experienced software engineer. Resu…

12 top Devops methodologies to read today

In this post explained 12 top DevoOps principles or features which are common to all the DevOps tools. Useful to give interviews and your projects.

DevOps means a concept to bring Development team and operation team together. So that you can speed up the deployment process. Before you start learning the tools you need to understand core principles.
The useful DevOps Principles to know for your project and interviewsTo deliver rapidly without affecting qualityCommunication and Collaboration are the key ideas in DevOps conceptMultiple deploys are possible- if code in Development team automatedOnce you commit the repository, it tests the code automatically against the automated test scriptsIf Build is successfully passed, it installs automatically in Testing environment When infrastructure is automated, it installs automatically to other serversMinor changes takes place in isolation, that means , it creates separate server to deploy minor changesSpeed in Devops, organizations to better se…

Top AWS services list quick tutorial

In this post, I have explained the top AWS services list. These services are useful to read before your next interview. knowing of this list is a must for all cloud-computing engineers.

AWS provides various services. This post gives clear understanding on AWS top services. Not only for traditional services, it also offer services for Mobile  IoS and Android Os.


Aws Service catalog helps organizations to manage their IT services.
List of Top AWS  ServicesEC2LambdaS3DynamoDBIAMAmazon CognitoDevice FarmMobile analyticsSNS AWS EC2 Instance EC2: Amazon Elastic Compute Cloud (EC2) provides secure, scalable, on-demand hardware virtualization in the cloud.
Using Amazon EC2 eliminates the need to invest in server hardware up front so that users can focus on, develop, and deploy applications faster. 
EC2 instances come in various hardware configurations and include an operating system.

Lambda Function in AWS AWS Lambda lets users run snippets of code without provisioning an infrastructure. 
This se…

Top Data Science tools complete list

Top data science tools and platforms providers across the world. Useful information for data science and data analytics developers.

Data Science is a combination of multiple skills. AI and Machine Learning are part of data science. You can create AI and Machine Learning products with data. 

Related Posts

Top Skills You Need for Data Science CareerData Science Sample Project an Example

PL/SQL: Popular Reserved Words

To become perfect in PL/SQL is an art. Knowing of top reserved words helps you to be a master in SQL.


Top List of PL/SQL Reserved Words.. Before you start knowing reserved words, wait one moment. The reserved words all are similar to words that you use in normal SQL. ALL*DESC*ISOLATIONOUTSQLERRMALTER*DISTINCT*JAVAPACKAGESTART*AND*DOLEVEL*PARTITIONSTDDEVANY*DROP*LIKE*PCTFREE*SUBTYPEARRAYELSE*LIMITEDPLS_INTEGERSUCCESSFUL*AS*ELSIFLOCK*POSITIVESUMASC*ENDLONG*POSITIVENSYNONYM*AUTHIDEXCEPTIONLOOPPRAGMASYSDATE*AVGEXCLUSIVE*MAXPRIOR*TABLE*BEGINEXECUTEMINPRIVATETHEN*BETWEEN*EXISTS*MINUS*PROCEDURETIMEBINARY_INTEGEREXITMINUTEPUBLIC*TIMESTAMPINTEGEREXTENDSMLSLABEL*RAISE

SQL top ideas on how to use built-in functions correctly

In this post I am giving top examples on SQL functions. About built-in functions, I have covered in my previous post.
List of Built-in FunctionsDATE-TIME functionsNumeric functionsChar functionsNull-related functions1. DATE/TIME functions SELECT p_code, launch_dt, CURRENT_DATE FROM product; CURRENT_DATE returns current date.
SELECT p_code, TO_CHAR(launch_dt, 'DD MONTH YYYY') reformatted_dt FROM product; TO_CHAR function returns DATE in CHAR format.
2. Numeric functions SELECT p_code, price, (price - 20), ABS(price - 20.00) FROM product; ABS - function returns absolute value
SELECT p_code, price, ROUND (price, 1) FROM product;
ROUND function - Round to 1 digit.
SELECT p_code, price, SIGN(price - 15) FROM product;
SIGN function - It returns sign; either + or -
SELECT p_code, price, TRUNC(price, 1) FROM product;
TRUNC function - Truncates to a certain number of decimal places.
3. CHAR functions SELECT p_code, CONCAT(CONCAT(p_name, ' -- ') , price) FROM product; CONCAT func…

SQL built-in functions useful to read quickly

You can find there are four different types of functions in SQL. All these functions are built-in functions. You no need to create these functions, and these come with your SQL.


I am discussing today about SQL functions List.
SQL functionsDATE-TIME functionsNumeric functionsChar functionsNull-related functions 1. DATE-TIME functions These functions useful to get DATE and Time. Also you can covert DATE and TIME to Char. These are TO_CHAR, CURRENT_DATE and CURRENT_TIME 2. Numeric Functions These functions you can use for numeric calculations. Those are TRUNC, SIGN, ROUND, ABS 3. Char Functions To handle string related tasks you can use CHAR functions. The CHAR functions are like SUBSTR, CONCAT, LENGTH. 4. NULL related functions To handle null values you can use different functions. Those are COALESCE, NVL, NULLIF

This post covered all your answers for SQL functions list, SQL built-in functions in Oracle, and SQL functions in any DBMS.
Also Read SQL tips to improve Query performanceSummary