Day 10
Introduction to SQL Server - Part 2
| Time | Activity |
|---|---|
| 08:30 AM |
Many-to-Many Relationships
Exercise - Database with Products and Favorites
UPDATE/DELETE with JOIN
Multiple Statements
Transactions
Exercise - Database with CustomerFavoriteSummaries
|
|
Lunch Break (12-1PM)
|
|
| 1:00 PM |
Aggregate Queries
Subqueries
Exercise - Composite Queries
Control-of-Flow Statements
TABLE variables and Temporary Tables
Exercise - Customer Favorites
Code Re-Use: Views, Stored Procedures, Functions, Triggers
|