Microsoft Office Excel 2003 or Oracle 10g

Microsoft Office Excel 2003: Comprehensive Concepts and Techniques, CourseC

Author: Gary B Shelly

For the past three decades, the Shelly Cashman Series® has effectively introduced computers to millions of students, consistently providing the highest quality, most up-to-date, and innovative materials in computer education. Enjoy the proven step-by-step style and improved Office 2003 updates of the Shelly Cashman Series® and enhance your Office application skills today!

Read also La Guía del Gerente Afortunado: Desarróllese Otros de Entrenador

Oracle 10g: SQL

Author: Joan Casteel

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.

Table of Contents:

1. Overview of Database Concepts
2. Basic SQL SELECT Statements
3. Table Creation and Management
4. Constraints
5. Data Manipulation and Transaction Control
6. Additional Database Objects
7. User Creation and Management
8. Restricting Rows and Sorting Data
9. Joining Data from Multiple Tables
10. Selected Single-Row Functions
11. Group Functions
12. Subqueries and Merge
13. Views
14. Formatting Readable Output
15. Exploring SQL Topics in Application Development
Appendices A. Justlee Database B. SQL Plus & ISQL Plus User's Guide C. SQL Sytax Guide D. Introductoin to Third Party Tool (TOAD) E. Practice Exams F. Oracle Resources G. SQL Loader