SQL for Beginners
SQL (Structured Query Language)
- It is high level language which provide you capability to query data from any structured data source (Tables).
- High level language means language which is used by us to communicate (English).
- For learning, we will be using online SQL editor provided by W3C.
- http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
SQL script:
SQL Queries:
Using Wild Card (*) :
Selecting all data
SELECT * FROM CUSTOMERS
Specific Columns:
SELECT CustomerName, ContactName,Address,
City FROM CUSTOMERS
Click to continue