Databases may be the most widespread computer application today. Hardly a business exists that does not employ databases to store critical information. The data stored in these databases is accessed and updated using database management systems such as Oracle, Microsoft Access and Microsoft SQL Server. This course is designed to give the student an understanding of databases and database management systems. Emphasis is placed upon the proper design of databases while meeting users' special needs. The Oracle database management system will be used throughout the course. The student will complete numerous database projects to reinforce these concepts and gain a proficiency in the design and use of databases. Students will become proficient in programming databases using the PL/SQL language. The student will also learn how to access databases via a procedural/ object-oriented high-level programming language. The course strongly emphasizes a hands-on approach to database programming and administration. | Getting Started | Information for Getting Started in Courses |
| Course Syllabus | Course Syllabus, Required and Recommended Materials, Policies, etc.. |
| Code of Conduct | Course policies relating to conduct in the classroom |
| Dr. Roussos' Schedule | Contact information for Dr. Roussos |
| Study Guide | A synopsis of important database concepts |
| Assignments | homework, project and programming assignments |
| Powerpoint Slides | Powerpoint Lecture Slides for each Chapter |
| Installing Oracle8i | Instructions and Screenshots for Oracle 8i installation |
| Student Downloads | Datafiles and other student resources |
| Oracle Resources | Oracle Resources on the web and elsewhere |
| VB.Net Oracle DB Access | Instructions on how to access an Oracle Database from VB.NET. |
|
Low-Level C/C++ Oracle DB Access C/C++ ODBC Oracle DB Access from cs.ua.edu/components/integrated/handouts/08-odbc-example.pdf |
Oracle Call Interface Programmer's Guide. Univ. of Alabama C++ ODBC to Oracle handout. |
| Oracle Certification | Oracle Web Site with information on becoming Oracle Certified |
| FREE online text books and courses from ACM | ACM members are entitled to access to FREE online text books. The ACM Professional Development Center lists nearly 400 such books. These are high quality, professionally written books that cover most CS topics from C++ to Data Structures to HTML. Student Lite membership is only $19 and includes access to all the books and courses in the Professional Development Center as well as a print subscription to Crossroads and online access to CACM, with the email alert service Student Pointers, plus Guide access. Apply at www.acm.org/membership/student/OnlineStudentApp.pdf |
Home page 