Acrobat X Files

Home > Programming > Oracle Programming

ECS 165A Database Systems General Information

Sort Desciption:

mentation of a database schema and application programming. ... Oracle SQL PL/SQL) but some assignments also focus on the formal background in database ...

Content Inside:

ECS 165A Database Systems General InformationPage 1ECS 165A Database SystemsSpring 2007Dr. Michael GertzMarch 29ECS 165A Database SystemsGeneral InformationWeb Sitehttp://dbis.ucdavis.edu/courses/165ASQ 07/Time and PlaceClassTR 4:406:00pm 217 ArtDisc. Section W 5:106:00pm166 ChemistryCourse PersonnelInstructor Dr. Michael Gertz3029 Kemper Hallgertz@cs.ucdavis.edu(530) 7526468OH: T 9:0010:00am and R 1:152:15pmTAMichael Byrdbyrd@cs.ucdavis.eduOH: M 11am12pm F 121pm 3106 Kemper HallCourse ObjectivesThis course focuses on the design of databases ranging from the conceptual design to the implementation of a database schema and application programming. You will learn about databasedesign concepts and methods data models (EntityRelationship and Relational Model) thedatabase query language SQL and the various components of a database management system.Further topics include query processing and optimization techniques transaction processingand management and storage and file structures.The course is heavily designoriented. In most of the assignments you have to design andimplement a database using a commercial database management system (Oracle10g). In particular you will learn the database query language SQL and the development of applicationsusing PL/SQL and Embedded SQL. The database system used in this course is the Oracle10gdatabase management system.PrerequisitesECS 110 (Data Structures and Programming) is essential for this course. I furthermore assumethat you have experience with the C C++ or Java programming language. I also expect thatyou have experience with the Unix (or Linux) operating system including shell programmingMakefiles etc.Page 2Textbook and ReadingsThe required textbook for this course isA. Silberschatz H. Korth S. Sudarshan: Database System Concepts (4th or 5th ed.)Copies of the 5th edition have been ordered and are available at the University bookstore (andof course at any other online bookstore).Copies of my transparencies will be posted on the cla ...

Source: dbis.ucdavis.edu

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...