Method signatures

Method signatures define/describe:

  • the name/identifier of the method
  • the parameters of the method (identifier and data type)
  • the return type of the method eg void or int etc

Objectives

Students will be able to:

  • Create Inner Joins in an SQL Query

Relational Databases

More Joins

 

Left and Right Joins

As well as Inner Join in SQL, there are also 2 other popular joins when querying a relational database.

  • left join
  • right join

Let's see if we can figure out how they work.

Watch the video and complete the worksheet.

Practical Inner Join Activity

Student enrollment

The Student enrollment database has 3 tables.

How can we ouput all enrollment data for every student enrolled in a course?

Complete the Worksheet task.

Objective

Write SQL queries which pull related data from multiple tables in order to produce a result.

Resources

Tags

methodCoding Bat recursion base case recursive call stack overflow returnunwind