Transcript Introduction to SQL

SQL & Database Design
 SQL
 Relational
Database Design
 Steve
Perry
 E-mail: [email protected]
 Messages: 714/582-4900 (x3066)
1
Class Survey
 How
people consider themselves to be...
– Programmers
– System Analysts
– Computer Users
2
Rules & Regulations
 Please
whisper if you need to talk during a
lecture.
 Attendance is Optional
– Read Book
– Do assignments
3
Class Format
 7:00-8:00
 8:00-8:15
 8:15-9:15
 9:15-9:45
 9:45
Lecture & Exercises
Break
Lecture & Exercises
Question & Answer Period
Class Dismissed
4
Class Breakdown
 17
Lectures - No Final
 SQL -
9 Lectures
 Embedded SQL - 1 Lecture
 Database Design - 5 Lectures
 Review - 2 Lectures
5
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/
6
Assignments
 10 Assignments
(on the web)
 5 Questions (each worth 2 points)
- There is only one correct answer!
 Submit Assignments on the Web
7
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 ]
8
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).
9
Class Grading
10 Assignments (10 points each)
 No Final
 10 point Bonus if you complete all assignments

Points
100-85
84-70
69-60
59-50
49-0
Letter Grade
A
B
C
D
F
10
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.
11
Connecting to the Database
 See
Web Instructions
 Start SQLAnywhere
 Menu: Command|Connect
 UserId: dba
Password: sql
 Database File: c:/sql/bookbiz.db
12
Class Exercises
 No
individual computers provided
 Hand write the class exercise solutions
 Work together
13
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
14
Covered from Instructor Notes
 Embedded
SQL
 Advanced Database Design
(Optional:
Data Modeling Essentials
by Graeme Simison)
15
Separated at Birth?
16
Last Slide - Introduction
17