SQL: Advanced Querying


Course Prerequisites:

  • SQL: Fundamentals of Querying

Description:

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.

Hardware and Software Required:

  • Please note that the content in the course you have selected is supported and should function without major error in current, popular browsers. However, it has not been optimized for them. Therefore, you may encounter slight formatting or functionality issues during your learning experience.

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-SQL-ADQ
  • Duration: 3 hours 30 minutes
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend