OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )

Ace the 1Z0-051 SQL Fundamentals I exam, and become a successful DBA by learning how SQL concepts work in the real world with this book and ebook

OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )

Steve Ries

Ace the 1Z0-051 SQL Fundamentals I exam, and become a successful DBA by learning how SQL concepts work in the real world with this book and ebook
Mapt Subscription
FREE
$30.00/m after trial
eBook
$21.00
RRP $29.99
Save 29%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$21.00
$49.99
$29.99 p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 ) Book Cover
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
$ 29.99
$ 21.00
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 25.20
Buy 2 for $35.00
Save $30.98
Add to Cart

Book Details

ISBN 139781849683647
Paperback460 pages

Book Description

The Oracle Database 11g: SQL Fundamentals I exam is the first stepping stone in getting the Oracle Certified Associate Certification for Oracle Database 11g. The SQL programming language is used in every major relational database today and understanding the real world application of it is the key to becoming a successful DBA.

This book gives you: the essential real world skills to master relational data manipulation with Oracle SQL and prepares you to become an Oracle Certified Associate. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.

We begin with the essentials of why databases are important in today's information technology world and how they work.

We continue by explaining the concepts of querying and modifying data in Oracle using a range of techniques, including data projection, selection, creation, joins, sub-queries and functions. Finally, we learn to create and manipulate database objects and to use them in the same way as today's expert SQL programmers.

This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand

This definitive certification guide provides a disciplined approach to be adopted for successfully clearing the 1Z0-051 SQL Fundamentals I exam, which is the first stepping stone towards attaining the OCA on Oracle Database 11g certification.

Each chapter contains ample practice questions at the end. A full-blown mock test is included for practice so you can test your knowledge and get a feel for the actual exam.

Table of Contents

What You Will Learn

  • Get insights into the fundamentals of databases and how they work
  • Create and manipulate databases
  • Create complex reports by joining data from multiple tables
  • Use functions to manipulate data for solving real world problems
  • Create database objects from scratch to store the types of data used in businesses today
  • Use SQL in application development
  • Aggregate data transformation using group functions
  • Combine SQL queries

 

Authors

Table of Contents

Book Details

ISBN 139781849683647
Paperback460 pages
Read More

Read More Reviews

Recommended for You

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 25.20
Oracle Data Guard 11gR2 Administration : Beginner's Guide  Book Cover
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$ 35.99
$ 25.20
Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
SAP ABAP Advanced Cookbook Book Cover
SAP ABAP Advanced Cookbook
$ 29.99
$ 21.00
Excel 2010 Financials Cookbook Book Cover
Excel 2010 Financials Cookbook
$ 23.99
$ 16.80
Oracle SOA BPEL Process Manager 11gR1 - A Hands-on Tutorial Book Cover
Oracle SOA BPEL Process Manager 11gR1 - A Hands-on Tutorial
$ 32.99
$ 23.10