SQL

SQL understands fields that are in tables and how to find the data in the tables based on the contents of the fields. All SQL operations are then one of four general things you do to tables. Create: putting data into tables, Read query: data out of a table, Update change: data are already in a table, Delete: remove data from the table .this has been given acronym “CRUD” and is considered a fundamental set of features every data storage system must have.

SQL is concept driven, once understood it lasts for ages. To put it in the lucid way it works like Spreadsheet in Excel, but it has different functions and usage.

• Introduction to SQL
• Retrieving Data
• Updating Data
• Inserting Data
• Deleting Data
• Sorting and Filtering Data
• Advanced Filtering
• Summarizing Data
• Grouping Data
• Using Subqueries
• Joining Tables
• Managing Tables
• Using Views
• Stored Procedures
• Using Cursors
• Using Transactions