SQL: Advanced Querying

In this course you will be introduced to the advanced features of the SQL language, and how it can be used to query a database in order to answer business questions. In this course you will examine the following advanced features: querying with unions, advanced joins and sub queries, add, update and remove data, manipulate tables, views and various indexes, ensure data integrity with transactions, and create databases.

Objectives: After completing this course you will be able to use advanced techniques for querying a database, query with subqueries, add data to a database, change and delete data from a database, create, alter, and delete tables, and create, use, and delete views. You will also be able to create and delete indexes, manage how data is altered through the use of transactions, and create and drop databases. (duration: 210)