Oracle SQL Interactive Workbook (Interactive Workbook (Prentice Hall))

Before Oracle DBAs and developers can move on to sophisticated application development, they must gain an in-depth understanding of Oracle SQL. Oracle SQL Interactive Workbook is the fastest way to master Oracle SQL. This integrated book-and-Web learning solution teaches all the Oracle SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle SQL concept, including: entity-relationship diagrams, the SQL*Plus environment, SELECT and other statements, Boolean operations, joins, aggregate and not-aggregate functions; pseudocolumns; complex joins and subqueries; relational operators; date and conversion functions; DML, DDL, and more. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author; "Test Your Thinking" project solutions and explanations, interactive Q&As, self-review exercises, new projects, book updates, and more!