Murach’s Oracle SQL and PL/SQL


Автор: Murach J.
Издательство: Mike Murach & Associates

Год: 2008
Страниц: 640
Язык: английский
Формат: pdf
ISBN: 

 


Аннотация:

 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.Here are 5 of the ways that our book differs from the others

#1: You’ll see how to take advantage of the Oracle SQL Developer tool

SQL Developer is a free tool for working with database objects and SQL statements. Its graphical interface makes it more intuitive and easier to use than older command-line tools like SQL*Plus. I think you ll find it boosts your productivity as you use it to write and run queries, to work with database objects, or to debug stored procedures.

#2: You’ll start off with how to query a database, not how to design one

This book is written for application developers, and the first thing an application developer needs to know is how to write queries. So that’s what’s covered in the first 8 chapters of this book. It starts with simple queries, then moves on to complex inner and outer joins, summary queries, and subqueries that do more of the database processing so that your applications can do less.

 

Скачать книгу из интернета:

Вас заинтересует / Intresting for you:

SQL для чайников
SQL для чайников 5638 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
MySQL Crash Course
MySQL Crash Course 1564 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:20:13
MySQL Explained: Your Step By ...
MySQL Explained: Your Step By ... 1229 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
Jump Start MySQL
Jump Start MySQL 1101 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:11:06
Войдите чтобы комментировать