Oca Oracle Database Sql Certified Expert Exam Guide (exam 1z0- 047)

Oca Oracle Database Sql Certified Expert Exam Guide (exam 1z0- 047) (Paperback)

By Steve O Hearn 
Publisher: McGraw-Hill Education (India) Pvt Ltd
Edition: Paperback
Language: English
ISBN: 0070701415
EAN: 9780070701410
Publish Date: 2010-1-1
Binding: Paperback
Ships to India.

Description

About the Book :

A Fully Integrated Study System for OCA Exam 1Z0-047

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:

  •     DDL and SQL SELECT statements
  •     Manipulating, restricting, and sorting data
  •     Single-row and group functions
  •     Subqueries
  •     Schema objects
  •     Set operators
  •     Data dictionary views
  •     Large data sets
  •     Hierarchical retrieval
  •     Regular expression support
  •     User access control
  •     And more


On the CD-ROM:

  •     One full practice exam
  •     Detailed answers and explanations
  •     Score report performance assessment tool
  •     Bonus exam available with free online registration


About the Author :
    
Steve O'Hearn has been an Oracle Certified Application Developer since 1999. He has designed databases for 23 years for clients such as the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He has served as a Chief Technology Officer, a consultant, and Instructor, and is the author of several computer books, including the "Oracle OCP Developer PL/SQL Program Units Exam Guide," from Oracle Press.

Contents :

Chapter 1. Introduction to SQL
Chapter 2. Using DDL Statements to Create and Manage Tables
Chapter 3. Manipulating Data
Chapter 4. Retrieving Data Using the SQL SELECT Statement
Chapter 5. Restricting and Sorting Data
Chapter 6. Using Single-Row Functions to Customize Output
Chapter 7. Reporting Aggregated Data Using the Group Functions
Chapter 8. Displaying Data from Multiple Tables
Chapter 9. Retrieving Data Using Subqueries
Chapter 10. Creating Other Schema Objects
Chapter 11. Managing Schema Objects
Chapter 12. Using the Set Operators
Chapter 13. Generating Reports by Grouping Related Data
Chapter 14. Managing Objects with Data Dictionary Views
Chapter 15. Manipulating Large Data Sets
Chapter 16. Hierarchical Retrieval
Chapter 17. Regular Expression Support
Chapter 18. Controlling User Access
Appendix A. About the CD
Glossary
Index

show moreless

Specification

Title: Oca Oracle Database Sql Certified Expert Exam Guide (exam 1z0- 047)
Publisher: McGraw-Hill Education (India) Pvt Ltd
Author: Steve O Hearn
Edition: Paperback
Language: English
ISBN: 0070701415
EAN: 9780070701410
Publish Date: 2010-1-1
Binding: Paperback

Disclaimer

  • The book summary and image may be of a different edition or binding of the same title.
  • Book reviews are added by registered customers. They need not necessarily buy book.
  • These books are NOT available for reading online or for free download in PDF or ebook format.
  • Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.
  • www.infibeam.com/Books is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.
  • For the imported title, once the order gets placed ,it can’t be cancelled


Great Value

Safe Payment

Shop With
Confidence

Help Center

Free & Easy Return

Get Discounts & Offers
Stay Connected

Popular Searches on Infibeam.com

Online Shopping: Deal of The Day / Hot Deals / Best Deals / Offers

Apple iPhones: Iphone Xs Max / Iphone Xs / Iphone XR / iPhone 8 / iPhone 8 / iPhone 7 / iPhone 7 Plus / iPhone 6s / iPhone 5s

Mobile Phones:Unboxed Mobiles / Apple Mobiles / Samsung Mobiles / Micromax Mobiles / Sony Mobiles / Intex Mobiles / Latest Mobiles / Smartphones / 4G Phones / 3G Phones

Computers:Dell Laptops / Lenovo Laptops / Acer Laptops / HP Laptops / External Hard Disks / Pen Drives / Monitors / Softwares / Printers

Appliances:Air Conditioners / Air Coolers / Refrigerators / Geysers / Room Heaters / Immersion Rod / Water Purifiers / Washing Machines / Microwaves & OTG / Air Purifier

Electronics: Tablets / Cameras / Headphones / Power Bank / LED TVs / Gaming Consoles / Speakers / Tablet Accessories / Memory Cards

Men's Clothing: Shirts / T-Shirts / Tracksuits / Trousers / Ethnic Wear / Men's Denim / Cargo Shorts / Tees & Polos / Suits & Blazer

Women's Clothing: Dress Materials / Salwar Suits / Women Sarees / Kurtas & Kurtis / Leggings / Lingerie / Night Suits & Nighties / Women Shorts / Tops

Fashion:Men's Shoes / Women's Footwear / Fastrack Watches / Titan Watches / Timex Watches / Bags / Jewellery / Fastrack Sunglasses / Perfumes & Deodorants / Fashion Accessories

Online Book Store:Best Sellers Books / Business Books / History and Politics / Academic and Professional / Competitive Exams / Biographies and Autobiographies

Best Ecommerce Platform:Online Store Builder / Create Online Store / Best Ecommerce Solutions / Sell Online / Ecommerce Marketing Blog

Ecommerce Website Templates:Free Website Templates / Free Logo Design / SEO Audit Report / Theme Store / Wordpress Themes / Web & App Development Company

Copyright © 2007-2019 Infibeam.com and Affiliates
Site is up