How to code, create, retrieve with Oracle SQL and PL/SQL

	Book summary Table of contents Who this book is for What people say about this book Related books



		FREE download of chapters 2 and 3 FREE download of the book examples What software you need Instructor's CD FAQs Book corrections

Table of contents for
Murach’s Oracle SQL and PL/SQL

Section 1	An introduction to SQL
Chapter 1	An introduction to relational databases and SQL	3
Chapter 2	How to use Oracle SQL Developer and other tools	47
Section 2	The essential SQL skills
Chapter 3	How to retrieve data from a single table	79
Chapter 4	How to retrieve data from two or more tables	119
Chapter 5	How to code summary queries	159
Chapter 6	How to code subqueries	179
Chapter 7	How to insert, update, and delete data	211
Chapter 8	How to work with data types and functions	229
Section 3	Database design and implementation
Chapter 9	How to design a database	283
Chapter 10	How to create tables, indexes, and sequences	311
Chapter 11	How to create views	249
Chapter 12	How to manage database security	369
Section 4	The essential PL/SQL skills
Chapter 13	How to write PL/SQL code	409
Chapter 14	How to manage transactions and locking	447
Chapter 15	How to create stored procedures and functions	461
Chapter 16	How to create triggers	503
Section 5	Advanced data types
Chapter 17	How to work with timestamps and intervals	531
Chapter 18	How to work with large objects	561
Resources
Appendix A	How to install the software and source code for this book	591
Appendix B	How to install the Standard or Enterprise Edition of Oracle Database	603
Index		613

To contact us, call us at (800) 221-5528 or email us at murachbooks@murach.com