SQL

• What is database? 

• Create Database  

• Create Table  

• DESC Command  

• Show Databases/ Tables  

• Data Types  

• Insert into  

• Select Statement  

• Single quotes Problem  

• WHERE Clause with Equal Operator  

• SQL Statements and Rules  

• AND Operator  

• OR Operator  

• IN Operator  

• BETWEEN operator  

• LIKE Operator  

• UNION Operator  

• ORDER BY  

• UNIQUE KEY 

• PRIMARY KEY  

• FOREIGN KEY  

• Auto Increment  

• ALTER TABLE  

• JOINs 

  Books :

  Microsoft SQL Server 2008, Second Edition

  Beginning Sensor Networks with Arduino and Raspberry Pi (Technology in Action) by Charles Bell (Author)