Basic SQL SELECT

Using SQL (Structured Query Language) to select data from a database

Created by: Eric Manske
Collector and Curator of Knowledge

What Will I Learn?

• Understand the logic of databases and succeed at pulling data from them
• Be able to answer the question, "What is SQL?" with a few different answers
• Know the basics of the six standard SQL SELECT statement clauses
• Understand a couple different ways to pull together data from more than one data set
• Construct well-formed SQL SELECT statements that allow others (and you in the future) to understand, at a glance, the business request
• Know how to pursue further SQL instruction and how to research your SQL questions

Requirements

• No SQL experience needed
• Access to a tool to execute SQL statements may be helpful

Target audience

• Anyone who has heard of SQL and wants to know a bit about what it is
• Businesspeople who have been given SQL statements and want to know more about what they have been given
• Beginners with SQL (all platforms)