CTS2445

=CTS2445 - SQL Programming =

Summer 2010

 * [|Syllabus]
 * [|Topic by Week]
 * [|How to Submit Exercises]
 * [|How to Copy the Results of a Query]
 * [|How to Create a Script File]

Chapter Notes
 * [|Chapter 1 - Installation]
 * [|Chapter 2 - Running MySQL]
 * **Chapter 3 - Database Design**
 * [|MySQL Concepts]
 * [|Database Design Principles]
 * [|Entities and Relationships]
 * [|Primary and Foreign Keys]
 * [|Normalization]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">**Chapter 4 - Creating a MySQL Database**
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Column and Data Types]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Indexes]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">**Chapter 5 - Basic SQL**
 * [|Compound Conditions]
 * [|Joins]
 * [|Inner and Outer Joins]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Chapter 6 - MySQL Functions]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">**Chapter 10 - Advanced SQL Topics**
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Transactions]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Subqueries]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Self-Joins]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Unions]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Regular Expressions]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">**Chapter 11 - Stored Procedures, Triggers, and Views**
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Stored Procedures]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Triggers]
 * <span style="display: block; font-family: Verdana,Geneva,sans-serif;">[|Views]