University of Arkansas

Walton College

The Sam M. Walton College of Business

SQL Fundamentals and Advanced SQL Curriculum

SQL Fundamentals and Advanced SQL Curriculum

 SQL Fundamentals

SQL Fundamentals Faculty Guide

SQL Fundamentals Solution Files (secure logon)

  1. SQL FUNDAMENTALS Introduction
  2. CREATE TABLES
  3. SELECT_FROM
  4. SSMS OVERVIEW
  5. SELECT FROM WHERE
  6. LOGICAL OPERATORS
  7. INEXACT MATCH
  8. IN AND NULL
  9. SORT CALCULATE
  10. TWO TABLES OR MORE
  11. AGGREGATES
  12. AGGREGATES PART 2
  13. SELF-JOINS
  14. SET OPERATORS

 Advanced SQL

Advanced SQL Faculty Guide

Advanced SQL Solution Files (secure logon)

  1. GREENHOUSE DATABASE INTRODUCTION
  2. EQUI-JOIN, ONE-SIDED OUTER JOIN, FULL OUTER JOIN, IS NULL
  3. NESTED QUERIES: TYPE 1 SUBQUERY
  4. NESTED QUERIES: TYPE 2 SUBQUERY
  5. IN-LINE QUERY in the FROM clause
  6. NESTED AGGREGATES
  7. DIVISION PROBLEMS