Home Page Icon
Home Page
Table of Contents for
cover
Close
cover
by Melanie Caffrey, Inger Jørgensen, Tim Gorman, Lex De Haan
Beginning Oracle SQL: for Oracle Database 12c, Third Edition
Title Page
Contents at a Glance
Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Introduction
CHAPTER 1: Relational Database Systems and Oracle
1.1 Information Needs and Information Systems
1.2 Database Design
1.3 Database Management Systems
1.4 Relational Database Management Systems
1.5 Relational Data Structures
1.6 Relational Operators
1.7 How Relational Is My DBMS?
1.8 The Oracle Software Environment
1.9 Case Tables
CHAPTER 2: Introduction to SQL and SQL Developer
2.1 Overview of SQL
2.2 Basic SQL Concepts and Terminology
2.3 Introduction to SQL Developer
CHAPTER 3: Data Definition, Part I
3.1 Schemas and Users
3.2 Table Creation
3.3 Datatypes
3.4 Commands for Creating the Case Tables
3.5 The Data Dictionary
CHAPTER 4: Retrieval: The Basics
4.1 Overview of the SELECT Command
4.2 The SELECT Clause
4.3 The WHERE Clause
4.4 The ORDER BY Clause
4.5 AND, OR, and NOT
4.6 BETWEEN, IN, and LIKE
4.7 CASE Expressions
4.8 Subqueries
4.9 Null Values
4.10 Truth Tables
4.11 Exercises
CHAPTER 5: Retrieval: Functions
5.1 Overview of Functions
5.2 Arithmetic Functions
5.3 Text Functions
5.4 Regular Expressions
5.5 Date Functions
5.6 General Functions
5.7 Conversion Functions
5.8 Stored Functions
5.9 Exercises
CHAPTER 6: Data Manipulation
6.1 The INSERT Command
6.2 The UPDATE Command
6.3 The DELETE Command
6.4 The MERGE Command
6.5 Transaction Processing
6.6 Locking and Read Consistency
CHAPTER 7: Data Definition, Part II
7.1 The CREATE TABLE Command
7.2 More on Datatypes
7.3 The ALTER TABLE and RENAME Commands
7.4 Constraints
7.5 Indexes
7.6 Performance Monitoring with SQL Developer AUTOTRACE
7.7 Sequences
7.8 Synonyms
7.9 The CURRENT_SCHEMA Setting
7.10 The DROP TABLE Command
7.11 The TRUNCATE Command
7.12 The COMMENT Command
7.13 Exercises
CHAPTER 8: Retrieval: Multiple Tables and Aggregation
8.1 Tuple Variables
8.2 Joins
8.3 The JOIN Clause
8.4 Outer Joins
8.5 The GROUP BY Component
8.6 Group Functions
8.7 The HAVING Clause
8.8 Advanced GROUP BY Features
8.9 Partitioned Outer Joins
8.10 Set Operators
8.11 Exercises
CHAPTER 9: Retrieval: Some Advanced Features
9.1 Subqueries Continued
9.2 Subqueries in the SELECT Clause
9.3 Subqueries in the FROM Clause
9.4 The WITH Clause
9.5 Hierarchical Queries
9.6 Analytic Functions
9.7 Row Limiting
9.8 Flashback Features
9.9 Exercises
CHAPTER 10: Views
10.1 What Are Views?
10.2 View Creation
10.3 What Can You Do with Views?
10.4 Data Manipulation via Views
10.5 Data Manipulation via Inline Views
10.6 Views and Performance
10.7 Materialized Views
10.8 Global Temporary Table
10.9 Invisible Columns
10.10 Exercises
CHAPTER 11: SQL*Plus Basics and Scripting
11.1 Introduction to SQL*Plus
11.2 SQL*Plus Variables
11.3 Bind Variables
11.4 SQL*Plus Scripts
11.5 Report Generation with SQL*Plus
11.6 HTML in SQL*Plus
11.7 Building SQL*Plus Scripts for Automation
11.8 Exercises
CHAPTER 12: Object-Relational Features
12.1 More Datatypes
12.2 Varrays
12.3 Nested Tables
12.4 User-Defined Types
12.5 Multiset Operators
12.6 Exercises
APPENDIX A: The Seven Case Tables
ERM Diagram
Table Structure Descriptions
Columns and Foreign Key Constraints
Contents of the Seven Tables
Hierarchical Employees Overview
Course Offerings Overview
APPENDIX B: Answers to the Exercises
Chapter 1, 2 and 3: No exercises
Chapter 4 Exercises
Chapter 5 Exercises
Chapter 6: No exercises
Chapter 7 Exercises
Chapter 8 Exercises
Chapter 9 Exercises
Chapter 10 Exercises
Chapter 11 Exercises
Chapter 12 Exercises
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset