SQL, or Structured Query Language, is a powerful and widely used programming language designed for managing, querying, and interacting with relational databases. It serves as the backbone of countless applications, enabling users to retrieve specific information, manipulate data, define database structures, and control access to stored information. From small-scale projects to large enterprise systems, SQL is essential for efficiently organizing and extracting meaningful insights from data.

Learning objectives

  1. Deepen understanding of the purpose and structure of SQL.
  2. Learn the basic SQL concepts of LEFT JOIN, RIGHT JOIN, INNER JOIN, CROSS JOIN, FULL OUTER JOIN, DISTINCT, UNION, and UNION ALL.
  3. Retrieve and interpret data using SQL queries.

Suitable courses: AIS, Data Analytics

You must have an account with EYARC Experience and then go to the Assignment Catalog to review

Join EYARC for Full Access
EYARC Experience Image

EYARC Experience

Turn case studies into powerful teaching moments for your students. Active EYARC users can explore our experiential learning platform to access cutting-edge curricula and innovative teaching resources.

Try It Now

Academic Case Materials

Access free resources to prepare students for the global marketplace. Resources include case studies, data sets, analytics workbooks, videos and many other tools focused on business and accounting topics.

Academic Case Materials Image

To search by multiple tags, enter the search word followed by a comma and the next word, etc.
For example, entering "Audit, Excel, Intermediate" will list cases related to audit AND Excel AND intermediate difficulty. To search by a single tag, enter it in the search box or click on the tag below in the Popular Tags area.