 |
 |
COMP 210 - Fall 2002 Database Design I |
| ||||||||||||||||||||
| ||||||||||||||||||||
|
||||||||||||||||||||
|
|
ResourcesPlease feel free to suggest new resources for this page. Jump to Articles, Books, Software, or Websites.ArticlesJump to Top of Page.Introduction to Structured Query Language <www.highcroft.com/highcroft/sql_intro.pdf> James Hoffman has graciously taken the time to summarize the basics of SQL for us. But don't bother reading past page 16 or so, when he starts into the evils of Embedded SQL. Mary Lou and Bobby Sue's Beginners' Guide to SQL* Plus <www.dbatoolbox.com/WP2002_06/beginners_sql_plus.pdf> Putting aside the title for the moment, this article will give you a very quick overview of both SQL and some of the more useful SQL*Plus commands. Oracle, IBM, Microsoft Challenged by Free Database Software <quote.bloomberg.com> The big banks won't be switching to MySQL any time soon, but experience with Open Source database engines is a good résumé builder. Take a look at Open-Source Databases Hike Enterprise Appeal too. Oracle: SQLPlus Documentation <otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/toc.htm> Here are the official instructions for using both the command line and Windows versions of Oracle's infernal SQL client tool. You may need to register (it's free) on the Oracle site to view this documentation. W3Schools: SQL Tutorial <www.w3schools.com/sql> This is a thorough tutorial that covers the essentials of the Structured Query Language. Once you're finished, try the sample quiz. I got 100%. Let's see you do better, smartypants. BooksJump to Top of Page.Access Cookbook Ken Getz, Paul Litwin & Andy Baron, O'Reilly & Associates Inc. A compendium of common Access problems and roadblocks, and the solutions for each. Access Database Design and Programming Steven Roman, O'Reilly & Associates Inc. A tour de force explanation of all things Access, including a surprisingly-theoretical discussion of Normal Forms. Nevertheless, if you're new to Access's many programming options (SQL, macros, and Visual Basic modules) this book will give you the gist of it all. Database Design for Mere Mortals: A Hands-On Guide to Relational Michael J. Hernandez, Addison Wesley. If you're interested in another perspective on database design, try this book on for size. Hernandez favours a bottom-up approach, but his techniques may give you a bit more insight into the top-down modelling methodology that COMP 210 encourages. This book is on reserve in the library. Database Processing: Fundamentals, Design, and Implementation 8th Edition, David M. Kroenke, Prentice Hall. The COMP 210 textbook. Fundamentals of Database Systems 2nd Edition, Ramez Elmasri & Shamkant B. Navathe, Benjamin Cummings. Just in case one textbook isn't enough, this old-timer is on reserve in the library. Managing and Using MySQL 2nd Edition, George Reese & Randy Jay Yarger & Tim King, O'Reilly & Associates Inc. MySQL doesn't have all of the features of a traditional RDBMS--although InnoDB tables help a lot--but for pure unvarnished read speed, MySQL beats 'em all. Once you're familiar with database topics, this book will explain the MySQL specifics. Mastering Oracle SQL Sanjay Mishra & Alan Beaulieu, O'Reilly & Associates Inc. Once you're comfortable with the basics of Oracle SQL, check out this book for more advanced examples, especially if you're interested in subqueries. This book is on reserve in the library. Oracle Database Administration: The Essential Reference David C. Kreines & Brian Laskey, O'Reilly & Associates Inc. Oracle database administration is a career unto itself (and a fairly profitable one at that). This book is a good reference for experienced DBAs, but it's not the place to start if you're looking for a gentle introduction into the arcane esoterica of Oracle administration. Oracle Developer Advanced Forms and Reports Peter Koletzke & Paul Dorsey, McGraw-Hill Ryerson. More than you ever need know about Oracle's heavyweight and proprietary applications development framework. Oracle PL/SQL Programming 2nd Edition, Steven Feuerstein & Bill Pribyl, O'Reilly & Associates Inc. While the COMP 210 course won't cover stored procedures in detail, if you intend to develop serious applications using Oracle, learning PL/SQL is a must. Oracle SQL: The Essential Reference David C. Kreines, O'Reilly & Associates Inc. Just as all other database vendors, Oracle has its own dialect of SQL. Fortunately, Oracle's SQL is reasonably compliant with the ANSI standard. In particular, Oracle's DDL syntax is much "cleaner" than the equivalent offerings from the others. PostgreSQL: Introduction and Concepts Bruce Momjian, Addison Wesley Professional. Written by a member of the development team, this book provides a lot of details about the PostgreSQL program itself, but for a general reference, Practical PostgreSQL is a better choice. Practical PostgreSQL John C. Worsley & Joshua D. Drake, O'Reilly & Associates Inc. Looking the features of an Oracle-like RDBMS, but at a MySQL price? PostgreSQL will fit the bill, and this book covers the topic from soup to nuts. Principles of Transaction Processing for the Systems Professiona Philip A. Bernstein & Eric Newcomer, Morgan Kaufmann. Transaction management should be in the minds of all database developers. It's just about all you think about when writing highly-scalable systems. This is the authoritative reference for the topic. SQL In A Nutshell: A Desktop Quick Reference Kevin Kline & Daniel Kline, O'Reilly & Associates Inc. A good reference to have handy if you plan on serious SQL work. Covers the Oracle, SQL Server, MySQL, and PostgreSQL dialects of the SQL language. This book is on reserve in the library. Web Programming: Building Internet Applications Chris Bates, John Wiley & Sons. The COMP 220 textbook. This should start appearing in the bookstore in January. SoftwareJump to Top of Page.IBM DB2 <www-3.ibm.com/software/data/db2> With its purchase of Informix in 2002, IBM wrested the database market share crown from Oracle. However the DB2 product remains IBM's central RDMBS platform. DB2, like its hierarchical cousin IMS, is rarely seen outside of mainframe shops, even though it does run on Windows and Linux. Microsoft SQL Server <www.microsoft.com/sql> Microsoft has taken its RDBMS a long way from its humble Sybase origins. The enterprise version of the product includes an OLAP server, replication & clustering, and SMP support. SQL Server now claims 7 of the top 10 TPC-C performance benchmark results. MySQL <www.mysql.com> The Open Source database for the simplicity-conscious performance seeker. The basic MySQL is a stripped-down RDBMS, lacking many features common to the competition, but it's a good choice for smaller read-bound applications, particularly websites. The MySQL-Max version adds new table types that permit simple transactional control and referential integrity. MySQL runs on Windows and a variety of Unices, including Linux and Macintosh OS X. Oracle <www.oracle.com/ip/deploy/database/oracle9i> Oracle has long been the name in big-iron RDBMS. The Oracle RDBMS is highly configurable and renowned for its reliability; unfortunately, it's also renowned for its administrative burden and hokey toolset. PostgreSQL <www.ca.postgresql.org> Not as well known as MySQL, perhaps because it doesn't as easily run on Windows, PostgreSQL is a full-featured Open Source RDBMS based on the Berkeley INGRES project. Postgres compares favourably with the relational database products from Oracle, IBM, and Microsoft for medium to large single-server solutions. WebsitesJump to Top of Page.O'Reilly and Associates Oracle Series <oracle.oreilly.com> O'Reilly has a whole series of books covering Oracle (all with bugs on the cover). And O'Reilly's reknowned signal-to-noise ratio in its books means that each volume has a lot of information stuffed inside. Oracle9i Database List of Books <otn.oracle.com/docs/products/oracle9i/doc_library/release2/index.htm> It's more than a little overwhelming, but here is all of the Oracle9i documentation. We'll actually be using Oracle8i in class, but for our purposes there aren't any significant differences. You may need to register (it's free) on the Oracle site to view this documentation. Simon Sheppard's Oracle Reference <www.ss64.demon.co.uk/ora/index.html> This is a well-organized and concise reference to the most common SQL DDL and DML statements. The site also includes an invaluable list of Oracle's metadata views, including the list of columns for each view. |
| |||||||||||||||||||||||||
|
|
||||||||||||||||||||||||