Full file at

Course Syllabi –SQL for SQL Server by Bordoloi and Bock

This syllabus is based on a 16-week semester with four examinations.

Week / Topic / Assignments
1 / Chapter 1 – Introduction / Concepts Quiz: 1, 2, 3, 5, 7; SQL Coding Exercises Company Database: 2, 4, 6, 8, 10; Riverbend Database: 2, 4, 6, 8, 12.
2 / Chapter 2 – Creating Tables and Indexes / Concepts Quiz: 2, 4, 8, 9, 10, 12, 14, 16, 18; SQL Coding Exercises Company Database: 5 to 14, 18; Riverbend Database: 1 to 18.
3 / Chapter 3 – Single Table Query Basics / Concepts Quiz: all even numbered questions; SQL Coding Exercises Company Database: 1 to 14; Riverbend Database: 2, 4, 5, 8, 12, 14.
4 / Review and Examination #1
5 / Chapter 4 – Adding Power to Queries / Concepts Quiz: 2, 3, 6, 7, 8, 10, 12; SQL Coding Exercises Company Database: 3, 4, 5, 8, 10, 12, 14; Riverbend Database: 2, 4, 8, 9, 12.
6 / Chapter 5 – Aggregate Functions and Grouping of Data / Concepts Quiz: 4, 6, 8, 10, 12, 13, 15, 16; SQL Coding Exercises Company Database: 4, 6, 7, 10, 14, 15; Riverbend Database: 2, 4, 6, 8, 9, 10, 12, 14.
7 / Chapter 6 – Joins / Concepts Quiz: 5, 6, 7, 12, 14, 16, 18; SQL Coding Exercises Company Database: 4, 6, 8, 9, 10, 12; Riverbend Database: 2, 4, 8, 12, 14.
8 / Review and Examination #2
9 / Chapter 7 – Subqueries / Concepts Quiz: 4, 8, 12, 14, 17, 18, 20; SQL Coding Exercises Company Database: 1, 2, 4, 6, 10, 11, 12; Riverbend Database: 4, 5, 6, 8, 11, 12.
10 / Chapter 8 – Views and Synonyms / Concepts Quiz: 1, 2, 3, 6, 8, 11, 12, 14, 15, 16, 18, 20; SQL Coding Exercises Company Database: 1, 2, 4, 9, 12; Riverbend Database: 1, 2, 4, 8, 11, 12.
11 / Chapter 9 – Additional Functions / Concepts Quiz: 3, 5, 7, 11, 12, 14, 15; SQL Coding Exercises Company Database: 1, 3, 4, 6, 7, 10, 14, 15; Riverbend Database: 2, 3, 4, 6, 10, 14.
12 / Review and Examination #3
13 / Chapter 10 – Stored Procedures and Triggers / Concepts Quiz: 2, 4, 6, 7, 10, 11, 12, 14, 15, 16, 20, 22, 24; SQL Coding Exercises Company Database: 2, 3, 4, 7, 8, 12, 14, 16; Riverbend Database: 1 through 15.
14 / Chapter 11 – SQL Server Database Administration / Concepts Quiz: all even numbered questions; SQL Coding Exercises: 1 through 17.
15 / Chapter 12 – Embedded SQL / Concepts Quiz: 2, 4; SQL Coding Exercises Company Database: 1 through 4; Riverbend Database: none.
16 / Review and Final Examination

This syllabus is based on an 11-week quarter with three examinations. Chapter 12 is not covered in this syllabus.

Week / Topic / Assignments
1 / Chapter 1 – Introduction / Concepts Quiz: 1, 2, 3, 5, 7; SQL Coding Exercises Company Database: 2, 4, 6, 8, 10; Riverbend Database: 2, 4, 6, 8, 12.
2 / Chapter 2 – Creating Tables and Indexes / Concepts Quiz: 2, 4, 8, 9, 10, 12, 14, 16, 18; SQL Coding Exercises Company Database: 5 to 14, 18; Riverbend Database: 1 to 18.
3 / Chapter 3 – Single Table Query Basics; Chapter 4 – Adding Power to Queries / Concepts Quiz: all even numbered questions; SQL Coding Exercises Company Database: 1 to 14; Riverbend Database: 2, 4, 5, 8, 12, 14.
Concepts Quiz: 2, 3, 6, 7, 8, 10, 12; SQL Coding Exercises Company Database: 3, 4, 5, 8, 10, 12, 14; Riverbend Database: 2, 4, 8, 9, 12.
4 / Review and Examination #1
5 / Chapter 5 – Aggregate Functions and Grouping of Data; Chapter 6 – Joins / Concepts Quiz: 4, 6, 8, 10, 12, 13, 15, 16; SQL Coding Exercises Company Database: 4, 6, 7, 10, 14, 15; Riverbend Database: 2, 4, 6, 8, 9, 10, 12, 14.
Concepts Quiz: 5, 6, 7, 12, 14, 16, 18; SQL Coding Exercises Company Database: 4, 6, 8, 9, 10, 12; Riverbend Database: 2, 4, 8, 12, 14.
6 / Finish Chapter 6; Chapter 7 – Subqueries / Concepts Quiz 4, 8, 12, 14, 17; SQL Coding Exercises 1, 2, 4, 6, 10, 11.
7 / Finish Chapter 7; Chapter 8 – Views and Synonyms / Concepts Quiz: 4, 8, 12, 14, 17, 18, 20; SQL Coding Exercises Company Database: 1, 2, 4, 6, 10, 11, 12; Riverbend Database: 4, 5, 6, 8, 11, 12.
Concepts Quiz: 1, 2, 3, 6, 8, 11, 12, 14, 15, 16, 18, 20; SQL Coding Exercises Company Database: 1, 2, 4, 9, 12; Riverbend Database: 1, 2, 4, 8, 11, 12.
8 / Review and Examination #2
9 / Chapter 9 – Additional Functions; Chapter 10 – Stored Procedures and Triggers / Concepts Quiz: 3, 5, 7, 11, 12, 14, 15; SQL Coding Exercises Company Database: 1, 3, 4, 6, 7, 10, 14, 15; Riverbend Database: 2, 3, 4, 6, 10, 14.
Concepts Quiz: 2, 4, 6, 7, 10, 11, 12, 14, 15, 16, 20, 22, 24; SQL Coding Exercises Company Database: 2, 3, 4, 7, 8, 12, 14, 16; Riverbend Database: 1 through 15.
10 / Finish Chapter 10; Chapter 11 – SQL Server Database Administration / Concepts Quiz: all even numbered questions; SQL Coding Exercises: 1 through 17.
11 / Review and Final Examination