My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free US shipping over $10
Trustpilot
Proud to be B-Corp

Oracle SQL Interactive Workbook Alex Morrison

Oracle SQL Interactive Workbook By Alex Morrison

Oracle SQL Interactive Workbook by Alex Morrison

Reviews:
$4.56
Condition - Good
Only 1 left
Good

Summary

A complete, interactive tutorial on the four most important topics that lead to Oracle DBA Certification: SWL, PL/SQL, Forms and Oracle DBA.

Faster Shipping

Get this product faster from our US warehouse

Oracle SQL Interactive Workbook Summary

Oracle SQL Interactive Workbook by Alex Morrison

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!

About Alex Morrison

Alexandrea Morrison and Alice Rischart are faculty members at the Columbia University School of Continuing Education. Series Technical Advisor Douglas Scherer is a certified Oracle database administrator, and President and Founder of Core Paradigm, Inc. He has been an Oracle specialist, database architect, and consultant to a wide range of leading companies, including Deutsche Bank. He is also a member of the faculty at the Columbia University School of Continuing Education.

Table of Contents

(NOTE: All chapters conclude with Test Your Thinking.)

1. SQL and Data.

Data, Databases, and the Definition of SQL. A Case Study Schema Diagram. Referential Integrity and Table Relationships. The SQL *PLUS Environment.



2. SQL: The Basics.

The Anatomy of a SELECT Statement. Editing a SQL Statement. The WHERE Clause: Comparison and Logical Operators. The ORDER BY Clause.



3. Character and Number Functions.

Character Functions. Number Functions.



4. Date and Conversion Functions.

Converting from One Datatype to Another. Applying Oracle's Date Format Models. Performing Date and Time Math. The NVL and DECODE Functions.



5. Aggregate Functions, GROUP BY, and HAVING.

Aggregate Functions. The GROUP BY and HAVING Clauses.



6. Equijoins.

The Two Table Join. Joining More Than Two Tables.



7. Subqueries.

Simple Subqueries. Correlated Subqueries. ANY, COME, and ALL Operators in Subqueries.



8. Set Operators.

The Power of UNION and UNION ALL. The MINUS and INTERSECT Set Operators.



9. Complex Joins.

Outer Joins. Self-Joins.



10. Insert, Update, and Delete.

Manipulaitng Data and Transaction Control.



11. Create, Alter, and Drop Tables.

Creating and Dropping Tables. Altering Tables and Manipulating Constraints.



12. Views, Indexes, and Sequences.

Creating and Modifying Views. Indexes. Sequences.



13. The Data Dictionary and Dynamic SQL Scripts.

The Oracle Data Dictionary Views. Dynamic. SQL Scripts.



14. Security.

Users, Privileges, Roles, and Synonyms.



15. Advanced SQL Queries.

DECODE Magic and In-line Views. Hierarchical Queries.



16. SQL Optimization.

The Oracle Optimizer and Writing Effective SQL Statement.



Appendix A: Answers to Self-Review Questions.


Appendix B: SQL Formatting Guide and SQL*Plus Command Reference.


Appendix C: Student Database Schema.


Index.

Additional information

CIN0130157457G
9780130157454
0130157457
Oracle SQL Interactive Workbook by Alex Morrison
Alex Morrison
Used - Good
Paperback
Pearson Education (US)
20000512
516
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Oracle SQL Interactive Workbook