COST:
Group discounts for 5+ apply
DURATION: 1 day


Do you need to analyse and make sense of large volumes of data?  This hands-on course introduces SQL techniques to better manage and report on information contained in databases. Build on the skills you learned from our Introduction to SQL course to gain additional techniques to more effectively extract information from the data, and discover more powerful ways to manage and maintain that data.
 

Intended for:

You, if you need to be able to work with relational data using SQL.

Prerequisites:

An understanding of SQL SELECT statements is necessary for you to get the maximum benefit from attending this course. This is covered in our Introduction to SQL course.
 

Learning outcomes:

By the end of this course you will be able to extract the required information from the data in the database and manage that data more effectively.

Content:

  • Review of SELECT
  • Returning expressions
  • Using views
  • Review of joins
  • Self-joins
  • Nested queries in SELECTs
  • Combining queries
  • Cross-tab queries
  • Nested queries in INSERT, UPDATE and DELETEs
     

Method used:

Lecturing is kept to the minimum necessary, most of the learning is achieved through applying the practices and techniques.

Take your learning to the next level:

Intermediate SQL

Related courses:

Course outline:
Download PDF