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

Steve Ries

  • 出版商: Packt Publishing
  • 出版日期: 2011-11-27
  • 售價: $1,860
  • 貴賓價: 9.5$1,767
  • 語言: 英文
  • 頁數: 460
  • 裝訂: Paperback
  • ISBN: 1849683646
  • ISBN-13: 9781849683647
  • 相關分類: OracleOracle 認證SQL資料庫
  • 下單後立即進貨 (約3~4週)

商品描述

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

  • Successfully clear the first stepping stone towards attaining the Oracle Certified Associate Certification on Oracle Database 11g
  • This book uses a real world example-driven approach that is easy to understand and makes engaging
  • Complete coverage of the prescribed syllabus
  • Learn from a range of self-test questions to fully equip you with the knowledge to pass this exam
  • After reading this book, you can enter the exam room with confidence, knowing that you have done all you can to prepare for the big day

In Detail

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.

What you will learn from this book

  • 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

Approach

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, you will find a variety of practice questions to strengthen and test your learning.

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

Who this book is written for

This book is for anyone who needs the essential skills to pass the Oracle Database SQL Fundamentals I exam and use those skills in daily life as an SQL developer or database administrator.

商品描述(中文翻譯)

通過學習SQL概念在現實世界中的應用,成功通過1Z0-051 SQL Fundamentals I考試,成為一名成功的資料庫管理員。


  • 成功通過獲得Oracle Database 11g的Oracle Certified Associate認證的第一個里程碑

  • 本書採用以實例為驅動的方法,易於理解並引人入勝

  • 完整涵蓋指定的課程大綱

  • 通過一系列自測問題學習,充分裝備您通過考試所需的知識

  • 閱讀本書後,您可以自信地進入考試室,知道您已經做了一切準備迎接重要的一天

詳細內容

Oracle Database 11g: SQL Fundamentals I考試是獲得Oracle Database 11g的Oracle Certified Associate認證的第一個里程碑。SQL編程語言在今天的主要關聯式數據庫中都被使用,了解其在現實世界中的應用是成為成功的資料庫管理員的關鍵。

本書提供您:掌握使用Oracle SQL進行關聯數據操作的基本實用技能,並為您成為Oracle Certified Associate做好準備。初學者以邏輯方式介紹概念,而從業者可以將其用作直接跳轉到相關概念的參考資料。

我們從解釋為什麼數據庫在當今信息技術世界中重要以及它們的工作原理的基本知識開始。

然後,我們通過使用各種技術(包括數據投影、選擇、創建、連接、子查詢和函數)解釋在Oracle中查詢和修改數據的概念。最後,我們學習創建和操作數據庫對象,並以與今天的專業SQL程序員相同的方式使用它們。

本書以易於理解的實例驅動方法,為您準備掌握SQL編程語言的基礎知識。

這本權威的認證指南提供了一種紀律性的方法,以成功通過1Z0-051 SQL Fundamentals I考試,這是獲得Oracle Database 11g認證的第一個里程碑。

每章末尾都有充足的練習問題。還包括一個完整的模擬測試,供您練習,以便您可以測試自己的知識並對實際考試有所了解。

您將從本書中學到什麼


  • 深入了解數據庫的基礎知識以及它們的工作原理

  • 創建和操作數據庫

  • 通過從多個表中結合數據來創建複雜報表

  • 使用函數來操作數據以解決現實世界問題

  • 從頭開始創建數據庫對象,以存儲當今企業使用的數據類型

  • 在應用程序開發中使用SQL

  • 使用分組函數進行數據聚合轉換

  • 結合SQL查詢

方法

本書充滿了真實世界的例子。每個主要的認證主題都在單獨的章節中介紹,這有助於更容易理解概念。每章末尾,您將找到各種練習問題,以加強和測試您的學習。

通過解決模擬考試題目,您將對實際的SQL Fundamentals I考試有所了解。

本書適合對象

本書適用於任何需要通過Oracle Database SQL Fundamentals I考試的基本技能,並將這些技能應用於日常生活中作為SQL開發人員或資料庫管理員的人。