Skip to main content

Murach's Oracle SQL and PL/SQL


Murach's Oracle SQL and PL/SQL
by Joel Murach
18 chapters,627 pages, 271illustrations
ISBN: 978-1-890774-50-9

 

If you're developing applications that access Oracle databases, why not let SQL do more of the work for you?
With the new, free, Express Edition of Oracle Database and Oracle SQL Developer (also free), you can set up the database environment you need and train yourself right on your own computer. This new book shows you how!

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.

Design databases like a DBA

This isn't a DBA book. But you may be called upon to create test tables for your applications. And to write efficient queries, you need to understand how database design decisions affect security and performance.

So section 3 shows you how to design an Oracle database. Then, it shows you how to code SQL DDL (Data Definition Language) statements to implement the design, to create views, and to manage security.
Along the way, you'll gain insight into the issues DBAs deal with every day...a plus if you decide you want to move in that career direction.

Master PL/SQL

PL/SQL is Oracle's procedure language that allows you to code loops, if-else structures, and error-handling structures to build more complex scripts. That, in turn, allows you to manage transactions that maintain data integrity in a database. And it allows you to create stored procedures, functions, and triggers…named blocks of PL/SQL code that are stored in the database for ready access.

Handle special-purpose data

In today's increasingly global and digital world, you may need to handle time zones from around the world, and you may need to handle large amounts of text and binary data such as graphics, sound, and video. So section 5 shows you how to use Oracle's data types to make these tasks easier.

"The SQL book most developers don't even know they need"

That's how you're going to think of this book when you're done with it. You'll be delighted at how much time and work you'll save on each database application you write, using SQL skills that you didn't know you were missing before!
At that point, this book will become a terrific SQL reference for you to use on the job each day. Try and see for yourself.

Download link :http://www.filesonic.com/file/961803151/1890774502_SQL.pdf

Comments

Popular posts from this blog

Murach's JavaScript and DOM Scripting

by Ray Harris 20 chapters, 764 pages, 337 illustrations ISBN: 978-1-890774-55-4 Today, web users expect web sites to provide advanced features, dynamic user interfaces, and fast response times. To deliver that, you need to know the JavaScript language. Beyond that, though, you need to know how to use JavaScript to script the Document Object Model (or DOM). Now, at last, you can learn both JavaScript and DOM scripting in this one great book. In fact, by the end of chapter 3, you'll be able to develop and debug significant JavaScript applications. By the end of section 2, you'll know the complete JavaScript language and some elementary DOM scripting. And by end of section 3, you will have raised your DOM scripting skills to an expert level.

Murach's Java SE 6

Murach's Java SE 6 by Joel Murach and Andrea Steelman 22 chapters, 810 pages, 351 illustrations ISBN-10: 1-890774-42-1; ISBN-13: 978-1-890774-42-4 "I love your Java book. It cuts right to the essential information, providing the perfect balance between too many details and too little information. I bought another well-known Java book, but I spent several hours trying to learn what I learned from your book in about 45 minutes." That's what one developer wrote us about the JDK 5 edition of our core Java book. Now, you can expect that same practical, time-saving approach in the current edition that covers the latest version of Java, Java SE 6. What you'll learn from the SE 6 edit...

Murach's Java Servlets and JSP (2nd Edition)

by Joel Murach and Andrea Steelman    24 chapters, 729 pages, 329 illustrations ISBN-13: 978-1-890774-44-8 Ever since we published the first edition of this book back in 2003, we've been getting feedback like this from developers: "This book is excellent, excellent, excellent! The authors have a gift for developing the topic of JSP, Servlets, and building a Java-based ecommerce site in a methodical, easy-to-understand approach." Now, I'm delighted to tell you that you'll feel the same way about this new, 2nd edition. The content has been redone from start to finish, so you'll learn the best features, tools, and techniques for developing today's web applications (see what's NEW below).But our popular approach hasn't changed: This 2nd edition still presents Java web programming ...