Generated on October 21 2022 22:18 PM
Old data? UPDATE !
The score is 62/100
Title
PostgreSQL Tutorial - Learn PostgreSQL from Scratch
Length : 51
Great, your title tag's length is between 40 and 70 characters. Title tag length between 50 and 70 characters is optimal for SEO.
Description
Learn PostgreSQL quickly through a practical PostgreSQL tutorial designed for database administrators and application developers.
Length : 129
Great, your meta description tag's length is between 90 and 160 characters. A description tag of 155 to 160 characters is optimal.
Keywords
Not good (but low priority). We haven't found a meta keywords tag on your page. Use this free online meta tags generator to create a keywords tag.
Og Meta Properties
This page does not take advantage of Open Graph Properties. This tags allows social crawler's better structurize your page. Use this free og properties generator to create them.
Headings
H1 | H2 | H3 | H4 | H5 | H6 |
1 | 11 | 23 | 0 | 0 | 0 |
Images
We found 14 images on this web page.
12 image alt attributes were missing. Please add alt text to all images to help search engines better understand the content of your images.
Text/HTML Ratio
Ratio : 14%
This page's ratio of text to HTML code is below 20 percent, this means that your website probably needs more text content in order to do well in search engines. Note: This may also result from a false reading due to your server blocking external scripts from accessing the home page.
Flash
Perfect, no Flash content has been detected on this page.
Iframe
Awesome, there are no Iframes found on this page.
URL Rewrite
Good. Your links look SEO friendly and are easy to crawl!
Underscores in the URLs
Great! No underscores found in your URLs.
In-page links
We found a total of 123 links including 0 link(s) to files
Anchor | Type | Juice |
---|---|---|
Skip to content | Internal | Passing Juice |
- | Internal | Passing Juice |
Home | Internal | Passing Juice |
Getting Started | Internal | Passing Juice |
Views | Internal | Passing Juice |
Indexes | Internal | Passing Juice |
Triggers | Internal | Passing Juice |
PL/pgSQL | Internal | Passing Juice |
Aggregate Functions | Internal | Passing Juice |
Window Functions | Internal | Passing Juice |
Date Functions | Internal | Passing Juice |
String Functions | Internal | Passing Juice |
Math Functions | Internal | Passing Juice |
PostgreSQL PHP | Internal | Passing Juice |
PostgreSQL Python | Internal | Passing Juice |
PostgreSQL JDBC | Internal | Passing Juice |
Administration | Internal | Passing Juice |
Select | Internal | Passing Juice |
Column aliases | Internal | Passing Juice |
Order By | Internal | Passing Juice |
Select Distinct | Internal | Passing Juice |
Where | Internal | Passing Juice |
Limit | Internal | Passing Juice |
Fetch | Internal | Passing Juice |
In | Internal | Passing Juice |
Between | Internal | Passing Juice |
Like | Internal | Passing Juice |
Is Null | Internal | Passing Juice |
Joins | Internal | Passing Juice |
Table aliases | Internal | Passing Juice |
Inner Join | Internal | Passing Juice |
Left Join | Internal | Passing Juice |
Self-join | Internal | Passing Juice |
Full Outer Join | Internal | Passing Juice |
Cross Join | Internal | Passing Juice |
Natural Join | Internal | Passing Juice |
Group By | Internal | Passing Juice |
Having | Internal | Passing Juice |
Union | Internal | Passing Juice |
Intersect | Internal | Passing Juice |
Except | Internal | Passing Juice |
Grouping Sets | Internal | Passing Juice |
Cube | Internal | Passing Juice |
Rollup | Internal | Passing Juice |
Subquery | Internal | Passing Juice |
ANY | Internal | Passing Juice |
ALL | Internal | Passing Juice |
EXISTS | Internal | Passing Juice |
PostgreSQL CTE | Internal | Passing Juice |
Recursive query using CTEs | Internal | Passing Juice |
Insert | Internal | Passing Juice |
Insert multiple rows | Internal | Passing Juice |
Update | Internal | Passing Juice |
Update join | Internal | Passing Juice |
Delete | Internal | Passing Juice |
Upsert | Internal | Passing Juice |
PostgreSQL Transactions | Internal | Passing Juice |
Import CSV file into Table | Internal | Passing Juice |
Export PostgreSQL Table to CSV file | Internal | Passing Juice |
Data types | Internal | Passing Juice |
Create a table | Internal | Passing Juice |
Select Into | Internal | Passing Juice |
Create table as | Internal | Passing Juice |
Auto-increment | Internal | Passing Juice |
Sequences | Internal | Passing Juice |
Identity column | Internal | Passing Juice |
Alter table | Internal | Passing Juice |
Rename table | Internal | Passing Juice |
Add column | Internal | Passing Juice |
Drop column | Internal | Passing Juice |
Change column data type | Internal | Passing Juice |
Rename column | Internal | Passing Juice |
Drop table | Internal | Passing Juice |
Truncate table | Internal | Passing Juice |
Temporary table | Internal | Passing Juice |
Copy a table | Internal | Passing Juice |
Primary key | Internal | Passing Juice |
Foreign key | Internal | Passing Juice |
CHECK constraint | Internal | Passing Juice |
UNIQUE constraint | Internal | Passing Juice |
NOT NULL constraint | Internal | Passing Juice |
Boolean | Internal | Passing Juice |
CHAR, VARCHAR and TEXT | Internal | Passing Juice |
NUMERIC | Internal | Passing Juice |
Integer | Internal | Passing Juice |
DATE | Internal | Passing Juice |
Timestamp | Internal | Passing Juice |
Interval | Internal | Passing Juice |
TIME | Internal | Passing Juice |
UUID | Internal | Passing Juice |
Array | Internal | Passing Juice |
hstore | Internal | Passing Juice |
JSON | Internal | Passing Juice |
User-defined data types | Internal | Passing Juice |
psql commands | Internal | Passing Juice |
How to compare two tables | Internal | Passing Juice |
How to delete duplicate rows in PostgreSQL | Internal | Passing Juice |
How to generate a random number in a range | Internal | Passing Juice |
EXPLAIN statement | Internal | Passing Juice |
PostgreSQL vs. MySQL | Internal | Passing Juice |
What is PostgreSQL? | Internal | Passing Juice |
PostgreSQL Sample Database | Internal | Passing Juice |
Install PostgreSQL on Windows | Internal | Passing Juice |
Connect to Database | Internal | Passing Juice |
Load Sample Database | Internal | Passing Juice |
Install PostgreSQL on macOS | Internal | Passing Juice |
Install PostgreSQL on Linux | Internal | Passing Juice |
RIGHT JOIN | Internal | Passing Juice |
DELETE Join | Internal | Passing Juice |
CASE | Internal | Passing Juice |
COALESCE | Internal | Passing Juice |
NULLIF | Internal | Passing Juice |
CAST | Internal | Passing Juice |
PostgreSQL Exception | Internal | Passing Juice |
PL/pgSQL Continue | Internal | Passing Juice |
PL/pgSQL Exit Statement | Internal | Passing Juice |
PostgreSQL Python: Call PostgreSQL Functions | Internal | Passing Juice |
Donation ❤️ | Internal | Passing Juice |
PostgreSQL Cheat Sheet | Internal | Passing Juice |
Resources | Internal | Passing Juice |
About Us | Internal | Passing Juice |
Contact Us | Internal | Passing Juice |
Privacy Policy | Internal | Passing Juice |
Keywords Consistency
Keyword | Content | Title | Keywords | Description | Headings |
---|---|---|---|---|---|
postgresql | 72 | ||||
table | 56 | ||||
how | 50 | ||||
data | 43 | ||||
section | 22 |
Url
Domain : postgresqltutorial.com
Length : 22
Favicon
Great, your website has a favicon.
Printability
Great. We have found a Print-Friendly CSS.
Language
Good. Your declared language is en.
Dublin Core
This page does not take advantage of Dublin Core.
Doctype
HTML 5
Encoding
Great. Your declared charset is UTF-8.
W3C Validity
Errors : 19
Warnings : 10
Email Privacy
Great no email address was found in plain text!
Deprecated HTML
Great! We haven't found deprecated HTML tags in your HTML.
Speed Tips
Excellent, your website doesn't use nested tables. | |
Not great, your website is using inline styles. This is not optimal. | |
Great, your website has few CSS files. | |
Perfect, your website has few JavaScript files. | |
Awesome, your website takes advantage of GZIP compression for SEO optimization. |
Mobile Optimization
Apple Icon | |
Meta Viewport Tag | |
Flash content |
XML Sitemap
Great, your website has an XML sitemap.
https://www.postgresqltutorial.com/sitemap_index.xml |
Robots.txt
http://postgresqltutorial.com/robots.txt
Great, your website has a robots.txt file.
Analytics
Great, your website uses an analytics script.
Google Analytics |
Website Review is a free SEO site review and rating tool. Get a free review of your site and see areas that may need optimization.