How to Use SQL in SEO

If you talk to any search engine optimization specialist, they’ll surely tell you how many tools are used throughout their workday – from keyword research and backlinking to crawling and metric analysis tools. SEO is a world of its own with countless facets of information that need tweaking and examination constantly. It can quickly become overwhelming if you don’t have the right tools at your disposal. Or if you simply don’t understand how to make your job easier with SQL. 

(more…)

Medium Cross Post – Write Code to Write About Code

Any of you who read my blog posts here regularly know I am passionate about SQL, PHP, and Back-end Development. I consider writing an integral part of my brand and growth. Continue reading and learn more about what’s on my mind lately with writing and code…

(more…)

MySQL Count Weekday occurrences

Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE functions and the WITH clause…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]

MySQL COUNT() aggregate function – Medium cross post

I recently published a blog post over on Medium about the differences in 2 versions of the MySQL COUNT() aggregate function: COUNT(*) and COUNT(column_name or expression). I wanted to share the post here with any readers who may be interested so continue reading for more on this post…

[Keep reading for more SQL database and PHP/Python-centric content >>>]

WordPress Contact Form 7: Blog post compilation

Anyone with a website surely needs a reliable contact form to allow visitors and guests to reach out to them. If you are using WordPress, there are more options for contact form plugins than I could fill up in words here in this post. However, one of the more popular and easy-to-configure plugins is Contact Form 7. I recently wrote a couple of blog posts over on Medium detailing how to create a simple contact form using the Contact Form 7 plugin and want to share those posts here on my blog for readers who may be interested…

(more…)