Summary 📝

Structured Query Language (SQL) is used to search and retrieve data from a database. 

The SELECT command is the most common way to do this. It allows you to choose which fields (columns) you want to see and which records (rows) should be shown. 

You can also use WHERE to filter the results based on conditions. For example, you can search for students with a particular grade or products that cost more than a certain amount. 

SQL lets you sort the results using ORDER BY and even rename columns with AS. These tools help you get exactly the data you need in an efficient way, which is important when working with large amounts of information. 

Key Learning Points 📌

• SQL is used to search for specific data from a database.
  
  

• The SELECT command shows chosen fields (columns).
  
  

• FROM shows which table the data is coming from.
  
  

• WHERE filters records based on a condition (e.g., age > 16).
  
  

• ORDER BY sorts results (e.g., alphabetically or by number).
  
  

• You can use AS to rename a field in the results.
  
  

• Conditions can use symbols like =, <, >, AND, OR.
  
  

• Searches help find useful data from large tables quickly.