1 / 17

SQL & Database Design

SQL & Database Design. SQL Relational Database Design Steve Perry E-mail: sqlclass@yahoo.com Messages: 714/582-4900 (x3066). Class Survey. How people consider themselves to be... Programmers System Analysts Computer Users. Rules & Regulations.

henrye
Download Presentation

SQL & Database Design

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL & Database Design • SQL • Relational Database Design • Steve Perry • E-mail: sqlclass@yahoo.com • Messages: 714/582-4900 (x3066)

  2. Class Survey • How people consider themselves to be... • Programmers • System Analysts • Computer Users

  3. Rules & Regulations • Please whisper if you need to talk during a lecture. • Attendance is Optional • Read Book • Do assignments

  4. Class Format • 7:00-8:00 Lecture & Exercises • 8:00-8:15 Break • 8:15-9:15 Lecture & Exercises • 9:15-9:45 Question & Answer Period • 9:45 Class Dismissed

  5. Class Breakdown • 17 Lectures - No Final • SQL - 9 Lectures • Embedded SQL - 1 Lecture • Database Design - 5 Lectures • Review - 2 Lectures

  6. We're on the Web • saddleback.cc.ca.us • http://iserver.saddleback.cc.ca.us/spring99/22730.shtml • iserver.saddleback.cc.ca.us/faculty/sperry/sql/

  7. Assignments • 10 Assignments (on the web) • 5 Questions (each worth 2 points)- There is only one correct answer! • Submit Assignments on the Web

  8. Using SQLAnywhere • A runtime version of SQLAnywhere is included on the CD in back of your book • Install it on your own PC or use the Lab • Assignment answers are designed to run on SQL Anywhere • Note: the Bookbiz database is in a separate directory on the CD (Examples folder)[ bookbiz.db ]

  9. Assignment Grading • 1 point may deducted from assignment grade for each week past due. • Questions are from the Book and Instructor Notes (on the Web Page).

  10. Class Grading • 10 Assignments (10 points each) • No Final • 10 point Bonus if you complete all assignmentsPointsLetter Grade100-85 A84-70 B69-60 C59-50 D49-0 F

  11. Questions • Can ask during class or during Breaks • Can ask during the Q&A Period • Do NOT ask before class while I’m busy setting up.

  12. Connecting to the Database • See Web Instructions • Start SQLAnywhere • Menu: Command|Connect • UserId: dba Password: sql • Database File: c:/sql/bookbiz.db

  13. Class Exercises • No individual computers provided • Hand write the class exercise solutions • Work together

  14. Covered in SQL Book • Database queries using the SQL Select statement • Database manipulation using the Insert, Delete and Update statements. • Basic Database Design • Using Views • Fundamental Database Management

  15. Covered from Instructor Notes • Embedded SQL • Advanced Database Design(Optional: Data Modeling Essentials by Graeme Simison)

  16. Separated at Birth?

  17. Last Slide - Introduction

More Related