Sams Teach Yourself Oracle PL/SQL in 10 Minutes - Softcover

Forta, Ben

Softcover

ISBN 10: 0672328666 ISBN 13: 9780672328664

Publisher: Sams Publishing, 2015

Synopsis

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

About this title

About the Author

Ben Forta has three decades of experience in the computer industry in product design and development, support, training, and marketing. As Adobe Inc.’s Senior Director of Education Initiatives, he spends a considerable amount of time teaching, talking, and writing about Adobe products, coding and application development, creativity, and digital literacy and provides feedback to help shape the future direction of Adobe products.

 

Ben is the author of more than 40 books, including the world’s bestselling title on SQL, as well as titles on topics as diverse as Regular Expressions, mobile development, and Adobe ColdFusion. More than 750,000 copies of his books are in print in English, and titles have been translated into fifteen languages. Many of these titles are used as textbooks in colleges and universities worldwide.

 

Education is Ben’s passion. Between writing, lecturing, and in-classroom experience, Ben has dedicated his professional and personal lives to teaching, inspiring, and sharing his love for technology and creativity. He is immensely grateful to have had the opportunity to share with millions worldwide.

 

Ben is also a successful entrepreneur with experience creating, building, and selling start-ups. He is a sought-after public speaker, a writer, and a blogger, and he presents on education and development topics worldwide.

From the Back Cover

PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good working knowledge of PL/SQL. 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. Sams Teach Yourself Oracle PL/SQL in 10 Minutes is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling on 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. It uses the format of the author's bestselling  Sams Teach Yourself SQL in 10 Minutes =, which has proven to be highly effective and popular.

 

Edition details

• Publisher: Sams Publishing
• Publication date: 2015
• Language: English
• ISBN 10: 0672328666
• ISBN 13: 9780672328664
• Binding: Paperback
• Edition number: 1
• Number of pages: 288