Murach’s Oracle SQL and PL/SQL
If you’re developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.
Get started fast with Oracle SQL Developer
In chapter 1, you’ll quickly master the database concepts you have to know to handle Oracle databases effectively. Then, chapter 2 gets you started using Oracle SQL Developer. This graphical tool makes it far easier to work with an Oracle database than it is with command-line tools like SQL*Plus, so you can be more productive right from the start.
Master the SQL that you’ll use every day
Section 2 starts you off writing SQL statements that retrieve and update the data in an Oracle database. But it doesn’t stop with simple SQL statements. Instead, it also teaches you how to work with complex inner and outer joins, summary queries, subqueries, data types, and functions…all features that allow you to retrieve and update data more efficiently.