Book description
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.
Table of contents
-
OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
- Table of Contents
- OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. SQL and Relational Databases
-
2. SQL SELECT Statements
- The purpose and syntax of SQL
- Retrieving data with SELECT statements
- Displaying the structure of a table using DESCRIBE
- Using aliases to format output of SELECT statements
- Using arithmetic operators with SELECT
- Using DISTINCT to display unique values
- Concatenating values in SELECT statements
- Summary
- Test your knowledge
-
3. Using Conditional Statements
- Implementing selectivity using the WHERE clause
- Using conditions in WHERE clauses
-
Examining conditions with multiple values
- Constructing range conditions using the BETWEEN clause
- Using the IN clause to create set conditions
- Pattern-matching conditions using the LIKE clause
- Understanding Boolean conditions in the WHERE clause
- Examining the Boolean OR operator
- Understanding the Boolean AND operator
- The Boolean NOT operator
- Using ampersand substitution with runtime conditions
- Sorting data
- Summary
- Certification objectives covered
- Test Your Knowledge
- 4. Data Manipulation with DML
-
5. Combining Data from Multiple Tables
- Understanding the principles of joining tables
-
Using ANSI standard joins
- Understanding the structure and syntax of ANSI join statements
- Examining ambiguous Cartesian joins
- Using equi joins—joins based on equivalence
- Understanding the row inclusiveness of outer joins
- Retrieving data from multiple tables using n-1 join conditions
- Working with less commonly-used joins—non-equi joins and self-joins
- Understanding Oracle join syntax
- Summary
- Test your knowledge
- 6. Row Level Data Transformation
- 7. Aggregate Data Transformation
-
8. Combining Queries
- Understanding the principles of subqueries
- Examining different types of subqueries
- Investigating further rules for subqueries
- Using set operators within SQL
- Summary
- Certification objectives covered
- Test your knowledge
-
9. Creating Tables
- Introducing Data Definition Language
- Using database constraints
- Extending the Companylink Data Model
- Summary
- Test your knowledge
-
10. Creating Other Database Objects
- Using indexes to increase performance
- Working with views
- Using sequences
- Object naming using synonyms
- Summary
- Test your knowledge
- 11. SQL in Application Development
- A. Companylink Table Reference
- B. Getting Started with APEX
- Index
Product information
- Title: OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
- Author(s):
- Release date: December 2011
- Publisher(s): Packt Publishing
- ISBN: 9781849683647
You might also like
book
Pandas for Everyone: Python Data Analysis, First Edition
The Hands-On, Example-Rich Introduction to Pandas Data Analysis in Python Today, analysts must manage data characterized …
book
Advanced Oracle PL/SQL Developer's Guide - Second Edition
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle …
book
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
Learn how to become an Oracle certified database administrator Prepare for Oracle Database Administration I certification …
book
Oracle SQL Developer
Learn Database design, development,and administration using the feature-rich SQL Developer 4.1 interface About This Book Explore …