Test Bank for Oracle 12c SQL 3rd Edition by Joan Casteel – Ebook PDF Instant Download/Delivery: 1305251032, 978-1305251038
Full download Oracle 12c SQL 3rd edition after payment
Product details:
ISBN 10: 1305251032
ISBN 13: 978-1305251038
Author: Joan Casteel
Now you can master the latest version of the fundamental SQL language used in all relational databases today with ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you transform a basic knowledge of databases into proficiency with the latest SQL and Oracle concepts and techniques. You learn to use Oracle 12c SQL most effectively as you prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores both basic data query techniques as well as advanced query topics using a proven hands-on approach. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help you transition to further studies and even more advanced books in this series, appendixes introduce SQL tuning, compare Oracle’s SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Trust ORACLE 12C: SQL, 3E to provide the knowledge you need for Oracle certification testing and the solid foundation for pursuing a career as a database administrator or developer.
Oracle 12c SQL 3rd Table of contents:
Chapter 1. Overview of Database Concepts
Introduction
Database Terminology
Database Management System
Database Design
Entity-Relationship (E-R) Model
Database Normalization
Relating Tables in the Database
Structured Query Language (SQL)
Databases Used in This Textbook
Basic Assumptions
Tables in the JustLee Books Database
Topic Sequence
Software Used in This Textbook
Chapter Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 2. Basic SQL SELECT Statements
Introduction
Creating the Justlee Books Database
Select Statement Syntax
Selecting All Data in a Table
Selecting One Column from a Table
Selecting Multiple Columns from a Table
Operations in the Select Statement
Using Column Aliases
Using Arithmetic Operations
NULL Values
Using DISTINCT and UNIQUE
Using Concatenation
Chapter Summary
Chapter 2 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 3. Table Creation and Management
Introduction
Table Design
Table Creation
Defining Columns
Viewing a List of Tables: USER_TABLES
Viewing Table Structures: DESCRIBE
Table Creation with Subqueries
CREATE TABLE … AS Command
Modifying Existing Tables
ALTER TABLE … ADD Command
ALTER TABLE … MODIFY Command
ALTER TABLE … DROP COLUMN Command
ALTER TABLE … SET UNUSED/DROP UNUSED COLUMNS Command
Renaming a Table
Truncating a Table
Deleting a Table
Chapter Summary
Chapter 3 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 4. Constraints
Introduction
Creating Constraints
Creating Constraints at the Column Level
Creating Constraints at the Table Level
Using the Primary Key Constraint
Using the Foreign Key Constraint
Using the Unique Constraint
Using the Check Constraint
Using the Not Null Constraint
Including Constraints during Table Creation
Adding Multiple Constraints on a Single Column
Viewing Constraint Information
Disabling and Dropping Constraints
Using DISABLE/ENABLE
Dropping Constraints
Chapter Summary
Chapter 4 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 5. Data Manipulation and Transaction Control
Introduction
Inserting New Rows
Using the INSERT Command
Handling Virtual Columns
Handling Single Quotes in an INSERT Value
Inserting Data from an Existing Table
Modifying Existing Rows
Using the UPDATE Command
Using Substitution Variables
Deleting Rows
Using Transaction Control StatemEnts
COMMIT and ROLLBACK Commands
SAVEPOINT Command
Using Table Locks
LOCK TABLE Command
SELECT … FOR UPDATE Command
Chapter Summary
Chapter 5 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 6. Additional Database Objects
Introduction
Sequences
Creating a Sequence
Using Sequence Values
Setting and Altering Sequence Definitions
Altering Sequence Definitions
Removing a Sequence
Use Identity Columns Instead of Sequences for Primary Key Columns
Indexes
B-Tree Indexes
Bitmap Indexes
Function-Based Indexes
Index Organized Tables
Verifying an Index
Altering or Removing an Index
Synonyms
Deleting a Synonym
Chapter Summary
Chapter 6 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 7. User Creation and Management
Introduction
Data Security
Creating a User
Creating Usernames and Passwords
Assigning User Privileges
System Privileges
Granting System Privileges
Object Privileges
Granting Object Privileges
Managing Passwords
Using Roles
Creating and Assigning Roles
Using Predefined Roles
Using Default Roles
Enabling Roles After Login
Viewing Privilege Information
Removing Privileges and Users
Revoking Privileges and Roles
Dropping a Role
Dropping a User
Chapter Summary
Chapter 7 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 8. Restricting Rows and Sorting Data
Introduction
Where Clause Syntax
Rules for Character Strings
Rules for Dates
Comparison Operators
BETWEEN … AND Operator
IN Operator
LIKE Operator
Logical Operators
Treatment of Null Values
Order by Clause Syntax
Secondary Sort
Sorting by SELECT Order
Chapter Summary
Chapter 8 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 9. Joining Data from Multiple Tables
Introduction
Cartesian Joins
Cartesian Join: Traditional Method
Cartesian Join: JOIN Method
Equality Joins
Equality Joins: Traditional Method
Equality Joins: JOIN Method
Non-equality Joins
Non-equality Joins: Traditional Method
Non-equality Joins: Join Method
Self-joins
Self-joins: Traditional Method
Self-Joins: JOIN Method
Outer Joins
Outer Joins: Traditional Method
Outer Joins: JOIN Method
Set Operators
Chapter Summary
Chapter 9 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 10. Selected Single-Row Functions
Introduction
Case Conversion Functions
The LOWER Function
The UPPER Function
The INITCAP Function
Character Manipulation Functions
The SUBSTR Function
The INSTR Function
The LENGTH Function
The LPAD and RPAD Functions
The LTRIM and RTRIM Functions
The REPLACE Function
The TRANSLATE Function
The CONCAT Function
Number Functions
The ROUND Function
The TRUNC Function
The MOD Function
The ABS Function
The POWER Function
Date Functions
The MONTHS_BETWEEN Function
The ADD_MONTHS Function
The NEXT_DAY and LAST_DAY Functions
The TO_DATE Function
Rounding Date Values
Truncating Date Values
CURRENT_DATE versus SYSDATE
Regular Expressions
Other Functions
The NVL Function
The NVL2 Function
The NULLIF Function
The TO_CHAR Function
The DECODE Function
The CASE Expression
The SOUNDEX Function
The TO_NUMBER Function
The Dual Table
Chapter Summary
Chapter 10 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 11. Group Functions
Introduction
Group Functions
The SUM Function
The AVG Function
The COUNT Function
The MAX Function
The MIN Function
Grouping Data
Restricting Aggregated Output
Nesting Functions
Statistical Group Functions
The STDDEV Function
The VARIANCE Function
Enhanced Aggregation for Reporting
The GROUPING SETS Expression
The CUBE Extension
The ROLLUP Extension
Pattern Matching
Chapter Summary
Chapter 11 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 12. Subqueries and Merge Statements
Introduction
Subqueries and their Uses
Single-Row Subqueries
Single-Row Subquery in a WHERE Clause
Single-Row Subquery in a HAVING Clause
Single-Row Subquery in a SELECT Clause
Multiple-Row Subqueries
The IN Operator
The ALL and ANY Operators
Multiple-Row Subquery in a HAVING Clause
Multiple-Column Subqueries
Multiple-Column Subquery in a FROM Clause
Multiple-Column Subquery in a WHERE Clause
Null Values
NVL in Subqueries
IS NULL in Subqueries
Correlated Subqueries
Nested Subqueries
Subquery Factoring Clause
DML Actions Using Subqueries
MERGE Statements
Chapter Summary
Chapter 12 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Chapter 13. Views
Introduction
Creating a View
Creating a Simple View
DML Operations on a Simple View
Creating a Complex View
DML Operations on a Complex View with an Arithmetic Expression
DML Operations on a Complex View Containing Data from Multiple Tables
DML Operations on a Complex View Containing Functions or Grouped Data
DML Operations on a Complex View Containing DISTINCT or ROWNUM
Summary Guidelines for DML Operations on a Complex View
Dropping a View
Creating an Inline View
CROSS and OUTER APPLY Methods for Joins
TOP-N Analysis
Creating a Materialized View
Chapter Summary
Chapter 13 Syntax Summary
Review Questions
Multiple Choice
Hands-On Assignments
Advanced Challenge
Case Study: City Jail
Appendix A. Tables for the Justlee Books Database
Appendix B. SQL*Plus and SQL Developer Overview
Appendix C. Oracle Resources
Appendix D. SQL*Loader
Appendix E. SQL Tuning Topics
Appendix F. SQL in Various Databases
People also search for Oracle 12c SQL 3rd:
joan casteel 2015 oracle 12c sql 3rd edition
joan casteel 2016 oracle 12c sql 3rd edition
solution manual for oracle 12c sql 3rd edition casteel
oracle 12c sql 3rd edition pdf free download
oracle 12c sql 3rd edition by joan casteel
Tags: Joan Casteel, Oracle 12c SQL