SQL Statement Fundamentals: The COUNT Function
Hello, hello, hello SQL fans! (Or gracious friends and family perusing the site. 🙂 ) The journey into learning SQL continues, and today we’ll cover the COUNT function. Jumping right into it, here’s our working definition of the SQL COUNT function: The COUNT function should return the number of input rows that match a […]
Getting Started with Amazon Alexa Development: Signing Up To Amazon Web Services (AWS)
Welcome back, folks, to our foray into Amazon Alexa Skill Development. If you’ve visited the blog recently, you’ll notice I’ve been juggling a few subjects for a minute, including SQL. For context, here’s our first article, starting Amazon Alexa skill development from the absolute beginning. (Following my haphazard skill development of Silly Marketing Strategies at […]
SQL Query Fundamentals: SELECT WHERE
Welcome back, travelers! The journey continues in learning SQL. In case you missed it, the past couple of posts were learning to use SELECT DISTINCT and Restoring an SQL database with table schema only. Today we’re going to learn about using the SELECT clause with the WHERE statement for essential SQL queries. A Quick Recap, […]
The SELECT Clause, SQL Statement Fundamentals
Getting Started in SQL Statement Fundamentals Howdy, all, welcome back to our journey learning SQL. This post will deal with basic SQL statements. In fact, most of these SQL statements should be applicable to most major types of SQL databases (MySQL, Oracle, and so forth.) The SELECT Statement (or Clause) First up, we’ll start with […]
Restoring a SQL Database with Table Schema Only in pgAdmin x PostgreSQL
Howdy! Welcome back to our shared journey of learning SQL. Last time, we learned about creating, deleting and completely restoring SQL databases in pgAdmin. Today, we’ll learn about how to restore a database, but only its table schema. Specifically, we’ll restore the table names and preferences for types of data within those tables. However, the […]
Creating, Restoring and Deleting SQL Databases with pgAdmin 4
Howdy! Let’s continue the journey into learning Structured Query Language (or SQL). Previously, I shared my notes on the absolute beginning point for starting SQL, and also getting started with PostgreSQl and pgAdmin. Now, we venture into some basics of database management via SQL: • Creating a database with pgAdmin • Restoring a database with […]
Starting SQL from the Absolute Beginning
What is this? To be honest, I haven’t done much blogging or writing lately. Life (read: work) happens, and it gets busy. However, I’m feeling invigorated with a strong desire to expand my horizons. One such manifestation (snooze, I know) of this is to learn a bunch of new things, for where technology and industry […]
How to Explain SEO in 5 Minutes
Today, you’re going to learn how to explain SEO to anyone in five minutes! Is it a comprehensive, end-all, be-all example? No. Will it help someone quickly understand the basics of a complex practice? Yes. Let’s jump in. This is, after all, a five minute guide! Starting Point: SEO is not a black box. For […]
Winning Long Term SEO for Years
A few years ago, the average CMO tenure was 23 months. Yikes. That’s barely long enough to get acquainted and jamming with your staff. Happily, a recent indicates a CMO’s average tenure now sits at 45 months. It’s no secret that personnel and vendors come and go with the executive. For agencies and in-house digital […]