What is Seo Consulting?

SEO as an industry is growing increasingly important today. Owes its success and growth of qualified SEO consultants. The main aim of SEO or search engine optimization is a more effective use of the Internet. SEO is not something to learn and be taught korkuclacak issue.

In brief seo seo consulting firms to transfer knowledge and experiences and, if requested to do some improvement work.
A good SEO consultant will follow its own in the latest updates. Fine have references. Do not will not keep promises. SEO consulting is available, however, as bad as all the other specialties. Yet the industry is a new and frequently updated certification and otoriteleşmesi incomplete.

For example, in 2005 with seo consulting seo consultancy of 2011 is different. In this process, facebook, twitter and many web 2.0 seo field have been included in the item.

SEO consultant to do the first issue. Information resources to identify and track them firmly. These sources are official announcements of the search engines for the area, letters and görsellerdir çıkardıkları trusted sites. To understand what is unreliable, reliable, what you do not need a graduate of Harvard. You can determine for yourself the reliability of a human approach.

Another issue is the choice of the customer. Good SEO consultants prefer to work with clients informed is easier for them because the agreement.

There are some signs that determine seo consultant. For example, Google adwords certification, web sites, whether it has programming knowledge, tecrübesel age in that area, observation skills and the availability of other, as with everything and not have some virtues. Work discipline, hard work, communication skills and so on.

Seo consultant to be a matter of a process. Just wait for the time, such as a piece of fruit ripening. Webmaster site is probably the most information in the most orderly manner sitelerdendir hosts. Taking advantage of one of us to become a good SEO consultant can achieve many benefits.

What are the stages of how to seo ?

1) to learn about the aims and demands:

Learn and make a note of requests on this subject, talk to a good contact. We always try for the purpose of SEO outsourcer. Sometimes people do not know SEO to be misleading. Targets established by the minds of the customer’s words and not really a need. For example, “pet” call 1 an online shop that sells pet supplies instead of going for the “pet supplies” call 1 exit may be more important.

2) Describe what you can.

Only instead of organic SEO (PPC or adwords) Tell seosundan. Always Deliver 2 choices. One of the other natural seo artificial. There are both advantages disadvantages.

3) Collect information from the Internet.

Calls directed to gather information, measure the current competition.
4) Decide on a good domain name.

Sometimes SEO is so bad that the name of the desired site may be considered a new domain name registration başlanmak. Especially in a highly competitive and the quality of sektörse domain name is much more to the fore.

5) Stable (Stable and fast broadband that) and work with a hosting company, run it.

Sometimes, seo, bad experiences with the contaminated host. Large projects for at least a VPS or dedicated environment to carry seolarını persuade.

6) Provide the maximum level to obtain the static and the original content.

Content is king, we understand this, we know. However, by providing seo job information may be incomplete in that direction.

7) The original design and use a script.

Es exceed the quality and continuity of the available software in the name of this stage at least once a check, the problem is. Do not make a seo company that uses the script itself is illegal.

Technical details of some of the other

8) To prepare the Robots.txt. (In accordance with the definition of Seo)
9) Sitemap prepare.
10) to introduce part of the robots.txt and sitemap to your Google Webmaster Tools.
11) Enter the Google webmaster tools to make the necessary settings and controls. (See definitely see how the site to google)
12) Google analytics code, or add a counter and track visitors.
13) To carry out studies in site performance, h1, h2, div tags, control, içlink external link counts, page color, if necessary, correct, amend, a contact page to set up, do surveys. Visitors leave satisfied, and all of them collect information from visitors to the new page is to make internal and external regulations.
14) Competitor sites to examine, understand and acquire links from quality directories, including dmoz.org first to add our site.
15) Regularly check and report on the results that you obtained.
16) Keep track of developments.

Israel Arabs hacker shock!

Group-XP claimed alliance with the Saudi’s and the Anonymous hacker group, Israel’s leading sports sites One.co.il ‘i hack’leyerek captured data. Personal information of 400,000 people, addresses, phone numbers, identification numbers and credit card information söylüyorlor seized …

But the Israeli Bank Hapoalim bank, said in a statement, the attack is much lower this number of people affected by the current card numbers around 14,000, he said. Been done in some card information stolen from the internet shopping has been detected, but the bank says that this amount is very small, other users can not take responsibility of all the cards have been canceled, and the purchases announced.

Group, “What is fun for us? 400,000 people in front of banks to collect and monitor them to complain about playing this card. 400,000 Israeli banks to allocate credit card pieces and make new ones to watch. Israel’s credit cards, credit cards, just as Nigeria’s distrust of all people, to show to the world “he said. And now the millions of social security numbers of Israelis are enrolled in Pastebay’i hack’leyeceklerini and share their data, he said.


PHP 4 version of the mysql commands and short descriptions

PHP 4 version of MySQL, and short descriptions of all commands that can be used for communication.
The number of rows affected by a previous transaction.

Closes the specified mysql connection.

Opens a database connection to the server.

Opens in MySQL database.

The result is the order line.

Sends the query to MySQL.

Deletes the database server.

MySQL gives the error number in the previous process.

MySQL gives the error message, the previous process.

The results of the array variable is.

As a result, the table is the name of the object.

The result is the length of the array variable table.

Gets a result row as an object.

Variable table, you get a result.

The result of the name of the table gives the result table.

Index that takes place as a result table.

The domain name of the table gives the result.

The resulting field indicates what type.

The resulting space is defined which specifies the type of extra parameters.

Field gives the length of the resulting database.

Frees the memory assigned to the results.

Returns the value of the automated data placement to the previous data.

The resulting lists of all the table fields.

Lists all the databases on the server.

Lists all the tables in the database.

The resulting field gives the number.

Returns the number of rows in result.

Defines a permanent connection to the server.

Sends the query to the database.

The results of the query are returned.

Select from the server database.

To belong to the given name of the table gives the area.

Database Created

Database_ismi CREATE DATABASE;


Created in the database table

CREATE TABLE database_ismi;


Adding Data to SQL in the command

INSERT INTO table_name VALUES (‘Data1’, ‘veri2’, ‘veri3’,…..);

Crafts table command to add a new profession

EX: INSERT INTO jobs VALUES (’11 ‘,’ Teacher ‘, ’12’, ’20 ‘);

eg: INSERT INTO Students VALUES (23, ‘Length’, ‘GULER’);

Getting Data from the table command (list command)

SELECT kolon1, kolon2, kolon3 colony …. FROM table_name;
SELECT * FROM table_name (to take all);

eg: SELECT id, kayitno FROM Students;

eg: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM professions;

eg: SELECT name, surname, address FROM staff;

Ranking of the captured data from a table

ORDER BY domain, ASC; (ASC)
Domain, an ORDER BY DESC; (DESC)

EX: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM jobs ORDER BY ASC meslekismi;
EX: SELECT id, meslekno, meslekismi, girissaati, cikissaati FROM jobs ORDER BY DESC meslekismi;

Dates of birth of the same name, last name, sorted according to the shape of a data
eg: SELECT id, name, last name, dtarihi DTARİH FROM staff ORDER BY DESC, name, surname, ASC;

Any SQL command that operate according to a Contingent (Required Instruction)

WHERE condition şart_alanı şart_ifadesi (=,<,>)

eg: SELECT id, name, last name, dtarihi FROM staff WHERE name = ‘bob’;
eg: SELECT id, name, last name, dtarihi FROM staff WHERE dtarihi <’01 .01.1967 ‘ORDER BY DESC BASE;


id name salary meslekid meslekadi address Sayad dtarihi Dyer

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer Dyer FROM WHERE costs plus = ‘London’;

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus> 300 ORDER BY salary DESC;

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer Dyer FROM WHERE costs plus = ‘London’ AND meslekadi = ‘doctor’ ORDER BY NAME ASC;

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus <250 OR meslekadi = ‘servant’ ORDER BY NAME ASC;

Between the two Vari Processing Command

bakilacak_alan BETWEEN value1 AND value2

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE salary costs plus BETWEEN 200 AND 300 ORDER BY NAME, LASTNAME DESC;

eg: SELECT id, name, Sayad, dtarihi, salaries, meslekid, meslekadi the address s, Dyer FROM WHERE costs plus dtarihi BETWEEN ’06 .05.1989 ‘AND ’01 .01.2000’;


bakilacak_alan IN (value1, value2, …., the value of value)

teknikservis IT purchase accounting

eg: SELECT * FROM WHERE meslekadi costs plus IN (‘IT’, ‘accounting’, ‘purchase’, ‘teknkservi s’)

eg: SELECT * FROM WHERE costs plus meslekadi = ‘IT’ OR meslekadi = ‘accounting’ OR meslekadi = ‘purchase’ OR meslekadi = ‘teknkservis’;

Search within the command

LIKE bakilacak_alan bakilacak_deger note (not important where the bay%)

eg: SELECT * FROM WHERE ıcretler address LIKE ‘% host%’

eg: SELECT * FROM WHERE ıcretler address LIKE ‘% Turkey’

Relational Tables


id, name, surname, address, birthplace, sicilno, isebaslama, with sex, medenidurumu, dtarih

costs plus
id, per_sicil_no, aylikucret, sigortaprimi, yemekyardi, yakityardimi


eg: SELECT name, surname, aylikucret FROM staff, fees WHERE sicilno = per_sicil_no;

eg: SELECT name, last name, salary FROM staff, fees sicilno = per_sicil_no AND WHERE Birthplace = ‘London’ AND address LIKE ‘% istanbul’;
ie: more than 300 salary and insurance of the underlying

SELECT name, surname, sigortapirimi FROM staff, fees AND WHERE per_sicil_no aylikucret sicilno => 300 AND sigortaprimi> 0;
eg: for 15 years, the employee’s salary under 200 YTL firstname.lastname yenimahallede based staff, and address lists pprogram

SELECT name, surname, address FROM staff, fees sicilno = per_sicil_no AND WHERE aylikucret <200 AND address LIKE ‘% host%’ AND isebaslama BETWEEN (’07 .05.1991 ‘AND ’06 .05.1992’);

EX: NAME AND E accounting and computing unmarried women 30 years of age working in any of buying a small salary that more than 100 YTL

SELECT * FROM staff, fees
WHERE sicilno = per_sicil_no
AND meslekadi = ‘accounting’ OR meslekadi = ‘IT’ OR meslekadi = ‘purchase’
AND name LIKE ‘E%’ AND sex = ‘Sex’
AND medenidurumu = ‘single’
AND dtarih> ’01 .011977 ‘
AND aylikucret> 100;

Data Delete command from the table

DELETE FROM table_name WHERE condition

DELETE FROM wages, staff WHERE AND aylikucret per_sicil_no sicilno = <100;

eg registration number 123 that deletes the record from the database program

DELETE FROM wages, staff WHERE per_sicil_no = ‘123 ‘AND sicilno = ‘123’;

Data update command

UPDATE table_name SET value1 = domain1, domain2 = value2 … FieldName = value;

A neighborhood W of the street address of 123 registration number of the personnel of Ankara Yenimahalle

UPDATE staff SET address = ‘A street Yenimahalle Ankara neighborhood W’ WHERE sicilno = ‘123 ‘;

Costs plus aylikucret * UPDATE SET aylikucret = 1.2;

UPDATE wages, staff SET ylikucret = aylikucret-100 WHERE meslekadi = ‘IT’ AND sicilno = per_sicil_no;

Grouping Commands

The largest command:

SELECT MAX (field_name) FROM table_name

the maximum salary of the staff:
SELECT MAX (aylikucret) FROM costs plus

ie, the more fuel-assistance program, showing the salary of the staff and the registration number

SELECT aylikucret, per_sicil_no, MAX (yakityardimi) FROM costs plus


SELECT MIN (field_name) FROM table_name


SELECT SUM (field_name) FROM table_name

the total fuel subsidy:
SELECT SUM (yakityardimi) FROM Fees;

Average command:

SELECT AVG (field_name) FROM table_name

SELECT AVG (aylikucret) FROM wages, staff WHERE meslekadi = ‘IT’;
SELECT AVG (yakiyyardimi) FROM wages, staff WHERE meslekadi = ‘accounting’ AND gender = ‘Female’;


SELECT COUNT (*) FROM table_name



SELECT COUNT (Distict field_name) FROM table_name

There are many different family group working with us

SELECT COUNT (Distict Sayad) FROM staff

Our company has several different departments.

SELECT COUNT (Distict meslekadi) FROM staff

Doğru Facebook Zaman Tüneli Kapak Fotoğraf Boyutu seçin

Yeni Facebook Timeline kapak fotoğraf boyutu × 315 (850px genişliğinde ve 315px yükseklik) ve birçok ücretsiz duvar kağıdı siteleri Facebook kullanıcıları seçmek için teşvik olarak bu yeni Facebook Kapak resmi boyutu boyutu, web üzerindeki 850x315px Facebook duvar kağıtları yeni bir çılgınlığı başlattı 850 IS Facebook kapak resmi.

zaman çizelgesi kapak fotoğrafı
Facebook Timeline Kapak Fotoğraf Boyutu

Facebook Timeline şu anda etkinleştirmek ve Facebook sayfasında bir başlık görüntüsü gibi görür ve yaşamı, ya da olaylar hakkında eşsiz bir görüntü sergilemek için büyük bir 850px geniş görüntü kullanmak için büyük bir fırsat, yeni bir kapak fotoğrafı elde edebilirsiniz.

zaman çizelgesi kapak fotoğrafı

Kapak Resmi boyutu nedir?
850px genişliğinde ve 315px yüksekliği tam boyutu ile mükemmel uyum doldurmak yüksek çözünürlüklü bir görüntü yüklemek için iyi bir fikir.

Kapak Fotoğrafı minimum genişlik nedir?
Resmi Facebook SSS kapak resmi, en az 720 piksel genişliğinde olması gerektiğini söyledi. Küçük görüntüleri yükleme hataları alırsınız. Ben küçük bir görüntü yüklemek için çalıştım ve en azından 399px geniş kapak fotoğrafı yüklemek için bir mesaj var. (Akşam yemeği ve yerleştirilmesine) görüntüleri 399px geniş ve üzeri yükleme başardı. Herhangi bir görüntü yüksekliği, öyle görünüyor ki kabul edilir.

Fotoğraf kapağı boyutu

Ne başka bir boyutta kapak fotoğrafı kullanırsam ne olur?
Öncelikle Facebook Kapak fotoğrafları aşağıda izin boyutu yükleme Kapak Fotoğrafı kabul edilmeyecektir. Başka bir boyutta yüklerseniz, Facebook neredeyse distored ve pikselli yapacak görüntü kırpma / yeniden boyutlandırmak için zorunlu olacak. Tam boyutunu yükleyin.

Kapak Fotoğrafı kırpma / düzenleyebilir miyim?
Facebook, sadece daha büyük bir resim upload eğer Kapak resmi yeniden konumlandırmak için izin verecektir. En büyük görüntüler için, bu, 850 × 315 sabit boyutta ilgi alanı olsun kadar aşağı yukarı ve hareketli görüntüler gibi daha fazla işe yarayacaktır. Sonra sizin Facebook Kapak kaydedebilirsiniz.

Diğer insanların Kapak Resimleri kaydedebilir miyim?
Bu görüntü, kamu kullanımı için görünür ve kaydedilebilir. Önemli olan bu sanal bir ürün gibi olduğunu, insanların, sağ tıklayın ve Facebook kapak kaydetmek için karar verirseniz, onlar tam uncropped görüntü kazandıracak. örneğin Kendini büyük bir tam boyutlu fotoğraf yüklemek ve daha sonra kapak fotoğrafı olarak baş yapmaya karar, görüntüyü kaydederken insanların tam bir resim görebilirsiniz. Yani tam boyutunu yüklemek için iyi bir fikri.

Tüm bunları görmek mümkün olacak gibi bütün kapak resimleri kamu unutmayın, bu yüzden akıllıca seçin.