Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 2 3 4 5 6 < 7 > 8 9 10 11 12 13 .. 76 >> Next


Introduction....................................................5-2

Relational Algebra..............................................5-2

Teradata SQL Expressions........................................5-3

Arithmetic Operators............................................5-3

Aggregate Operators.............................................5-4

Comparison Operators............................................5-4

Logical Operators...............................................5-5

Partial String Matching Operator................................5-5

Set Operators...................................................5-6

Other Operators.................................................5-6

Arithmetic Functions............................................5-7

Using Fully Qualified Names to Reference Databases and

Tables in Teradata SQL............................................5-8

Introduction....................................................5-8

Fully Qualified Names...........................................5-8

Simple SQL Queries: Using the SELECT Statement......................5-9

Introduction....................................................5-9

Selecting All Rows from a Table.................................5-9

Selecting Specific Columns from a Table.........................5-9

Selecting Specific Rows from a Table...........................5-10

Using Comparison and Logical Operators to

Select Specific Rows.......................................5-11

Specifying Order in the Results Table..........................5-12

Defining Groups................................................5-12

Including Information from More Than

One Table in a Query.......................................5-13

Nesting Subqueries.............................................5-14

xviii

Introduction to the Teradata RDBMS for UNIX
Table of Contents

Using the INSERT Statement......................................5-16

Introduction................................................5-16

INSERT: First Form..........................................5-16

INSERT: Second Form.........................................5-17

INSERT: Third Form..........................................5-17

Using the UPDATE Statement......................................5-18

Introduction................................................5-18

How to Change Rows Using the UPDATE Statement...............5-18

Using the DELETE Statement to Delete Rows from a Table..........5-19

Introduction................................................5-19

How to Delete Rows from a Table.............................5-19

Using Teradata SQL in Application Programs......................5-20

Introduction................................................5-20

Embedded SQL and Client Programming Languages...............5-20

Cursors.....................................................5-21

For More Information............................................5-22

Chapter 6

Views

About This Chapter...................................................6-1

Introduction.....................................................6-1

Why Use Views?...................................................6-1

Creating and Altering Views..........................................6-2

Introduction.....................................................6-2

Creating a Teradata RDBMS View...................................6-2

Altering a Teradata RDBMS View...................................6-3

Why You Should Use Views.............................................6-4

Introduction.....................................................6-4

Simplified User Perception of the Database.......................6-4

Security for Restricting Table Access and Updates................6-4

Well-Defined, High Performance Access to the Database...........6-4

Logical Data Independence........................................6-5

Restrictions on DML Operations on Views..............................6-6

Introduction.....................................................6-6

Views with Aggregates............................................6-6

Views with Joins.................................................6-6

For More Information.................................................6-7

Introduction to the Teradata RDBMS for UNIX xix
Table of Contents

Chapter 7

Data Dictionary

About This Chapter..................................................7-1

Introduction....................................................7-1

DD Objects......................................................7-1

DD Users........................................................7-1

Structure of the Data Dictionary....................................7-2

Introduction....................................................7-2

A Summary of the DD Views.......................................7-2

End User Views..................................................7-3
Previous << 1 .. 2 3 4 5 6 < 7 > 8 9 10 11 12 13 .. 76 >> Next