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
На этой странице сайта вы можете посмотреть видео онлайн SQL Tutorial for Data Analysis 4: Basic SELECT Statements длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Ram Kedem 06 Сентябрь 2020, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 1,495 раз и оно понравилось 9 зрителям. Приятного просмотра!
