OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide

Overview

OCA Oracle Database 11g: SQL Fundamentals I: A real world certification guide for anyone who needs the essential skills to pass the Oracle SQL Certified Expert Exam and use those skills in daily life as an SQL developer or database administrator.

This book is packed with real word examples. Each major certification topic is covered in a separate chapter, which helps to make understanding of concepts easier. At the end of each chapter, there is an exhaustive list of practice questions to strengthen and test your learning.

You will get a feel for the actual SQL Fundamentals exam by solving practice papers modeled on it.

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 of our own design and to use them in the same way as today's 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.

Read More