Advanced SQL for Query Tuning

Topics:

• Use nested queries to generate query output.

• Manipulate table data by inserting and updating records in a table and deleting records from a table.

• Manipulate table structure.

• Create views, manipulate data through views, modify the view structure, and drop views.

• Create indexes on table columns and drop inefficient indexes.

• Mark the beginning of a transaction, roll back a transaction, and commit a transaction.