Author: admin
-
Build links to your website.
Once you signal relevancy to search engines via your keywords, it’s time for the hard work to start: building inbound links to your website from authoritative sites in your industry or niche. This is arguably one of the most important SEO steps you have to take. The number and quality of links pointing to your website are…
-
Use keywords in the page’s content.
Using your target keywords in your content is an essential part of your on-page SEO strategy. Why? Because doing that signals to search engines that the page is actually about the keyword and should show up in search results. I have heard from “experts” that you should use your keyword anywhere from 4-6 times to 10-12…
-
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 other 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. Here’s an example from a local…
-
Put keywords in your meta description.
Your page’s meta description can further tell search engines and users what your page is about. While metadata is not nearly as important as it used to be, it still counts. Take advantage 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…
-
Put keywords in the page URL.
Google and other search engines also use the text of the URL of the page to determine the content of the web page. You should use your keyword or phrase specifically in the slug. Image Source Don’t overdo it, though. If you sell coffee, for instance, don’t create a slug as follows: mycoffeecompany.com/coffee-atlanta-near-me-fulton-county-greater-atlanta-area-coffee Keep it short,…
-
Put keywords in the page title.
Once you’ve chosen a keyword, it’s time to put it into action. First up, you want to put in your web page’s 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. It’s what appears on top of your web…
-
Find keywords
Keyword research is as simple as picking a list of words and phrases relevant to your business. Think about which words are most likely to get people to do what you want them to do (visit your website and submit a form) and focus on those words. You can use a dedicated keyword research tool, but as…
-
PostgreSQL CASE Expression
CASE The CASE expression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). Once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSE clause. If there is no ELSE part and no conditions are true, it returns NULL.…
-
PostgreSQL ALL Operator
ALL The ALL operator: ALL means that the condition will be true only if the operation is true for all values in the range. Example List the products if ALL the records in the order_details with quantity larger than 10. Note: This will of course return FALSE because the quantity column has many different values (not only the value…
-
PostgreSQL HAVING Clause
HAVING The HAVING clause was added to SQL because the WHERE clause cannot be used with aggregate functions. Aggregate functions are often used with GROUP BY clauses, and by adding HAVING we can write condition like we do with WHERE clauses. Example List only countries that are represented more than 5 times: Run Example » More HAVING Examples The following SQL statement lists only orders…