Share
Create bookmark
OCA Oracle Database 11g
SQL Fundamentals I: A Real World Certification Guide
Do you like this document?
Notes
Please login to add notes
- Cover
- Copyright
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Table of Contents
- Preface
-
+
Chapter 1: SQL and Relational Databases
-
+
Chapter 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
-
+
Chapter 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
-
+
Chapter 4: Data Manipulation with DML
-
+
Chapter 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
- + Chapter 6: Row Level Data Transformation
-
+
Chapter 7: Aggregate Data Transformation
- + Chapter 8: Combining Queries
-
+
Chapter 9: Creating Tables
- + Chapter 10: Creating Other Database Objects
-
+
Chapter 11: SQL in Application Development
- + Appendix A: Companylink Table Reference
- + Appendix B: Getting Started with APEX
- Index
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.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.
Your free to read time expires in minutes. After that you have to pause for an hour.
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Database Management > General
Publishers
Publication year : 2011
License: All rights reserved ©
Times read: 151
