Synopsis

Oracle 10g: SQL prepares students for the first exam in both the Oracle Database Administrator (DBA) and Oracle Forms Developer certification tracks and offers them a solid understanding of Oracle10g and how to use it effectively. This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. Students begin with a solid foundation for creating databases (7 chapters) then strengthen their knowledge in creating queries (7 chapters). To assist students in bridging SQL topics to further studies, the last two chapters introduce students to SQL tuning, compare Oracle's SQL syntax to other databases (MS SQL Server and MySQL) and describe how SQL can be embedded in applications (ASP.net). This textbook also covers SQL*Plus and iSQL*Plus so students can identify and distinguish the differences between these interfaces.

Biography

Joan Casteel has more than twelve years of experience in application development in various business environments. She has been teaching Oracle development at Tidewater Community College for the past seven years in the Database Specialist curriculum. Joan has authored two textbooks for Course Technology, a part of Cengage Learning.