Search engine optimization (SEO)

         

On Page Optimization

On-Page SEO refers to how Good your website’s content is presented to search engines. On page optimization involves ensuring whether a particular webpage is structured in a manner so that it gets found by the search engines for given keywords and key phrases. It not only helps in getting good search engine ranking but also increases overall readability of the site. The Good part is that not much has changed about the on-page optimization approach. It can still be improved immediately by tweaking incorrect elements on a webpage.

There 5 key elements of a successful on page optimization

Off Page Optimization

 Off-Page SEO refers to your website’s overall “authority” on the web determined by what other websites say about your site. Off-page optimization is a long-term process and takes time to improve. Simply put, off page is all about your online reputation. Off page optimization includes acquiring backlinks to your page from the authority sites in your niche. Backlinks is the currency of any off-page strategy. And, unlike on-page optimization, off-page optimization efforts are not apparently visible on the webpage itself; it does the background work for a better search result.

Search Engine Optimization

SEO is short for search engine optimization. Search engine optimization is a methodology of strategies, techniques and tactics used to increase the amount of visitors to a website by obtaining a high-ranking placement in the search results page of a search engine (SERP) -- including Google, Bing, Yahoo and other search engines

 

 White Hat SEO

In search engine optimization (SEO) terminology, white hat SEO refers to the usage of optimization strategies, techniques and tactics that focus on a human audience opposed to search engines and completely follows search engine rules and policies.
For example, a website that is optimized for search engines, yet focuses on relevancy and organic ranking is considered to be optimized using White Hat SEO practices. Some examples of White Hat SEO techniques include using keywords and keyword analysis, backlinking, link building to improve link popularity, and writing content for human readers.
White Hat SEO is more frequently used by those who intend to make a long-term investment on their website. Also called Ethical SEO

 Black hat SEO

In search engine optimization (SEO) terminology, black hat SEO refers to the use of aggressive SEO strategies, techniques and tactics that focus only on search engines and not a human audience, and usually does not obey search engines guidelines.
Some examples of black hat SEO techniques include keyword stuffing, invisible text, doorway pages, adding unrelated keywords to the page content or page swapping

Overview of SQL

SQL is a standard language for accessing and manipulating databases.

---

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

SQL is just a query language, it is not a database. To perform SQL queries, you need to install any database for example Oracle, MySQL, MongoDB, PostGre SQL, SQL Server, DB2 etc.

SQL DATABASE

SQL CREATE, DROP and RENAME DATABASE

SQL TABLE

SQL CREATE, DROP, DELETE, RENAME, TRUNCATE and COPY TABLE

SQL SELECT

SQL SELECT statement with UNIQUE, DISTINCT, AS and IN keywords and first(), last(), top(), sum(), random() and count() functions.

SQL INSERT

SQL INSERT INTO, INSERT SELECT and INSERT multiple rows.

SQL UPDATE

SQL UPDATE statement, update with JOIN and update DATE.

SQL DELETE

SQL DELETE TABLE, DELETE One Row, DELETE all rows, DELETE VIEW, DELETE database, DELETE duplicate rows and DELETE with INNER JOIN

 

Most important aspect of SQL : SQL Joins

Want to know the differnces between HTML & CSS here is the difference