DB Concepts 2: Structured Query Language S'Q'L' - PowerPoint PPT Presentation

1 / 7
About This Presentation
Title:

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

Description:

20 years of IT experience as a Programmer, Analysts, Consultant and Manager ... Windows XP Pro (not tested on Vista) Oracle 10g Database 10.2 (free download) ... – PowerPoint PPT presentation

Number of Views:19
Avg rating:3.0/5.0
Slides: 8
Provided by: conest
Category:

less

Transcript and Presenter's Notes

Title: 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!
Write a Comment
User Comments (0)
About PowerShow.com