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 )

Progressing
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
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781849683647
Paperback460 pages

About This Book

  • 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
  • Get Mock test exam paper and Mock test answers

Test your Knowledge

Who This Book Is 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.

Table of Contents

Chapter 1: SQL and Relational Databases
Relational Database Management Systems
Structured Query Language
Working with SQL
An introduction to Oracle SQL Developer
Summary
Test your knowledge
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
Sorting data
Summary
Certification objectives covered
Test Your Knowledge
Chapter 4: Data Manipulation with DML
Persistent storage and the CRUD model
Creating data with INSERT
Modifying data with UPDATE
Removing data with DELETE
Transaction control
Recognizing errors
Summary
Test your knowledge
Chapter 5: Combining Data from Multiple Tables
Understanding the principles of joining tables
Using ANSI standard joins
Understanding Oracle join syntax
Summary
Test your knowledge
Chapter 6: Row Level Data Transformation
Understanding functions and their use
Understanding String functions
Handling DATE functions
Using arithmetic functions
Examining functions that execute conditional retrieval
Summary
Test your knowledge
Chapter 7: Aggregate Data Transformation
Understanding multi-row functions
Grouping data
Putting it all together
Certification objectives covered
Summary
Test your knowledge
Chapter 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
Chapter 9: Creating Tables
Introducing Data Definition Language
Using database constraints
Extending the Companylink Data Model
Summary
Test your knowledge
Chapter 10: Creating Other Database Objects
Using indexes to increase performance
Working with views
Using sequences
Object naming using synonyms
Summary
Test your knowledge
Chapter 11: SQL in Application Development
Using SQL with other languages
Understanding the Oracle optimizer
Advanced SQL statements
Exam preparation
Summary
Practice test paper

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

 

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.

Authors

Table of Contents

Chapter 1: SQL and Relational Databases
Relational Database Management Systems
Structured Query Language
Working with SQL
An introduction to Oracle SQL Developer
Summary
Test your knowledge
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
Sorting data
Summary
Certification objectives covered
Test Your Knowledge
Chapter 4: Data Manipulation with DML
Persistent storage and the CRUD model
Creating data with INSERT
Modifying data with UPDATE
Removing data with DELETE
Transaction control
Recognizing errors
Summary
Test your knowledge
Chapter 5: Combining Data from Multiple Tables
Understanding the principles of joining tables
Using ANSI standard joins
Understanding Oracle join syntax
Summary
Test your knowledge
Chapter 6: Row Level Data Transformation
Understanding functions and their use
Understanding String functions
Handling DATE functions
Using arithmetic functions
Examining functions that execute conditional retrieval
Summary
Test your knowledge
Chapter 7: Aggregate Data Transformation
Understanding multi-row functions
Grouping data
Putting it all together
Certification objectives covered
Summary
Test your knowledge
Chapter 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
Chapter 9: Creating Tables
Introducing Data Definition Language
Using database constraints
Extending the Companylink Data Model
Summary
Test your knowledge
Chapter 10: Creating Other Database Objects
Using indexes to increase performance
Working with views
Using sequences
Object naming using synonyms
Summary
Test your knowledge
Chapter 11: SQL in Application Development
Using SQL with other languages
Understanding the Oracle optimizer
Advanced SQL statements
Exam preparation
Summary
Practice test paper

Book Details

ISBN 139781849683647
Paperback460 pages
Read More

Recommended for You

Oracle Database 11g – Underground Advice for Database Administrators
$ 10.00