Overview

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

Full Product Details

Author:   Ben Forta
Publisher:   Pearson Education (US)
Imprint:   Sams Publishing
Dimensions:   Width: 14.00cm , Height: 1.00cm , Length: 21.00cm
Weight:   0.322kg
ISBN:  

9780672328664

ISBN 10:   0672328666
Pages:   288
Publication Date:   08 October 2015
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Introduction Chapter 1: Understanding SQL   Chapter 2: Getting Started with Oracle and PL/SQL  Chapter 3: Working with Oracle   Chapter 4: Retrieving Data Chapter 5: Sorting Retrieved Data   Chapter 6: Filtering Data  Chapter 7: Advanced Data Filtering   Chapter 8: Using Wildcard Filtering  Chapter 9: Searching Using Regular Expressions Chapter 10: Creating Calculated Fields Chapter 11: Using Data Manipulation Functions Chapter 12: Summarizing Data Chapter 13: Grouping Data Chapter 14: Working with Subqueries Chapter 15: Joining Tables Chapter 16: Creating Advanced Joins Chapter 17: Combining Queries Chapter 18: Inserting Data Chapter 19: Updating and Deleting Data Chapter 20: Creating and Manipulating Tables Chapter 21: Using Views Chapter 22: Working with Stored Procedures  Chapter 23: Using Cursors Chapter 24: Using Triggers Chapter 25: Managing Transaction Processing Chapter 26: Managing Security Appendix A: The Example Tables   Appendix B: Oracle PL/SQL Datatypes Appendix C: Oracle PL/SQL Reserved Words and Keywords Index

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions