On-Page SEO Checklist- Important On-page SEO Techniques

Include Meta tags in correct order:

  • Title Tag
  • Description Tag
  • Keywords Tag

The information composed inside of these tags are utilized to render the title, description and keywords in the SERPs, and what the user/searchers or visitors see.

Title tag

Title length should be approximately 55 characters including spaces.

Description tag

The Description length ought to be around 155 characters including spaces.

Keywords tag

Google has already stated that the keywords tag is not a consideration in ranking but we should always include this as an important element. Comma to be used as a separator between keywords.

Heading levels

In the body of your content, you always keep first heading as an <H1> and subsequent heading tags as <H2>, <H3>, <H4>, <H5> and <H6>, and be used in TOC (table of contents) page.

Minimum word count

Minimum 250 words are suggested. Additionally, avoid copy content and dependably utilize fresh and quality content, generally Google Panda Update punishing low-quality substance.

Missing "alt" attributes

Images ought to have relevant title and captions (you can utilize your keywords). Alt attributes are additionally an important component of SEO to validate your HTML code.

Proper url structure

Ensure that URL shouldn't contain underscores, question mark, ampersand, etc., these are alpha characters and do not isolate words. Always use hyphens to separate words within url.

Sitemap

Ensure your site has an HTML sitemap for client, and each page ought to connection to that sitemap. You ought to additionally have a XML sitemap you submit to web crawlers.

Anchor text

Use anchor text navigation for both internal and external link, not JavaScript or Flash navigation that spiders can't crawl. Internal links can help users or search engine understand the anchor link on your site.

Robots.txt file

Ensure that Robots.txt file exists, regardless of the possibility that there is no statement. The Robots.txt file tells the search engine spiders what to index and what not to index.

Keyword research

The competitive and best keyword research is an ongoing process that essentially never ends. It starts with extensive research and thought and it is most important part of SEO checklist.

Web analytics setup

Web analytics is utilized for measuring web traffic and enhance the viability of a site. Additionally this can be utilized as an apparatus for business and statistical research. You ought to have this legitimately setup and monitor them consistently to see whether the keywords that are generating traffic are in your keyword list as well your site is enhanced for them.

Link building (Inbound/Outbound)

Your inbound/outbound links ought to be a piece of an organic, ethical/natural in consistence with web index rules, and be checked repeatedly.

HTTP response code

Regularly check for crawl errors (i.e., 404 errors, 301 redirects) and other errors to ensure the best seo effort.

Static pages

Make sure your URL appears static instead of dynamic because dynamic URLs could be a problem. You can also use the Canonical tag within head tag. <link rel="canonical" href="http://www.url" />;

Hidden text or text within images

Don't use essential text in image as spiders can't see this, also don't rely much on images as visitors can't see your message if the images don't display.

Avoid black hat techniques

Ensure your SEO techniques are following Google Webmaster Guidelines and there is no duplicate content, hidden text or links, etc.

Google Webmaster Tools account

Set up Google Webmaster Tools (GWT) account that offers you to identify issues like crawl errors and penalties with your website and can even let you know if it has been infected with malware.

Crawl errors

If a page has a crawl error, it means Google is unable to crawl the page. It can be checked in the Crawl section of Google Webmaster Tool to troubleshoot.

Cracking Laravel Interviews

Today In this post I am login to share questions that helps you to cracl laravel framework Interview. 

Everyone loves to work in a reputated company. these days Laravel is quite more popular php framework. Most of companies are hiring laravel developer. If you are a PHP developer and looking to change Job and start your carrer as Laravel developer then this article is for you.

Here are Top 10 Laravel interview questions for beginers theta you must know.

So without wasting time in searching interview questions on web you can directly read it from above url. for starting I have list few important questions here.

  1. Explain what is Laravel
  2. How do I install Laravel, talk about the different ways?
  3. Explain what is MVC architecture?
  4. Describe Laravel Service Provider?
  5. Explain Laravel Service Container?
  6. What is a Facade?
  7. What is a Schema?
  8. What is a Job?
  9. What are Events in Laravel?
  10. What is an Observer in Laravel?
  11. What are Policies?
  12. What are helper functions and name 10 with their purposes?
  13. What is Method Spoofing?
  14. What is CSRF Protection in Laravel?
  15. How do I turn off CSRF Protection?
  16. What are Contracts?
  17. What are Collections?
  18. What are Model Factories?
  19. What are Route Parameters?
  20. What is a named route?
  21. What is the default session timeout duration and How can it be set?
  22. What are Accessors and Mutators in Eloquent and why should you use them?
  23. What is Attribute Casting and How does it work in Eloquent?
  24. How do I register a middleware?
  25. How do I register a Service Provider?
  26. How do I register an Artisan Command?
  27. How does the IOC (Inversion of Control) Container work?
  28. How do I use sub-domain routing?
  29. How do I make all of my forms Bootstrap opinionated?
  30. How do I setup localization for an application?

Comman DBMS Interview Questions

Are you looking to join an industry as a DBMS developer? Have you prepared yourself to face DBMS interview questions? If not, then dig into some technical insights for DBMS. Database management has become popular more than ever. A set of logically arranged data for a specific purpose is commonly known as Database. A collection of programs, which can be used to create and maintain a database is known as Database Management System or DBMS. It is basically a systematic way of executing a command with data.

If one is through with the basics, half the battle is won. The more the knowledge on the subject, the easier will it be to crack the DBMS interview questions. There is a vast list of questionnaire available on Google to help you gain confidence before facing the interview panel.

Read Best DBMS Interview Questions

1. What is DBMS?

DBMS (Database Management System) is a computer software application that allows users and other applications to view, monitor and analyze data. It is an application to handle data on various subjects.
 

2. Enlist various types of interactions created by DBMS?

There are various kinds of interactions supported by DBMS like-
  • Data definition
  • Update
  • Retrieval
  • Administration

3. What are different relationships existing in database?

A relationship in database is established when one table has a foreign key that references the primary key of another table. There are three relationships existing between database-
  • One-to-one– This simple relationship exists among two tables having same rows or columns.
  • One-to-many– Two tables connected by a foreign key and a primary key enjoys one-to-many relationship.
  • Many-to-many – It is a complex relationship in which many records in one table is connected to many records in another table.

4. What are different cursor types?

A database cursor enables traversal over the records in database. The different cursor types are-
  • Dynamic – it is highly subject to changes while scrolling the cursor in database.
  • Static – it doesn’t show any changes while scrolling. It also works on recording of snapshot.
  • Keyset – it enables the user to modify the data without displaying the new data.

5. List few restrictions that are imposed while creating views?

There are certain restrictions that are applied while creating views in database-
  • Only current database can have views. No other database is allowed to have views other than the current database.
  • You cannot make any changes in the computed values of any view.
  • You cannot apply full text index definitions.
  • Temporary views cannot be created and temporary tables cannot have views.
  • It is not associated with any default definitions.
  • There are integrity constants that define the working of commands such as insert and delete.
  • Triggers such as INSTEAD of is associated with views

6. What is join? Mention its types.

Join depicts the relationship between two or more tables. It combines row of different tables and enables you to select data with reference to data of some other table. There are several joins in database like CROSS JOINs, NATURAL JOINs, EQUI-JOIN, etc. Two most important joins are –

  • INNER JOIN – this join returns values that have matching record in both the tables. In this, blank rows are combined in middle.
  • OUTER JOIN– it returns all the records of left table. It also returns the values that match with the right table. Blank rows are put in specified side by joining tables in other side.

The above questionnaire for DBMS interviews comprises some basics and advanced level questions from the technical aspect. In the basic category, questions are asked regarding the definition and properties of a database, its advantages over the obsolete file processing system and disadvantages, E-R model, normalization, data definition language, data abstraction levels and so on. Being thorough with the subject can easily fetch you good remarks from the interviewer and will give you an edge over the others. Technical aspects also have advanced questions like interactions catered by the DBMS, extension and intension, system – R, etc., and even these are easy to answer. One may also check on integrity rules and different languages available in DBMS.