This 1-day SQL Advanced Querying training course takes students beyond basic queries using SQL. Students will learn advanced queries as well as how to add, update, and delete data, tables, views, and indexes.They will also be introduced to transaction control concepts involving locking and COMMIT and ROLLBACK processes.

Upon successful completion of this course, students will be able to:

• Use advanced techniques for querying a database.
• Query with sub-queries.
• Add data to a database.
• Change and delete data from a database.
• Create, alter, and delete tables.
• Create, use, and delete views.
• Create and delete indexes.
• Manage how data is altered through the use of transactions.
• Create and drop databases.

Course outline