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 -
https://ramkedem.com/en/sql-basics-ex...
ACDB Database -
https://ramkedem.com/en/acdb-sample-d...
Written SQL tutorials including exercises -
http://ramkedem.com/en/sql-server/
About Myself -
https://ramkedem.com/en/about/
My Linkedin Page -
/ ram-kedem-a5b4b33b
My Facebook Page -
/ ramkedemfeed
SQL Platform Differences (comparing MySQL & Oracle)
Syntax covered in this lesson stays exactly the same on MySQL & Oracle
On this page of the site you can watch the video online SQL Tutorial for Data Analysis 4: Basic SELECT Statements with a duration of hours minute second in good quality, which was uploaded by the user Ram Kedem 06 September 2020, share the link with friends and acquaintances, this video has already been watched 1,495 times on youtube and it was liked by 9 viewers. Enjoy your viewing!
