SQL Tutorial for Data Analysis 4: Basic SELECT Statements

In this SQL Tutorial we're going to learn how to issue basic SELECT statements. We’ll start with a quick introduction to the ACDB database, the database which we will use throughout this course.
Next we’ll learn how to retrieve all the data from a specific table, and how to select specific columns. Toward the end of this lesson, I'll provide some general guidelines.

Key Concepts to Remember -
* The SELECT clause Lets you choose what columns to display.
* The asterisk sign (*) indicates that you want to retrieve all data from all
columns. Instead of *, you can indicate which exact columns you want to retrieve.
* The FROM clause: Allows you to specify from which table you want to retrieve all of these information.
* The SELECT and FROM clauses are mandatory
* Write Your queries in a readable form.

Course Examples -

ACDB Database -

Written SQL tutorials including exercises -

About Myself -

My Linkedin Page -

My Facebook Page -

SQL Platform Differences (comparing MySQL & Oracle)
* Syntax covered in this lesson stays exactly the same on MySQL & Oracle

[bjaka]

In order to download ACDB Database, should I register and pay?