ORDER BY Clause: SQL Statement Fundamentals
Welcome back to our SQL learning journey! It’s been a week and a half since my last post on using LIMIT. Work got crazy and I got the flu! 🙁 But we’re back in action. Today, we’ll delving deeper into SQL statements in PostgreSQL: ORDER BY. Let’s jump in. Why would you need a statement […]
SQL Statement Fundamentals: The LIMIT Statement
[av_section min_height=” min_height_px=’500px’ padding=’default’ shadow=’no-shadow’ bottom_border=’no-border-styling’ bottom_border_diagonal_color=’#333333′ bottom_border_diagonal_direction=’scroll’ bottom_border_style=’scroll’ scroll_down=” id=” color=’main_color’ custom_bg=” src=” attach=’scroll’ position=’top left’ repeat=’no-repeat’ video=” video_ratio=’16:9′ video_mobile_disabled=” overlay_enable=” overlay_opacity=’0.5′ overlay_color=” overlay_pattern=” overlay_custom_pattern=”] [av_image src=’http://www.zldoty.com/wp-content/uploads/2017/02/DSC_0265-1500×430.jpg’ attachment=’941′ attachment_size=’featured’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image] [/av_section][av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ padding=’0px’ border=” border_color=” radius=’0px’ background_color=” src=” […]
Getting Started with Alexa Development 02: Signing Up to Alexa Development Portal
Welcome back to our journey in learning how to program Amazon Alexa Skills via Echo voice search. In the previous article, we walked through the process of setting up an Amazon Web Services (AWS) account. Today, we’ll set up an account at the Alexa Development portal, a distinct entity from the AWS portal. Without […]
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, […]
Using the SQL SELECT clause with the DISTINCT Keyword
Introducing the SELECT DISTINCT SQL Statement Alright, welcome back to our journey with SQL! If you’re just tuning in, we: Started SQL from the absolute beginning Got up and running with PostgreSQL and pgAdmin Created, restored and deleted/dropped SQL databases Restored databases with table schema only Used the SELECT clause as our “Hello World!” for […]
The Absolute Beginning for Amazon Alexa Voice Skill Development
An Introduction to this Alexa Learning Journey So if you’ve visited my site at all in the past, you’ll notice this is the most blogging I’ve done in…ever? Put another way, a significant confluence of factors has dialed up my motivation to doggedly pursue learning and growth. So, here we are at learning Alexa skills! […]
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 […]