SQL Querying: Advanced

Course objective

Gain hands-on expertise in working with advanced SQL Queries. This course will cover advanced SQL knowledge and skills to use subqueries to perform advanced querying, manipulate table data, and table structure, work with views, index data, and manage transactions. This course is ideal for those who studied the SQL Querying: Fundamentals course and individuals who already work in the field but wants to boost their knowledge and skills in SQL.

What is included

  • Pre and post assessment
  • Flashcards and quizzes
  • Virtual labs
  • Study planner
  • Certification of completion

Course outline

  1. Using subqueries to perform advanced querying
  2. Manipulating table data
  3. Manipulating the table structure
  4. Working with views
  5. Indexing data
  6. Managing transactions
  7. Appendix A