Syllabus: http://fenzilla.com/QMB2302C/585242.html

The image to the right/below is called a Schema or Entity Relationship Diagram. We will review how to read it in class.

Schema we will use: HR:

1. How to Login: http://fenzilla.com/QMB2302C/QMB2302C_index.html

2. Read this and write down questions you might have. I will answer these in class :Lesson 1 Introduction

3. Read this and try every single query you see. If you get an error, fix it and then try again!:Lesson 2 Retrieving Data with SELECTs

4. Try assignment 1 Assignment1

5. Read this and try every single query you see. If you get an error try and fix it and try again! Lesson 3 Restricting and Sorting Data

6. Read this and try every single query you see. If you get an error try and fix it and try again! Lesson 4 Single-Row Functions

7. Try assignment 2 Assignment2

8. Read this and try each query you read. Lesson 5 conversion function and conditional expressions