DB Concepts 2: Structured Query Language S'Q'L'

1
DB Concepts 2Structured Query Language (S.Q.L.)

• Meyer Tanuan, BCS, MBA, MMath (CS)
• PROG 2050
• Fall Term 2007

2
All About Me

• 20 years of IT experience as a Programmer,
  Analysts, Consultant and Manager
• Business Applications (ERP, MRP)
• Software Development and QA (Handhelds,
  AppServer)
• Full-time
• Professor at Conestoga College ITAL (5 years)
• Programs CP/CPA and HIM
• Part-time
• Software QA at Sybase
• OOAD, .NET and J2EE Consulting
• www.conestogac.on.ca/mtanuan

3
Course Outline

• Structure Query Language (S.Q.L.)
• Use Oracle and MS-Access
• Retrieve, store and modify data
• Build complex queries
• Create tables
• Summarize data
• Work with unions, subqueries and joins
• Intro. to Relational DB Query Languages
• Relational Algrebra, Domain and Tuple Calculi

4
Evaluation Methods

• Tests
• Mid-term (30), Finals (30)
• Assignments (40)
• Total of 5 or more assignments
• Standards CP/CPA (CP2A) Handbook
• Submit at the 1D17 drop box or during lab hours
  (no other place!)

5
Resources

• Textbook
• SQL Fundamentals (Patrick)
• Doon Computer Labs
• 1C7 (lab hours)
• 1C3, 2A220a b (open labs)
• Oracle10g_at_home
• Windows XP Pro (not tested on Vista)
• Oracle 10g Database 10.2 (free download)

6
How you can succeed

• Attend ALL classes
• Review the Course Requirements
• Check the course announcements and course
  schedule (once a week)
• Read the textbook and do the tutorials
• Start your assignments early
• If you dont understand, get help right away!

7
How you can help me succeed

• Give me feedback
• Send me email (mtanuan_at_conestogac.on.ca)
• If you have an issue, please be specific and
  provide a proposed solution (if possible)
• Attend ALL classes!