Understanding SQL-1

Understanding SQL-1:       

• Data Types
• Creating Tables
• Creating a Table with data from Another table.
• Inserting Values into a Table
• Updating Column(s) of a Table
• Deleting Row(s) from a Table
• Dropping a Column
• Querying database tables.
• Conditional retrieval of rows
• Working with Null Values
• Matching a pattern from a table.
• ordering the result of a Query Aggregate Functions.
• Grouping the Result of a Query
• creation and deletion of Views
• Managing privileges with Grant and Revoke Command
• COMMIT and ROLLBACK
• Functions: 

1. Character Functions, 
2. Date Functions, 
3. Group Functions