1 / 12

Introduction to Database using Oracle

Introduction to Database using Oracle. Lecture 1 Sen Zhang. Welcome!. Be prepared to study hard Have fun You have many years for other things, but only 4 years for studying. Course Information - Instructor . Name: Sen Zhang Email: zhangs@oneonta.edu Room: 224 Fitzelle Hall

landis
Download Presentation

Introduction to Database using Oracle

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. Introduction to Database using Oracle Lecture 1 Sen Zhang

  2. Welcome! • Be prepared to study hard • Have fun • You have many years for other things, but only 4 years for studying.

  3. Course Information - Instructor • Name: Sen Zhang • Email: zhangs@oneonta.edu • Room: 224 Fitzelle Hall • Office hours: • My course syllabus • Other time slots: by appointment • Any questions?

  4. How about you? • Let your classmates know something about you!

  5. Course Information –Grade breakdown • Midterm Exam 1 13% • Midterm Exam 2 14% • Final Exam 32% • Term Projects 18% • Homework ( including Lab assignment) 20% • Class Participation 3% • Syllabus has the most updated information! • Please use the information on the syllabus for the grading policy, if there is any contradiction between syllabus and this slide! • You see, if you have to maintain the same information at different places, it is not easy to keep them consistent! This is one thing database has addressed well

  6. Communications • Angel • Notes • Homework • Lab assignment • Term project description • Other important announcement • Course Web page: • http://employees.oneonta.edu/zhangs/, from where follow course link. • other resources will be here • Email • Stop by

  7. Prerequisites: • Programming courses • (Java, C++\C, VC, Perl etc.) • Data structures (not a must, but should be helpful!) • You know, we are talking about DATAbase • sort, search, index etc.

  8. Textbook Guide to Oracle 10g Rocky Conrad, Joline Morrison and Mike Morrison, 0-619-21629-8 Buy the book and software (optional) This is the only book you need to buy.

  9. Other Texts Many classic textbooks (All good books) • Oracle PL/SQL 101, by Christopher Allen, published by McGraw-Hil Osborne Media, ISBN# 007212606X. • An Introduction to Database Systems, C.J. Date • Database Systems Concepts, Silverschatz, (4. edition) • Database Systems: The Complete Book, Hector Garcia-Molina, Jeffrey Ullman, Jennifer Widom • Database Management Systems, Ramakrishnan • Fundamentals of Database Systems, Elmasri, Navathe • Databases and Transaction Processing, An application-oriented approach: Philip M. Lewis, Arthur Bernstein, Michael Kifer, Addison-Wesley 2002.

  10. Material on the Web • http://www.w3schools.com/sql/default.asp • http://www.1keydata.com/sql/sql.html • http://philip.greenspun.com/sql/ • And many other resources

  11. The Project – Side Effects • Trains your soft skills • independent work strongly encouraged. Team work is subject to my approval. • deal with bugs, train how to document, … • produce with limited time resources, progress management. • be familiar with full cycle of application development. • Results useful for your future job hunting, for seeking a database developer position. • Demo to class, demo to your potential employers • Project should be fun 

  12. Goal and expected outcome of the course • Overview of Database systems • What are database systems • Fundamental Concepts and the big picture of RDBMS • Using oracle • a solid understanding about database and to be able to meet real world challenge using skills you will have learned from this course! • Basic SQL • E-R model • advanced SQL • PL/SQL • Strong emphasis on Oracle • Front end + backend application • Practice • Homework and implementing projects • Advanced topics (optional) • Depending on the class progress, there might be a little bit theory, optional. (e.g. relational algebra)

More Related