Limit this search to....

Oracle Pl/SQL in 10 Minutes, Sams Teach Yourself
Contributor(s): Forta, Ben (Author)
ISBN: 0672328666     ISBN-13: 9780672328664
Publisher: Sams Publishing
OUR PRICE:   $26.99  
Product Type: Paperback
Published: September 2015
* Not available - Not in print at this time *Annotation: Many of the current PL/SQL titles are overkill for those who need to use PL/SQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. In "Oracle PL/SQL Crash Course," author expert Ben Forta distills the essentials of PL/SQL into a set of self-paced lessons in which you complete practice exercises designed to illustrate the most important aspects of setting up, using, and administering PL/SQL. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. You learn how to:
  • Use the PL/SQL toolset
  • Retrieve and sort data
  • Filter data using comparisons, wildcards, and full text searching
  • Use the aggregate functions to analyze data
  • Perform insert, update, and delete operations
  • Join relational tables using inner, outer, and self joins
  • Combine queries using unions
  • Use views
  • Create, and modify tables, and access table schemas
  • Create and use stored procedures, cursors, and other advanced database features
  • Manage databases, users, and security privileges
Additional Information
BISAC Categories:
- Computers | Programming Languages - Sql
- Computers | Databases - General
Dewey: 005.757
Series: Sams Teach Yourself
Physical Information: 0.8" H x 5.4" W x 8.1" (0.75 lbs) 288 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
Covers Oracle DBMS versions 10, 11, 12, and XE

 Sams Teach Yourself Oracle PL/SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 26 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Oracle's PL/SQL language.

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, regular expression and full text-based searches, stored procedures, cursors, triggers, table constraints, and much more.

10 minutes is all you need to learn how to...

  • Use PL/SQL in the Oracle environments and tools
  • Construct complex PL/SQL statements using multiple clauses and operators
  • Retrieve, sort, and format database contents
  • Pinpoint the data you need using a variety of filtering techniques
  • Use string, date-time, and math functions to manipulate your data
  • Join two or more related tables
  • Insert, update, and delete data
  • Create and alter database tables
  • Work with views, stored procedures, cursors, triggers, and more