Easier Invitations Mean More Followers and Blog Contributors

Easier Invitations Mean More Followers and Blog Contributors.

First, now you can invite people to follow your blog. If your blog is public, anyone can use the Follow button to sign up to receive an update each time you publish new content. But if you’d like to share your blog with specific people, we’ve made it easy to send them an invitation to check out your site.

The best way to do Do SEO – Keywords are most important

Keywords are the most important SEO element for every search engine, they are what search strings are matched against. Choosing the right keywords to optimize for is thus the first and most crucial step to a successful SEO campaign. If you fail on this very first step, the road ahead is very bumpy and most likely you will only waste your time and money. There are many ways to determine which keywords to optimize for and usually the final list of them is made after a careful analysis of what the online population is searching for, which keywords have your competitors chosen and above all – which are the keywords that you feel describe your site best.

1. Choosing the Right Keywords to Optimize For

It seems that the time when you could easily top the results for a one-word search string is centuries ago. Now, when the Web is so densely populated with sites, it is next to impossible to achieve constant top ratings for a one-word search string. Achieving constant top ratings for two-word or three-word search strings is a more realistic goal.

For instance, If you have a site about dogs, do NOT try and optimize for the keyword “dog” or “dogs”. Instead you could try and focus on keywords like “dog obedience training”, “small dog breeds”, “homemade dog food”, “dog food recipes” etc. Success for very popular one-two word keywords is very difficult and often not worth the trouble, it’s best to focus on less competitive highly specific keywords.

The first thing you need to do is come up with keywords that describe the content of your website. Ideally, you know your users well and can correctly guess what search strings they are likely to use to search for you. You can also try the Website Keyword Suggestions Tool below to come up with an initial list of keywords. Run your inital list of keywords by the Google keyword Suggestion tool, you’ll get a related list of keywords, shortlist a couple of keywords that seem relevent and have a decent global search volume.

2. Keyword Density

After you have chosen the keywords that describe your site and are supposedly of interest to your users, the next step is to make your site keyword-rich and to have good keyword density for your target keywords. Keyword density although no longer a very important factor in SEO is a common measure of how relevant a page is. Generally, the idea is that the higher the keyword density, the more relevant to the search string a page is. The recommended density is 3-7% for the major 2 or 3 keywords and 1-2% for minor keywords. Try the Keyword Density Checker below to determine the keyword density of your website.

Introduction to SQL

SQL Tutorial

SQL (Structured Query Language) is used to modify and access data or information from a storage area called database. This beginner sql tutorial website teaches you the basics of SQL and how to write SQL queries. I will be sharing my knowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can be applied to most of database systems. The syntax used to explain the concepts is similar to the one used in Oracle database.

SQL Introduction

SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. It is a query language used for accessing and modifying information in the database. IBM first developed SQL in 1970s. Also it is an ANSI/ISO standard. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it’s feature and making it a powerful tool. Few of the sql commands used in sql programming are SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, ORDER Clause, Joins, Views, GROUP Functions, Indexes etc.

In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:

  • store data
  • modify data
  • retrieve data
  • modify data
  • delete data
  • create tables and other database objects
  • delete data

SQL SELECT Statement

The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name. The whole query is called SQL SELECT Statement.

Syntax of SQL SELECT Statement:

SELECT column_list FROM table-name
[WHERE Clause]
[GROUP BY clause]
[HAVING clause]
[ORDER BY clause];

  • table-name is the name of the table from which the information is retrieved.
  • column_list includes one or more columns from which data is retrieved.
  • The code within the brackets is optional.

database table student_details;

id first_name last_name age subject games
100 Rahul Sharma 10 Science Cricket
101 Anjali Bhagwat 12 Maths Football
102 Stephen Fleming 09 Science Cricket
103 Shekar Gowda 18 Maths Badminton
104 Priya Chandra 15 Economics Chess

NOTE: These database tables are used here for better explanation of SQL commands. In reality, the tables can have different columns and different data.

For example, consider the table student_details. To select the first name of all the students the query would be like:

SELECT first_name FROM student_details;

NOTE: The commands are not case sensitive. The above SELECT statement can also be written as “select first_name from students_details;”

You can also retrieve data from more than one column. For example, to select first name and last name of all the students.

SELECT first_name, last_name FROM student_details;

You can also use clauses like WHERE, GROUP BY, HAVING, ORDER BY with SELECT statement. We will discuss these commands in coming chapters.

NOTE: In a SQL SELECT statement only SELECT and FROM statements are mandatory. Other clauses like WHERE, ORDER BY, GROUP BY, HAVING are optional.

How to use expressions in SQL SELECT Statement?

Expressions combine many arithmetic operators, they can be used in SELECT, WHERE and ORDER BY Clauses of the SQL SELECT Statement.

Here we will explain how to use expressions in the SQL SELECT Statement. About using expressions in WHERE and ORDER BY clause, they will be explained in their respective sections.

The operators are evaluated in a specific order of precedence, when more than one arithmetic operator is used in an expression. The order of evaluation is: parentheses, division, multiplication, addition, and subtraction. The evaluation is performed from the left to the right of the expression.

For example: If we want to display the first and last name of an employee combined together, the SQL Select Statement would be like

SELECT first_name || ' ' || last_name FROM employee;


first_name || ‘ ‘ || last_name
Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra

You can also provide aliases as below.

SELECT first_name || ' ' || last_name AS emp_name FROM employee;


Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra

Check out the Famous Websites

Live Cricket & Nature of India
ERP-SAP Functional Consultant | Web Designer Developer | SEO Expert | Auto-blogger
Ganoderma411 – Your Premier Online Source For 411 On The King Of Herbs Known As Reishi, Lingzhi, And Ganoderma Lucidum
Ganoderma Herbs & benefits by ganoderma411.info
Mojo Magnet Marketing Attracting That Premium Business You Need In This New World Market
Al spaulding no tag, no labels, just value from All angels – Going beyond the scope of Social Media & Online Marketing

About SEO

1. Analyze keywords : This step has to be taken place initially while developing the website, Keywords, those are very useful for your business should be used in the content of the website itself. In other case, if you are looking for SEO to brush up your website then make update of the articles and blogs useful for your website in the content afterwards containing the Keywords having density 4%. This will help you in getting more traffic.
2. Use keywords in the page content : Keywords should be used in 4% density as it is very useful in link building, Putting the keyword in your page content also signals to search engines that the page is actually about the keyword and should show up in search results. We have heard from “experts” that you should use your keyword anywhere from 4-6 times to 10-12 times.Our advice is to just write naturally.

3. Put keywords in Meta Data : While the page metadata (Page Description and Keywords) are not nearly as important as they used to be, they still count.Take advantage of them by putting your keyword or phrase there.The description should be readable by a person and make sense and the keyword metadata should focus on your keyword or phrase – do not make it long, less is more
4. Put keywords in Page Title :The Page Title is one of the most important things that Google and other search engines evaluate to determine what is on a web page.Put your keyword or phrase in the title, keep it short.
5. Put keywords in your H1 text :The H1 text is usually the title of an article or some larger bold text at the top of your page.Google and the smaller search engines can see this and they put extra importance on the words in the H1 text.Make sure your keyword or phrase is there.
6. Reduce Image Size :Too many images or large images on your website page will slow down the loading time of your website. Confirm your images have a resolution of 72ppi. Slice big images into smaller pieces with your graphics editor.
7. Find incoming links (backward links) : Websites that link to yours raise your link popularity. Search for websites that are relevant with yours and have a PR 3 or more to do a link exchange. Write optimized articles and include them on your website. This means your website has a greater opportunity of being indexed quickly also as getting a boost in its rankings.Create absolute links from all your internal pages to your home page. This will increase the number of links pointing to your homepage.
8. Place any script code into external files : when using JavaScript (i.e. for exchange images on your navigation bar) it creates a lot of code between the header tags, pushing down the text that search, engines would spider first. Placing the script code in an outer file reduces the code to just one line.
9. Write clean html code : website editors frequently write additional code. This can increase the loading time of your website pages. Verify your html code by running it through an html validator
10. Monitor Your Rank : Give the search engines some time to do their thing and then keep checking your rank to see what happened and track your progress.

Welcome Dear Friend!

We are a group of IT professionals We can offer websites n softwares and graphic designers and web templetes. We, IT service providers, you can choose/post many projects. You are most welcome here. Let us share ideas, doubts and many more in the king of programming languages. * You will find Developer , Coder, Designer, Stylist, Scripter , Flasher & SEO * specialists You will be able to post as many tasks as you want, these tasks could be in any Programming language. We work on: * WEB DESIGN o Flash o AJAX * Programming o JS o PHP o MySQL o ASP.NET o VB.NET o Flash Action Script For FAQs, see the thread:



How Green is your Valley?

Though India's per capita carbon emission is low, urbanites have a high personal carbon footprint. Here's how to reduce it at little cost-

IF YOU go by numbers alone, concerns about carbon emission may seem exaggerated. At an average per capita carbon emission of 1.18 tonnes, India is a laggard compared with countries like the US (19 tonnes), Japan (9.7 tonnes) and even our stiffest competitor China (4.6 tonnes). Moreover, households contribute a meagre 10-12 per cent to the national carbon footprint. So why bother about the carbon emission you are responsible for or the ways to reduce it?

"It is because the top 25 per cent of the population, which includes the middle class, has a larger carbon footprint than others," says Jyoti Parikh, executive director, Integrated Research and Action for Development (Irade). "As low-income households consume more resources to improve their standard of living, their footprint will increase. To maintain the overall balance, the top bracket must reduce energy wastage."

The CII-Sohrabji Godrej Green Business Centre has helped formulate the carbon footprint of an average urban household for money today. According to their study, an urban family of four emits 13,865 kg of greenhouse gases every year. Says N. Muthusezhiyan, senior counsellor at the CII Centre, "We have assumed the maximum possible usage of devices. Most people will have a carbon footprint ranging from 80-100 per cent of 13,865 kg."

This figure may be lower than the average household emission in the West, but it is way higher than the carbon footprint of rural and low-income families. "It is the difference between owning two cars and none. If people incorporate the steps that we have suggested (see Small is not Costly), middle-class households can cut emissions by as much as 42 per cent," he says.

The problem, as most people believe, is that shrinking your carbon footprint may bloat your budget. A green lifestyle, they think, is an elitist pursuit and requires big-ticket expenses. Is it true or just a convenient way to pass the buck?

To find the answer, we worked out the cost of adopting the measures suggested by CII. The result is surprising. A green lifestyle can be yours for as little as Rs 1.03 lakh a year. We say 'little' because this is not incremental, but absolute cost. Moreover, it includes one-time expenses like a 5-star rated air conditioner, a solar heater and double-glazed glass for windows. From the second year onwards, staying green becomes much cheaper – about Rs 8,020.

The only other obstacle in popular imagination is the tedium of maintaining an eco-friendly lifestyle. "It involves no hassles," says 40-year-old Arjun Valluri, who built a green home in Hyderabad last year. It boasts solar panels for heating, a sewage treatment plant and double-glazed glass windows, besides other features. "Of the nearly Rs 6 crore that I spent, only five-six per cent was on green additions," says Valluri. It is no noblesse oblige that motivated him to shell out extra. "The payback period for these measures is five years. For instance, the monthly electricity bill for a house of this size would be about Rs 22,000, whereas I pay only Rs 4,000-5,000 a month," he says.

Does this convince you that an eco-friendly lifestyle is easy to adopt and inexpensive to maintain? However, you may not know how to start building one.

Here is a ready reckoner to take you through the nitty- gritty of going green.

Construction add- ons

If you are lucky enough to be building an independent house, you can enjoy a greener lifestyle than those living in an apartment.

Introduce the green elements at the blueprint stage itself. For instance, ensure that you make maximum utilisation of day light to reduce electricity bills. The trick is to know when too much light transmission will result in too much heat and increase your cooling cost.

Experts suggest that sunlight ranging from 100 to 500 lux (the unit used to measure illuminance) is adequate for a room.

Similarly, good ventilation is crucial to keep the cooling bills down. For the same reason, maintain a low window- to- wall ratio.

This means that the number of windows in every room should be as few as possible. Says Vishal Garg, associate professor and head, Centre for IT in Building Sciences, IIIT, Hyderabad, "An ordinary window with an area of 1 sq m brings in about 850 watt of heat if it is exposed to direct sunlight.

This can be cut by 75 per cent by using shades, doubleglazed glass, etc." As windows account for 10- 25 per cent of your heating bills, these methods are very cost- effective in the long run.

The upfront cost of doubleglazed glass is steep, ranging from Rs 400- 800 per sq ft, but you can opt for cheaper alternatives like sun films or shades, though they aren't as aesthetic as glass.

Retrofitting apartments

Readymade homes do not have too many options for changes in architecture. As the shell cannot be torn apart, you must concentrate on energy conservation by using efficient equipment. However, little things do add up.

Intelligent equipment

For most people, energy- efficiency ends with buying a starrated air conditioner. "Refrigerators also have a high electricity intake as they are never switched off," says Garg. They can constitute up to 35 per cent of the total electricity consumption of your household depending on their capacity and your usage pattern.

So it is important that all appliances have a high star rating.

Fuel economy

Apart from the obvious, such as walking instead of driving to the neighbourhood market and car pooling, you can reduce fuel consumption by maintaining your car well and driving by rules.


 [tags dilbag koundal, IT Projects, ERP/SAP Consultant, Web designer, Pantnagar, Kangra, Weonlinecoders, Himachal News]