All Material from Chapter 1 to 11, including:
Midterm will be 50 multiple choice or true/false on websmart.
The link for the midterm will be available by 6:30 PM on 3/13/2012
Parts of a RDBMS: Attributes, Entities, Relationships: 1 to 1, 1 to Many, Many to Many (how to implement)
Primary & Foreign Keys: What they are, why they are important, and best practices. LAST_INSERT_ID()
Client/Server concepts & architecture
Data Types. Case sensistivity, i.e. BINARY vs. NON-BINARY, character sets.
Basic DDL Commands: CREATE, ALTER, DROP
Parts of the SELECT COMMAND: (rows vs. groups), UNION, Pattern Matching, BOOLEAN logic (AND/OR)
Other Basic DML INSERT, DELETE, UPDATE.
Indexes: What they are and why they are important.
SQL Expressions & Functions, see Chapter 10: truncate, concat / ||, CASE, IF, convert, TEMPORAL Functions. ISNULL & IFNULL.